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(10861765,10846416,10846417,8631496,8631506,8631624,8631625,8631662,8631719,8631721,8631725,8631728,8631856,8631857,8631858,8067396,10951118,8632439,8632440,8632443,8632444,8632447,8632448,8632451,8632454,8632457,8632460,8632528,10860243,10860245,8629610,8629714,8629718,8629731,8629732,8629733,8629734,8629735,8629736,8629765,8629769,10860453,8629811,10860478,10860518,8629956,8629957,10872808,10872809,10872810,8620591,9214418,8630482,8630483,8559041,7201382,7201386,8627795,8627796,8627797,7201399,8627801,8627802,7201406,7201413,7201415,7201420,7201424,7201426,7201427,7201431,7201434,7201444,7201453,7201454,10866548,8627943,8627945,8627946,8627948,8627949,8627951,8627952,8627953,8627954,8627955,8627956,8627957,8627958,8627959,8627960,8627961,8627962,8627963,8627964,8627965,8627966,8627967,8627968,8627969,8627970,8627971,8627972,8627973,8627974,8627975,8627976,8627977,8627978,8627979,8627980,8627981,8627982,8627983,8627984,8627985,8627986,8627987,8627988,8627989,8627990,7201607,8628035,8595078,10858908,10858909,10858910,10858912,10858913,10858916,8065807,8628490,8628491,8065823,8628492,8628493,8628627,8628655,8628656,8628657,8628658,8628659,8628660,8628670,8628671,8628720,8628731,8628732,8628736,8628737,8628738,8628739,8628741,8628742,8628743,8628744,8628745,8628746,8628747,8628748,8628749,8628750,8628795,8628796,8629092,9794594,8629244,8629355,8629364,8629365,8629366,8629369,8629370,8629371,8629372,8629373,8629374,8629376,8629377,8629467,10997827,10997830,10997831,10997832,10997833,10997834,8626816,8626817,10857503,10857555,10857556,10857559,7200603,8625060,10863911,10863973,8625419,8625531,10840845,8625779,8625879,8626071,8626072,8626073,8626074,8626075,8626076,8626099,8626104,11048405,8626260,8626514,8626515,10865158,10865159,8612906,8612910,3923478,10967777,10967778,7197941,8624376,8624380,8624381,8624496,8624497,8624502,8624503,8624504,8624505,8624507,8624508,8624512,8624522,8624525,8634658,8634659,8634660,8634661,8541715,8634966,8634967,8634968,8634969,8634970,8634971,8634972,8634973,8634974,8634975,8634976,8634977,8634978,8634979,8634980,8634981,8634982,8634983,8634984,8634985,8634986,8634987,8634988,8634989,8634990,8634991,8634992,8634993,8634994,8634995,8634996,8634997,8634998,8634999,8635000,8635001,8635002,8635003,8635004,8635005,8635006,8635007,8635008,8635009,8635010,8635011,8635012,8635013,8635014,8635015,8635016,8635017,8635018,8635019,8635020,8905711,8632590,8632591,8632592,8632593,8632594,8632595,8632598,8632599,8632600,8632601,8632695,8632696,8632697,8632698,10620079,10620080,10620081,10620082,8632711,8632712,8632713,8632714,8632716,8632717,8632718,8632720,8632721,8632722,8632723,8632724,8632726,8632727,8632728,8632729,8632796,8632797,8632798,10847941,8632853,8632894,8632895,8632896,8632897,8632898,8632899,3581878,8633344,10615780,8634199,8634200,8634201,8634202,8634203,8634204,8634205,8634206,8634207,8634208,8634209,8634210,8634211,8634212,8634213,8634214,8634215,8634216,8634217,8634218,8634219,8634220,8634221,8634222,8634223,8634224,8634225,8634226,8634227,8634228,8634229,8634230,8634231,8634232,8634233,8634234,8634235,8634414,8634565,8634568,8634570,10559709,8542551,9211413,10612134,10612135,10612136,10612137,10119687,10119688,8851764,8851765,7058800,7058801,10613506,10613513,10613514,10613545,10610709,10610873,10610874,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,10517791,10517792,10517793,10517794,10517795,10517796,10517797,9912193,7056160,9912571,10419469,10415614,9190669,9916877,9175807,9175808,8917848,9184258,9184261,10175153,10175160,10890006,10171166,10630189,10630190,10630191,10162864,10580128,10580129,10580130,10580131,10522165,10522166,10522167,10522170,10522173,10522174,10522175,10522176,10522178,10522179,10522180,10522181,10522188,10522189,10522190,10522191,10522192,10522193,10423738,10423739,10423740,10413429,10413430,10413431,10413434,10413437,10486795,10414738,10414757,10414758) 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>