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(8630866,8630993,8631003,8631856,8631857,8631859,8632496,8629690,8629691,8629692,8629693,10860386,10860390,10860490,8629929,8629930,8630134,8630139,8630142,8630143,8630144,8630145,8630146,8630166,8630167,8630168,8630169,8630420,7201354,8628626,8628627,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,8628787,10857463,10857464,10857465,10857466,10857467,10857468,10865574,10865575,10865576,10865577,10865579,10865580,10865581,10865584,10865585,10865588,10865589,10865590,10958987,10865591,10958988,10958989,10865593,10865594,10865596,10865597,10865599,10865602,10865603,10865604,10865605,10865606,10865607,10865608,10865609,10865610,10865611,10865612,10865613,10865614,10865615,10865616,10865617,10865618,10865619,10865620,10865621,10865622,10865623,10865624,10865626,10865629,10865630,10865631,10865633,10865634,10865635,7200607,7200608,10857864,10857865,10857866,10857867,10857868,10857869,10857870,10857871,10857872,10857873,10857874,10857875,10857876,10857877,10857878,10857879,8627237,8627238,10857880,10857881,8627242,8627243,10857890,8627251,8627252,8627310,7201080,8627530,8627531,8627532,8627533,8627534,8627535,8627536,8627537,8627538,8627539,8627540,8627541,8627542,8627543,8627544,8627545,8627546,8627547,8627548,8627549,8627550,8627551,8627552,8627553,8627554,8627555,8627556,8627557,8627558,8627559,8627560,8627561,8627562,8627563,8627564,8627565,8627566,8627567,8627568,8627569,8627570,8627571,8627572,8627573,7198408,7198409,7198410,7198411,7198412,7198413,7198414,7198415,7198416,7198417,7198418,7198419,7198457,7198458,7198459,7198460,7198461,7198462,7198463,7198464,7198465,10864066,10864067,10864068,8626365,8624345,8624346,10620195,10620196,10620197,10620198,10620199,8633127,3231052,10426253,10426254,10426339,10614548,10614552,10614553,10614554,10611830,10611831,10611832,10611833,10611834,10611835,10611969,10612201,10612916,10612938,10612939,8852376,10610958,10118342,8850547,10417443,10417444,10417445,9168721,10418807,10418808,10418809,10418810,10418812,10418813,10418814,10418817,10418820,10418821,10418822,10418823,10418824,10418825,10418827,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,10418838,10418839,10418840,10418841,10418842,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418856,10418859,10418860,10418861,10418863,6673159,10628321,10884629,10889997,10632300,10632301,10632302,10900846,10887096,10887097,10507671,10507861,10507862,10507863,10507876,10412447,10412448,10412449,10412450,10412451,10412452,10412453,10412454,10412455,10412456,10412457,10412458,10412459,10412460,10412461,10412462,10412463,10412464,10412465,10412466,10414686,10414688,10414693,10414770) 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>