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(8595236,4970758,8628812,3227185,8629476,7198682,7198734,7198735,7198747,7198749,7198761,7199561,8908231,10865961,10865962,10865963,10865964,10865965,10865966,10865967,10865968,10865969,10865975,10865976,10865977,8905973,8905974,8905975,8905976,10866235,3923669,8906804,8906849,10854139,10854141,8906952,10854323,10854370,10838948,10426223,8611314,10864860,10864995,3232354,10865227,10865228,10852282,10852287,10282725,8905380,10622344,10860758,10860760,10860761,10860950,10860951,10860952,10615323,10615324,10615409,10615549,10615577,10861532,10615954,10862292,10614793,8851139,8851142,8851153,8851158,8851168,8851171,8851176,8851267,8851269,8851274,8851300,8851323,8851337,8851344,8851396,10612263,7017421,7017422,7017423,7017424,8851709,10612894,10612916,8852375,6673784,10117832,10117833,8850620,8850623,8850625,8850630,8850631,9913014,8850634,8850639,8850641,8850645,9913043,9913044,8850690,8850744,8850911,8850913,8850914,9913311,8850933,8851036,8851121,8851125,8851130,10418285,10419343,10419344,6672714,10418533,10418534,10418535,10419123,10419124,10419125,10419126,10419127,10419128,10419129,10419130,10419131,10419132,10419133,10419134,10419135,10419136,10419137,10419145,10419146,10419147,10418178,7055465,10469791,10469792,10469793,10469972,10469973,10469974,10470091,10470137,9167780,10468428,10470723,9168201,10888607,10888660,10888680,10889584,10889720,10877529,10877588,10882913,10882914,10887945,10627666,10888301,10888397,10888398,10888399,10888400,10162121,10876820,10876821,10647664,10582559,10604506,10604687,10508178,10508179,10415426,10415435,10508480,10508481,10507599,10507600,10508617,10506786,10415970,10410098,10408825,10408830,10408831) 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>