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(4970746,3229053,7066010,8632289,8632291,8632296,8632299,8632306,8632310,8632313,8632321,8632323,8632325,8632329,8632333,8632338,8632344,8632348,10863118,10863119,10863159,10863160,10863161,10863162,10863163,10863164,10863165,10863166,10863167,8067913,8629712,10861075,10861076,10861079,10861080,10861081,10861082,10861084,7201272,7201562,8595267,8595268,8595269,8595270,8595271,8595272,8595273,8595274,8595275,8595276,10858985,10859075,10859076,10859077,10859078,10859079,10859080,10859081,10859082,10859083,10859084,10859085,10859086,10859087,10859088,10859089,10859090,10859091,10859092,10859093,10859094,10859095,10859096,10859097,10859098,10859099,10859100,10859101,10859102,10859103,10859104,10859105,10859106,10859107,10859108,10859109,10859110,10859111,10859112,10859113,10859114,10859115,10859116,10859117,10859118,10859119,10859120,10859121,10859122,10859123,10859124,10859125,10859126,10859127,10859128,10859129,10859130,10859131,10859132,10859133,5654604,5654605,10859566,10859567,10859568,10865515,10857578,10857579,10857582,10857583,10857586,10857587,10857589,10857590,10857592,7200705,7200761,7200762,10855305,10855306,10855307,10855308,10863488,10863489,10863491,10863493,10863494,10863495,10863497,10863498,10863499,10863502,10863504,10863505,10863506,10856507,10856508,10856509,10856510,10856511,10856512,10856513,10856514,10101477,10101505,10865175,10865177,10865178,10865179,10865181,10865182,10865183,10865184,10865185,7196198,7196219,7196221,7196253,7196381,7196383,7196428,7196451,7196452,10618303,7196905,7196907,7196910,7196911,8906738,7196963,7196968,7196969,7197054,10854888,8905298,8905299,10622283,10622284,10622285,10622286,10622287,10622288,10622289,10622290,10622291,10622292,10622293,10622294,10622295,10622296,10622297,10622298,10622299,10622300,10622301,10622302,10622303,10622304,10622306,10622307,10622308,10622309,10622310,10622311,10622312,10622313,10622314,10622315,10622316,10622317,10622318,10622319,10622320,10622321,10622322,10622323,10622324,10622325,10622326,10622327,10622328,10622329,10622330,10622331,10622332,10622333,10622334,10622335,10622336,10622337,10622338,10622339,10622340,10622341,10622342,10622461,10622466,10622467,10622468,10622469,10622470,10622471,10622472,10622473,10622474,10622475,10622476,10622477,10622478,10622479,10622480,10622481,10622482,10622483,10622484,10622485,10622486,10622487,10622488,10622489,10622490,10622491,10622492,10622493,10622494,10622495,3922861,10622496,10622497,10622498,10622499,10622500,10622501,10622502,10622503,10622504,10622505,10616062,8611341,10616549,10616550,10611179,10611180,10611181,10614220,10614887,8851209,8851333,8851374,8851387,8851388,10612261,10612262,10612263,10612264,10612265,10612266,10612267,10612268,8851458,8851479,8851547,8851555,10612424,10610305,10610862,10117738,10117739,10117740,10117939,10117940,10117941,9169748,9912100,9912101,9912102,6674108,9912290,9912291,9912292,9912293,9912294,9912295,9912296,9912297,9912298,8850779,8850796,8850822,8850827,9913214,8850832,8850856,8850866,9168483,9168484,9168485,9168486,9168487,9168488,10418488,10418490,10418492,10418493,10418495,10418496,10418497,10418498,10418499,10416667,10416668,7014428,7014429,10416709,10416710,10416711,10416712,10416713,10416714,10416715,10416716,10416717,10418866,10417017,10417019,10417021,10417023,10417026,10417027,10417029,10417030,10417031,10417034,10417036,10417037,10417038,6673330,6673331,6673332,6673333,6673334,9169233,8550032,9175178,10468501,9168155,9168156,10628150,10884272,10884273,10884274,10884275,10884276,10884277,10884278,10884279,10889432,10889433,10889434,10889473,10889474,10889475,10889476,10889477,10884633,10884979,10885020,10885021,10885022,10885023,10885024,10885025,10885026,10885027,10885028,10885029,10885030,10887564,10887565,10883355,10883356,10883357,10887072,10601871,10508567,10507594,10507920,10507921,10413488,10411543,10411544,10411545,10411546,10411547,10411548,10411549,10411550,10413576,10413577,10413578,10413579,10413580,10413581,10413582,10413583,10413584,10413585,10413586,10413587,10413588,10413589,10413590,10413591,10413592,10413593,10413594,10413595,10413596,10413597,10413598,10413599,10413600,10413601,10413602,10413603,10413604,10413605,10413606,10413607,10413608,10413609,10413610,10413611,10413612,10413613,10413614,10413615,10413616,10413617,10413618,10413619,10413620,10413621,10413622,10413623,10413624,10413625,10413626,10413627,10413628,10413629,10413630,10413631,10413632,10494361,10494362,10494363,10414004,10414005,10414006,10412204,10412205,10412208,10412209,10412212,10412213,10412215,10412216,10412218,10410486,10410487,10410488,10415087,10415088,10415091,10415092,10415094,10415095,10415098) 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>