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(8574125,8574135,8574136,8574179,10962687,10962688,10962689,10848614,10848615,10848616,10848617,10848695,10848696,10848697,10848698,7068662,7068714,10940347,8569737,8574998,10940512,8575138,8066942,8066943,8575158,8583522,8575258,10868621,10868651,10868663,10868851,10868868,10868874,8584061,8584062,8584063,10868881,10868885,10868889,8560910,10961902,10929569,10929584,10929585,7067656,8573928,8573929,8573942,8573943,8573944,8573981,8574004,8574005,7067882,7067885,10972785,10972786,10972930,8835756,8835757,8835768,8835772,8835789,8835790,8835796,8835823,8835837,8835838,8835839,8835842,8835843,8835853,8835866,10986127,3899267,10843599,10843870,8066139,5654580,10844115,7073512,8066583,8066682,8066683,8066755,8066797,10102103,10102148,10102194,10102527,10102531,11037152,11037169,10842549,10866192,8555895,8555896,8908063,8908128,8908129,8908130,8908131,8908132,8908133,8908134,8908182,10969845,10969846,10969847,10969848,10969849,10969850,10969851,10969852,10969853,10969854,10969855,7069237,7069247,7069283,7069310,8556300,10970104,10970136,10970137,10970138,10970139,10970140,10970141,10970142,11035153,11035180,11035181,11035182,11035199,8625176,10864047,10864048,10970491,10970566,10970567,10970568,10970569,10970570,10970571,10970915,10970916,10970917,10841005,10970998,10971005,10101776,11036378,11036379,11010491,11032844,10618364,10618366,11007122,11033166,11033167,11033168,11033169,11033170,11033171,11033172,11033173,11033353,11033354,11033355,11033356,11033357,11033358,11033359,11033360,8554706,10968633,8613809,8613813,8613822,8613823,8613824,3924483,8613972,8614001,8614033,8614068,8907606,10624726,10624727,10624728,10855063,10855064,10855065,10624896,10622023,10622082,10622091,10622092,7155658,7155712,7155726,8612026,7155740,8541738,8541740,8541741,8541742,11006455,10620398,9217030,10850696,10850697,10930738,11043496,8904217,10616204,8904341,8904342,10621463,8577720,10621629,8541186,8541187,10621731,11005496,11005497,11005498,11005499,11005500,8853193,8853215,8853447,8853505,8853506,8853536,8853537,8853538,8853539,8853561,8853562,10122097,10611863,6678478,6678479,6678480,6678481,6678482,6678483,6678484,6678485,6678486,6678487,6678488,9913798,9913799,9913800,9913807,10119839,9913937,9913994,6676047,6676048,9914066,6676121,6676138,6676162,9914273,9914277,9914278,9914279,10120296,10120297,10612883,9172469,9172495,9172496,9172497,10120705,10120706,10120734,10120735,9914752,9914753,9914754,9914755,9914774,9914775,9914776,10610237,8863116,8567110,8863151,8863156,10121237,8863590,8863607,10564992,10564993,8863715,9185483,8849321,8849322,8592849,9161781,10515781,10515782,10515783,10515922,10515923,10515924,10515925,10515926,10515927,10515928,10515929,10515930,10515931,10515932,10515933,10515934,10515935,10515936,10515937,10515938,10515939,10515940,10515941,10515942,10515943,10515944,10515945,10515946,10515947,10515948,10515949,9912411,8850112,8850113,8850384,8850484,8850485,8850499,10118952,10118954,2809389,8850617,6675082,10512726,10512727,8552296,6675452,6675453,6675454,6675455,6675456,6675457,10419303,10427849,10427855,10427885,10417437,10417438,6672888,9176743,8848765,8848766,8848767,8848768,9169196,4971526,10469490,8550454,8550470,4972217,4972218,10467962,4972248,8847278,8855328,976357,4972448,4972472,4972474,10468204,10468205,8847495,8847496,8847497,10462308,10462309,10462310,10462311,9183803,9183804,976091,976128,8848036,8848037,8848038,8848039,8848040,9168294,10903500,10903501,10903502,10903503,8593576,10883593,10883628,10883661,10164857,10164858,10164859,10164931,10884039,10884042,10884054,10884065,8594147,10170237,10170238,10170239,10170240,10170311,10170345,10165380,10165381,10165382,10170413,10170414,10165449,10165450,10165451,10165452,10165453,10165454,10165455,10165456,10170474,10899474,10899475,10899476,10899477,10170504,10170505,10170506,10170507,10899495,10170508,10899522,10899523,10899524,10899525,10170540,10894544,10894545,10170557,10899548,10899566,10899567,10899580,10170593,10899581,10170594,10899582,10899583,10170595,10170596,10899584,10899601,10899602,10899614,10899623,10899625,10899626,10899627,10899630,10899632,10170645,10170646,10899643,10170658,10899659,10899660,10894699,10894703,10894756,10899766,10899863,10899864,10165910,10165954,10166047,10166048,10166049,10166050,10171087,7000923,7000968,7000972,10168811,10897885,10897886,10897949,10897975,10897976,10898064,10898103,10898158,10169395,10898437,10898459,10166692,10166693,10166694,10166695,10166696,10166877,10166883,10166947,10166950,10167171,10167187,10167188,10167189,10162253,10167260,10949106,10949121,10949122,10949123,10167352,10162602,10162603,10162631,10162632,10162633,10162634,10162635,10162636,10162637,10162733,10949533,10162738,10162748,10162803,10162816,10162819,10911822,10911835,10887097,10626711,10887225,10887234,10649314,10649335,10602168,10602176,10602177,10649395,10649396,10649397,10649900,10602730,10649956,10647982,10652135,10523639,10523640,10545802,10523829,10523830,10523831,10523832,10523833,10523834,10523835,10523836,10523837,10523838,10523839,10524386,10524410,10524411,10524525,10524526,10524527,10524528,10524549,10524550,10524551,10524552,10524553,10524554,10524618,10524676,10524688,10524717,10421114,10421131,10421141,10421214,10480983,10480984,10483988,10484131,10483138,10481151,10481152,10481153,10481154,10481155,10481156,10481157,10479163,10479164,10483181,10409627,10409628,10481378,10481379,10481380,10481381,10481382,10481383,10481384,10481385,10481386,10481387,10481388,10481389,10481466,10481514,10481543,10481544,10481545,10481595,10481596,10481597,10481598,10481599,10407956,10407957,10496749,10496750,10496751,10496752,10481872,10481873,10481902,10481903,10481913,10496982,10481982,10479993,10496997,10497036,10478043,10497050,10480265,10480266,10480315,10480316,10480317,10480386,10480387,10480388,10480389,10480431,10406884,10406885,10406962,10406963,10406964,10406965) 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'