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(8068861,8068862,8068863,10448245,10448246,10448247,10448248,10448249,10448250,10448251,10448252,10861723,3229108,3229109,10862243,10862244,10862245,10862246,3229850,10437523,10437524,10437525,10987628,10987629,10987630,8573243,10962228,10845357,10845358,10845359,10930184,10930185,10866354,8559023,8559024,8559025,8559026,8559027,8835727,10103729,10103730,10103731,10103732,10103733,10103734,10103735,10103736,10103737,3899189,7202427,7202428,10859600,10932720,10932721,10932722,10932723,8836947,8836948,9794595,9794596,6665033,6665034,6665035,6665036,6665039,6665040,6665041,6665042,10844324,6665085,6665086,6665089,6665090,6665091,6665092,7065820,10942618,10942619,10942620,10942621,11049245,11049246,11049247,11049248,7071461,3235458,3235459,3235460,3235461,3235462,3235463,3235464,3235465,3235466,3235467,3235468,3235469,3235470,3235471,3235472,3235473,3235474,3235475,3655893,3655894,3655895,3655896,3655897,10944786,10855875,8908730,8908773,10856313,10856314,3926831,3926832,3926833,3926834,8565174,8565175,8565176,8565177,8565178,8565179,8565180,8565181,8565182,8565183,8565184,8073298,8073299,8073300,8073301,8073302,8073303,8073304,8073305,8073306,8073307,8073308,8073309,8073310,8073311,8073312,8073313,8073314,8073315,8073316,8073317,8073318,8073319,8073320,8073321,8073322,8073323,8073324,8073325,8073326,8073327,8073328,8073329,8073330,8073331,8073332,8073333,8073334,8073335,8073336,8073337,8073338,8073339,8073340,11010430,11010431,11010432,11010433,11010434,11010435,7156526,7156527,7156528,7156529,11044727,8905178,8634778,8634780,8634781,8634782,8634783,8634784,8634788,8634789,10622536,10853218,8576355,8576376,8633102,10952163,10614182,10614519,10614520,10614521,10614522,10614523,10714410,10714411,10714412,10714413,10714414,10714415,8864550,8568596,8568597,8568598,8568599,8568600,8568601,8568602,8566546,9220477,9220478,10564856,10564857,10564858,10564859,10564860,10564861,10564862,10564863,10660229,10660230,10660231,10660232,10660233,10660234,6673738,10118233,3285906,3285907,3285908,3285909,3285910,3285911,3285912,8850258,8850277,8850306,8850348,9912798,9912799,9912800,9913360,10415933,10415934,4973952,4973953,9169292,9169293,10468888,4971322,4971323,9198801,9198802,9198803,9198804,9198805,9198806,9198807,9198808,9198809,9198810,9198811,9198812,9198813,9198814,9198815,9198816,9198817,9198818,9198819,9198820,9198821,9198822,9198823,9198824,9198825,9198826,9198827,9198828,9198829,9198830,9198831,9198832,9198833,9198834,9198835,9198836,10469619,6679278,6679279,6679280,6679281,6679282,6679283,9167207,9167208,9167209,9167210,8550876,8550877,976583,10628783,10628784,10628785,8594381,10176325,10176326,10176327,10176328,10176329,10176330,10176331,10176332,10176333,10176334,10176335,10176336,10176337,10176338,10176339,10176340,10176341,10176342,10176343,10176344,10176345,10176346,10176347,10176348,10176349,10176350,10176351,10176352,10176353,10176354,10176355,10176356,10176357,10176358,10176359,10176360,10176361,10176362,10176363,10176364,10176365,10176366,10176367,10176368,10176369,10176370,10176371,10176372,10176373,10176374,10176375,10176376,10176377,10176378,10176379,10176380,10176381,10176382,10176383,10176384,10176385,10176386,10176387,10176388,10176389,10176390,10176391,10176392,10176393,10176394,10176395,10176396,10176397,10176398,10176399,10176400,10176401,10176402,10176403,10176404,10176405,10176406,10176407,10176408,10887513,7001233,10893404,10161657,10905681,10162114,10626161,10626162,10911777,10911778,10911779,10911780,10902041,10652602,10652603,10652604,10652605,10652606,10652607,10541917,10550191,10409420,10414036,8563114,10715124,10715125,10715126,10715127,10715301,10715302,10411026) 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>