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(10861364,8630420,7201253,7201354,7201368,3238544,8595234,7201844,7201976,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,7202347,7202364,7202365,7202676,10859799,10859801,10860034,10857646,10857647,10857648,10857649,7200607,10857650,7200608,10857651,10857652,10857653,10857654,10857655,10857656,10866063,10866064,10866065,10866129,10866130,10866131,10866132,10866134,10866137,10866138,10866141,10866143,10866145,7198688,7198742,8625508,8625512,8625519,10864501,10864502,10864505,10864507,10864509,10864511,10864513,10864515,10864517,10864519,10864522,10864525,10864527,10864529,10864531,10864533,10864535,10864537,10864538,10864540,10864542,10864544,10864546,10864548,10864550,10864551,10864553,10864556,10864558,10864560,10864562,10864564,10864566,10864568,10864570,10864572,10864574,10864576,10864578,10864580,10864582,10864584,10864586,10864589,10864591,10864593,10864595,10864597,10864599,10864601,10864603,10864605,10864607,10864610,10864613,10864619,10864622,10864624,10864626,10864629,10864631,10101494,10838801,10615389,8611334,8611335,10614518,10614593,10611684,10611778,10611838,10611839,10611840,10611841,10611842,10609393,8566712,10612916,10612951,10613693,10610958,6674249,6674332,3285786,8850547,10419258,9168351,9168352,10417811,10417812,10417814,10417816,10417818,10417820,10417822,10417824,10417826,10417828,10417830,10417832,10417834,10417837,10417839,10417841,10417843,10417845,10417847,10417849,10417850,10417852,10417854,10417856,10417858,10417860,10417862,10417864,10417866,10417868,10417870,10417872,10417874,10417876,10417878,10417881,10417883,10417885,10417887,10417889,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,10419207,10419208,10419209,8549927,9167297,10883934,10883935,10883936,10883937,10884630,10884631,10884632,10884633,10884634,10884635,10884636,10884637,10884638,10884639,10880306,10880307,10882432,10647446,10647447,10647448,10647449,10647450,10647451,10601622) 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>