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(3228394,11040750,11040751,11040752,11040753,11040754,11014969,8621210,3228953,10873842,10873923,11015581,11015582,11015583,11015584,11015585,11015586,10846914,8622075,10849623,10849657,10849658,8622218,8622301,11016161,11016162,11016163,11016164,11016165,11016193,11016194,11016195,3230125,10847527,10847528,10847529,3227433,3227434,3227435,7075032,7075081,10929421,8629963,11040292,11040293,11040294,11040295,10962312,10873076,10873154,8594666,7064065,7064066,7064073,8911475,3898962,10973189,10973190,10858795,8911570,11012236,8911627,7201964,4967056,4967057,4967058,4967059,4967060,4967091,4967092,4967093,4967094,4967095,4967096,4967097,8572086,10867324,8560084,8560152,8560238,8560273,10104584,10933201,10933202,7065856,11013548,11013549,11013550,7073883,8063983,8063991,8063992,8063993,8063994,8063995,3927453,3927660,10857960,3238185,3238186,3238187,10839707,3925506,10840186,10840187,10840188,3656492,3236385,3236386,11022845,11048529,7070708,7070741,10618223,3923731,10623402,10968087,8554361,3923926,3924088,7157424,7157425,10838779,8563617,10852240,10927518,8611879,8611913,11044921,11044922,11044923,11044991,11006026,8541868,8612725,10925539,10925540,10925541,10620144,10926059,11043268,9217273,9217336,9217337,10952840,10952841,10952842,10952857,8577578,8611365,8611372,8552547,7027007,9915741,9915742,9915748,9173849,9916057,7019945,7025067,9187504,10119857,10119858,7057955,7057956,9211791,9195936,9171987,9172336,9172337,9172338,7018012,7018249,8863176,8863177,8863178,7026327,7026362,7018509,7026530,9173122,7026832,9201490,9201491,9201492,10125763,8849521,10513748,10513749,10513750,10513751,7023663,8551338,9912286,7023752,4974959,4974960,4974961,7023802,4975007,4975008,10513981,3285971,3286054,10556419,9170633,9170634,10518841,10518842,8861557,7022024,9160401,9160402,9160403,9160425,9160426,9160427,9160428,9160429,9160430,7022184,10416536,10125238,6681282,7022744,9201143,8864863,6666506,8865129,8569111,6678818,6678858,6678859,9206764,9206765,9206766,7020465,10471550,9207013,8916784,8916791,8916893,10123470,9191285,10115663,9207588,9199752,9199753,7021444,6474118,6667837,9175854,6474192,6672107,9175924,9207951,6474279,10462568,10462659,10462660,10462661,10628084,10628085,10159720,10159721,10159722,10159723,10159724,10159725,10159726,10893820,10893821,10893822,10893823,10893824,10909148,8594525,10170713,10629348,10894875,10875178,10875204,10875205,10875206,10875207,10915349,10915350,10915351,10915352,10915353,10915354,10915355,10915356,10915357,10915358,10912689,10912690,10912691,10153926,10153927,10153928,10153929,10153930,10153931,10153932,10153965,7001325,7001326,10913346,10913348,10179426,10893432,10172038,10891163,10891164,10891165,10891166,10891167,10891168,10187351,10187352,10187353,10187354,10187355,10187356,10177505,10177506,10177673,10177674,10945165,10945166,10945181,10945182,10643496,10643497,10643498,10643499,10643500,10643501,10643516,10643517,10643518,10643519,10643520,10643521,10602350,10602378,10602379,10602380,10602381,10602382,10602383,10602384,10602385,10602386,10602387,10602388,10602389,10602390,10602391,10602392,10583744,10583745,10650060,10587432,10587433,10653716,10653717,10653718,10584744,10584745,10653906,10581979,10582232,10573351,10573352,10570483,10651984,10543322,10545435,10545436,10545437,10545438,10545439,10545440,10529518,10529964,10529965,10529966,10529967,10529968,10529969,10522708,10538762,10424469,10424553,10423829,10423882,10483098,10483102,10496472,10475654,10475655,10487113,10495156,10412547,10407207) 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>