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(10437315,10437316,10437317,10437318,10437319,10437320,10437321,10929953,10931997,10843830,10843831,10843832,10843833,10843834,10843835,10843836,10843837,10843838,10843839,10843840,10843841,10843842,10843843,10843844,10843845,10843846,10103048,10944680,10944681,10944682,10944683,10944684,10944685,10944686,10944687,10944688,8615768,8615769,8615770,8615771,8557522,10997603,10997604,8070964,7156290,7156291,7156292,7156293,7156294,7156295,7156296,7156297,7156298,7156299,7156300,7156301,7156302,7156303,7156304,7156305,7156306,7156307,7156308,9216857,9216858,9216859,8568013,8568014,8568015,8568016,8568017,8568018,8568019,8568020,8568021,8568022,8568023,8568024,8568025,8568026,8568027,8568028,8568029,8568030,8568031,8568032,8568033,3655041,3655042,9220333,10660175,10660176,9190326,9190327,9190328,9190329,9190330,8917349,976640,976641,976642,7001104,10172950,10172951,10172952,10172953,10172954,10172955,10172956,10172957,10172958,10172959,10172960,10172961,10172962,10172963,10172964,10172965,10172966,10172967,10172968,10172969,10172970,10172971,10172972,10172973,10172974,10172975,10907306,10907307,10907308,10907309,10907310,10907311,10907312,10907313,10907314,10907315,10907316,10907317,10651702,10539996,10539997,10539998,10539999,10540000,10540001,10540002,10540003,10540004,10540005,10540006,10540007,10540008,10540009,10540010,10540011,10540012,10540013,10540014,10540015,10540016,10540017,8562692,8562693,10489475,10489476,10489477,10489478,10489479,10489480,10489481,10489482,10489483,10489484,10489485,10489486,10489487,10489488,10489489,10489490,10489491,10472789,10472790,10472791,10472792,10472793,10472794,10472795,10472796,10472797,10472798,10472799,10472800,10472801,10472802) 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>