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(8630785,8630786,8630787,8630788,8630789,8630790,10868167,10868168,10868169,10868170,10868171,8631659,8631660,8631661,8631662,8631663,8631664,8631665,8631666,8631667,8631668,8631669,8631670,8631671,8631672,8631673,8631674,8631675,8631676,8631706,8631707,10939417,8627694,8627695,8627696,8627697,10931546,10931547,8628258,8628259,8065804,8628591,8628599,8628601,8628602,8628603,8628604,3227179,3227180,8910577,8910578,8910579,8910580,8624810,8624811,10855463,10855464,10855465,10855466,10855467,10855468,10855469,10855470,10855471,10855472,10855473,10855474,10855475,10855476,10855477,10855478,10855479,10855480,10855481,10855482,10855483,10855484,10855485,10855486,10855487,10855488,10855489,10855490,10855491,10855492,10855493,10855494,10855495,10855496,10855497,10855498,10855499,10855500,10855501,10855502,10855503,10855504,10855505,10855506,10855507,10855508,10855509,10855510,10855511,7198737,7198738,7198751,8626049,8860329,3923407,8554292,10838791,10617208,3232874,3232916,8632743,10615623,8633326,7155250,7155251,10611372,8566537,10610006,10610339,10610340,10610341,10610342,10610343,10610344,10117565,9911967,9911968,8850176,8850177,8850420,6675124,9167962,9167963,9167964,9167965,9167966,10887512,7000825,10883417,10883418,10883419,10883420,10883421,10883422,10883423,10883424,10883425,10883426,10883427,10883428,10883429,10161847,10602445,10647388,10601705,10508501,10508502,10508503,10420768,10420769,10420770,10420771,10420772,10420773,10410638,10410639,10410640,10410641,10410642,10410643,10410644,10410645,10410646,10410647,10410648,10410649,10410650,10410651,10410652,10410653,10410654,10410655,10410656,10410657,10410658,10410659,10410660,10410661,10410662,10410663,10410664,10410665,10410666,10410667,10410668,10410669,10410670,10410671,10410672,10410673,10410674,10410675,10410676,10410677) 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>