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(10845719,10962658,10962659,10962660,10962661,10962662,10962663,10939615,10939616,10962690,10962691,10962693,10962694,10943453,10930312,10931024,10931025,10931026,8620980,10931040,10931041,10931043,10931044,10931045,10931046,8621130,8838812,8838868,8583102,10846549,11041773,10950826,8583700,8575424,10950957,7074458,10951249,10868915,3230158,10847543,7066823,10844720,10844725,10844726,8573173,10929294,10938685,10938686,10845186,7067490,8630425,8630426,8630427,7201329,10842862,10843310,8559504,8595305,7065005,10843916,7202523,8560328,8560330,8560331,8596244,10932965,8572919,3227180,10929131,3237473,10984906,10984907,10984908,3237762,10865633,8558386,8558411,3238160,10842653,7068945,10839729,7068997,8563809,8563979,7069345,10944794,10944815,10944819,7069454,8615675,3236283,8564589,8556985,10957746,7070322,7070341,8565061,3237018,10623477,10853804,3234005,8554691,8554703,8554714,8554715,8554730,8554732,8554734,8554735,8554741,8907096,10839104,10839105,10839106,10839107,10839109,3235027,10839377,3235073,3235074,3235076,3925074,8541693,8541942,8541960,8569997,3230487,8570102,8632773,8632779,10951999,9217044,10848230,8570507,8610430,11043446,11043447,11043448,11043449,10952471,8610792,10952623,7155243,3232287,10614259,10614267,10714158,9181997,9182001,9206120,8861877,10609343,10119973,8862727,7058453,10120662,9172476,9172515,9172516,9172517,9172518,9172520,9172521,9172522,10558478,10558479,10558540,7059221,7059229,7059233,7059249,8863682,9173228,9201401,9201470,10515765,10515766,10515767,8849917,10516056,10516057,10516058,10516067,9170254,10516068,10516069,9178299,9912943,9179123,10427965,9160891,10418863,9160946,10428335,10428336,9185010,9161047,9161110,10117419,10117420,10117421,10117422,9161279,9166474,9166624,9206656,9206658,10123508,10123509,10123510,9167553,9199557,9183756,10116074,9199985,10427433,9192122,10116392,10116395,10116396,10116397,10116400,10116401,10116402,10116403,10116404,10628788,10628789,10628790,10175329,10627910,10883429,10161589,10166641,10876746,10876747,10876748,10631454,10882373,10882374,10882375,10882376,10602175,10603777,10604372,10529447,10529448,10529450,10529463,10529464,10529465,10529466,10529467,10529468,10529469,10529470,10529471,10529472,10529473,10529476,10529477,10529500,10529501,10529502,10529503,10529504,10529505,10529509,10529510,10520295,10524855,10538869,10538870,10538897,10538900,10538903,10538910,10538911,10538913,10538914,10538915,10538929,10538930,10538931,10538932,10421228,10498386,8562675,8562677,8563083,10482019,10482020,10482021,10482022,10482023,10482024) 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>