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(8911539,10943532,10943533,10943534,10943535,10943536,10943537,10943538,10943539,10943540,10943541,10943542,7068080,7068081,7068082,7068083,7068084,7068085,7068086,7068087,7068088,7068089,7068090,7068091,7068092,7068093,7068094,7068095,7068096,7068097,7068098,7068099,7068100,8569402,8569403,8572133,8572134,8572135,8572136,8572137,8572138,8572139,8572140,8572141,8572142,8572143,8572144,8572145,8572146,8572147,8572148,8572149,8572150,8572151,8572152,8572153,8572154,8572155,8572156,8572157,8572158,8572159,8572160,8572161,4970920,10238042,7066806,7066807,8067846,8067847,8067848,8067849,8067910,8067911,8067912,7075256,7075257,7075258,7075259,7075260,7075261,7075262,7075263,7075264,7075265,7075266,7075267,7075268,7075269,7075270,7075271,7075272,8835395,8835396,8835397,8835398,8835399,8835400,10234296,10234297,10234298,10234299,10234300,7064241,7064242,7064243,7064244,7064245,7064246,7064247,7064248,7064249,7064250,7064251,7064252,7064253,7064254,10273528,10273529,10234643,10234644,8564763,8564764,8564765,8564766,8564767,8564768,8564769,8564770,4967461,4967462,4967463,4967464,4967465,4967466,4967467,4967468,4967469,4967470,4967471,4967472,4967473,4967474,4967475,4967476,4967477,4967478,4967479,4967480,4967481,4967482,4967483,4967484,4967485,4967486,4967487,4967488,4967489,4967490,4967491,4967492,4967493,4967494,4967495,4967496,4967497,4967498,4967499,4967500,4967501,4967502,4967503,4967504,8834171,8834172,4967505,4967506,8834173,8834174,4967507,8834175,4967508,8834176,4967509,8834177,8834178,8834179,10209760,10209761,10209762,10209763,10102272,10102273,10102274,10102275,10102276,10102277,10102278,10102279,10102280,10102281,10102282,10246150,8907524,10942921,10942922,10943138,8861389,8861390,10100191,10100192,10100193,10100194,10100195,10100196,10100197,10100198,10100199,10100200,10100201,10100202,10100203,10100204,10100205,10100206,8563779,8563780,8563781,8563782,8563783,8563784,8563785,8563786,8563787,8563788,8563789,8563790,8563791,8563792,10944467,10944468,10944469,10944470,10944471,10944472,8579058,8859524,8859525,10245416,8073457,8860621,8860622,10255162,10255163,10255164,10255165,10255166,10255655,10255656,10281820,8904411,8904412,8070832,8070833,10619353,10254245,10254289,10622197,10280541,10281005,10281006,10620591,10620592,10620593,10620594,10620595,10620596,10620597,10620598,10620599,10620600,10620601,10620602,10620603,10620604,10620605,10620606,10620607,10620608,10620609,10620610,10926121,10620611,10926122,10620612,10926123,10620613,10926124,10620614,10926125,10620615,10926126,10620616,10620617,10926127,10620618,10926128,10620619,10926129,10926130,10620620,10620621,10926131,10926132,10620622,10926133,10620623,10926134,10926135,10926136,10926137,10926138,10926139,10926140,10926141,10926142,10926143,10926144,10926145,8574227,8574228,8574229,10278802,8838582,8838583,8838584,8838585,8838586,8838587,8838588,8838589,8838590,8838591,8838592,8838593,8838594,8838595,10926264,10279109,10431279,10926912,10240537,10240538,10240539,10253877,10188904,10188905,10188906,10188907,10188908,10188909,10188910,10188911,10188912,10188913,10188914,10188915,10188916,10188917,10188918,10188919,10188920,10188921,10188922,10188923,10188924,10188925,10188926,10431857,10431858,10431859,7019074,7019075,7019076,7019077,7019078,7019079,7019080,7019081,7019082,7019083,7019084,7019085,7019086,7019087,7019088,7019089,7019090,7019091,7019092,7019093,7019094,7019095,7019096,7019097,7019098,7019099,7019100,7019101,7019102,7019103,7019104,7019105,7019106,7019107,7019108,7019109,7019110,7019111,7019112,7019113,7019114,7019115,7019116,7019117,7019118,7019119,7019120,7019121,7019122,7019123,7019124,7019125,7019126,7019127,7019128,7019129,7019130,7019131,7019132,7019133,7019134,7019135,7019136,7019137,7019138,7019139,7019140,7019141,7019142,7019143,7019144,7019145,7019146,8864320,9173989,9198029,10612166,10612167,9172342,8863079,8863220,8863221,8863222,8863223,8863224,8863225,8863226,8863227,8863228,8863229,9188968,4974273,9209529,9161684,9161685,9161686,9161687,9193735,9201813,9193848,9170024,7056246,10514178,10514179,10514180,10514181,10514182,2809112,2809113,2809114,2809338,9202922,9202923,8861660,8861661,8861662,8861663,8861664,8861665,8861666,8861667,8861668,8861669,8861670,8861671,8861672,8861673,8861674,8861675,8861676,8861677,8861678,8861679,8861680,8861681,8861682,8861683,10519038,10419581,7054898,7054930,9160838,9160839,9160840,9160841,9160842,9160843,9160844,9160845,9160846,9160847,9160848,9160849,9160850,9160851,9160852,9160853,9160854,9160855,9160856,9160857,9160858,9160859,9160860,9160861,9160862,9160863,9160864,9160865,9160866,9160867,9160868,9160869,9160870,9160871,9160872,9160873,9160874,9160875,9160876,9160877,9160878,9160879,9160880,9160881,9160882,9160883,9160884,9160885,9160886,9160887,9160888,9160889,9160890,9160891,9160892,9160893,9160894,9160895,9160896,9160897,9160898,9160899,9160900,9160901,9160902,9160903,9160904,9160905,10418827,9160906,9160907,9160908,9160909,9160910,9160911,9177072,9177073,9177074,9177075,9177076,9177077,9177078,9177079,9177080,9177081,9209095,9201159,9201207,8864881,8864882,8864883,8864884,8864885,8864886,8864887,8864888,8864889,8864890,8864891,6666611,8916393,8916394,8916395,8916396,8916397,8916398,8916399,4971722,4971723,4971724,4971725,4971726,4971727,4971728,4971729,4971730,4971731,4971732,4971733,4971734,4971735,4971736,4971737,4971738,4971739,4971740,4971741,4971742,4971743,4971744,4971745,4971746,4971747,4971748,9199256,9175256,9175257,9191465,8917155,8917156,8917157,8917158,9207640,9207641,9207642,9207643,9207644,9207645,9207646,9207647,9207648,9207649,9207650,9207651,9207652,9207697,9199776,9175877,9175886,9207915,9191961,9191976,10154484,10154485,10154486,10154487,10154488,10154489,10154490,10154491,10154492,10154493,10154494,10154495,10154496,10154497,10154498,10154499,10154500,10154501,10154502,10154503,10154504,10154505,10154506,10154507,10154508,10154509,10154510,10154511,10154512,10154513,10154514,10154515,10154516,10154517,10154518,10154519,10154520,10154521,10154522,10154523,10154524,10154525,10154526,10154527,10154528,10154529,10154530,10154531,10154532,10154533,10154534,10154535,10154536,10154537,10154538,10154539,10154540,10154541,10154542,10154543,10154544,10154545,10154546,10154547,10154548,10154549,10154550,10154551,10154552,10154553,10154554,10154555,10154556,10154557,10154558,10154559,10154560,10154561,10154562,10154563,10154564,10154565,10154566,10154567,10154568,10154569,10154570,10154571,10154572,10154573,10154574,10154575,10156254,10945641,10945642,10945643,10945644,10945645,10945646,10945647,10945648,10945649,10945650,10945651,10945652,10945653,10945654,10945655,10945656,10945657,10945658,10945659,10945660,10945661,10945662,10945663,10945664,10945665,10945666,10945667,10945668,10945669,10945670,10945671,10945672,10945673,10945674,10945675,10945676,10945677,10945678,10945679,10945680,10945681,10945682,10945683,10945684,10945685,10945686,10945687,10945688,10945689,10945690,10945691,10945692,10945693,10945694,10945695,10945696,10945697,10945698,10945699,10945700,10945701,10945702,10945703,10945704,10945705,10945706,10945707,10945708,10945709,10945710,10154427,10154428,10154429,10154430,10154431,10154432,10154433,10154434,10154435,10154436,10154437,10154438,10154439,10154440,10154441,10154442,10154443,10154444,10154445,10154446,10154447,10154448,10154449,10154450,10154451,10154452,10154453,10154454,10154455,10179455,10154456,10154457,10154458,10154459,10154460,10154461,10154462,10154463,10154464,10154465,10154466,10154467,10154468,10154469,10154470,10154471,10154472,10154473,10154474,10154475,10154476,10154477,10154478,10154479,10154480,10154481,10154482,10154483,10167402,10167403,10167404,10167405,10167406,10167407,10167408,10167409,10167410,10167411,10177569,10177570,10187571,10187572,10187573,10187574,10187575,10187576,10631269,10631270,10631271,10631427,10631658,10631703,10631844,10631845,10631846,10586122,10586123,10586124,10586125,10586126,10583846,10583847,10583848,10583849,10583850,10583851,10583852,10583853,10583854,10566972,10567224,10567225,10567226,10567227,10567228,10567229,10567230,10567231,10567232,10567233,10567234,10567235,10567236,10567237,10567238,10567239,10567240,10567241,10567317,10527913,10527914,10527915,10527916,10520814,10498341,10498485,10421931,10423969,10423970,10423971,10473650,10480085,10480086,10480087,10480088,10480089,10480090,10480091,10478468,10478469,10478470,10478471,10478472,10478473,10478474,10478475,10478476,10478477,10478478,10478479,10478480,10478481,10478482) 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'