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(8630581,8630582,8630583,8630584,8630585,8630586,8630587,8630588,8630589,8630590,8630591,8630592,8630593,8630594,8630595,8630596,8630597,8630598,8630599,8630600,8630601,8630602,8630603,8630604,8630605,8630606,8630607,8630608,8630609,8630610,8630611,8630612,8630613,8630614,8630615,8630616,8630617,8630618,8630619,8630620,8630621,8630622,8630623,8630624,8630625,4970738,8569510,8569511,3228960,3228961,3229077,3229078,3229106,3229107,3229108,3229109,3229110,3229130,3229131,3229171,3229177,3229182,3229285,8583434,8583479,8583480,8583481,8583482,8583483,8583486,8583487,8583488,8583489,8575733,8575734,8575735,8067927,8573316,8573335,8573336,8573337,10447545,10930095,7201203,7201209,7201210,7201253,7201309,7201354,7201366,7201367,7201368,7201377,7201464,7201468,7201477,7201478,7201479,7201483,7201487,7201492,7201514,7201727,7201728,7201729,8911629,7201861,7201890,7201903,7201959,7201974,7201976,7201977,10960474,7202127,7202132,7202133,7202136,7202161,7202165,7202168,7202171,7202196,7202205,7202209,7202210,7202211,7202212,7202213,7202214,7202257,7202285,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,7202347,7202364,7202365,5654588,7202585,7202586,7202683,7202684,7202695,7065457,9794578,9794579,9794580,9794588,9794589,9794592,9794594,3227094,3227186,3227207,3237391,3237392,8616849,7200548,7200607,7200608,8910449,8910450,8910451,10944447,7198381,7198678,7198679,7198680,7198681,7198682,7198683,7198684,7198685,7198687,7198688,7198690,7198694,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198709,7198710,7198711,7198712,7198713,7198714,7198715,7198716,7198717,7198718,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198726,7198727,7198728,7198729,7198730,7198731,7198733,7198736,7198737,7198738,7198739,7198740,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198753,7198754,7198755,7198756,7198757,7198759,7198760,7198762,7198763,7198764,7198765,7198766,7198767,7198768,7198769,7198770,7198772,7198785,7199006,7199508,7199575,10101491,10101492,10101534,7200030,7200087,10618320,10838801,10838803,10838806,3234663,3234664,10838999,3234729,3234730,8907461,8907462,8907463,8907464,8907465,3235067,7197896,7197899,7197900,7197901,7197902,7197903,7197904,7197905,7197906,7197907,7197908,7197909,7197910,7197911,7197912,7197913,3232382,8541521,8541549,10617118,10617126,10617138,10617139,10617140,8905290,8905291,8612185,3232910,3232913,3232914,3232915,8542165,8542254,8569936,10425358,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10951828,10615258,10615339,10615340,10615341,10615342,10615363,10615598,10425937,3231052,10615726,10615727,10615728,10426197,10426204,10615892,10615896,8540418,10616023,8540596,8540612,8540613,8540618,8540619,8540631,8540633,10616210,10616211,10616219,10616220,10616228,10616229,10616243,10616245,10616248,10616252,10616253,10616254,10616258,10616265,10616267,10616268,10616287,10616295,10616298,10616302,10616303,3231701,3231702,10616311,10616323,10616324,10616329,10616332,10616333,10616341,10616342,10616348,10616350,10616351,10616353,10616370,10616375,10616387,10616389,10616393,10616394,10616395,10616397,10616400,10616401,10616404,10616407,10616410,10616411,10616412,10616416,10616417,10616423,10616426,10616430,10616431,10616440,10616441,10616443,10616453,10616454,10616459,10616475,10616476,10616479,8611390,10616644,10616648,10616649,10616888,10616955,10613971,10614048,10614054,10614057,10565319,10614220,10611362,10611365,10611375,10614376,10611376,10611377,10611378,10611380,10611381,10611382,10611383,10611390,10611391,10611392,10611393,10611394,10611396,10611398,10611399,10611400,10611404,10611406,10611407,10611408,10611409,10611411,10611412,10611413,10611414,10611416,10611417,10611422,10611423,10611426,10611427,10611428,10611431,10611432,10611434,10611435,10611436,10611437,10611440,10611441,10611442,10611443,10611444,10611445,10611449,10611450,10611451,10611452,10611455,10611456,10611457,10611459,10611461,10611462,10611463,10611464,10611466,10611467,10611469,10611470,10611472,10611473,10611476,10611477,10611479,10611480,10611482,10611483,10611485,10611486,10611491,10611492,10611493,10611495,10611496,10611498,10611499,10611500,10611505,10611507,10611509,10611514,10611517,10611519,10611520,10611521,10611522,10611523,10611525,10611526,10611527,10611528,10611530,10611532,10611536,10611537,10611538,10611539,10611542,10611543,10611544,10611546,10614547,10611549,10611550,10611551,10611552,10611554,10611555,10611560,10611563,10611564,10611567,10611568,10611569,10611570,10611571,10611572,10611573,10611574,10611577,10611578,10611579,10611580,10611581,10611582,10611583,10611584,10611585,10611586,10611587,10611588,10611589,10611590,10611594,10611596,10611597,10611598,10611600,10611603,10611604,10611605,10611608,10611611,10611612,10611613,10611615,10611617,10611618,10611619,10611620,10611621,10611623,10611624,10611635,10611636,10611637,10611638,10611640,10611641,10611643,10611646,10611647,10611648,10611649,10611655,10611658,10611659,10611660,10611665,10611666,10611676,10611731,10611758,10611778,10611782,10611812,10611856,6666259,8549450,10612059,10612060,10612191,10612192,10612194,10612201,10609285,10609355,8862558,7058247,7058248,7058249,7058250,7058251,10612916,10609971,10613024,10613025,10613026,9172407,10613133,10613235,10613334,10613337,10613341,10613342,10613513,10613514,10613527,10613531,10610666,10613732,10613733,10613797,10613858,10613859,10613860,10610901,9169318,9169319,6673534,6673535,6673536,6673537,6673538,6673540,6673541,6673542,6673543,6673544,6673545,6673546,6673548,6673549,6673550,6673563,7055541,7055546,9169428,10117634,10117645,10117646,9169453,10515280,10117664,10515281,10515282,6673685,6673686,6673688,6673689,6673690,6673692,6673694,6673696,6673697,6673698,6673699,7055672,7055674,7055722,9169586,10117799,10117806,10117807,10117809,10117817,10117818,10117819,9169638,10117904,9169748,10515609,10515610,10515611,10515612,10515613,10517681,9169903,6674175,6674186,10118177,10118234,6674247,6674248,6674249,6674256,6674276,6674278,6674280,6674281,6674285,6674286,10118374,10118375,10118391,10118392,10516160,10516161,10516162,10516163,10516171,10516172,10516173,10516174,10516175,10516176,9178427,9178490,9178492,10512852,9168305,9168306,9168307,6672514,9168309,6672515,6672592,10419370,9168453,6672683,6672725,6672802,10419538,10415597,10415598,10415599,10415600,10415601,6672896,6672897,6672898,6672899,6672900,6672901,9168774,9168775,9168804,6673067,10418795,10418796,10418797,10418798,10418799,10418800,10418801,10418802,10418803,10418804,10418805,10418806,10418807,10418808,10418809,10418810,10418811,10418812,10418813,10418814,10418815,6673100,10418816,10418817,10418818,10418819,10418820,6673105,10418821,10418822,10418823,10418824,10418825,10418826,10418827,10418828,10418829,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,6673122,10418838,6673123,10418839,6673124,10418840,6673125,10418841,6673126,10418842,6673127,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418855,6673140,10418856,6673141,10418857,10418858,10418859,10418860,10418861,10418862,10418863,9161147,6670727,10123006,8550007,8550008,8550015,8550188,8916794,10469949,10469950,4972257,10470089,9167554,6671809,6671903,6671917,9167779,9167782,10470721,10470722,9168281,9168290,9168293,10888524,10888552,10888553,10893983,10893984,10893985,10893986,10893987,10893988,10889019,10889020,10889021,10889226,10889449,10884483,10884486,10884493,10884513,10884596,10884652,10884653,10884950,10874953,10874954,10889997,10890007,10890008,10890048,10885074,10890163,10885165,10885166,10885167,10880304,10880305,10880306,10880307,10880325,10880326,10885465,10885468,10885469,10632012,10632107,7000826,10627319,10888381,10888382,10883408,10883409,10883415,10883421,10161843,10886057,10886058,10886059,10886060,10162091,10949057,10881561,10881562,10881566,10881567,10881568,10881573,10881574,10891654,10891655,10626299,10626300,10626301,10886818,10886878,10167916,10886910,10167934,10167992,10168012,10882007,10882008,10882009,10882010,10887052,10887096,10887097,10877181,10887250,10882284,10882356,10882357,10882358,10882359,10643489,10643490,10643504,10598535,10598679,10598867,10644403,10648050,10648051,10585350,10579475,10579478,10579479,10582561,10545324,10529398,10529399,10521871,10521872,10521873,10544310,10528350,10543041,10543042,10498367,10421498,10498499,10407369,10407370,10408988,10409025) 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'