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(10263180,10263181,10263182,8619374,8837350,8837620,8837621,10252018,10102855,10842964,10842965,10842966,10842967,8557171,10261778,10261779,3925000,10283321,10218509,10244559,10257561,10257562,10257685,10257686,10244849,7070750,7070751,7070752,7070753,10255321,10255322,10255323,10229433,10229434,10229435,10229436,10229437,10229438,10229439,10229440,10229441,10229442,10229443,10229444,10229445,10229446,10229447,10229448,10229449,10229450,10229451,10229452,10229453,10229454,10229455,10229456,10229457,10255770,10255771,10255772,10255799,10254447,10432522,10432523,10928144,10252461,10846043,10253120,10122095,10122096,10122097,10122098,10122099,8862767,8862768,8862769,9185760,9185761,9185762,9185763,9185764,9185765,10519098,9200381,9201222,9201223,6667155,6667156,6667157,6667158,6679806,10116019,10904197,10920093,10920094,10920095,10920096,10917731,10917732,10917733,10183866,10917871,10917872,10917873,10917874,10917875,10177915,10177916,10177917,10177918,10177919,10177938,10177939,10177940,10177941,10569037,10569295,10569296,10569297,10569298,10609313,10575756,10569877,10569878,10573651,10573652,10573653,10573654,10573655,10573656,10573657,10573658,10573659,10573660,10573662,10571071,10530182,10530183,10530184,10530185,10530186,10530187,10530188,10530189,10530190,10530191,10530192,10530193,10530194,10530195,10530196,10530197,10530198,10530199,10530200,10530201,10530202,10530203,10530204,10530205,10530206,10530207,10530208,10530209,10530210,10530211,10530212,10530213,10530214,10530215,10530216,10530217,10530218,10530219,10530220,10530221,10530222,10530223,10530224,10530225,10530226,10530227,10530228,10530229,10530230,10530231,10530232,10530233,10530234,10530235,10530236,10530237,10530238,10530239,10530240,10530241,10530242) 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>