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(10870223,10870224,10870225,10870226,10870227,10870228,10870229,10870230,10870231,10870232,10870233,10870234,10870235,10870236,10870237,10870238,10870239,10870240,10870241,10870242,10870243,10870244,10870245,10870246,10870247,10870248,10870249,10870250,10870251,10843065,8836232,8836233,8836234,8628716,11048932,3925457,3925458,10941851,10941909,10941910,10941911,10941912,10941913,10941914,10941915,10941916,10941917,10941918,10941919,10941920,10941921,10941922,10941923,10941924,10941925,10941926,10941927,10941928,10941929,10941930,10941931,10941932,10941933,10941934,10941935,10941936,10941937,10941938,10941939,7070811,7070812,7070813,7070814,10992706,10992707,10992708,10992709,10992710,10992711,10992712,10992713,10992714,10992715,10992716,10992717,10992718,10992719,10992720,10992721,10992722,10992723,10992724,10992725,10992726,10992727,10992728,10992729,10992730,10992731,10992732,10992733,10992734,10992735,10992736,10992737,10992738,10992739,10992740,10992741,10992742,10992743,10992744,10992745,10992746,10992747,10992748,10992749,10992750,10992751,10992752,10992753,10992754,10992755,10992756,10992757,10992758,10992759,10992760,10992761,10992762,10992763,10992764,10992765,10992766,10992767,10992768,10992769,10992770,10992771,10992772,10992773,10992774,10992775,10992776,10992777,10992778,10992779,10992780,10992781,10992782,10992783,10992784,10992785,10992786,10992787,10992788,10992789,3654758,3654759,3654760,3654761,3654762,3654763,10122175,10122176,10122177,10122178,10122179,7057488,7057489,8592885,9186452,9186453,9186454,9186455,9186456,9186457,9186458,9186459,9186460,9186461,9186462,9186463,9186464,9186465,9186466,9186467,9186468,9186469,9186470,9186471,9186472,9186473,9186474,9186475,9186476,9186477,9186478,9186479,9186480,9186481,9186482,9186483,9186484,9186485,9186486,9186487,9186488,9186489,9186490,9186491,9186492,9186493,9186494,9186495,9186496,9186497,9186498,9186499,9186500,9186501,9186502,9186503,9186504,9186505,9186506,9186507,9186508,10903731,10903732,10903733,10903734,10903735,10903736,10903737,7001077,7001078,10531852,10531853,10531854,10531855,10531856,10531857,10531858,10531859,10531860,10531861,10531862,10531863,10531864,10531865,10531866,10531867,10531868,10531869,10531870,10531871,10531872,10531873,10531874,10531875,10531876,10531877,10531878,10531879,10531880,10531881,10531882,10531883,10531884,10531885,10531886,10531887,10531888,10531889,10531890,10531891,10531892,10531893,10531894,10531895,10531896,10531897,10531898,10531899,10531900,10531901,10531902,10531903,10531904,10531905,10531906,10531907,10531908,10531909,10531910,10531911,10531912,10531913,10531914,10531915,10531916,10531917,10531918,10531919,10531920,10531921,10531922,10531923,10531924,10531925,10531926,10531927,10531928,10531929,10531930,10531931,10531932,10531933,10531934,10531935,10531936,10531937,10531938,10531939,10531940,10531941,10531942,10531943,10531944,10531945,10531946,10531947,10531948,10531949,10531950,10531951,10531952,10531953,10531954,10531955,10531956,10531957,10531958,10531959,10531960,10531961,10531962,10531963,10531964,10531965,10531966,10531967,10531968,10531969,10531970,10531971,10531972,10531973,10531974,10531975,10531976,10531977,10531978,10531979,10531980,10531981,10531982,10531983,10531984,10531985,10531986,10531987,10531988,10531989,10531990,10531991,10531992,10531993,10531994,10531995,10531996,10531997,10531998,10531999,10532000,10532001,10532002,10532003,10532004,10532005,10532006,10532007,10532008,10532009,10532010,10532011,10532012,10532013,10532014,10532015,10422034,10422035,10422036,10422037,10422038,10422039,10422040,10422041,10422042,10422043,10422044,10422045,10422046,10422047,10422048) 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>