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(10845677,7067960,7067961,7067962,7067963,7067964,10939905,10939907,11014896,11015005,8583103,9215335,11041555,11015608,11015609,11015610,11015611,10862333,8631794,10849681,10849686,10849717,10849719,10849751,8622302,11016221,11016222,11016223,3229968,7074609,8609604,9216432,9216433,8560940,8629656,10844771,7075186,7075202,8561157,8561161,8620550,7067767,8910979,10985665,7072294,8559477,8559566,11012351,11012358,8595335,7201965,8628410,4967103,8559765,10999582,10999583,10999614,10999615,6665680,8560317,11000202,10961339,10961340,7073771,8063996,8063997,8063998,10857287,10943264,11011483,11011484,11011485,8563622,8563623,8563624,8563625,7069229,3235743,8615177,8615178,10840930,8616307,10856797,11010294,11010297,10618002,10618003,10618197,8612976,10968091,10968092,3233911,3233921,3924131,3924135,3924137,8907012,10920012,10839180,10839440,10839441,10839442,10966666,10966667,10966668,10966669,10836877,10927880,10927884,10927885,11006062,11006063,10954202,10460507,10425382,10425383,10615185,10615186,10615187,10615188,10615189,10615190,10615191,10615192,10615193,10615194,10926142,10848457,10848458,9217738,10952862,10952863,10952873,10952874,10952875,10952876,10952877,10952878,10952879,10952880,10952881,10952882,10952883,10952884,10952885,10952886,10952887,8540721,8540722,8540785,9189351,9915752,9205775,6670007,6670008,6670009,6670010,6670011,6670012,10559749,3962370,9211370,9211442,9211794,9211973,9220272,10564426,10564427,8863193,9205011,10610958,10513328,10513329,9201538,9161547,6673814,10125929,8551347,8551348,4975074,4975233,3651726,9186535,9186536,6674818,10118917,8861565,10518858,10518859,10518860,10518861,9171127,9160434,9160435,9160437,9160438,9160439,9160440,9160441,9160442,10116705,9192539,9192540,9200895,10416003,10416004,9201149,4974021,4974022,4974023,8864963,10123234,8563199,10115667,9207644,10462394,9199903,10462668,10462669,10462670,10462689,10462690,10462691,10462692,10462693,10462694,10462695,10462696,10462697,10462698,10462699,10462700,10462701,10462702,10462703,10462704,10462705,10462706,10462707,10462708,8917838,10159527,10893833,10893834,10893835,10893836,10893837,10893838,10893839,10883972,10883973,10883974,10875210,10875211,10875212,10915389,10915390,10915391,10626966,10153975,10153976,10153977,10153978,10153979,10153980,10153981,10153982,10153983,10153984,10153985,10153986,10153987,10153988,10890774,10172039,10891096,10187554,10187587,10177714,10177734,10177735,10187880,10877187,10945192,10945193,10945194,10945195,10945196,10945197,10643523,10643524,10643525,10643526,10643536,10589546,10589547,10602397,10589548,10602398,10589549,10602399,10589550,10589551,10589552,10589553,10602468,10602469,10602470,10602471,10602472,10644590,10644591,10644592,10584783,10651362,10570434,10570435,10607538,10607539,10529341,10545814,10546313,10522715,10522716,10522717,10548907,10498504,10421931,10407229,10407259,10407260,10407286,10486040,10486041,10486042,10479136,10496307,10411709,10412049,10478359,10478360,10715296) 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>