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(10849491,8631857,8632575,10872752,8630195,10872848,10872851,8630304,8559029,10866452,10931548,7201826,7201827,7201828,7201830,7201832,7201833,7201836,7201838,7201839,8628310,7201959,10104071,5654816,10859771,10859773,10859775,9794594,10932917,10932956,10932958,10932960,10932973,10932976,8629417,8616850,10865445,10865446,10865452,8626811,7200470,10865584,10865585,11037113,11037128,11037207,11037208,11037209,11037210,11037215,11037226,11037239,11037240,11037241,10857998,8624652,8624656,8624658,8624766,8624767,8624768,8624769,8624770,8624771,8624772,8624773,8624774,8624775,8624776,8624777,8624778,8624779,8624780,8625431,10856099,11035945,11035946,8626104,8626188,8626396,8626397,8626398,7157017,11046626,11046627,11046628,11046629,11046630,11046631,7197810,7197811,7197813,10624633,8624373,10922496,10922497,10922498,10922515,8905251,8634846,8905262,8634853,8634860,8634866,10852587,3232909,3232910,10853147,8632610,8632611,8632621,8632625,10425350,8632631,8632690,8632714,8632722,10850743,10850751,8633206,8633208,9217222,9217223,9217224,10425937,8633290,8633291,10952313,10952325,8633546,8577911,8577968,8577969,8578008,8578010,8578014,10852126,10922436,10922437,10922441,10922443,10922444,10922445,10922446,10922447,10922448,10922449,10922450,10610963,10610965,9205324,9205341,9205343,9205346,9205374,9205379,10611459,10611472,10611479,10611483,10611485,10611495,10611496,10611498,10611499,10611509,10714437,10714438,10714441,10611666,10611676,10611856,7017820,7017821,7017822,7017823,10613192,10610243,10117529,10117679,10515309,4974715,4974716,4974719,4974720,4974721,4974722,4974723,4974724,4974726,4974727,4974730,4974731,4974732,4974733,4974739,8850509,8851098,8851100,8851101,8851102,8851104,10417395,10417397,10417398,10417399,10417400,10417401,10417410,10417417,10417423,10417534,6672832,6672892,10418735,10418817,6681111,6681146,8568864,8568865,8568866,8568871,8568910,8568911,8568912,8568917,9916952,9916955,9916956,9916957,9916958,9916959,9916961,10463748,10463796,10465822,10465829,10465858,8855146,9191563,10462325,10466369,10466374,10466394,8550975,10466402,8550993,10462429,10466456,10462511,10883585,10883586,10883589,10883590,10883591,10883592,10883593,10883596,10884082,10884083,10884172,10890154,10890173,10176232,10630056,10905693,10630274,10911784,10631419,10950147,10950148,10950149,10950152,10950154,10580391,10580408,10580409,10580512,10579478,10579479,10579820,10422380,10422381,10422382,10423583,10423584,10423585,10422588,10423614,10423615,10423616,10423617,10423618,10423619,10423620,10423621,10423622,10423623,10423624,10423625,10423626,10422686,10423689,10423690,10423691,10423692,10423693,10423694,10423695,10420712,10423738,10423739,10423740,10423754,10421758,10421759,10421760,10421761,10421763,10421770,10421772,10421774,10421775,10421776,10421777,10421781,10421783,10507677,10507678,10507679,10421789,10507680,10507681,10424875,10423919,10423920,10423921,10423922,10423019,10423020,10422167,10407228,10407229,10407232,10411284,10411285,10409352,10490336,10490342,10490343,10492444,10492445,10492447,10411839,10407998,10473700,10473703,10475757,10474001,10410403,10474075,10474080,10474083,10474092,10474099,10474101,10474103,10412584,10414758,10414767,10408774,10409045,10407077) 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>