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(8630753,8630756,8630810,8630811,8630854,8630855,8630856,8630902,8630903,8630993,8631003,8631161,8631636,10862911,8067927,8629705,8629736,10860729,10860730,10860733,10860734,10860740,10860746,10860749,10860750,10860751,10860768,10860782,10860786,10860787,10860788,10860792,10860808,10860820,10860822,10860860,10860864,10860869,10860884,10860906,10860914,10860917,10860924,10860925,10860930,10860947,10860948,10860949,10860950,10860951,10860952,10860957,10860973,10860974,8627471,8627472,8628101,8595164,8628212,8065841,8065842,8629340,8629341,10857890,10855624,7198722,7198723,8625157,7199006,3923441,3923467,10853411,10854361,8624409,8624410,8624412,8624413,8624416,8624417,8624418,8905772,8905777,8632614,8632615,8632616,8632617,8632625,10850371,10426358,10426359,10426360,10613967,10613981,10613982,10613983,10613987,10613999,7059524,10614022,10614023,10614024,10614027,10614028,10614029,10614034,10614044,10614048,10614050,10614054,10614055,10614056,10614057,8852021,10613797,10613829,10613830,10613831,10613837,10613840,10613844,10613853,10613858,10613859,10613860,10613874,10613904,10613908,10613909,10613912,10613928,10613929,10613942,10613943,6673685,6673688,6673692,6673700,10118153,9912648,10416481,6673085,6673088,6673089,9169055,9169057,9169066,9169075,9169076,10469354,10469384,8550077,10115665,10886057,10886061,10886071,10886080,10886082,10886135,10886136,10886139,10886154,10886158,10886161,10886163,10886180,10886183,10886270,10886308,10886322,10886361,10886362,10886439,10886446,10886452,10886478,10886547,10886559,10886563,10886568,10886569,10886570,10886582,10886589,10886595,10886601,10886631,10886654,10886671,10886672,10886678,10886694,10886698,10886725,10886738,10886741,10886742,10886743,10886744,10886745,10886746,10886747,10886748,10886749,10886750,10886751,10886752,10886753,10886761,10886765,10886772,10886773,10886774,10886775,10886799,10886800,10886802,10886818,10886821,10886846,10886861,10608607,10647550,10647551,10647552,10647564,10410787,10414962,10414963,10414965,10414966,10414967,10414968,10414969,10414970,10414971,10414974,10414975,10414976,10414977,10414978,10414987,10414988,10414989,10414990,10414991,10414992,10414994,10414995,10414996,10414997,10414998) 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>