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(10872243,10872244,10872245,10845422,10845423,10845424,10845425,10845426,10103768,10103769,7073622,11010620,11010621,11010622,11010623,11010624,11010625,11010626,11010627,11010628,11010629,11010630,11010631,11010632,11010633,11010634,11010635,11010636,11010637,11010638,11010639,11010640,3235512,3655908,8576393,10565710,10565711,10565712,10565713,10565714,10565715,10565716,10565717,10565718,10565719,10565720,10565721,10565722,10565723,10565724,10565725,10565726,10565727,10565728,10565729,10565730,10565731,10565732,10565733,10565734,10565735,10565736,10565737,10565738,10565739,10565740,10565741,10565742,10565743,10565744,10565745,10565746,10565747,10565748,10565749,10565750,10565751,10565752,10565753,10565754,10565755,10565756,10565757,10565758,10565759,10565760,10565761,10565762,10565763,10565764,10565765,10565766,10565767,10565768,10565769,10565770,10565771,10565772,10565773,10565774,10565775,10565776,10565777,10565778,10565779,10565780,10565781,10565782,10565783,10565784,10565785,10565786,10565787,10565788,10565789,10565790,10565791,10565792,10565793,10565794,10565795,10565796,10565797,10565798,10565799,10565800,10565801,10565802,10565803,10565804,10565805,10565806,10565807,10565808,10565809,10565810,10565811,10565812,10565813,10565814,10565815,10565816,10565817,10565818,10565819,10565820,10565821,10565822,10565823,10565824,10565825,10565826,10565827,10565828,10565829,10565830,10565831,10565832,10565833,10565834,10565835,10565836,10565837,10565838,10565839,10565840,10565841,10565842,10565843,10565844,10565845,10565846,10565847,10565848,10565849,10565850,10565851,10565852,10565853,10565854,10565855,10565856,10565857,10565858,10565859,10565860,10565861,10565862,10565863,10565864,10565865,10565866,10565867,10565868,10565869,10565870,10565871,10565872,10565873,10565874,10565875,10565876,10565877,10565878,10565879,10565880,10565881,10565882,10565883,10565884,10565885,10565886,10565887,10565888,10565889,10565890,10565891,10565892,10565893,10565894,10565895,10565896,10565897,10565898,10565899,10565900,10565901,10565902,10565903,10565904,10565905,10565906,10565907,10565908,10565909,10565910,10565911,10565912,10565913,10565914,10565915,10565916,10565917,10565918,10565919,10565920,10565921,10565922,10565923,10565924,10565925,10565926,9199023,9199024,9199025,9199026,9199027,9199028,9199029) 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>