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(10943596,10943597,10943598,10943599,10943600,10943601,10943602,10943603,10943604,10873668,10873675,8569409,8569410,8569411,10940229,9215702,9215703,10868462,8583706,8622178,8622182,8575626,8609687,10460473,10460474,10460482,10460487,10460491,10460494,10938674,10938675,10961803,10961804,10961805,10961806,7064334,7064335,8559481,8836227,10999590,10999591,10999592,10999593,10999594,10999595,10999596,10999597,10999598,10999599,10999600,8065916,8628873,7202487,7202488,8628955,10928856,8560574,10859934,4967873,4967874,4967875,4967876,4967877,4967878,4967879,4967880,4967881,4967882,4967883,4967884,10961363,8560736,8560794,11036733,8626755,8626993,8626994,8064557,8064558,8064559,8064560,8064561,8064562,8064563,8064564,8064565,8064566,8064567,8064568,8627339,7201001,8970193,10944479,10944480,10944481,10944482,10100250,10100251,3235663,8563980,8563981,8563982,8563983,8563984,8563985,8563986,8563987,8563988,8563989,8563990,8563991,8563992,8563993,10863670,10863721,8615318,3926056,8564776,8564777,10864429,8616193,8834216,8834217,8909853,8909854,10918581,10918582,10918583,10918584,10918585,10968117,8613299,10994800,10994945,10994946,10994947,10994948,10839261,10839262,8624496,11044625,11005709,8541608,8541610,10837032,10837033,10837034,10917877,10917878,10917879,10917887,10917888,11045063,11045064,3922869,3922870,3922871,3922872,10617523,10460508,10460509,10460510,10620103,10620104,10847873,10615178,10850444,10850445,10850446,10850447,10850448,10850449,10850450,10425537,10425538,10425539,10951878,10951880,10951881,10951882,3231046,11043312,10620798,10620799,10620800,10926336,10615870,7154522,8540627,10426611,10991962,10991963,8904419,8634343,10953501,10953502,10953503,10953504,10953505,10953506,8552848,3232337,7059849,9174118,9190167,3962517,3962518,9171600,10120113,10120114,10612650,10613109,10610167,10610168,10610295,9915154,9915155,8567749,9177382,9177383,9177384,8592689,8551560,2809144,8565724,8565725,8565726,8565727,8565728,8565729,8565730,8565731,9211273,9211274,9211275,9211276,6680751,9200806,9200807,9200808,10417740,9161219,9161220,9161221,9161222,9161223,9161224,9161225,9161226,10417188,6678607,6670720,6670721,6670722,9916732,8854373,8854375,6666756,10463381,10463382,10463383,10463384,10463385,10463386,10463387,10463388,10463389,4971861,8917161,10116033,10116034,10116035,10116036,9208035,9208110,6668124,10946326,10946327,10946328,10946329,10946330,10946331,10946332,10946333,10946334,10946335,10946336,10914333,10914334,10914335,10914336,10914337,10914343,10914344,10914345,10914346,10914347,10914348,10914349,10914350,10155436,10155437,10155438,10155439,10155440,10155441,10155442,10904837,10904838,10904839,10904840,10904841,10904843,10915038,10892490,7000690,7000691,10632044,10158607,10158608,10158609,10158610,10158611,10158612,10158613,10158614,10903129,10171562,10171563,10171564,10171565,10171566,10171567,10167563,10876618,10876619,10876620,10876621,10876622,10876623,10876624,10876625,10876626,10876627,10876628,10876629,10876630,10876631,10876632,10876633,10906651,10906652,10631726,10631727,10631728,10589530,10598888,10599141,10644260,10644261,10644262,10644263,10644264,10644265,10644266,10644267,10644268,10644269,10644270,10644271,10647597,10650785,10650786,10650787,10650788,10650789,10650790,10650791,10650792,10650793,10650794,10603620,10603621,10603622,10603623,10603624,10603625,10603626,10603627,10603628,10603629,10603630,10603631,10603632,10603633,10603634,10603635,10603636,10603637,10603638,10603639,10603640,10603641,10603642,10603643,10603644,10603645,10603646,10603647,10645267,10645268,10645269,10645270,10645271,10604480,10648976,10519138,10548095,10528141,10424320,10424326,10505349,10505350,10508021,10508022,10508023,10508024,10407797,10407798,10407799,10481460,10414329,10495573,10478872,10478873) 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>