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(10861548,8630945,10861704,3228910,3228987,3229183,3229184,10862875,10862876,10863209,8067906,8067910,10860307,8067911,10860694,10860695,10860957,10861064,7201387,7201578,8595045,8595055,8595056,7201698,8595115,7201791,10858960,10867284,10859468,5654600,7202654,8626971,8626990,8627050,8910470,8910471,7200660,7200661,8627111,8627112,8627113,10857812,10865892,10865948,10102857,10866059,7201106,10855273,7198348,7198433,7198476,7198706,7198733,10863806,10101205,10856612,10856636,10856641,10856642,10856643,8557335,10856691,10856692,10856715,10856716,10856749,10856750,3927266,10857171,3237338,10853272,10853273,10853460,10853638,10853744,10853819,10853918,10853919,10853952,8906759,10853992,10853993,10854139,10854140,7197139,10854203,7197208,10854417,8907418,8907458,3235104,3235105,8552913,10622199,8905467,8905537,8905859,3923241,10425586,10850511,10850512,10850519,10850520,10615317,10615862,10426215,10616073,10616304,10616608,10616790,10616794,10616795,10953529,8904990,10614094,10611179,10614472,10614486,9166043,10611774,10614821,10611850,10611852,10611878,10611880,10611955,10611971,10612009,10612039,10612050,10612077,8851248,10612088,10612172,10612173,10612178,8851400,8851405,10609285,10609296,10609297,10609298,10609339,10609340,8851505,8851564,10612481,8851647,10609496,10609505,10612552,10612554,10609562,10612566,10612567,10612625,10609654,10612844,10609979,10609989,10610006,10610174,10610190,10610323,8852612,8852627,10613630,8852855,10613768,10613769,10610903,9911669,9169469,9169470,10117750,10117758,10117759,8849406,10117814,9911956,9911957,9911958,9912111,10118246,10118283,6674340,8850040,8850184,9912759,990967,991001,8552197,8850759,8850786,8850874,8851048,8851049,10417288,10416441,10416442,10415444,10419497,9168596,9910817,10415575,10416649,10416650,10417702,6672992,6672993,10416709,10416710,8848631,8848680,8848697,10415842,10415851,6673145,10418934,10418935,10418936,10418937,10418938,10418939,10418941,10418942,8848849,10418972,10418973,6673260,6673283,6673284,6673285,6673296,10419061,10420111,10419117,10418142,9169232,9169255,6670759,10469540,10469947,10468097,976373,976443,10468336,9167872,10470778,9168227,8848064,8848066,9168264,8848120,10888684,10889116,10889131,10889187,10889987,10885064,10885332,10882519,10882672,10882673,10882951,10882957,10888014,10627712,10888367,10883381,10883382,10888402,10883444,10885893,10885993,10881572,10876749,10887353,10887390,10882451,10602116,10602124,10602160,10608886,10603841,10604394,10604395,10604440,10604468,10550370,10505543,10505547,10507106,10411238,10413428,10409459,10409460,10409605,10411613,10411623,10411624,10411642,10411643,10409661,10411666,10411694,10411695,10411696,10411697,10409816,10409817,10407822,10407854,10407868,10413927,10409968,10411986,10409998,10409999,10410003,10410004,10410013,10410014,10410015,10410138,10410139,10414197,10414204,10414207,10414208,10414209,10414212,10414213,10414215,10414216,10414270,10410457,10410461,10414933,10414997,10407036,10407037,10415076) 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>