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(8068859,10448231,10448232,10448233,10448234,8067416,10437504,10437505,10437506,10437507,10437508,10437509,10437510,10437511,10437512,10437513,10872214,10872215,10845353,10930176,8558990,8558991,8558992,8558993,8558994,8558995,8558996,10103696,10103697,10103698,10103699,10103700,10103701,10103702,10103703,10103704,10960400,10986449,10986450,8618744,8618745,8618746,8618747,10932705,10932706,10932707,10932708,10932709,10932710,8836940,6665061,6665062,6665065,6665066,6665067,6665068,7073591,7073592,7073593,7073594,7073595,6665109,6665110,6665113,6665114,6665115,6665116,10099914,10099954,10942606,10842349,3235395,3235396,3235397,3235398,3235399,3235400,3235401,3235402,3235403,3235404,3235405,3235406,3235407,3235408,3235409,3235410,3235411,3235412,3235413,3235414,3235415,3235416,3235417,3235418,3235419,3235420,3655874,3655875,3655876,3655877,10944776,10944777,10944778,8564863,3926818,3926819,3926820,8073182,8073183,8073184,8073185,8073186,8073187,8073188,8073189,8073190,8565165,8073191,8073192,8073193,8073194,8073195,8073196,8073197,8073198,8073199,8073200,8073201,8073202,8073203,8073204,8073205,8073206,8073207,8073208,8073209,8073210,8073211,8073212,8073213,8073214,8073215,11010351,11010352,11010353,11010354,11010355,11010356,11010357,11010358,11010359,11010360,7156503,7156504,7156505,7156506,7156507,7156508,7156509,7156510,7156511,7156512,7156513,7156514,3235349,7155551,7155563,8576347,8576348,8576349,8576350,8576351,8576352,8576353,8576354,8576357,8576358,8576359,8576360,8576361,8576362,8576363,8576364,8576365,8576366,10952148,10952149,10952150,10952151,3582185,9915664,9915665,8864544,8864545,8568558,8568559,8568560,8568561,8568562,8568563,8568564,8568565,8568566,8568567,8568568,8568569,8568570,8568571,8568572,8568573,8568574,8568575,8568576,8568577,7057858,7057859,7057860,7058458,7058459,7058460,7058461,7058462,7058463,9220476,10564885,10564886,10564887,10564888,10564889,10564890,10564891,10564892,10564893,10564894,10564895,10564896,10564897,10564898,10564899,10564900,10564901,10564902,10564903,10564904,10564905,10564906,10564907,10564908,10564909,10564910,10564911,10564912,10564913,10564914,10564915,10564916,10564917,10564918,10564919,10564920,10564921,10564922,10564923,10564924,10564925,10564926,10564927,10564928,10564929,10564930,10564931,10564932,10564933,10564934,10564935,10564936,10564937,10564938,10564939,10564940,10564941,10564942,10564943,10660212,10660213,10660214,10660215,10660216,10660217,10660218,3285890,3285891,3285892,3285893,3285894,3285895,4973957,4973958,4973959,4973960,4973961,4973962,9198648,9198649,9198650,9198651,9198652,9198653,9198654,9198655,9198656,9198657,9198658,9198659,9198660,9198661,9198662,9198663,9198664,9198665,9198666,9198667,9198668,9198669,9198670,9198671,9198672,9198673,9198674,9198675,9198676,9198677,9198678,9198679,9198680,9198681,9198682,9198683,9198684,9198685,9198686,9198687,9198688,9198689,9198690,9198691,9198692,9198693,9198694,9198695,9198696,9198697,6679258,6679259,6679260,6679261,6679262,6679263,6679264,8550742,8550866,8550867,8917670,10628754,10628755,10628756,10628757,10628758,10628759,10628760,10628761,10628762,10628763,10628764,10628765,10628766,8594369,8594370,8594371,10176068,10176069,10176070,10176071,10176072,10176073,10176074,10176075,10176076,10176077,10176078,10176079,10176080,10176081,10176082,10176083,10176084,10176085,10176086,10176087,10176088,10176089,10176090,10176091,10176092,10176093,10176094,10176095,10176096,10176097,10176098,10176099,10176100,10176101,10176102,10176103,10176104,10176105,10176106,10176107,10176108,10176109,10176110,10176111,10176112,10176113,10176114,10176115,10176116,10176117,10176118,10176119,10176120,10176121,10176122,10176123,10176124,10176125,10176126,10176127,10176128,10176129,10176130,10176131,10176132,10176133,10176134,10176135,10176136,10176137,10176138,10176139,10176140,10176141,10176142,10176143,10176144,10176145,10176146,10176147,10176148,10176149,10176150,10176151,10176152,10176153,10176154,10176155,10176156,10176157,10176158,10176159,10176160,10176161,10171175,10171176,10900686,10911715,10911716,10911717,10911718,10911719,10911720,10911721,10911722,10911723,10911724,10911725,10911726,10911727,10911728,10911729,10911730,10911731,10911732,10911733,10911734,10911735,10911736,10911737,10911738,10911739,10652594,10652595,10652596,10423394,10423395,10483112,10483113,10483114,10483115,10483116,10490214,10490215,10490216,10477469,10477508,10473551,10473552,10473553,10473554,10473555,10473556,10473557,10473558,10473559,10473560,10473561,10473562,10473563,10473564,10473565,8563108,10714991) 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'