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(8628171,8628626,8628724,8628725,10859478,10859479,10859481,10859482,10859483,10859491,10859492,10859493,10859498,8629166,7202769,8629188,8629393,8629396,8629472,10860386,8629756,8629838,8629858,8629859,8629917,8629932,8629934,8629942,8629945,8629950,8629953,10870719,8627109,8627121,8627314,8627316,8627318,8627319,8627320,10102876,10871050,8627574,8627575,8627576,8627577,8627578,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627625,8627626,8627627,8627628,8627629,8627630,8627631,8627632,8627633,8627634,8627708,8627711,8627713,7201432,10843100,8908494,7198683,7198685,7198696,7198697,7198699,7198710,7198711,7198714,7198716,7198724,7198730,7198742,7198743,7198749,7198750,7198760,7198762,7198770,7198772,8625575,8625576,3236570,8626234,8626248,8626253,8626319,8626320,8626321,8626322,8626328,8626329,8626330,8626331,8626332,8626333,8626334,8626335,8626336,8626337,8626338,8626339,8626340,8626341,8626342,8626343,8626344,8626345,8626346,8626347,8626348,8626349,8626812,8626892,8626893,8626894,8626895,8626896,8626897,8626898,8626899,8626900,8626901,7200527,7200528,7197805,3925016,10855037,8624417,8624524,8624525,8624683,8624684,8624750,8624754,10233976,10852643,8071685,8071693,8071699,8071700,8071701,8541920,8071750,10231136,8071758,8071764,8071765,8071766,10231194,10231195,8071815,10231205,8071824,8071829,8071830,8071831,8071880,8071888,8071894,8071895,8071896,8071945,8071953,8071959,8071960,8071961,8072010,8072018,8072024,8072025,8072026,8542252,8072075,8072083,8072089,8072090,8072091,8072140,8072148,8072154,8072155,8072156,10231547,10231548,8542364,8542371,8072205,8072213,8072219,8072220,8072221,8072270,10853232,10853233,8072278,8072284,8072285,8072286,10866538,10866575,10866576,10866577,10866578,4937290,4937298,4937305,4937306,4937307,4937359,4937367,7196890,4937373,4937374,4937375,4937424,4937432,4937438,4937439,4937440,4937489,4937497,4937503,4937504,4937505,8554746,4937554,4937563,4937568,4937569,4937570,4937619,4937627,4937633,4937634,4937635,4937684,4937692,4937698,4937699,4937700,4937749,4937757,4937763,4937764,4937765,4937814,4937822,4937828,4937829,4937830,3234554,4937879,4937887,4937893,4937894,4937895,4937944,4937952,4937958,4937959,4937960,4938009,4938017,4938023,4938024,4938025,3234740,3234741,3234742,3234743,3234744,10850648,10850650,3581902,8633200,8633272,8633273,8633274,8633275,8633276,8633277,10229584,10229585,10229605,10229606,10229616,8633570,8540530,8540543,8540569,8540589,8540591,8540592,8633949,10230093,10230094,10230096,8634131,8634132,8634133,8634134,8634135,8634136,8634137,8634138,8634139,8634147,8634148,8634149,8634151,10851969,8634541,8634545,8634615,8634616,8634617,8634688,8634689,8634690,8634691,8634692,8634693,8071552,8071560,8071567,8071568,8071569,8071620,8071628,10865591,8071634,8071635,8071636,10865634,10865635,10459923,10459924,10459925,10459958,10459962,10459965,10459966,10459967,10459998,10460002,10460005,10460006,10460007,10460038,10460042,10460045,10460046,10460047,10460078,10460083,10460085,10460086,10460087,10460118,10460122,10460125,10460126,10460127,10460158,10460162,10460165,10460166,10460167,9216252,9216253,10460198,10460202,10460205,10460206,10460207,10460238,10460242,10460245,10460246,10460247,10460278,10460282,10617323,10617324,10460285,10460286,10460287,3230165,10460318,10460322,10460325,10460326,10460327,3230183,10617378,10460358,10460362,10460365,10617405,10460366,10460367,10617426,10617427,10617456,8632628,8632632,10425553,10848007,8632908,8632909,8632910,8630235,10620208,8630640,8630642,8630647,8630653,10861435,8630913,8630914,8630917,8630919,10616059,10616417,10431549,8631678,10849376,10849377,10849378,10849379,10849380,10849381,10849382,10849383,10849384,10849385,10849386,10849387,8631859,10459916,10459920,10614857,9211556,9211557,9211567,8067286,8067368,8067369,9212319,9212320,9212463,9172545,9188685,10613369,6677250,8567664,8567683,8567686,8567688,10117516,10117517,8849322,8849378,9185614,9911858,9185838,9185839,9185840,9161881,9912425,9912437,9912438,9912966,9186799,9186801,9913359,9913361,10419468,10419494,8848719,8848725,8848726,8848728,8848730,10418822,8848741,8848744,8848746,8848747,8848767,8848866,9193119,9193120,9193121,8847268,8847310,8847476,8847478,8847480,8847496,8847514,9168121,8847998,8848002,8848003,8848006,8848014,8848018,8848036,8848037,10883624,10890141,10890144,10890148,10883045,10630026,10630029,10630030,10630033,10630034,10630039,10630040,10630043,10630044,10630045,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630055,10630056,10630057,10630058,10630059,10630060,10630061,10630062,10630063,10630064,10630065,10630066,10630067,10630093,10881537,10881538,10626236,10602171,10602176,10602179,10602182,10602191,10583441,10598575,10598576,10602704,10602705,10602724,10602725,10590279,10590300,10603696,10591756,10591800,10601686,10601688,10601693,10601695,10601697,10601702,10529399,10541445,10549588,10549589,10528164,10522352,10422354,10415371,10422596,10422597,10422598,8562439,10407925,10413934,10413935,10413937,10413938,10413939,10413947,10413948,10413949,10413950,10413955,10410251,10414686,10414688,10497381,10497382,10497387,10497393,10497403,10497406,10406982,10406983,10406984,10406985,10406986,10406987,10406988,10406989,10406990,10406991,10406992,10406993) 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'