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(10845667,3228340,7067933,10943463,10943464,10943544,11040726,11040727,11040728,11040729,11040730,7068046,11040731,11040732,11040733,11040734,3228465,11040735,11040736,11040737,11040738,11040739,10447931,11040740,11040741,11040742,10943570,11040743,11040744,11040745,10930349,8620913,10943606,8620981,7076177,7068213,3228683,10448154,3228705,3228708,9214959,3228726,3228739,3228794,8621268,8621269,8621270,8621271,8621272,8621273,10448344,8631123,8631124,8839019,10944073,8631208,8631209,8631210,10873853,10873854,10873855,3228985,10870879,10873883,10873884,8839111,3229044,10944163,10849033,11015505,11015506,3229239,10933282,10846598,3229330,10950554,8583399,10933368,3229347,3229360,3229435,10871312,8575207,10950666,10849335,3229496,10846909,10846910,10846911,10846912,10846913,10950909,10950910,9215993,7066363,7074395,8622271,8583962,11029205,10990249,10990250,10990251,10847399,8067734,10990354,10437691,10437692,10437693,10437694,10951408,8560763,8560764,8560765,8619666,8629508,8629513,8619705,11026669,11026670,10929304,10929309,7075078,10929479,10929497,3227651,7075402,8630069,8630070,10860713,8630071,7075429,3227875,8630129,10845344,8630248,7067655,10845471,8630402,8630403,7071822,8835494,3238458,10842953,7072347,10986125,8628239,10932080,8911718,10960382,7064777,8628454,8065980,8066010,8628598,7064956,3899594,8572299,8560149,8628857,8628858,8628859,8628860,8628899,8628900,8628901,8628902,8628903,8628904,8628905,8628906,8628907,8628908,8628909,8628910,8628911,8628912,8628913,7202521,7202522,8628926,8628927,8628928,8628929,8628930,8628931,8628943,8628944,8628945,8628946,8628947,8628948,7202576,8628980,8628981,8628982,8628983,8628984,8628985,8628986,8628987,8628988,5654677,8628989,8628990,8628991,8629004,8629014,8629015,8560321,8560322,8629025,8629026,8629027,8629028,8629029,8629030,8629031,8629032,8629033,8629034,8629039,8629040,8629041,8629042,8629043,8629052,8629053,8629054,8629055,8629056,8629057,8629058,8629059,8629060,8629061,7065530,10844344,10928864,10859942,10859968,10859991,3227163,7073806,8560753,8560754,8560755,11010517,11010518,11010519,10984531,10984532,10984533,10857214,3237369,3927430,3927438,10865366,10997843,10841946,8834709,10842000,8626905,10857601,10865632,8558322,10842170,10842182,8834993,8910585,10842398,10866033,10842566,8555786,8555791,8555798,8624521,8624549,10839681,8563704,10944526,8555968,10944540,10944583,8614933,3235532,10944625,10839912,10839913,8564023,7069343,10944907,10944913,10944915,10944919,10944928,10944972,10944973,10840221,8564314,10863924,7069699,10941490,8615619,7069817,3236252,7069838,8615754,8615756,8564651,8556939,3236423,3236531,8564834,8564835,8557115,10856487,7070279,7070295,7070297,7070344,7070346,7070415,10856740,10856742,3923298,10853495,3233687,3923675,10968019,10968020,10968021,10919182,3924133,8613621,8613645,8613665,8554782,7157416,3924292,10838700,10619177,8555007,11007754,8555024,8555025,10838854,8614084,3924727,3234825,8614500,3925077,8555758,10927489,10927490,11018555,11018556,11018557,11018558,11018559,11018560,11018561,11018562,11018563,11018564,11018565,3232325,8611748,11005713,11044992,10837216,8578654,10837320,8542154,11019378,11019379,8553668,10920512,10920513,10847642,8632543,10620092,10620093,10620094,9216606,10925712,8632771,8632772,10850486,10850487,10615363,8570365,3230814,10850823,11004254,10952250,9217335,10930651,10848528,8633585,10991740,10426528,10916988,10916989,10916990,10916991,10916992,8611268,10966312,8634312,8611546,8611569,10616880,7059494,9173477,10565303,6677717,9165572,10611359,9916034,8853658,9181886,6678178,9166234,9166247,9190250,6666253,9182255,6678475,8542586,7057637,9179477,8862013,10119701,8862053,7057718,8862153,8862221,8862253,8862379,9195890,9163977,8851882,8862680,7058464,7058465,9204376,10613117,10120773,10610334,8852520,8852521,9204754,9204755,8863355,8863525,8863557,9165148,9165151,9165175,8853050,9177392,10513291,9209481,9209484,9185739,4974599,4974784,4974942,4974943,4974944,4974945,7056497,9186358,9186359,9186360,3286021,3286044,9178430,6674673,9202664,9170669,9178895,9170919,9913288,9913291,9913292,9179139,8861745,8861746,8917982,10427972,9160598,10428003,9200662,9160663,9184666,7014388,7014389,8848625,9208858,10418862,9184955,9177055,10125270,10125271,10125272,10125273,10117417,9161223,10428616,10419192,9916529,8864851,8864937,9166541,9166641,8865165,8569169,8569170,8569171,9166702,9206986,9207002,9199002,9207003,9199003,9207004,9199004,9199005,8854894,6473431,9199154,9199172,9191282,8550465,9167346,10467978,9175409,8563437,9199608,6473919,9175658,9175715,6667834,6474158,9175859,8551089,9200022,9200060,9184067,9200129,8551295,8551296,9176143,9200143,9176144,9200152,9200210,10427601,10179632,10908644,10154937,10159953,10894667,10874923,10910017,10905313,10905314,10166388,10166389,10173585,10183884,7001366,10883201,10179375,10627917,10176631,10187341,10187342,10187343,10187344,10187345,10881486,10881487,10631143,10631144,10631145,10631146,10187906,10187907,10177931,10882368,10571223,10571224,10571364,10571365,10569270,10569271,10569272,10569273,10590540,10569674,10653904,10582221,10582222,10582223,10582224,10585342,10585343,10585344,10585345,10585346,10585347,10585348,10588357,10588358,10588359,10588360,10588361,10588362,10588363,10588364,10648470,10582452,10601675,10585889,10571008,10571009,10543475,10543485,10543487,10543488,10543614,10543669,10543673,10543674,10543780,10543844,10546724,10546725,10546726,10546727,10546728,10546729,10546730,10546731,10546732,10546733,10546734,10546735,10546736,10546737,10546738,10546739,10546740,10546741,10546742,10546743,10546744,10546745,10546746,10546747,10546748,10546749,10546750,10546751,10546752,10546753,10546754,10546755,10546756,10538891,10538892,10538893,10538894,10538895,10538896,10538919,10525009,10525010,10424480,10424481,10424482,10424511,10424512,10422516,10422795,8562211,8562487,10411525,10409631,10411656,10411659,10407809,10412015,10412228,10474003,10414351,10414364,10414387,10495592,10414947) 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'