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(10943426,8630685,8630759,7076128,8630777,8630778,10988892,10943628,10939940,10873733,8631251,8583100,10862167,8631586,8631607,10963667,8575197,10849377,7066178,10849557,10951029,8575733,10964440,10964441,10964442,10964443,10964444,10964445,8561076,10872444,10844944,7067196,8561412,7075485,7075498,8630443,8630446,8573995,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627629,8627634,8594636,10842887,10842913,7201453,11011910,11011911,10866538,7201564,10866620,10866628,10866643,10866655,10866656,10866657,10866658,10866659,10866660,10866663,10866666,8559379,8559380,8559381,8559382,8559383,8559384,8559385,8559386,8595109,10931819,10931820,10931821,10931828,10931834,10931837,10859195,10867202,10867203,8065953,8065958,10986728,8628725,10999812,5654763,8560516,3227190,10865573,7071304,10857649,4430182,7200817,7200906,7200907,7200908,8558650,8558651,8558652,8558653,10866011,10866017,8970227,8970228,8970229,10866198,6000195,6000197,6000199,10944449,10855400,10855401,7198360,7198361,7198362,10840147,10840148,10840149,10941038,7198680,7198688,7198695,7198700,7198701,7198717,7198742,7198743,7198760,7198767,7198769,11009237,11009263,8615497,8625318,8625319,7069781,7199061,8908974,3236593,8557310,8557311,8557338,8557339,8557341,8616242,10101868,10857142,10857146,10857147,10857148,10857152,10857155,10857156,10857160,10857162,10967862,10967863,10967864,10967865,10967866,10853510,3233665,3233666,3233667,3233668,3233669,3233695,10623660,10623661,10623662,3234106,3234107,3234108,3234109,3234110,3234111,10838518,10838526,10838535,10838536,10838538,10838539,10838540,8906892,7197288,10838816,10838970,10838977,10838981,10838982,10838984,8907462,8555365,3924827,3924828,8907513,10619509,3234957,10995306,3235092,3235093,10995533,11047578,8563614,8624555,8552882,3232431,10617126,10836870,8905260,8612105,10617323,10617324,10617364,8612185,10617379,10617387,10617401,3232899,3232900,3232904,8612408,8612409,8612410,8569953,8632764,10620208,10850489,10425575,8632891,10620289,10848057,3581790,8633116,3581896,3581898,3581900,3581901,3581902,3581903,3581905,3581910,10930665,10930666,10930667,10851035,3582191,10848582,7154410,10851161,10851162,7154418,8540450,10616023,10616045,10952809,10952810,10952811,10952812,10952813,8540752,8904337,3231722,8633974,8904390,8633980,8633981,8633983,8633985,3232187,8634459,10953508,10953509,10953510,3232270,3232301,10562175,8853207,8853208,8853212,8853213,8853214,8853219,8853228,10614262,9197676,9197677,9197678,9197679,9197680,9197681,9197682,9173712,9173714,9173715,9173716,9173717,9173718,9173719,9173720,9173721,9173722,9173723,9173724,9173725,9173726,9173727,9173728,9173729,9173730,9173731,10614502,10611612,9214239,6666259,9182280,10611944,10612104,10612105,7057665,7057666,8862099,8566539,9172148,9172149,9212323,9188332,7058533,7058534,9188432,9188433,9188434,9188435,9188438,7058620,10610343,10610344,10120919,9204765,9204770,9204771,9204772,9204773,10121124,10561755,10561756,10561757,10561758,10561759,10561760,10561761,10561762,10561763,10561764,10561765,10561766,10561767,10561768,10561769,10561770,10561771,10561772,10561773,10561774,10561775,10561776,10561777,10561778,10561779,10561780,10561781,10561782,10561783,10561784,10561785,10561786,10561787,10561788,10561789,10561790,10561791,10561792,10561793,10561794,10561795,10561796,10561797,10561798,10561799,10561800,10561801,10561802,10561803,10561804,10610691,9197140,8567759,9161492,9169748,8592965,9161897,9169935,6674152,9912227,8551329,6674311,6674332,9912437,8850170,10118606,10118607,10118610,10118679,9912966,10518649,10518650,10518651,10518652,10518653,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518665,10518666,10518667,10518668,10518669,10518670,10518671,10518672,10516682,9210938,9210939,9210940,8565537,10119319,9913351,9913354,9913365,9160363,10427754,10427755,10419307,10416362,9176445,6672772,10419505,10419516,10419528,10419529,10419530,10419531,10419532,10419535,6672829,6672830,6672831,6672832,6672833,6672869,6672877,6672897,6672903,10428147,6673017,10419739,10428209,6673082,8848725,10428301,10428302,9168937,10415873,8848790,8848791,8848792,6673196,4973895,6673272,6673273,6681281,6673304,9911318,10420037,10420038,9169136,10419166,10419172,10419173,9169289,9169290,8549460,10122553,10122554,10469502,8550155,8550265,9191262,9175286,10469949,8847268,8847273,8847274,8847283,8847310,9183501,9167525,8847511,8847512,8847517,10468323,10468325,976581,4972666,4972667,10468413,10468414,10462464,10462465,10462466,10462467,9168102,9192211,9192214,8848059,9184234,8848060,9184235,8848061,8848062,10883559,10883560,10883561,10883562,10883569,10883570,10883587,10883591,10883592,10883624,10883625,10883626,10883660,10883664,10893688,10946564,10884077,8068992,10889777,10890127,10890144,10890145,10890146,10890176,10632163,10632164,10632165,10153879,10153880,10153881,10153882,10153883,10153884,7001085,10627775,10883401,10883407,10883410,10883411,10883412,10910549,10900848,10886069,10162091,10162245,10172412,10881491,10876864,10887096,10173116,10173118,10173119,10173120,10173121,10887122,10887123,10887124,10892157,10892158,10892159,10892160,10892161,10892162,10892163,10892164,10892165,10892166,10892167,10892168,10892169,10892170,10892171,10892172,10892173,10892174,10892175,10892176,10892177,10892178,10892179,10892180,10892181,10892182,10887224,10945103,10892391,10631896,10158457,10568114,10568115,10568121,10568122,10568123,10568124,10568125,10568126,10601174,10601238,10601286,10601287,10601288,10601289,10601290,10601294,10568294,10601295,10568295,10601296,10568296,10601297,10568297,10601298,10568298,10601299,10568299,10601300,10568300,10601301,10568301,10601302,10568302,10601303,10568303,10601304,10568304,10568305,10568306,10568307,10568308,10568309,10568310,10568311,10568312,10568313,10568314,10568315,10601320,10601321,10601322,10601324,10601325,10601326,10601327,10643478,10643479,10643480,10643481,10643482,10643483,10602316,10602317,10602318,10602319,10643546,10602692,10602700,10602703,10602705,10602706,10602726,10583937,10583941,10590308,10647388,10599386,10650475,10647702,10603693,10603696,10579475,10579478,10601436,10601437,10651653,10588655,10588656,10588657,10588658,10588659,10601688,10601700,10549772,10534309,10522571,10528650,10528660,10528661,10528662,10528663,10528664,10520811,10536849,10536850,10536851,10546992,10546993,10422226,10498250,10498251,10498252,10424373,10421381,10423502,10423505,10423563,10508598,10423767,10423807,10421818,10421835,10507922,10422091,10407408,10486104,10486105,10486106,10486107,10486118,10486119,10486120,10486121,10407513,10407530,10407531,10409642,10409643,10483369,10483370,10407805,10486570,10411964,10411965,10411969,10411972,10411973,10411977,10408152,10408187,10408188,10477872,10496901,10496911,10408279,10478005,10497033,10493047,10410579,10410580,10408584,10493253,10493254,10408612,10408613,10493296,10493297,10493298,10493299,10493300,10493301,10493302,10497430,10408934,10406983) 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>