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(10861894,10861895,10861896,10861897,10861898,10861899,10861900,10861901,10861902,10861903,10861904,10861905,10861906,10861907,10861908,10861909,10861910,10861911,10861912,10861913,10861914,10861915,10861916,10861917,10861918,10861919,10861920,10862001,10862002,10862003,10862004,10862005,10862006,10862007,10862008,10862009,10862010,10862011,10862012,10862013,10862014,3229207,8631598,8583528,7066208,10862821,10862822,10862824,10862835,3229967,8629792,8629795,8629800,10860628,10860629,10860635,10860636,10860637,10860642,10860643,10860699,10860709,10860710,8630268,8630430,10939423,7201197,10866428,10866503,10866504,10866505,10866583,10866589,10866590,10866593,10866594,10866598,10866599,10866600,10866603,10866605,10866607,10866609,7201643,10866746,10866747,10866748,10866749,10866750,10866751,10866752,10866753,10866754,10866755,10866756,10866757,10866758,10866759,10866760,10866761,10866766,10866767,10866768,10866769,10866770,10866771,10866772,10866774,10866775,10866776,10866777,10866778,10866779,10866783,10866784,8595175,8595203,10866968,10866969,10866970,10866971,10866972,10866973,10866974,10866975,7201965,8628604,10867258,10867259,10867260,10867261,10867262,10867263,10867264,10867265,10867266,10867267,10867268,10867269,10867270,10867271,10867272,10867466,10867467,10867468,10867469,10867470,10867471,10867472,10867473,10867474,10867475,10867476,10867477,10867478,10867479,7202524,5654633,7202613,7202751,8629340,8629341,7200383,7200384,7200385,7200405,8834761,10959088,7200766,7200767,7200768,7200769,7200770,7200771,7200772,7200773,10865853,10865957,10863248,7198718,7198724,7198725,7198726,7198727,7198728,7198729,8909072,7199269,7199270,7199271,10856315,7199290,7199291,7199292,7199293,7199294,7199295,7199296,7199297,7199298,10101546,11048488,8626406,7200137,8906538,7196890,7196891,7196892,7197027,7197028,7197068,10838781,10838884,3235068,8624547,8624548,8624549,7198180,8905729,8905879,8905895,10615169,10615248,10426317,10426378,10426379,10426380,8611394,8611406,8611407,8611408,8611409,8611410,8611411,8611412,8611413,8611414,8611455,8611456,8611457,10616787,10616788,10611239,10611240,10611241,10614518,10614555,10614619,10614620,10614621,10614622,10614623,10614624,10614625,10614626,10614627,10614628,10614629,10614630,10614631,10614726,10614727,10614728,10614729,10614730,10614731,10611823,10612053,10612320,10612321,10612407,8566311,8851869,10612772,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,10612809,10612811,10612812,10612813,10612815,10612816,10612817,10609820,10612869,10612952,8852249,10613349,7014953,7014954,7014955,7014956,7014957,7014958,7014959,9169324,9169325,9169344,9169345,9169346,9169347,9169348,9169349,9169350,9169351,9169352,9169401,10117848,990142,990143,990144,990162,10118250,10118264,10118265,10118266,10118267,10118268,10118269,9912826,9912827,9912828,9912829,9912830,9912831,9912832,9912833,9912843,9912844,9912845,9913153,9168357,10416383,10416385,10416398,10419407,10419408,10419446,10419447,10419448,10419449,10419472,10419475,10419476,10419478,10419479,10419482,10419483,10419484,10419486,10419488,10419490,10419492,10419602,10419603,10419604,10419605,10419606,10419607,10419608,10419609,10419610,10419611,10419612,10419613,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10419631,10419632,10419633,10419634,10419635,10419636,10419641,10419642,10419643,10419644,10419645,10415717,10415718,10415719,10415720,10415721,10415722,10415723,10415724,10415725,9168817,10416779,10415782,10415783,10415784,10415785,10415786,10415787,10415788,10419023,10419024,10420084,10420085,10420086,10420087,10420088,10420089,10420090,10420091,10420092,10420093,10420094,10420095,10420096,10420097,10420098,10117433,7014905,7014906,7014907,7014908,7014909,7014910,7014911,7014912,7014913,7014914,7014915,7014916,7014917,7014918,7014919,7014920,7014921,7014922,7014923,7014924,7014925,7014926,7014927,7014928,7014929,7014930,7014931,7014932,7014933,7014934,7014935,7014936,7014937,7014938,7014939,7014940,7014941,7014942,7014943,7014944,7014945,7014946,7014947,7014948,7014949,7014950,7014951,7014952,10469656,10469657,10469658,10469659,10469668,10469669,10469670,10469671,10469672,10469673,10469674,10469675,10469676,10469677,8855352,976551,9168190,9168191,10888826,10888827,10884335,10889646,10889647,10884786,10885075,10875092,10890205,10890206,10880248,10880249,10885254,10885308,10877579,10887580,10887581,10887582,10887583,10887584,10887585,10887586,10887587,10887588,10887589,10887590,10887591,10887592,10887593,10887594,10887595,10887596,10887597,10887598,10887599,10887600,10887601,10887602,10887603,10887604,10887654,10887655,10887656,10887657,10887658,10887659,10887660,10887661,10887662,10887663,10887664,10887665,10887666,10882883,10887922,10888323,10888324,10885676,10885815,10625364,10631455,10631456,10882295,10647613,10647661,10647662,10603653,10603654,10603655,10603658,10420252,10420253,10420254,10420255,10420256,10420257,10420258,10420259,10420260,10420261,10420262,10420263,10420264,10420265,10420266,10420267,10420268,10420455,10508349,10425085,10425086,10425087,10414870,10414871,10414877,10414878,10414879,10414880,10414885,10414886,10414936,10414942,10414943,10414944) 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'