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(8838577,8838578,11001916,11001917,11001918,11001919,11001920,8838934,10861754,10861755,8621455,10940440,10940441,10940442,10940443,10940444,7068897,7068898,7068899,7068900,7068901,7068902,7068903,7068904,7068905,7068906,7068907,7068908,7068909,7068910,7068911,7068912,7068913,7068914,7068915,7068916,7068917,7068918,7068919,7068920,7068921,7068922,7068923,7068924,7068925,7068926,7068927,7068928,7068929,7068930,7068931,7068932,7068933,7068934,7068935,8622084,10950973,10951267,3230139,10964566,10964567,8561120,7075248,7067250,10845608,10845609,10843503,7072932,8560413,8560419,8596256,3927456,10102371,10102372,10102373,10102374,10102375,10102376,8617102,8617510,11011394,11011395,11011396,11011397,11011398,11011399,6000112,3238258,8555925,11035343,7198924,8615567,3236485,3236486,10856845,11010278,11010292,8554649,8554650,8613715,8613716,8613717,8613718,8613719,8613720,8613721,8613722,8613723,8613724,8613725,8613726,8613727,8613728,8613729,8613730,8613731,8613732,8613733,8613734,8613735,8613736,8613737,8613738,8613739,8613740,8613741,8613742,8613743,8613744,8613745,8613746,8613747,8613748,8613749,8613750,3924411,3924412,3924413,3924414,3924415,3924416,3924417,3924418,3924419,3924420,10619350,7156082,7156083,7156084,7156085,8579057,10921303,10921304,10921305,10921306,10921307,10921308,10921309,10978581,10978582,10978583,10978584,10978585,10978586,10978587,10978588,10978589,10978590,10978591,10978592,10978593,10978594,10978595,10978596,10978597,10978598,10978599,10978600,10978601,10978602,10978603,10978604,10978605,10978606,10978607,10978608,10978609,10978610,10978611,10978612,10978613,10978614,10978615,10978616,10978617,10978618,10978619,10978620,10978621,10978622,10978623,10978624,10978625,10978626,10978627,10978628,10978629,10978630,10978631,10978632,8610824,10616890,10616891,8567820,8567821,8567822,7027051,8853645,8853646,7024994,7025184,7025269,9172132,9172133,9172134,8566678,3653555,3653556,7058525,7018157,7026216,7018298,10613366,7026413,9164771,7026452,10564659,7026609,10564830,6677348,7018814,7026877,10555124,10555125,10555126,10555127,10555128,10555129,10555130,10555131,8592600,8592785,8592786,8592787,8592788,8592789,8592790,8592791,10517718,10517719,9209992,7023738,3285825,7023936,4975264,9178598,9178599,9178600,9178601,9178602,9178603,9178604,9178605,9178606,9178607,9178608,9178609,9178610,9178611,9178612,9178613,9178614,9178615,9178616,9178617,9178618,9178619,9178620,9178621,9178622,9178623,9178624,9178625,9178626,9178627,9178628,9178629,9178630,9178631,9178632,9178633,9178634,9178635,9178636,9178637,9178638,9178639,9178640,9178641,9178642,9178643,9178644,9178645,9178646,9178647,9178648,9178649,9178650,9178651,9178652,9178653,9178654,9178655,9178656,9178657,9178658,9178659,9178660,9178661,9178662,9178663,9178664,9178665,9178666,9178667,9178668,9178669,9178670,9178671,9178672,9178673,9178674,9178675,9178676,9178677,9178678,9178679,9178680,9178681,9178682,9178683,9178684,9178685,9178811,9178812,9178813,9178814,9178815,9178816,9178817,9178818,10119339,10119340,6672506,6672507,10467082,7020179,9174747,9174748,9174749,7020606,4971932,4971933,6473668,9207624,9207625,6474196,6474284,9208065,10116284,10116285,6672496,10169869,10169870,10169947,10169948,10909425,10155755,10155756,10155757,10155758,10155759,10155760,10155761,10155762,10155763,10158974,10158975,10158976,10158977,10158978,10158979,10158980,10158981,10158982,10949056,10187566,10172650,10172651,10172652,10172653,10172654,10172655,10172656,10172657,10896701,10631683,10631684,10631850,10608514,10583706,10583707,10605921,10603214,10644529,10584512,10584513,10584514,10644775,10650886,10585513,10585514,10527154,10527155,10527156,10527157,10527158,10527159,10527160,10527161,10527162,10551345,10523659,10523660,10523661,10527902,10510952,10495900,8562635,8562636,8562637,8562638,8563101,10489394,10489395) 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>