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(8630858,8630859,8631630,8631640,8631641,8631642,8631643,8631717,8631718,8631719,8631721,8631722,8631724,8631725,8631726,8631727,8631728,8631729,8632495,8629956,8629957,8629958,7201366,7201386,8627821,7201677,8628391,8628393,8628394,7202329,8629250,3237391,3237392,8627059,8627060,8627061,8627069,8627070,8627122,10855242,10855245,7198683,8625135,8625136,8625137,8625140,8625143,8625458,8625459,8625460,8625461,8625474,8625475,8625476,8625477,10856196,10856221,10856222,10856223,10856224,10856225,10856228,10856229,10856230,10856231,10856232,10856234,10856235,10856236,10856238,10856316,11048387,11048388,11048389,8626420,7200121,10853233,10853772,10853773,10853774,10853775,7196891,10854225,7197854,7197855,7197856,8624263,8624264,8624265,8624266,8624267,8624268,8624318,8624319,8624557,8624564,8624573,8624574,8624575,8634618,8634619,8634620,8634621,8634622,8634623,8634624,8634625,8634626,8634627,8634628,8634629,8634630,8634631,8634632,8634633,8634634,8634635,8634636,8634637,8634638,8634639,8634640,8634641,8634647,8634648,8634649,8634650,8634651,10852364,10852365,8634811,10852643,10425484,10425574,10850716,8633116,8633117,8633118,8633119,8633120,8633121,8633122,8633123,8633124,8633125,8633170,8633171,8633172,8633173,8633174,8633175,8633176,8633177,8633178,8633179,8633180,8633181,8633182,8633183,10425944,8633422,8633425,8633429,8633430,8633432,8633433,8633434,10616888,10616955,10610995,10610996,10611025,10614221,10614857,10612201,10609749,8852372,10610775,10610777,10610958,10117726,9912147,6674152,8850517,8850547,8850596,8850597,9168752,9168121,10884720,10884721,10884723,10884725,10885361,10630093,10626720,10598615,10604035,10604036,10411293,10411312,10411313,10411314,10411315,10411316,10411317,10411318,10411319,10411320,10411321,10411322,10411323,10411325,10411386,10409758,10409759,10407971,10410427,10410430) 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>