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(10861416,10861420,10861449,10861915,3229167,10862901,10860261,10860262,10860263,10860264,10860265,10860267,10860268,10860384,8573321,10860432,10860445,10860455,10860456,10860457,10860561,10860716,10860884,10860947,10860948,10860949,10860950,7201273,7201274,7201277,3238519,7201448,7201449,10866550,10866551,10866552,10866553,10866554,10866555,10866672,10866673,10866674,10866675,10866676,10866677,10866678,10866679,10866680,10866681,10866683,10866684,10866685,7201840,10859577,10865311,10865904,10865910,7201073,7201074,7201075,10866131,10866134,10855306,7198677,7198750,7198766,10863920,10863921,10863922,10864491,10864492,10864493,10864494,7199568,7199569,7199570,10864711,10864992,10864993,10864994,10865010,10865056,10857098,10857099,10857103,10857110,10853257,3923406,10853375,3923554,10853738,10853739,8906548,8906550,10854137,10854314,10854323,10854380,10854381,10854382,10854383,10854384,10854385,3234864,3234865,7197885,7197886,7198127,7198128,10855183,8634673,8634674,8634675,8905826,8632686,8632687,8632688,8632689,3230572,10615401,10615403,10615582,10615695,10615724,10615760,10615765,10851036,10615775,10615776,10615777,10615778,10615779,10851061,10851076,10851080,10851081,10851082,10851083,10851084,10851085,10851087,10851088,10851089,10851090,10851092,10851095,10851096,10615905,10615906,10615907,10615915,10615916,10615917,10615918,10615919,10615920,10615971,10615972,10616003,10616004,10616087,8611449,6669823,7016989,7016990,7016991,7016992,7016993,7016994,7016995,7016996,10612294,8851583,7017673,7017674,7017675,7017676,7017677,7017678,7017679,7017680,7017681,7017682,7017683,7017684,7017685,7017686,7017687,7017688,8566536,7017689,7017690,7017691,7017692,7017693,7017694,7017695,7017696,7017697,7017698,7017699,7017700,8851871,7017785,7017786,7017787,7017788,7017789,7017790,7017791,8851990,8566712,8852135,8852136,8852392,8852525,10613653,10610790,9169394,6673700,9911721,9169548,9169558,9169563,9169578,9169611,9169612,9169632,9169693,7015486,7015487,7015488,7015489,7015490,7015491,7015492,7015493,7015494,7015495,7015496,7015497,7015498,7015499,7015500,7015501,7015502,7015503,7015504,7015505,7015506,7015507,7015508,7015509,8849708,8849710,8849712,6674179,9912225,8849917,10118412,10118433,8850120,8850122,8850123,8850124,8850125,8850126,10118499,8850127,10118500,10118501,10118502,8850138,8850139,8850140,8850141,8850142,8850143,8850144,8850145,8850147,8850148,8850322,8850323,8850324,8850325,8850326,8850327,8850328,8850329,8850330,8850331,8850332,8850333,8850334,8850335,8850336,8850337,8850338,8850339,8850340,8850341,8850342,8850343,8850344,8850345,8850346,8850347,8850348,8850349,8850350,7016269,7016270,7016289,7016290,7016291,7016292,7016293,7016294,7016297,7016298,7016301,7016302,7016303,7016304,7016305,7016306,9912944,9912970,9913116,8552220,9913184,9168327,10418284,10418300,10418301,10418341,10416470,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419551,10419552,10419553,10419554,10419558,10419559,10419560,10419561,10418620,7014456,7014457,7014458,7014459,7014460,7014461,7014462,7014463,7014464,7014465,7014466,7014467,7014468,7014469,7014470,7014471,7014472,7014473,7014474,7014475,7014476,7014477,10417801,10417802,10417803,10417804,10418036,10469326,8549966,8550093,8550094,10470164,9167932,9167975,10470657,10470658,10888584,10888644,10888657,10888669,10888738,10888739,10888759,10888780,10888838,10888841,10888930,10888931,10888932,10888933,10888946,10888947,10888975,10884016,10884017,10884018,10889051,10884422,10884426,10884427,10884428,10884642,10884643,10884654,10889664,10889761,10889762,10889977,10887908,10887961,10887964,10886057,10162119,10162169,10886446,10604430,10508199,10508332,10508333,10508449,10507607,10409448,10409536,10411937,10411941,10411948,10414017,10410108,10410109,10410110,10410111,10410112,10410113,10408153,10410367,10482596,10414952) 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>