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(10861446,10861447,10861448,10849558,10849559,10849560,10849561,10849562,10849583,10849586,10849588,10849589,10849590,10849592,10860277,10861122,10861131,10861137,10861139,10861147,10861148,10861163,10861164,10861165,10861166,10861167,10861168,10861169,10861170,10861181,10861182,10861183,10861190,10861191,10861192,10861193,10861194,10861195,10861196,10861197,10861198,10861199,10861200,10861201,10858826,10858827,10858828,10858829,10858830,10858831,10858832,10858835,10858837,10859168,10859169,10859170,10859171,10859172,10859173,10859174,10859176,10859182,10933036,10855400,10855401,10855403,10855404,10855405,10855406,10855408,10855409,10855440,10855444,10855449,10855451,10855452,10855454,10855456,10855457,10855461,10864198,8073547,10855007,10855008,10855009,10855010,10855011,10855149,10855150,8905071,10852704,10852705,10850614,10850615,10850616,10850617,10850618,10850619,10850620,10850621,10850804,10850805,10850806,9217250,9217252,10615916,9205439,10614864,10609983,10609984,10609985,10609986,10609987,10610162,10610163,9911847,9911899,8593099,8593100,8593102,8850127,10118650,10118662,10118663,10118664,10417534,9916970,9916971,9916974,9916977,9916978,9916979,9916980,8549953,8551009,8551010,8551011,8551014,9167859,9167860,9167861,8551017,10116195,10116196,10116197,10116198,10184490,10184491,10184492,10184514,10184539,10184540,10184544,10184545,10184546,10184556,10184571,10184574,10184575,10184589,10184593,10184604,10879920,10883238,10883239,10883240,10161838,10161839,10507577,10413376,10413378,10490279,10490280,10490289,10490304,10490305,10413660,10413662,10473658,10408034,10408035,10408036,10490864,10410220,10410221,10410222,10490878,10410223,10410224,10410225,10490884,10490885,10490906,10490909,10490912,10490918,10490924,10490937,10490938,10490951,10490965,10490978,10490979,10410344,10410345,10491003,10491004,10491017,10491030,10491031,10491056,10491062,10491063,10491071,10491072,10491073,10491089,10491107,10491108,10491114,10491119,10491120,10491121,10491129,10410579,10410580,10410581,10410582,10410583,10410584,10410585,10410586,10474255,10474258,10474266,10474267,10474268,10474269,10474270,10410615,10410619,10410624,10410625,10410627,10410628,10410630,10474286,10410632,10410633,10410635,10474294,10474297,10474308,10474309,10474310,10474315,10474332,10474333,10474334,10474348,10474353,10474361,10474362,10474383,10474384,10474406,10474407,10474422,10474438,10474443,10474444,10474454,10474455,10474456,10474464,10474465,10474487,10474504,10474505,10474512,10474526,10474527,10474552,10474556,10474564,10474572,10474573,10474574,10474591,10474595,10474596,10474597,10474598,10474607,10409099,10409100,10409101,10415127,10415129,10415135,10415141,10407142,10415143,10407143,10407144,10407145,10407146,10407147,10415150,10415151,10415161,10415162,10415163) 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>