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(8630635,10861747,8631120,8631121,3229077,3229110,10860390,8629930,8630134,8630166,8630167,8630169,10447545,8630420,10861142,10861143,10861144,10861145,10861172,10861173,10861174,10861175,10861176,10861177,10861178,10861179,10861180,7201309,8628118,8628119,8628148,10866922,10866923,10866924,10866925,10866927,10866928,7201902,8628667,10859368,5654555,10859536,10857444,10857452,10857461,10857462,10857463,10857464,10857465,10857468,10865575,10865577,10865580,10865581,10865585,10865589,10865590,10865594,10865597,10865599,10865603,10865604,10865606,10865608,10865610,10865612,10865614,10865616,10865618,10865621,10865623,10865624,10857625,10865626,10857626,10865630,10857631,10865631,10865633,10857639,10857640,10857653,7200753,10857803,10857804,10857823,10857828,10857829,10857831,10857833,10857864,10857865,10857866,10857867,10857868,10857869,10857870,10857871,10857872,10857873,10857874,10857875,10857876,10857877,10857878,8627237,10857879,10857880,8627238,10857881,8627242,8627243,8627251,8627252,8627288,10865945,8627310,7201080,8627530,8627532,8627533,8627534,8627537,8627538,8627540,8627541,8627543,8627544,8627546,8627547,8627549,8627551,8627552,8627553,8627554,8627555,8627557,8627558,8627559,8627561,8627562,8627564,8627565,8627567,8627568,8627570,8627571,8627572,8627573,8624611,7198408,7198410,7198411,7198412,7198413,7198414,7198415,7198416,7198417,7198418,7198457,7198464,7198465,10863993,10863994,10863995,10863996,10863997,10864001,10864002,10864003,10864068,10864199,7199480,10101492,10101493,11048437,10618178,10618179,10618180,10618181,8624345,8624346,8624454,10855120,10855121,10855122,10855123,10855124,10855125,8634742,8634747,8634758,10622258,10622264,10622266,10622268,10622360,10622405,10622431,10622447,10622514,10622516,8612652,10850422,8632835,8632836,8633127,10851039,10426254,8540599,10616644,10427106,10427112,10714020,10714023,10614246,10614260,10614261,10614262,10614263,10614264,10614267,10614268,10614270,10614476,10611476,10611477,10614518,10614552,10614553,10614554,10611812,10611821,10611830,10611831,10611832,10611833,10611834,10611835,10611910,10611915,10611927,10611947,10611949,10611950,10611951,10611952,10611969,10612194,10612195,10612196,10612197,10612198,8851659,7058247,7058248,7058249,7058250,8862672,10613097,10613098,8852376,10613337,10610917,10610918,10610919,10610958,9169520,6673738,6674249,10118452,9912521,9912522,9912712,9912713,8850547,10417398,10417399,10417400,10417401,10417402,10417406,10417407,10417408,10417445,10417535,10415604,10415605,10415606,6673020,6673035,6673036,10419802,10419803,10419804,10419805,10419806,10419808,10418808,10419809,10418810,10418813,10418814,10418817,10418820,10418821,10418823,10418825,10418827,10418831,10418832,10418834,10418836,10418838,10418840,10418842,10418844,10418846,10418848,10418850,9168930,10418852,10418854,10418856,10418860,10418861,10418863,6673159,10419114,10469289,976476,10468410,10468414,10468417,10468418,10468419,10468420,10889451,10884629,10884698,10889997,7000826,10632300,10632301,10632302,10627321,10883325,10887132,10601964,10601969,10601985,10601997,10602005,10602036,10602058,10602243,10647475,10601756,10601759,10601760,10601787,10601799,10601805,10601910,10601930,10601947,10507670,10507671,10507804,10507861,10507862,10507863,10507889,10407781,10413819,10408157,10412174,10412238,10412239,10412244,10410323,10410324,10410325,10410326,10410327,10410328,10412395,10412396,10412410,10412411,10412414,10412417,10412419,10412422,10412447,10412448,10412449,10412450,10412451,10412452,10412453,10412454,10412455,10412456,10412457,10412458,10412459,10412460,10412461,10412462,10412463,10412464,10412465,10412466,10414693,10415146,10415147,10415148,10415157,10415158,10415159,10415160) 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>