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(10874010,10843734,10104247,8560119,10873100,10437650,7074763,7074764,10278038,10278039,10278040,10278041,10278042,10278043,10278044,10278045,10278046,10278047,10278048,10278049,10278050,10278051,10278052,10278053,10278054,7075056,10870900,6000109,8615702,8615703,10933241,10220157,10220158,10100082,8542132,8542133,7157333,7157334,7157335,7157336,10433346,10433403,9217791,3232244,8584155,8584156,10228612,10228613,10228614,10228615,8632575,10845195,10845196,10925639,10925640,10925641,10925642,8570364,8838488,8838489,8838490,8621238,8621239,8621240,8621241,10431674,10846879,10846880,10846881,10846882,8864336,3655026,10122126,8864783,8067730,9205120,9205121,9205122,7023334,7023335,9161856,4974990,4974991,4974992,4974993,4974994,3286013,3286014,8917956,10125253,10125254,10125255,10428643,8569026,9174563,9206866,9206867,9206868,9206869,9206870,3656354,3656355,3656356,9183150,3656357,9183151,3656358,9183152,9183153,3656525,6665645,8917344,6667708,6667709,6667710,6667711,6667712,6667713,6667714,6667825,10116197,8594520,10899664,10183963,10183964,10187187,10187188,10631113,10631114,10877345,10877346,10877347,10877348,10877349,10877350,10580118,10653288,10653797,10653798,10587950,10587951,10587952,10587953,10587954,10582111,10582112,10582113,10582114,10582115,10582116,10582117,10582118,10582119,10582120,10582121,10582122,10582123,10582124,10582125,10582126,10582127,10582128,10582129,10582130,10582131,10580044,10580045,10422537,10424617,10423846,10494402,10481476) 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>