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(9214499,9214582,7076207,7076288,4970736,7076407,7076408,7076409,7076410,9215143,8839146,9215477,9215596,8631616,8631809,8583644,8583645,8631836,10847165,9216074,10437545,10847383,10844871,8573636,8573637,8573638,8573639,8573640,8630186,10870034,7067791,8617757,8617953,8559134,10103442,10103443,8559460,8559461,8559462,8628211,10103928,8628721,8628722,8628723,8618925,8618926,7065327,8619207,5654788,5654789,5654790,5654791,5654792,10844228,8837046,8629251,8629253,10844368,8629264,8629265,7073634,7073635,8626517,8626522,8558363,7071545,11011270,11011271,11011272,11011273,11011274,11011275,11011276,11011277,11011320,7200920,10998387,10998388,10842491,10842493,10839618,11047579,11047580,11047581,11047582,11047583,10944789,8625210,8625211,8625214,8625247,8625380,8625617,8564730,8564731,8564732,7199393,7199412,10101338,10841065,10841066,10841067,10841068,8565096,8565097,8565098,10967914,10967915,10967916,10967917,10967918,11007078,3924079,7157475,8554976,8614210,8624280,8624281,8624282,8624283,8624284,8624285,8624286,8624287,8624288,8624289,8624290,8624291,8624292,8624293,8624294,8624295,8624296,3925178,8611858,8611860,11044919,8541879,8541880,8635056,8635057,8635058,8635059,8635060,8635061,8635062,3923148,9216474,8570063,8632808,8570178,10848123,8570526,10991458,10848586,10848587,9217582,9217583,9217586,9217587,9217588,9217589,9217590,9217591,9217592,9217593,9217594,9217690,9217691,10952732,10952749,9218156,3232021,3232022,8634408,9915508,9915509,9915510,9915511,9915512,9915513,9915514,9915515,9915516,9915517,9915518,9915685,9915686,9915687,9915688,9915689,9915690,9915691,9915717,9915718,9915719,7059765,7059768,7059769,7059770,7059771,7059772,7059777,10559427,9189621,9166009,9198160,9214248,9214249,9214250,9214251,9214252,9214253,9214254,9214255,9190256,9214256,9214257,9214258,9214259,9214260,9214261,9214262,9214263,9214264,9214265,9214266,9214267,9214268,9214269,9214270,9214271,9214272,9214273,9214274,9214275,9214276,9214277,9214278,9214279,9214280,9214281,9214282,9214283,9214284,9214285,9214286,9214287,9214288,7057601,9171648,10563571,7058094,7058151,7058313,10561094,10561095,10561096,10561097,10561098,10561099,10561100,10561101,10561102,10561103,10561104,10561105,10561106,10561107,9212301,9212302,9212303,9212304,9212305,9212306,9212307,9212308,9212323,9212324,7058653,7058654,7058655,8567054,9196758,9196759,10558614,10558615,10558616,10558617,9915446,9915447,4975294,10427694,9176428,7054878,7054900,7055260,7055364,6666528,6666549,9199329,6667407,6667412,9207484,8550901,8917520,10124083,10124084,10124085,10124086,10124087,10124089,8917690,9184053,9176082,976128,10628224,10628420,10175182,10628721,10628875,10628892,8069046,10899939,10629455,10629456,10629457,10629458,10629459,10629460,10629461,10629462,10629463,10629464,10629465,10629466,10629467,10629468,10629469,10629470,10632310,10632311,10632312,10632313,10912838,10601344,10601345,10601346,10601347,10601348,10601349,10601350,10601351,10601352,10601353,10601354,10601355,10601356,10601357,10601358,10601359,10601360,10601361,10601362,10601363,10601364,10601365,10601366,10601367,10601368,10601369,10601370,10601371,10601372,10601373,10601374,10601375,10601376,10601377,10601378,10601379,10601380,10601381,10601382,10601383,10601384,10601385,10601386,10601387,10601388,10601389,10601390,10601391,10601392,10601393,10601394,10601395,10601396,10601397,10601398,10601399,10601400,10601401,10601402,10601403,10568522,10568523,10568524,10568525,10568526,10568527,10568528,10568529,10568530,10568531,10568532,10567496,10498448,10488155,10488156,10488157,10488158,10488159,10488160,10488161,10488162,10488163,10488182,10488282,10493384,10493385,10493386,10493387,10493388,10493389,10493390,10493396) 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>