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(8630632,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630643,8630649,8630650,8630651,8630652,8630653,8630654,10861361,10861365,8630935,10861599,10861604,10861606,10862613,10862615,10862616,10863023,8629590,8629597,10860286,8629732,8630179,8630181,8630183,8630185,10861050,7201307,7201333,7201334,7201399,7201401,7201402,7201403,7201452,10866563,10866564,10866567,10866568,10866571,10866573,10866577,10866579,10866580,10866583,10866588,10866590,10866597,10866599,10866603,10866605,10866607,10866609,10866789,10866790,10866791,10866797,10866798,10866799,10866800,10866801,10858822,10858823,10858824,10858959,8628475,8628476,8628477,8628478,8628479,8628480,8628481,8065838,8065839,8065840,10859207,8628632,8629547,8629548,8629549,8629550,8626835,8626836,8626837,8626838,8626839,8627010,8627050,8627051,8627052,8627053,8627071,8627072,8627073,8627074,8627075,8627076,8627077,8627078,8627079,8627080,8627081,8627082,8627083,8627084,8627085,8627086,7200699,7200707,10865791,10866055,10866175,8624928,8624929,8624930,8624931,8624932,8624933,8624934,8624935,8624936,8624937,8624938,8624939,8624940,8624941,8624942,8624943,8624944,8624945,8624946,8624947,8624948,8624949,8624950,8624951,8624952,8624953,8624954,8624955,8624956,8624957,8624958,8624959,8624960,8624961,8624962,8624963,8624964,8624965,8624966,8624967,8624968,8624969,8624970,8624971,8624972,8624973,8624974,8624975,8624976,8624977,8624978,8624979,8624980,8624981,8624982,8624983,8624984,8624985,8624986,8624987,8624988,8624989,8624990,8624991,8624992,8624993,8624994,8624995,8624996,8624997,8624998,8624999,8625000,8625001,8625002,8625003,8625004,8625005,8625006,8625007,8625008,8625009,8625010,8625011,8625012,8625013,8625014,8625015,8625016,8625017,8625018,8625019,8625020,8625021,8625022,8625023,8625024,8625025,8625026,8625027,8625028,8625029,8625030,8625031,8625032,8625033,8625034,8625035,8625036,8625037,8625038,8625039,8625040,8625041,8625042,8625043,8625044,8625045,8625046,8625047,8625048,8625049,8625050,8625051,8625052,8625053,8625054,8625055,8625056,8625057,8625058,8625059,10857104,10857105,10857106,10857107,10857108,10857109,10857110,10857111,10857140,10857141,10857162,10853260,10853261,10853354,10853355,10853356,10853357,10853358,10853359,10853411,10853465,10853466,10853491,3923602,3923604,3923606,8554369,10853729,10853730,10853767,10853770,10853771,10854123,10854124,10838893,10838942,8907473,8624459,10852613,10853153,10614996,10614999,10615000,10615202,10850587,10851040,10616070,10616092,10426454,10616175,10852045,10852048,8634441,8634442,8634443,8634444,8904919,10616888,10616913,10614050,10611126,10614166,10614524,10559708,10559710,10614588,10614632,10611856,10612168,10612169,10612273,10612315,10609350,10609367,10609394,10609395,10609396,10609824,10609965,10610006,10613378,10610709,10610942,10610958,9911548,9169393,9911603,6673774,6673775,6673778,6673779,6673781,6673782,6673784,6673785,6673786,6673789,6673791,10118044,10118263,10118290,9912934,9912944,8850577,10416256,10416258,10416259,6672564,10419472,10419474,10419476,10419477,10419481,10419483,10419486,10419488,10419490,10419492,10419653,10419654,10419655,10419661,10419662,10419663,10419664,10419665,8550126,8550127,8550128,8550129,9167680,10884336,10885103,10885313,10887870,10886068,10607651,10508267,10508268,10508269,10507811,10413371,10413372,10409747,10409748,10411942,10411943,10411944,10411945,10411946,10411947,10411948,10411949) 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>