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(3229020,3229021,3229048,3229049,7065937,7066235,10861101,10858620,10858622,10858625,10858628,10858629,10858630,10858635,10858636,10858637,8595016,8595017,8595019,8595020,8595021,8595022,8595023,8595024,8836259,10859556,10859557,7202651,7200061,7200062,7200063,7200064,7200065,10865502,10863294,10863295,10863298,10863299,10863300,10863301,10863302,10863305,10863309,10863312,10863313,10863314,10863315,10863316,10863317,10863318,10863320,10863321,10863324,10863325,10863326,10863327,10863328,10863329,10863331,10863332,10863333,10863336,10863337,10863340,10863344,10863345,10863348,10863351,10863352,10863353,10863354,10863355,10863356,10863357,10863358,10863359,10863361,8625116,7199424,7199896,7199902,7199904,7199905,7199906,7199907,7199908,7199941,7199944,7199992,7200045,7200047,10618281,10618286,10618287,10618291,10853808,10853809,10853828,8906634,8906645,10853891,10853893,10853905,8906677,8906685,8906712,10853976,7196997,10854059,10854253,7198007,10425484,10615545,10615580,3581867,10615802,10615804,10615860,10616096,10426354,10426453,10616840,8552639,10616841,10616928,10611104,10611126,10611223,10611303,10611314,10614635,10614636,10611878,10612126,10612331,10612341,10609421,10609425,10609439,10609443,10609444,8851811,8862519,8852314,8852568,10613574,10613617,10613618,10613619,10613620,10613633,6673577,6673578,6673579,6673580,6673581,6673582,6673583,9911585,6673584,6673585,6673586,6673587,6673588,6673589,6673590,6673591,6673592,6673593,6673594,6673595,6673596,6673597,6673598,6673599,6673601,6673602,6673607,6673608,9911611,6673611,6673613,6673614,6673616,6673627,6673630,6673631,6673632,6673633,9911738,9169588,9169646,9169647,9169648,10117894,9912114,9912115,10118128,6674185,6674188,6674189,7015670,7015671,7015672,7015673,9912577,9912578,9912579,9912585,9912586,9912587,8850604,8552178,9913162,9913273,10416822,10416823,10416826,10416827,10416828,10416829,10416830,10416833,10416837,10416840,10416841,10416842,10416843,10416844,10416845,10416846,10416848,10416849,10416850,10416851,10416854,10416855,10416856,10416857,10416858,10416859,10416860,10416861,10416863,10416864,10416865,10416868,9168946,10416869,10416870,10416873,10416874,10416878,10416879,10416880,10416883,10416886,10416887,6673172,10416888,6673173,10416889,10416890,10416891,10416892,10416893,10416894,10416895,10416897,10416900,10470968,8549811,10467495,10468285,6672079,10470827,10883818,10883820,10888842,10888843,10888844,10888845,10888846,10888847,10888848,10888849,10888850,10889285,10889286,10884384,10884404,10884424,10884644,10884678,10910055,10890093,10890237,10890239,10885361,10885398,10888014,10888018,10888019,10888020,10883435,10883442,10949007,10881491,10882467,10647339,10647389,10647623,10603503,10603504,10603505,10603506,10506786,10507948,10507949,10507950,10507951,10507952,10507953,10507954,10507955,10413995,10413996,10415106,10415107,10413159,10413161,10413164,10413167,10413168,10413169,10413174,10413175,10413176) 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>