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(10930262,10930263,10846016,10846017,8621152,8621153,8621154,8621155,7074130,7074131,7074132,7074133,7074134,7074135,7074136,7074137,8067541,8584121,8584187,8584188,8584189,8575918,8575927,11039889,8620204,8620205,8620206,8620207,8620208,8620209,8620210,8620211,8620212,8620213,8620214,8620215,8620216,8620217,8620644,8620645,8620646,10998687,10998688,3899542,8066200,5654812,10932851,10867967,8629386,8629387,8629389,8629390,11036890,11036891,11036892,11036893,11036894,11036895,4430397,4430398,4430399,11034948,11034949,11034950,11034951,11034952,11034953,11034954,11034955,11034956,11034957,11034958,11034959,11034960,11034961,11034962,11034963,11034964,11034965,11034966,11034967,11034968,11034969,11034970,11034971,11034972,11034973,11034974,11034975,11034976,11034977,11034978,11034979,11034980,11034981,11034982,11034983,11034984,11034985,10942287,11048804,10980722,10980723,10980724,10980725,10980726,10980727,10980728,10980729,10980730,10980731,10980732,10980733,7157016,10618944,10618945,10618946,10618947,10618948,8624474,8624475,8624476,8624477,8624478,8624479,8624480,8624481,8624482,8624483,8624484,8624485,8624486,8624487,8624488,8624495,10922475,9217061,9217062,9217063,9217064,10952622,10921545,10921546,10921547,10921548,10921549,10921550,10921551,10921552,10921553,10921554,10921555,8540674,8540675,10426783,10426784,10426785,10426786,10426787,10426788,10426789,9205300,9205301,9205317,9179610,9204367,9204368,9204369,9204370,9204371,9204372,9204373,9204374,9204375,9204376,9204377,9204378,9204379,9204380,9204381,9204382,9204383,9204384,9204385,9204386,9204387,9204388,9204389,9204390,9204391,9204392,9204393,9204394,9204395,9204396,9204397,9204398,9204399,9204400,9204401,9204402,9204403,9204404,9204405,9204406,9204407,9204408,9204409,7058754,9172889,7023563,7023564,7023565,7023566,7023567,7023568,7023569,7023570,7023571,7023572,7023573,10513753,7023625,6674532,6674555,10124533,10418503,6680885,6680886,6680887,6680888,6680889,6680890,6680891,6680892,6680893,4973548,6681082,6681083,6681084,9206640,9206641,9916854,9916855,9916856,9916857,9174761,9174762,10123042,976688,976689,10898542,10898543,10898544,10898545,10898546,10898547,10898548,8594455,8594456,8594457,8594458,8594459,10892958,10892959,10892960,10892961,10892962,10184137,10183382,10183383,10183384,10183385,10183386,10183387,10183388,10183389,10183390,10183391,10183392,10183393,10183394,10183395,10183396,10183397,10183398,10183399,10183400,10183401,10649820,10653207,10653208,10653209,10653210,10653211,10653212,10653213,10653214,10653215,10653373,10653374,10653375,10578543,10578544,10578545,10578546,10578547,10578548,10578549,10578550,10578551,10578552,10578553,10578554,10578555,10578556,10578557,10578558,10578559,10578560,10578561,10578562,10578563,10578564,10578565,10578566,10578567,10578568,10578569,10578570,10578571,10578572,10578573,10578574,10578575,10578576,10578577,10578578,10578579,10578580,10578581,10578582,10578583,10578584,10578585,10578586,10578587,10578588,10578589,10578590,10581774,10494233,10494234,10494235,10494236,10494237,10494238,10494239,10494240,10494241,10494242,10494243,10494244,10494245,10494246,10494247,10494248,10494249,10494250,10494251,10494252,10494253,10494254,10494255,10494256,10494257,10494258,10494259,10494260,10494261,10494262,10494263,10494264,10494265,10494266,10494267,10494268,10494269,10494270,10494271,10494272,10494273,10494274,10494275,10494276,10494277,10494278,10494279,10494280,10494281,10494282,10494283,10494284,10494285,10494286,10494287,10494288,10494289,10494290,10494291,10473775,10473776,10473777,10473778,10473779,10473780,10473781,10473782,10473783,10473784,10473785,10473786,10473787,10473788,10473789,10473790,10487200,10714906,10476838) 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>