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(4970650,10929234,8573222,8573223,8573224,8573225,8573226,10861089,7201590,7201591,7201592,8594990,7201596,7201600,10858786,10865177,10865182,7200753,7200756,7200762,7200765,7200770,7200771,7200772,7200777,8910591,7200780,7200782,7200783,10863498,10863505,10101400,10101401,10101402,3923364,10853361,10853362,10853363,8904873,8904874,8904875,8904876,8904877,8904878,8904879,8904880,8904881,8904882,8904883,8904884,8904885,8904886,8904887,8904888,8904889,8904890,8904891,8904892,8904893,8904894,8904895,8904896,8904897,8904898,8904899,8904900,8904901,8904902,10852185,10852569,8611238,8904863,8904864,8904865,8904866,8904867,8904868,8904869,8904870,8904871,8904872,10714106,10714107,10714108,10608962,10608963,10608964,10608965,10608966,10608967,10608968,10608969,10608970,10608971,10608972,10608973,10608974,10608975,10608976,10608977,10608978,10608979,10608980,10608981,10608982,10608983,10608984,10608985,10608986,10608987,10608988,10608989,10608990,10608991,10608992,10608993,10608994,10608995,10608996,10608997,10608998,10608999,10609000,10609001,10609002,10609003,10609004,10609005,10609006,10609007,10609008,10609009,10609010,10609011,10609012,10609013,10609014,10609015,10609016,10609017,10609018,10609019,10609020,10609021,10609022,10609023,10609024,10609025,10609026,10609027,10609028,10609029,10609030,10609031,10609032,10609033,8566520,8566620,9911556,9911557,9911558,9911559,9911560,9911561,9911562,9911563,9911564,9911565,9911566,9911567,9911568,9911569,9911570,9911571,9911572,9911573,9911574,9911575,9169701,8849984,8849985,8849986,8849987,8849988,8849989,8849990,8849991,8849992,8849993,8849994,8849995,991021,8552155,6672524,6672525,10418490,10418496,10417030,10417037,10117329,10117330,10117331,10117332,10117333,10117334,10117335,10117336,7055389,7055390,7055391,7055392,7055393,10469131,10467313,10467314,10467315,10467316,10467317,10467318,10467319,10467320,10467321,10467322,10467323,10467324,10467325,10467326,8549910,8549911,8549912,9167345,9167346,9167347,9167348,9167349,9167350,9167351,9167352,9167353,9167354,9167355,9167356,9167357,9167358,9167359,9167360,9167361,9167362,9167363,9167364,9167365,9167366,9167367,9167368,9167369,9167370,9167371,9167372,9167373,9167374,9167375,9167376,9167377,9167378,9167379,9167380,9167381,9167382,9167383,9167384,9167385,9167386,9167387,9167388,9167389,9167390,9167391,9167392,9167393,9167394,9167395,9167396,9168084,10888936,10889943,10161683,10161684,10161685,10161686,10161687,10161688,10161689,10161690,10161691,10161692,10161693,10161694,10161695,10161696,10881567,10882088,10882089,10882090,10882091,10882092,10882093,10882094,10882095,10882096,10882097,10882098,10882099,10882100,10882101,10882102,10882103,10882104,10882105,10882106,10882107,10882108,10882109,10882110,10882111,10882112,10882113,10882114,10882115,10882116,10882117,10882118,10882119,10882120,10882121,10882122,10882123,10882124,10882125,10882126,10882127,10882128,10882129,10882130,10882131,10882366,10608816,10608817,10608818,10608819,10608820,10608821,10608822,10608823,10608824,10608825,10608826,10608827,10608828,10608829,10608830,10608831,10608832,10608833,10608834,10608835,10608836,10608837,10608838,10608839,10608840,10608841,10608842,10608843,10608844,10608845,10608846,10608847,10608848,10608849,10608850,10608851,10608852,10608853,10608854,10608855,10608856,10608857,10608858,10608859,10608860,10608861,10608862,10608863,10608864,10608865,10608866,10608867,10608868,10608869,10608870,10608871,10608872,10608873,10608874,10608875,10608876,10608877,10608878,10608879,10608880,10608881,10608882,10608883,10608884,10608885,10608886,10608887,10608888,10608889,10608890,10608891,10608892,10608893,10608894,10608895,10608896,10608897,10608898,10608899,10608900,10608901,10608902,10608903,10608904,10608905,10608906,10608907,10608908,10608909,10608910,10608911,10608912,10608913,10608914,10608915,10608916,10608917,10608918,10608919,10608920,10608921,10608922,10608923,10608924,10608925,10608926,10608927,10608928,10608929,10608930,10608931,10608932,10608933,10608934,10608935,10608936,10608937,10608938,10608939,10608940,10608941,10608942,10608943,10608944,10608945,10608946,10608947,10608948,10608949,10608950,10608951,10608952,10608953,10608954,10608955,10608956,10608957,10608958,10608959,10608960,10608961,10647233,10647234,10647235,10647236,10647237,10647238,10647239,10647240,10647241,10647242,10647243,10647244,10647245,10647246,10647247,10647248,10647249,10647250,10647251,10647252,10647253,10413347,10409522,10409523,10409524,10409525,10409526,10409527,10488267,10488268,10488269,10488270,10488271,10488272,10488273,10488274,10496728,10496729,10496730,10408801,10415103) 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<br>
ERROR: Unknown column 'p.products_specials' in 'order clause'<br>