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(10861488,3229285,10862199,10862266,10862275,10862276,10862291,10862551,10849640,10862727,10862728,8561115,7201341,10866403,10866903,10866905,10859185,10859221,8629273,8629477,7200387,8834763,10855253,10855254,7198682,10856088,10856095,11048369,11048440,7200140,7200171,3923595,10617114,10617145,10617146,10617155,10617156,10617157,10617159,10953985,10953991,10954023,10954024,10954195,10954197,10954199,10425349,10425351,10425360,10615024,10615077,10850452,10615238,10615239,10615240,10615241,8633334,10615943,10615950,10615953,10615955,8634558,10611339,10614463,10614572,10614772,10614773,10614774,10614791,10614792,10611802,10612284,10612285,10612407,10612484,10612485,10612486,10612487,10612490,10612492,10612496,10612501,10612502,10612503,10612516,10612517,10612518,10612519,10612520,10612523,10612526,10612527,10612529,10612530,10612553,10612556,10612557,10612565,10612573,10612586,10612589,10612597,10612604,10612608,10612609,10612611,10612637,10612641,10612644,10612655,10612668,10612677,10612684,10612687,10612688,10612689,10612699,10612700,10612705,10612707,10612714,10612715,10612723,10612755,10612824,10612833,10612834,10612837,10612841,10612842,10612846,10612860,10612867,10612868,10612939,10612942,8852321,8567072,8567073,10610296,10610318,10610319,10610362,10610836,10610840,10610941,9169452,9912875,10415318,10419783,10419785,10415896,10415944,10415952,10415953,10415969,10469710,10469711,10469712,10469713,10469788,10469789,10469790,10904077,10888291,10888292,10888293,10162048,10603503,10603504,10603505,10603506,10604646,10604651,10604658,10604661,10604664,10604668,10604704,10508198,10507816,10507817,10413669,10413691,10410438,10410439,10411220) 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>