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(8630716,8630717,8574467,4970700,4970723,3228953,10861895,10861897,10861898,10861900,10861901,10861903,10861904,10861907,10861908,10861909,10861910,10861914,10861915,10861916,10861919,10862001,10862002,10862003,10862004,10862005,10862006,10862007,10862012,10862013,10862014,3229207,8631598,8583528,7066164,8632193,3229967,8629792,10860548,10860628,10860635,10860636,10860642,10860699,10860783,10860872,10860882,10860883,10860887,10860895,10860896,8630430,7201197,7201339,7201340,7201341,7201342,7201343,10866428,10866589,10866593,10866594,10866598,10866600,3238791,3238792,10866746,10866747,10866748,10866749,10866750,10866751,10866752,10866753,10866754,10866755,10866756,10866757,10866758,10866759,10866760,10866761,10866766,10866767,10866768,10866769,10866770,10866771,10866772,10866774,10866775,10866776,10866777,10866778,10866779,10866783,10866784,7201965,7201975,10960474,7202524,5654633,7202613,7202751,7202769,8629340,8629341,7200137,10857283,8626827,8626829,10959088,7200766,7200767,7200768,7200769,7200770,7200771,7200772,7200773,7200879,10865957,10865996,7198683,7198718,7198724,7198725,7198726,7198727,7198728,7198729,10855897,8909072,7199269,7199270,7199271,10856315,7199290,7199291,7199293,7199296,7199297,7199298,10101321,10101546,7199882,8626406,8905895,3923508,3923564,3923565,7196890,7196891,7196892,7197264,7197273,10838781,10838792,3234501,3234502,10838884,3235068,10854944,10854979,10854985,10617343,10954017,10954018,3922813,10954201,8905729,8632546,8632626,8632627,8632628,8632629,8632630,8632631,10425350,10425358,10425484,10425571,10425574,3581886,10425936,10425944,10426010,10426017,3231146,3231151,10616684,8611455,10616787,10614048,10614050,10614518,10614555,10614619,10614620,10614621,10614622,10614625,10614626,10614627,10614628,10614629,10614630,10614730,10614731,10612053,10612309,10612310,10612320,10612321,10612407,8566311,8851869,10612772,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,8566628,10612809,10612811,10612812,10612813,10612815,10612816,10612817,10609820,8566688,10612869,10609946,10612952,10609962,10613349,10613847,9169325,9169349,9169351,9169352,7055530,9169401,9169449,6673694,9911804,9911805,9911806,9911807,10117848,990142,990162,9161792,10118163,9912236,9912260,10118250,10118265,10118269,8850094,9912826,9912827,9912829,9912831,9912832,9912833,10419407,10419408,10419475,10419478,10419479,10419482,10419484,10419602,10419603,10419604,10419605,10419606,10419607,10419608,10419609,10419610,10419611,10419612,10419613,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10419631,10419632,10419633,10419634,10419635,10419636,10419641,10419642,10419643,10419644,10419645,10415717,10415718,10415719,10415720,10415721,10415722,10415723,10415724,10415725,9168817,10415782,10415783,10415784,10415785,10415786,10415787,10415788,6673093,6673094,6673095,6673096,6673097,6673098,6673101,6673102,6673117,6673118,6673119,6673120,6673121,6673122,6673124,6673125,6673128,6673129,6673131,6673133,6673134,6673135,6673136,6673137,6673138,10117433,7055450,7055451,7055452,7055453,10469366,10469656,10469657,10469668,10468552,10116206,10116207,10116208,10116209,10116210,10116211,10116212,10116213,10116214,10116215,10116216,10116217,10116218,10116219,10116220,9168023,10116221,9168024,10116222,10116223,10903862,10884786,10885144,10885175,10890206,10880341,10877579,10887580,10887586,10887587,10887589,10887591,10887592,10887594,10887595,10887596,10887597,10887598,10887601,10887654,10887655,10887656,10887657,10887658,10882883,10887922,10162094,10162095,10886157,10886387,10886389,10886426,10886477,10886522,10886524,10886544,10886554,10886556,10886581,10886584,10886586,10886624,10886625,10886688,10886689,10886692,10886699,10631455,10631456,10608810,10647566,10647568,10647661,10603653,10508319,10410185,10410186,10410198,10410201,10410205,10414870,10414877,10414878,10414885,10414936,10414942,10411036) 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>