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(10930319,7076288,7076291,10861923,10871050,10950673,8561170,8561171,10870073,10870106,8627828,10866591,10866592,10866593,10866594,10843100,10858910,8836216,10103986,10859640,10932917,8629282,8629283,8629284,11037113,11037128,10102876,10959557,10855537,10855553,10855554,10941695,7196378,7196417,7157017,7196899,7196909,7196952,7196965,3924132,10838967,10838980,3234732,3234744,11047484,11047489,11047490,11047495,11047496,11047497,7156033,10993412,10993414,10993415,8542254,10853100,10425348,10425349,10425483,10425518,10425556,10425567,10425571,10850718,8633186,8633195,10425942,10425943,10426015,10426018,10426019,10848431,10952313,8540353,8540354,8540358,8540359,10616044,10616045,8540544,8540572,8540573,8611260,8611353,3232026,8611455,3232074,3232075,8577911,8577968,8577969,10922436,10922437,10922441,10922443,10922444,10922445,10922446,10922447,10922448,10922449,10922450,9205324,9205341,9205343,9205346,10611399,10611452,9214037,9214038,9214179,8851278,8851279,10612136,10119707,8851449,10609354,8851764,8566586,10613082,6677258,10513118,10513119,4974715,4974716,4974719,4974720,4974721,4974722,4974723,4974724,4974726,4974727,4974730,4974731,4974732,4974733,4974739,10118247,10118248,8850507,8850508,9186799,9186801,8851098,8851100,10419477,10419478,10419479,7054871,10415727,6681111,6681146,9193119,8568864,8568865,8568866,8568871,8568910,8568911,8568912,9190616,8550359,10463922,8550974,8550975,10889451,10632163,10632164,10632165,10630273,10630274,10172082,10886081,10886087,10626125,10907284,10598631,10598632,10598633,10598668,10598669,10598702,10598703,10598704,10598705,10598719,10598750,10598753,10598755,10598795,10598819,10598820,10598854,10598858,10590279,10541443,10528193,10522284,10548440,10536860,10524894,10547077,10547078,10547079,10420443,10420444,10422597,10508597,10421981,10421998,10413431,10486128,10486129,10486130,10407973,10414073,10474001,10410701,10410717,10410718) 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>