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(11014551,10873928,10459212,10873929,10459228,10459291,10459320,10862132,10459417,8631573,10950646,11042349,3230166,3230167,11013578,11013579,11013691,10929386,7075194,7075195,7067294,8573535,6000175,8911004,8617795,11011771,8594788,10866536,11012252,10859145,10999572,7073792,10942571,10857375,10857403,3927723,7200659,7200709,7200725,6000034,6000044,10839627,10840287,3236402,3236403,10942231,10942246,3927028,8612980,10968137,10968138,10968139,10968140,10968141,10968142,11046720,10619366,8624249,8624250,3235057,10917499,11005798,11018854,11005895,11005896,10617445,10953989,11006000,8634980,8635007,11006234,11032420,8609755,11016685,11016686,11016687,10915730,10915781,10915782,10915783,10915793,10915794,10915795,10915796,10915797,10915798,10915799,11016916,9217625,10926728,9915839,9206073,9174171,9174172,9174173,9174174,9174175,9174176,9174177,9174178,9174179,10611924,7025090,9195889,8566944,7026559,8852770,6673757,6673765,9201578,9201579,9201580,10125873,7023701,7023827,3285950,10117013,10415841,10125335,10125371,9201254,9182450,6666523,6666524,6666525,6666526,7020512,4972006,9207602,9207603,9207604,9167818,9208084,8551242,9176194,10159509,10893875,10893876,10908916,10170762,10166312,10166441,10892511,10163541,10158748,10158749,10158750,10158751,10158752,10158753,10158754,10158755,10158756,10158757,10158758,10158759,10158760,10158761,10158762,10158763,10158764,10158765,10158766,10158767,10158768,10158769,10158770,10158771,10158772,10158773,10158774,10158775,10158776,10158777,10158778,10912849,10912850,10161593,10171674,10171675,10172004,10172005,10172006,10630650,10630651,10630652,10891193,10178012,10178013,10178014,10178015,10178110,10877224,10598943,10598944,10598945,10599042,10650111,10650112,10650113,10650114,10650115,10584226,10587314,10587315,10587316,10587317,10587318,10587319,10587320,10587321,10587322,10587323,10587324,10587325,10587326,10587327,10587328,10587329,10587551,10587552,10587553,10587554,10654152,10654153,10654154,10654155,10651331,10651332,10645410,10645411,10645412,10645413,10645414,10645415,10645416,10645417,10645418,10645419,10645420,10645421,10645422,10645423,10645424,10645425,10645426,10645427,10645428,10645429,10645430,10645431,10645432,10645433,10645434,10645435,10645436,10645437,10645438,10645439,10645440,10645441,10645442,10645443,10645444,10645445,10645845,10529278,10529279,10529280,10529281,10529282,10519283,10529283,10529284,10519284,10519285,10519286,10519287,10519288,10519289,10519290,10519291,10519292,10519293,10519294,10519295,10519296,10519297,10519298,10519299,10519300,10519301,10519302,10519303,10519304,10519305,10519306,10519307,10519308,10553745,10553746,10553747,10541763,10541798,10541801,10527946,10522738,10522739,10522740,10522741,10522742,10522743,10522744,10522745,10522746,10522747,10505389,10424558,10424559,10505498,10505499,10505500,10505501,10496486,10408019,10495168,10476614,10476615,8562181) 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>