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(10841675,10841676,10841677,10841678,10841679,10841680,10841681,10841682,10841683,10841684,10841685,10102462,10102463,8835668,8835669,3924600,3924601,3924602,10427015,10427016,10427017,10427018,10427019,10427020,10427021,10427022,10427023,10427024,10427025,10427026,10427027,10427028,10217408,10217409,10217410,10217411,10217412,10217413,10217414,10217415,10217416,10217417,10217418,10217419,10217420,10217421,10217422,10217423,10217424,10217425,10217426,10217427,10217428,10217429,10217430,10217431,10217432,10217433,10217434,10217435,10217436,10217437,10217438,10217439,10217440,10217441,10217442,10217443,10217444,10217445,10217446,10217447,10217448,8967030,8967031,7069067,7069068,7069070,7069071,8583815,8583816,8583817,8583818,8583819,8583820,8583821,8583822,8583823,8583824,8583825,8583826,3582012,3582013,9215317,8574792,8574793,8574794,8574795,8574796,8574797,8574798,8574799,9179694,9179695,9179696,9179697,9179698,9179699,9179700,9179701,9179702,9179703,9179704,9179705,9179706,9179707,9179708,9179709,9179710,9179711,9179712,9179713,9179714,9179715,9179716,9179717,9179718,9179719,9179720,9179721,9179722,9179723,9179724,9179725,9179726,9179727,9179728,9179729,9179730,9179731,9179732,9179733,9179734,9179735,9179736,9179737,9914549,6676548,6676549,6676550,6676551,6676552,10120555,8592800,8592801,8592802,8592803,7056866,7056867,7056868,7056869,7056870,7056871,7056872,7056873,7056874,7056875,7056876,7056877,7056878,7056879,7056880,8066887,10427864,10427865,10427866,10427867,8567320,8567321,8567322,8567323,8567324,8567325,8567326,8567327,8567328,8567329,8567330,8567331,8567332,8567333,8567334,8567335,8567336,8567337,8567338,8567339,8567340,8567341,8567342,8567343,8567344,8567345,8567346,8567347,8567348,8567349,8567350,8567351,8567352,8567353,8853428,10169699,10169700,10169701,10169702,10169703,10169704,10169705,10169706,10169707,10169708,10169709,10169710,10169711,10169712,10169713,10169714,10823882,10823883,10683815,10683816,10683817,10683818,10683819,10683820,10683821,10683822,10683823,10683824,10683825,10683826,10683827,10683828,10683829,10683830,8594083,8594084,10649823,10649824,10649825,10649826,10649827,10649828,10523736,10523737,10480494,10480495,10480496,10480497,10480498,10480499) 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>