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(8630469,11027754,11027755,11027756,11027757,11027758,11027759,11027760,11027761,11027762,7076092,7076093,7076096,7076097,10861441,10861442,10861443,10861444,10861445,11001909,11001910,11001911,11001912,11001913,11001980,8631176,10862655,10862786,10862787,10862808,10862852,7074632,8632301,8632302,7066842,7066843,7066853,10860242,10860243,10860244,10860245,10860246,10860247,10860249,8629725,8629779,8573426,10860536,10860667,10860668,10860672,10860673,10860674,10860676,8630311,8630312,10866116,10866117,10866118,10866119,7201114,7072182,10972867,10931634,10931638,7201811,7201812,11025258,11025265,7201833,7201950,8628353,7202131,7202133,7202134,7202148,7202150,7202152,7202157,7202159,7202174,7202267,7202394,7202395,10867707,10867708,10865157,10865160,10865161,10857504,10857555,10857557,10857559,10857561,10857563,7200664,7200665,7200666,7200703,7200704,7200705,7200713,7200714,8627118,8627119,7200720,10985273,11034558,11034559,11034560,11034779,7198696,7198697,7198702,7198710,7198714,7198716,3925902,7198820,7198822,10863973,10970760,10856417,10971216,8860526,10865038,10865041,10837697,10837701,3923486,3923488,3923489,3923546,3923547,11032894,11032895,11032896,3923619,3923620,3923621,11033468,11033469,11033470,11033471,11033472,10854185,10619176,11033773,11033774,10969301,10969302,10969303,10969304,8624415,11031748,11031749,11031750,10951564,10951565,8632629,11003715,11003716,8632766,8632786,10620361,10615389,11029960,11029961,11029962,11029963,11029964,11029965,11029966,11029967,11029968,8570509,8570510,3231157,8633595,8633596,8633597,8633676,8633677,8633678,8633679,8633680,8633681,8633826,8633827,8633828,8633829,8633830,8633831,8633832,8633833,8633834,8633835,8633836,8633837,8633838,8633839,11004884,8541097,11031294,11031469,11031470,11031471,11031472,11031473,11031474,3654875,3654876,9190020,9212257,9172495,9172496,9172570,9172571,9172625,9172626,9172627,9172628,9172629,9172630,10613538,10613549,10613550,10555577,10555578,10118157,10118158,9202005,10555844,10555845,10555846,10555847,9170199,9170200,9170201,9170202,10556066,6674479,10118932,9187263,10416277,10418323,10418326,10416349,10416350,10416371,10415377,10416415,9200619,9200748,10122759,10122760,10122800,10122801,10122802,8569312,10123339,10123372,10123373,10123374,10469909,10469918,9183473,9183474,9175553,9175721,10124184,10124357,10124489,10627910,10630065,10630102,10885829,10885860,10631233,10887345,10649452,10649453,10577570,10574824,10577930,10577931,10577932,10577933,10574964,10574965,10575465,10648234,10523117,10523118,10523119,10523120,10523121,10523122,10523123,10523124,10523125,10523126,10551307,10551308,10551309,10551385,10553623,10553624,10553625,10553626,10553627,10553628,10553629,10551666,10539776,10536099,10536100,10536101,10536102,10534253,10534254,10534255,10534256,10534257,10536423,10536424,10536425,10536426,10554441,10554442,10552552,10552553,10552554,10552555,10552556,10552557,10552558,10552559,10552560,10552561,10552562,10552563,10552564,10552565,10552566,10552567,10552568,10552569,10552570,10552571,10552572,10552573,10552574,10552575,10552576,10552577,10552578,10552579,10552580,10552581,10534681,10540848,10540849,10540850,10540851,10540852,10554853,10554854,10554855,10554856,10554857,10554858,10554859,10554860,10554861,10554862,10554863,10554864,10554865,10554866,10554867,10554868,10554869,10554870,10554871,10554872,10554873,10554874,10554875,10554876,10554877,10554878,10554879,10554880,10554881,10554882,10554883,10554884,10554885,10554886,10554887,10554888,10554889,10554890,10543039,10523105,10523106,10523107,10523108,10523109,10523110,10420433,10424696,10424697,10424698,10424699,10424700,10424701,10424702,10424703,10424704,10424705,10424706,10424862,10411456,10409956,10412179,10496921,10495015,10495016,10414816,10414915,10414916,10414919,10414920,10414921,10414923) 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>