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(10873230,10873397,10448039,8838707,8838708,8838709,8838710,8838755,10846060,10448297,4970895,8621716,8621737,8621760,7074116,10862589,10871634,8622314,8575755,8620000,10872494,8837702,10872585,8620147,8620252,8620253,8591663,8620279,8837965,8837978,8838138,8838139,8068552,8068553,8594779,8559503,7072719,7072765,7202031,7072818,7072864,7072970,7072976,7072977,7073075,8626744,8626748,10942739,10942750,10942753,8617013,8617014,11049119,8617135,8617140,8617304,8617379,8617421,8617474,4430316,4430382,8617596,4430393,4430432,7071867,8617723,3655581,3655591,3925587,3925653,3925805,3925889,8625216,3925974,8625262,8625263,8625264,8625265,8625266,8615735,10864216,3656725,3656727,8909308,8909309,8909329,8909330,8909587,8557500,8909786,10942438,8909949,8906077,10918661,8906188,8906365,8906383,10918938,10918939,10919299,10919300,10919301,10919302,10919303,10919304,10919305,10919644,10919645,10919646,10954281,10918173,10918174,10918175,10918176,10918177,10918178,10918179,10918362,10918363,10918364,10918365,10918366,10918367,10918368,10920601,10920602,10920676,10920702,10920703,8632862,8632863,8632864,8632865,8632866,8632867,8632868,8632869,8632870,10425592,10920764,8576637,8576638,10921101,10921102,10921268,10921269,10615845,8577043,10921484,10921485,8577160,10921534,10921600,8577252,10921645,10921646,10921647,10921648,10921772,10921773,10921774,8577422,8577438,8577439,8577753,8577770,8577813,6677947,6677948,6677949,6678195,9916244,9916245,9916257,8853929,8853944,9916379,8854121,10557123,10557124,10557125,10557126,10557127,10557128,9203325,9171354,9195452,9203500,9203501,9203502,9203503,9195566,9195567,10557458,10557459,10557460,9195648,10557461,9195649,9195650,9203684,9195723,9195724,9195797,9195798,9195799,9195800,9195801,9187804,9187805,9203845,9203846,9203847,9203848,9203849,9203952,7058293,9188129,9204137,9196156,9188260,9204275,9204350,9204351,9204455,7058727,9204592,9204601,8852435,8852439,8852490,8852495,9204708,9915209,9189067,10610765,10610766,9189138,6673523,9193393,9193405,9911807,9193613,8849467,8849476,10555494,10555565,10555566,10555567,10555568,10555569,10555570,8849597,8849611,9194118,9194133,9194134,9194135,9202135,6674398,9194362,9202430,9202442,10556341,10556342,10556343,10556344,10556345,9202619,9194734,9194735,9202758,9202759,9202760,9194776,9194901,9194902,10556751,10556752,10556753,10556754,10556755,10556756,10556757,10556758,9195120,9195143,9203154,9203173,9203174,9171258,9211271,10416233,9200486,6680731,8848359,8848396,8848397,10116802,10417548,6680889,6680909,9200743,10428138,9200845,9200846,10428392,6681323,10428496,10417128,8849062,8849094,8849095,8854135,8568825,9916569,9916570,9916670,8854292,8854308,9916720,10122757,9916780,6678798,9916841,9916842,8854473,8854487,10123183,8550198,10123316,10123317,10123464,10464046,10464047,8847380,8847394,10470243,6679877,10470392,10470396,6680083,8847740,10470505,10470512,8847788,10470599,10124259,9192102,10124310,9200267,10124468,10124479,10174504,10174505,10628076,10628083,10908782,10908783,10888852,8593879,10888875,10908877,10179891,10888883,10180161,10180162,10180163,10180202,10180203,10904226,10909325,10914411,10904473,10904474,10914484,10914485,10904508,10904509,10904510,10909526,10180564,10180565,10180566,10180613,10180614,10180615,10914649,10914674,10909689,10909690,10909691,10909710,10904717,10909730,10909731,10909906,10904920,10180946,10180975,10914976,10914977,10914978,10914979,10181224,10181246,10181247,10629732,10629733,10629764,10629765,10183540,10183639,10183640,10183641,10183642,10183656,10183657,10183722,10168750,10168751,10168752,10183816,10183899,10912958,10913178,10888185,10174437,10174454,10181513,10181739,10890784,10182046,10182061,10182062,10906159,10906160,10182213,10182229,10177353,10182376,10906365,10906366,10177419,10896457,10182479,10182488,10182645,10182646,10187718,10187719,10187753,10187754,10182809,10182810,10182819,10906819,10906820,10906821,10906822,10182994,10183000,10183076,10183083,10183145,10183155,10183256,10183327,10183334,10183450,10183480,10577123,10571477,10571478,10577547,10577548,10577549,10577550,10577551,10577552,10577553,10577554,10577555,10577556,10577557,10577558,10568692,10568693,10568694,10602576,10602577,10574741,10574742,10574743,10574744,10574761,10577925,10577926,10574952,10574953,10574954,10574955,10578080,10578081,10578082,10575180,10575201,10575202,10575203,10575204,10578208,10578209,10578210,10578219,10578220,10572311,10572314,10572370,10578400,10578401,10575463,10578524,10578573,10578574,10578650,10578651,10578767,10579391,10651683,10576764,10576765,10576766,10576767,10576768,10576769,10551217,10553250,10553251,10553252,10551292,10551293,10551294,10551295,10551383,10551384,10535463,10535464,10535465,10535466,10535467,10535468,10535469,10535470,10535471,10535472,10535473,10539534,10539535,10553611,10551646,10551647,10551648,10551649,10551650,10551651,10551652,10551653,10551654,10551655,10551656,10551657,10554013,10554014,10554015,10554016,10554017,10554018,10554019,10554020,10536086,10536087,10554273,10554274,10554439,10554440,10552484,10552485,10552486,10552546,10552547,10552548,10552549,10552550,10552551,10550574,10550575,10550576,10550577,10534669,10534670,10540772,10540773,10540795,10550825,10548916,10550948,10534950,10534951,10534952,10534953,10534954,10534955,10534956,10534957,10534958,10534959,10534960,10550969,10550970,10550971,10550972,10423930,10424066,10487939,10494019,10488022,10494031,10494143,10494144,10494244,10494269,8563184,10497337,8562043,10493744,10493760,10493844) 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>