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(3229009,3229010,3229011,3229012,10862772,10862773,10862774,10929241,8595038,8595039,8595296,10858947,8065795,7202681,10865383,10959260,10866119,10866123,10866124,10866125,10931197,10866175,10866186,10866187,10855459,10101205,7199407,7199408,7199416,10101451,10101452,10101453,10101454,10101455,10101555,8626239,8626243,3923394,3923395,3923396,3923397,8554290,10853668,10853669,7197131,7197132,7197133,10854285,10854286,10854287,10854288,10854289,10854290,10854291,10854292,10854293,10854294,10854295,10854296,10854297,10854298,10854299,10854300,10854301,10854302,10854303,10854304,10854305,10854306,10854307,10854308,10854309,10854310,10854311,10854312,10854313,10854314,10854315,10854316,10854317,10854318,10854319,10854320,10838833,10617346,10615232,10850670,3581860,3581861,3581862,10426207,10616092,10616175,8611353,8611354,8611355,8611356,8611401,8611402,10616842,10616913,8904952,8904953,10614050,10611062,10611063,10614588,10614632,10611856,8549450,10609286,8566534,8566535,10609718,10609719,10609720,10609721,10609722,10609723,10609724,10609725,10609726,10609727,10609728,10609729,10609730,10609731,10609732,10609733,10609734,10609735,10609736,10609737,10609738,10609739,10609740,10609741,10609742,10609743,10609744,10609745,10609746,10609747,10609748,10609749,10609750,10609751,10609752,10609753,10609754,10609755,10609756,10609757,10609758,10609759,10609760,10609761,10609762,10609763,10609764,10609765,10609766,10609767,10609768,10609769,10609770,10609771,10612982,10613262,10613693,9169448,9911751,9911752,9911753,9911754,9911755,9911756,9911757,9911758,9911759,9911760,9911761,9911762,9911763,9911764,9911765,9911766,9911767,9911768,9911769,9911770,9911771,9911772,9911773,9911774,9911775,9911776,9911777,9911778,9911779,9911780,9911781,9911782,9911783,9911784,9911785,9911786,9911787,9911788,9169692,10118029,10118269,8850095,8850096,8850097,8850098,8850099,10118826,8552173,9913288,10419254,9160375,10419299,6672591,6672592,6672593,6672594,10416336,10416337,10416338,10418682,10117486,10117487,10469109,10469110,8549931,8549932,8549933,8549934,10467559,10467560,10467561,10467562,10467563,10467564,10467565,10467566,10467567,10467568,10467569,10467570,976428,976429,9167793,9167794,9167795,9167796,9167797,9167798,9167799,9167800,9167801,9167802,9167803,9167804,9167805,9167806,9167807,10427631,10889232,10889982,10885415,10882691,10882692,10882693,10882694,10882695,10882696,10882697,10882698,10882699,10882700,10882701,10882702,10882703,10882704,10882705,10882706,10882707,10882708,10882709,10882710,10882711,10882712,10882713,10882714,10882715,10882716,10882717,10882718,10882719,10882720,10882721,10882722,10882723,10882724,10882725,10882726,10882727,10882728,10882729,10882730,10882731,10882732,10882733,10882734,10882735,10882736,10882737,10882738,10882739,10882740,10882741,10882742,10882743,10882744,10882745,10882746,10882747,10882748,10882749,10882750,10882751,10882752,10882753,10882754,10882755,10882756,10882757,10882758,10882759,10882760,10882761,10882762,10882763,10882764,10882765,10882766,10882767,10882768,10882769,10882770,10882771,10882772,10882773,10882774,10882775,10882776,10882777,10882778,10882779,10882780,10882781,10882782,10882783,10882784,10882785,10888281,10627771,10161817,10647340,10647341,10647342,10647443,10647444,10590577,10603654,10603655,10603658,10604042,10413462,10409686,10409687,10410039,10410040,10410041,10410042,10410043,10410044,10410045,10410046,10410047,10410048,10410049,10410050,10410051,10410052,10410053,10410054,10410055,10410056,10410057,10410058,10410059,10410060,10410061,10410062,10410063,10410064,10489181,10489182,10489183) 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>