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(7075892,3228392,10930321,8838589,10939906,11014964,10940004,8621205,8838987,8839002,8839015,8839016,8839017,10846313,10846314,9215233,8621450,10459195,8583102,10873922,8621484,10459246,10459247,11041364,10950306,10459274,10459295,10459296,10874047,10874049,10459339,8569752,8569753,10459404,11015542,11015543,11015544,11015545,11041546,11041547,11041548,11041549,11041550,11041655,4968316,4968317,8583569,10950852,10950964,10847097,8067415,8622249,8622294,11016145,11016146,11016147,4968847,3230019,3230020,11013500,11013501,11013502,11013503,11013504,3227407,8560950,8560951,8560984,8561003,8561004,8561103,7075185,7075188,7075199,8561151,8561152,8561153,8561154,7067212,7067213,7067220,7075234,8561182,3227658,7075263,7075264,7075295,7075296,11040273,8620484,10845413,10962375,10873070,6000218,8065080,8065082,8065093,8065096,3238457,7064056,10931852,8911569,10960311,7072635,7072636,7072637,10960403,7201972,4967068,8595405,8595406,10843557,8595495,10999567,8572087,8618807,8618808,8836657,7202525,8560261,8560262,8560340,10867873,10867874,10867875,10867876,10867877,10867878,8596248,10987343,10933196,3227201,3227202,11013496,11013497,11013498,11013499,8063985,3927480,3927558,3927635,3927643,3927644,3927645,3927646,3927735,8617219,10998101,7200691,8861384,7200730,10857948,10857949,10857950,10857951,10857952,8617602,11011464,11011465,3238229,10100111,10995827,10100344,7069317,8556311,10840181,10840182,8072437,10840506,8615616,10957473,8615634,10856145,3656624,3236381,3236382,8615896,11022816,11022817,11022818,11022819,3656888,10864492,10101425,8557369,10856792,3926945,8860486,3927003,10856936,8860554,10958365,10958366,7070706,8579054,11019649,7156565,11032751,11019802,8612975,11006880,3233774,10968076,10968077,10968078,10968079,3923803,3233910,3233920,7196890,3234122,3234124,3924130,3924134,7157288,8554816,7157421,10838657,8554989,10619325,10619326,8555147,8907266,8907267,8907268,8907269,8555383,8555384,4938175,10622027,10622053,10852235,11005667,11044702,11044703,11018704,10427408,10836876,10927907,3922817,3922818,3922819,3922820,10954259,8553540,8542239,11006492,10964524,10964525,10964526,10964527,10460413,10964528,10964529,10925532,10925533,10460541,10460542,10615234,10847856,8632767,8632768,10847888,10620327,3230614,3230615,10847953,10920887,9217030,10926034,10926035,11043267,10965549,3231447,9217801,10952845,8577579,9218124,7155065,8611369,8541144,10852063,8634456,9189340,7027002,9189349,10611179,9915725,9915736,10565444,10565523,10565524,10565525,10565526,10565527,10565528,10565529,10565530,10565531,10565532,10565533,10565534,10565535,10565536,10565537,10565538,10565539,10565540,10565541,10565542,10565543,10565565,10565597,10565598,10565599,10565600,10565601,10565602,10565603,10565604,10565605,10565606,8864319,10565632,10565633,10565634,10565635,10565636,10565637,10565638,9173826,10565639,10565640,9173827,10565641,9173828,10565642,9173829,9173830,10565643,10565644,9173831,10565645,9173832,9173833,9173834,9173835,9916053,8568477,9166112,8864672,10566060,7019925,7019926,7019940,9913558,9211359,7025062,9913664,10119703,10119716,9211577,10119830,10119831,10119832,9211785,9171981,10612824,10612960,10612961,9172335,7018007,9188567,7018244,9914854,7026322,7026357,9164757,7026500,7018504,10564683,7026525,9204937,9915232,9189108,8852962,7026827,9189216,9169458,9169459,10517320,8849378,10117830,9185665,8849491,8849492,8849493,10125876,10125922,10125934,10125935,9912044,9209966,8849795,9209973,9912207,7023658,8849838,8849877,7023747,4974950,4974951,4974952,4974953,10118335,7023797,4975001,8850044,4975072,3285966,4975228,4975229,3286048,3286049,6674600,6674683,10556368,10556369,10556370,9913184,10518799,10518800,10518801,8565563,10517096,6672512,8917983,9160350,7022019,9160376,9160416,9192456,10116666,10116721,7022179,9910916,9910917,9910918,10419680,4973666,6673042,10417802,9176887,9176888,9208913,9911189,7022739,9201139,10125349,10125350,10125365,10125366,10125367,10125403,10428620,8864862,10122642,6666504,10465107,9916844,8865164,6678857,9190705,9206753,9206754,9206755,8549958,7020460,9190846,9917063,9190876,9190882,9190883,6665231,6665232,8854830,9917235,8854895,8916788,10465756,9199394,6665651,6665667,9175472,9175473,9207580,9207589,8917336,7021439,6474102,6474114,9175868,10462551,10462552,10462553,10462554,9184057,10427435,10462640,10462641,10116492,8593489,10159503,10169529,10888530,10893810,10893811,10169888,10169889,10169890,10909113,10909114,10909115,10909116,10909117,10909118,10155738,10894733,10175784,10889782,10155808,10155834,10155835,10879893,10879902,10915329,10915330,10915331,10915332,10156365,10915359,10915360,10915361,10915362,10915363,10915364,10915365,10915366,10915367,10915368,10915369,10905448,10905449,10183509,10183510,10183511,10168846,10173886,10627665,10908189,10179439,10905775,10161921,10166926,10171985,10171986,10177496,10177497,10177498,10177499,10172549,10172550,10172551,10631068,10177659,10177660,10177698,10177699,10187982,10187988,10949812,10949813,10949814,10949815,10949833,10892279,10892280,10892281,10892282,10892283,10631799,10945170,10907458,10163478,10163479,10605083,10605084,10602181,10643513,10652572,10602366,10602367,10602368,10602369,10602370,10589594,10589595,10589596,10589597,10589598,10589599,10589600,10589601,10589602,10589603,10589604,10589605,10589606,10589607,10589608,10589609,10589610,10589611,10589612,10589613,10589614,10589615,10589616,10589617,10589618,10589619,10589620,10589621,10589622,10589623,10602517,10583694,10583695,10583696,10583697,10583698,10602691,10605910,10605911,10605912,10605952,10587162,10584190,10584191,10584192,10584193,10653271,10587255,10644342,10647432,10644618,10644619,10603571,10584728,10584729,10584730,10584731,10584732,10603703,10581968,10654035,10645042,10606888,10606900,10606941,10606951,10606976,10651311,10651317,10651318,10654326,10654327,10654328,10654329,10573350,10604201,10648474,10648475,10648485,10648486,10607536,10607547,10607607,10591758,10607609,10645831,10645832,10645833,10601687,10529434,10545567,10545601,10545602,10545603,10545604,10545605,10537646,10545752,10541769,10541770,10538446,10538447,10548502,10548503,10548504,10548505,10548506,10548507,10548508,10548509,10548510,10548511,10548512,10548513,10528546,10528547,10528548,10528549,10528550,10528551,10528552,10528553,10528554,10528555,10528556,10528557,10528558,10528559,10528560,10522689,10552737,10552738,10552739,10552740,10552741,10552742,10552743,10552744,10552745,10552746,10552747,10552748,10552749,10552750,10552751,10552752,10552753,10552754,10552755,10552756,10552757,10520757,10552758,10552759,10552760,10552761,10552762,10538859,10524862,10522864,10522865,10538901,10538914,10538927,10505431,10420560,10420561,10420562,10420563,10424640,10424642,10505553,10498689,10510802,10424018,10507974,8562285,8562625,10411704,10496466,10496467,10496468,10496476,10486500,10481635,10496675,10493073,10412535,10412536,10412537,10412538,10412539,10408720,10476514,10476515,10476516,10476517,10472671,10472672,10472673,10472674,10472675,10472676,10472677,10472678,10472679,10472680,10472681,10487783) 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>