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(8630736,10873383,10873384,10873385,10873386,10873387,10873388,10873389,10873390,8630785,8630786,8630787,8630788,8630789,8630790,8630796,8630798,8630799,8630802,8630803,8630804,8630805,8630806,8630807,8630809,8630813,8630814,8630815,8630816,8630824,8630825,8630826,8630827,8630828,8630832,8630837,8630838,8630847,8630848,8630849,8630850,8630851,8630853,8630854,8630855,8630862,8630865,8630871,8630872,8630873,8630886,8630887,8630888,8630889,8630890,8630891,8630892,8630893,8630894,8630895,8630896,8630897,8630898,8630899,8630900,8630901,8630902,8630903,8630904,8630905,8631658,8631663,8631664,8631665,8631666,8631667,8631668,8631669,8631670,8631671,8631672,8631673,8631674,8631675,8631676,8631677,8631678,8631679,8631696,8631697,8631698,8631699,8631700,8631701,8631702,8631703,8631704,8631706,8631707,8631715,8631716,8631722,8631723,8631724,8631725,8631726,8631727,8631728,8631729,8631730,8631731,8631732,8631740,8631741,8631742,8631743,8631744,8631745,8631746,8631747,8631748,8631749,8631750,8631751,8631752,8631753,8631754,8631755,8631756,8631757,8631758,8631765,8622710,10103088,8627904,8627905,8627906,8627907,8627908,8627909,8627910,8627911,8627912,8627913,8627914,8627915,8627916,8627917,8627918,8627919,8627934,8627935,8627936,8627937,8627938,8627939,8627940,8627941,8628201,8911921,8911922,8911923,8911924,8911925,8911926,8911927,8911928,8911929,8911930,8911931,10857442,10857443,8627069,8627070,8627091,8627092,8627095,3927867,8624609,8624610,8625218,8625219,8625220,8625221,8625222,8625223,8625282,8625283,8625284,10853243,10853244,8624340,8624342,8624379,8624395,8624396,8624397,8624398,8624399,8634811,8634812,8634813,8634814,8634815,8634816,8634817,8634818,8634819,8634820,8634821,8634822,8634823,8634824,8634825,8634829,8634830,8634831,8634832,8634833,8634834,8634835,8634836,8634837,8634838,8634839,8634840,8634841,8634842,8634843,8634896,8634897,8634898,8634899,8634900,8634901,8634902,8634903,8634904,10954202,8632644,8632645,8632646,10615623,8904203,8634093,8634094,8634095,9218203,8567867,9213470,9213471,7059800,10610339,8852544,8852545,10512147,8850420,8850421,8850422,8850423,8850424,8850427,9910895,10117030,10122664,8569317,8569383,9917313,8550404,8563592,10632187,10188240,10626869,10598518,10598519,10598520,10598521,10654566,10424053,10424054,10424055,10424056,10424057,10424058,10424059,10424060,10409438,10409439,10412172,10412173) 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>