QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(7076025,10962719,7068368,8569417,8569418,4970712,10989335,10989336,10963446,8067223,7066248,7066268,7074321,7074322,7074323,7074398,7074399,7074400,7074401,7074402,7074403,7074404,7074405,7074406,7066440,10437383,10437384,10437400,8067524,10437401,7066639,7066640,7066641,7066741,10437620,7066775,7074877,7074878,8067860,7075026,10961955,10961956,10961957,10961958,10961959,10962441,8068711,7067821,8068712,8068713,8068714,8068715,8068716,8068717,8068718,8068719,8068720,8068721,8068722,8068723,8068724,8068725,8068726,7071959,8065233,8065234,7072271,7072280,7072460,7064531,7064535,7064597,10960363,7064713,10960443,10932273,7073128,7073129,7073130,7073131,7073132,10961021,10932956,10961414,10961415,10961416,10933088,10933091,10933092,10933093,10933094,10933095,10933159,10933160,10933161,10933162,4968061,4968062,4968063,4968064,4968065,4968066,4968067,4968068,4968069,4968070,4968071,4968072,4968073,8066880,8066881,8066882,8066883,8066884,8066885,10958817,10958818,10958819,11049145,8074123,8074124,8074125,10943015,8074126,8074127,8074128,8074129,8074130,8074131,8074132,8074133,8074134,8074135,8074136,8074137,8074138,8074139,8074140,8074141,11049307,8074142,8074143,8074144,8074145,8074146,8074147,8074148,8074149,8074150,8074151,8074152,8074153,8074154,8074155,8074156,8074157,8074158,8074159,8074160,8074161,8074162,11049328,8074163,8074164,8074165,8074166,8074167,8074168,8074169,8074170,8074171,8074172,8074173,8074174,8074175,8074176,8074177,8074178,8074179,8074180,8074181,8074182,8074183,8074184,8074185,8074186,8074187,8074188,8074189,8074190,8074191,8074192,8074193,8074194,8074195,8074196,8074197,8074198,8074199,8074200,8074201,8074202,8074203,8074204,8074205,8074206,8074207,8074208,8074209,8074210,8074211,7071539,10959254,8064662,8064663,8064664,8064665,8064666,8064667,8064668,8064669,8064670,6000109,6000110,6000111,7071930,10940559,10940560,10940561,3655595,7069439,10944889,10944890,10944920,3656333,3656334,3656335,3656336,3656347,3656348,3656349,3656350,3656351,3656352,3656353,3656354,3656355,3656356,3656357,3656358,3656359,3656407,3656408,3656439,8072738,8072739,8072740,8072741,8072742,10983755,10983756,3656680,3656681,10996913,11048358,10971254,10942284,10997500,10997501,10980672,10980673,10980674,10980675,10980676,10980677,10980678,10980679,10980680,10980681,10980682,10980683,10980684,10980685,10980686,10980687,10980688,10980689,10980690,10980691,10980692,10980693,10980694,10980695,10928563,10928564,10918628,10623331,10918885,10623425,10618919,10619078,10619079,10619080,10920191,10920192,10920193,10920194,10920195,10920196,10920197,10920198,10619882,10922496,10922497,10922498,10922602,10922603,10622132,10953923,10922917,10922918,10922919,10922920,10922921,10922922,10922923,10922924,10922925,10922926,10922927,10922928,10922929,10954115,10954116,10954119,10954120,10954121,10954122,10954123,10954124,10954125,10954126,10954127,10954128,10954129,10954130,10954131,10954132,10954133,10954134,10954135,10954136,10954137,10954138,10954139,10928150,10928270,10928271,10928272,10928326,10990746,10990747,10615092,10915755,10915756,10915757,10915758,10915759,10915760,10915761,10915762,10915763,10915764,10915765,10915766,10915767,10915768,10915769,10991011,10991012,10991013,10991014,8570315,8570328,8570329,8570330,10991061,10991062,10991063,10991064,10991065,8570386,8570387,8570388,8570389,8570390,8570391,10915960,10915961,10915962,10915963,10915964,10915966,10915967,10930532,10930533,10930534,10930535,10930536,10930537,10620643,10620644,10926286,10926287,10926288,10926289,10926842,10621580,10621581,10621582,10621583,10621584,10621585,10621586,10621587,10621588,10621589,10621590,10621591,10621592,10621593,10621594,10621595,10621596,10621597,10621598,10621599,10621600,10621601,10621602,10621603,10621604,10621605,10621606,10621607,10621608,10621609,10922217,10611251,10614288,9165970,10611800,10611879,8864777,8864782,8864783,8864784,10611994,10612204,10612205,10563423,10563424,10563425,10609295,10609316,10612336,10612346,10557726,10557727,10557728,10557729,10557730,10557731,10557732,10557733,10557734,10557735,10557736,10557737,10557738,10557739,10557740,10557741,10557742,10557743,10557744,10557745,10557746,10557747,10557748,10557749,10557750,10557751,10612601,10557752,10557753,10557754,10557755,10557756,10557757,10557758,10557759,10557760,10557761,10557762,10557763,10557764,10557765,10557766,10557767,10557768,10557769,10557770,10557771,10557772,10557773,10557774,10557775,10557776,10557777,10557778,10557779,10557780,10557781,10557782,10557783,10612633,10557784,10557785,10557786,10557787,10557788,10557789,10557790,7058144,10557791,10557792,10557793,10557794,7058147,10557795,10557796,10557797,10557798,10557799,10612725,7058314,10609828,8862843,7058495,8862952,7058805,7058806,7058807,7058828,10613326,7058861,7058863,7058909,7058910,7058911,7058912,7058913,7058914,7058915,7058916,7058917,7058918,7058919,7058920,7058921,7058922,7058923,7058924,7058925,7058926,7058927,7058928,10558623,10613520,10613521,10613552,10613766,4974203,10517238,10517239,10517240,7055671,9161603,9161604,9161605,9161606,9161607,9161608,9161609,9161610,9161611,9161612,9161613,9161614,9161615,9161616,9161617,9161618,9161619,9161620,9161621,9161622,9161623,9161624,9161625,9161626,9161627,9161628,9161629,9161630,4974488,4974489,7055900,4974607,4974608,9161881,10513956,10513957,10513958,7056826,7056827,7056828,10512841,10516903,7057444,9160303,9160304,10417357,10417358,10417382,10417393,9160485,8918255,8918256,8918257,8918258,8918259,10416557,10416559,4973675,4973676,10415832,10415909,10415910,10415911,10415912,10415913,10415914,10415915,6666477,6666478,4971447,10467454,10467455,10469752,10469831,10463844,10463845,10463846,10463847,10463848,10463849,10463850,10463851,10463852,10463853,10463854,10463855,10463856,10463857,10463858,10463859,10463860,10463861,10463862,10463863,10463864,10463865,10463866,10463867,10463868,10463869,10463870,10463871,10463872,10463873,10463874,10463875,8563255,8563256,8563257,8563258,8563259,8563260,8563261,8563262,8563263,8563264,6667364,8563265,8563266,8563267,8563268,8563269,8563270,8563271,6667371,8563272,6667372,8563273,8563274,8563275,8563276,8563277,8563278,8563279,8563280,8563281,6667381,6667382,6667383,6667384,6667385,6667386,6667387,10470063,10470068,10470080,6667697,6667703,6667704,6667705,6667706,6667707,6667708,6667709,6667710,6667711,6667712,6667713,6667714,6667715,6667716,6667717,6667718,6667719,6667720,6667724,6667725,6667728,6667729,6667730,6667731,6667732,6667733,8917451,8917452,8917453,8917454,8917455,8917456,8917580,10466534,10462745,8917878,8917903,8917915,10159874,10159875,10155730,10155731,10155810,10632132,10627305,10627306,10627307,10627308,10627309,10630063,10630102,10630299,10630300,10630301,10630302,10630303,10630305,10630306,10630312,10630313,10630594,10630595,10630596,10630597,10630598,10630599,10630600,10630601,10630602,10630603,10630604,10630605,10630606,10630607,10630608,10630609,10630610,10630611,10630612,10630613,10630614,10630615,10630616,10630617,10630618,10630619,10630620,10630621,10630622,10630623,10630624,10630625,10630626,10630627,10630628,10630629,10630630,10630631,10630632,10630633,10630634,10630635,10630636,10630637,10630638,10630639,10630640,10630641,10630642,10630643,10630644,10626291,10626292,10626293,10631925,10626925,10571233,10571234,10571299,10571300,10571301,10571860,10571939,10571940,10566367,10569553,10569571,10566673,10573270,10573271,10567497,10573888,10573889,10573890,10571101,10571102,10523238,10523239,10523240,10523241,10523242,10523243,10523244,10523245,10523254,10521649,10521658,10519881,10519882,10519883,10519884,10519885,10519886,10519887,10519888,10519889,10519890,10519891,10519892,10519893,10519894,10519895,10519896,10519897,10519898,10519899,10519900,10519901,10519902,10519903,10519904,10519905,10519906,10520804,10522890,10525034,10421934,10421986,10423033,10423100,10423111,10423113,10474934,10474935,10474936,10475001,10475002,10475003,10475004,10475005,10475006,10475007,10475008,10475009,10475010,10475011,10475012,10475013,10475014,10475015,10475016,10475017,10475018,10475019,10475020,10475021,10475022,10475023,10475024,10475025,10475026,10475027,10475028,10475029,10475030,10475031,10475032,10475033,10475034,10475035,10475036,10475037,10475038,10475039,10475040,10475041,10475042,10475043,10475044,10475045,10475046,10475047,10475048,10475049,10475050,10475051,10475052,10475053,10475054,10475055,10475056,10475057,10475069,10475070,10475185,10475186,10475187,10475188,10475540,10475541,10475542,10475543,10475544,10475545,10475546,10475547,10475548,10475609,10473926,10473927,10474005,10476160,10476161,10474722,10476784) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'