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(3229002,3229003,3229004,3229005,3229006,3229007,8631713,8631714,8631715,8631763,8631764,8631765,10860287,10860288,10860289,10860290,10860291,10866368,10866369,10866370,7201973,7201974,10859452,10859453,10859454,10859455,10859456,10859457,10859458,10859459,10859460,10859461,10859462,10859463,10859464,10859465,10859466,10859467,10859468,10859469,10859470,10859471,10859472,10859473,10859474,10859475,10859476,10859477,7201008,7198355,7198356,7198357,7198358,10864142,10864413,10864414,3923523,8554315,10838830,7198048,7198124,8905423,10620195,10620196,10620197,10620198,10620199,10426335,10426336,10426337,8611348,8611349,8611350,8611351,8611352,10616568,10616569,10616570,10616571,8904950,10614050,10611823,8851776,8851874,10612916,10612917,10612918,10612919,10612920,10612921,10612922,10612923,10612924,10612925,10612926,10612927,10612928,10612929,10612930,10612931,10613369,10613370,9169764,10118102,6674162,9912412,9912525,8850218,9912894,10417499,10417500,9168701,9168877,8550045,8550046,8550253,9207331,976492,10468782,10468783,10468784,10888603,10888604,10884293,10889484,10889485,10889486,10889487,10889488,10889489,10889844,10885314,10885315,10885316,10885317,10885318,10885319,10885320,10885321,10885322,10885323,10885324,10885325,10885326,10885327,10885328,10885329,10885330,10885331,10885332,10885333,10885334,10885335,10885336,10885337,10877545,10877557,10877560,10887563,10877588,10877598,10888006,10885739,10885740,10885741,10886058,10886059,10886060,10887161,10508576,10508577,10508578,10508579,10508580,10508581,10508582,10507943,10413915,10413916,10413917,10413918,10413919,10413920,10413921,10413922,10413923,10413924,10413925,10413926,10413927,10413928,10413929,10413930,10413931,10413932,10413933,10414630,10414631,10414632,10414633,10414634) 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>