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(8630691,8630759,8630760,8630768,8630769,8630770,8630772,8630773,8630774,8630775,8630776,7068235,7068263,8630911,8630915,8630947,8630948,8630949,8630950,8630951,8630952,8630953,8631029,8631097,8631098,8631099,8631100,8631103,8631104,8631105,8631106,8631117,8631118,8631122,8631123,8631124,8631125,8631126,8631127,8631128,8631129,8631130,8631131,8631132,8631133,8631134,8631135,8631136,8631137,3228994,8569555,3228995,8569624,10950375,10950385,8631538,10950547,10950548,10950567,10950568,10950608,10950613,10950614,10950615,10950617,8631658,8631659,10950646,8631666,8631667,8631668,8631669,8631670,8631671,8631672,8631673,8631680,8631682,8631683,8631684,8631685,8631686,8631692,8631696,8631705,8631706,8631707,8631731,8631732,8631742,8631743,8631768,8631875,8631889,8631890,8631891,8622095,8622096,8622097,8622098,8622099,8622100,8622101,7066284,7066285,7066287,8575506,8575665,10437392,8632211,8632212,8632213,8632214,8632215,8632216,8632217,8632218,8632219,8632220,8632221,8632222,8632223,8632224,8632225,8632226,8632227,8632228,8632229,8632230,8632231,8632232,8632233,8632234,8632235,8632236,8632237,8632238,8632240,8632241,8632242,8632243,8632244,8632245,10951227,3230057,3227397,3227401,10938799,11001077,10962175,10929917,7064026,7201278,7201279,7201320,7201323,7201324,7201325,7201326,7201327,7201328,7201329,7201330,7201331,7201332,7201373,7201374,7201380,7201381,7201520,7201521,7201522,7201523,7201524,7201525,7201526,7201527,7201528,7201529,7072315,10843142,10843143,10843144,7201700,7201754,7201755,7201756,7201757,7201758,7201760,7201761,7201762,7201763,7201764,7201765,8618365,10960307,10843429,10843430,10843431,10843435,8911775,7202075,7202076,7202077,7202078,7202163,7202201,7202202,7202203,7073010,10999731,7073067,7202345,7202346,7202349,7202350,7202351,7202352,10999846,7202583,5654763,7202700,7202705,7202706,10844217,10844218,10844219,10844220,10844221,10844222,11000164,11000165,11000166,10844308,10844309,3227091,4968121,10942618,11048967,11048971,11048972,10942791,7071242,7071243,7071245,7071246,7071260,7071261,7071262,7071263,7071296,7071298,7071300,7071301,7071302,7071303,7071304,7071305,7071337,8910417,7200731,7200751,7200752,10959215,10959219,3237982,7200906,7200907,7200908,10102911,10102912,10102913,10102924,10102925,8970239,10100098,10100099,10100100,10100101,10100102,10100103,10100104,10100105,10100106,10100108,10100110,10100119,10839806,10839807,10100312,10100313,10100314,10100316,10100390,10940934,8615178,3235783,3235798,7198677,7198678,7198679,7198680,7198681,7198682,7198683,7198684,7198685,7198686,7198687,7198688,7198689,7198690,7198691,7198692,7198693,7198694,7198695,7198696,7198697,7198698,7198699,7198700,7198701,7198702,7198703,7198704,7198705,7198706,7198707,7198708,7198709,7198710,7198711,7198712,7198713,7198714,7198715,7198716,7198717,7198718,7198719,7198720,7198721,7198722,7198723,7198724,7198725,7198726,7198727,7198728,7198729,7198730,7198731,7198732,7198733,7198734,7198735,7198736,7198737,7198738,7198739,7198740,7198741,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198753,7198754,7198755,7198756,7198757,7198758,7198759,7198760,7198761,7198762,7198763,7198764,7198765,7198766,7198767,7198768,7198769,7198770,7198771,7198772,10101035,10101039,10101048,10101049,10101050,10101114,10101115,10101116,10101117,10101138,10101139,10996695,10101141,8564730,8564731,8564732,8909097,8564865,10101302,10101303,10101304,10101306,10101307,10101308,10101309,10101313,10101314,10101315,10101316,10101317,10101318,10101319,10101320,10101325,10101327,10101329,10101330,10101331,10101332,10101336,3236644,10101387,10101388,10101389,10101412,10101414,10101415,10101417,10101418,10101419,10101420,10101421,10101422,10101424,10101425,10101426,10101441,10101443,10101444,10101445,10101446,10841082,8565096,8565097,8565098,10101544,10101563,8616274,8616275,10101583,10101593,10942096,10942100,10101655,10101656,11010332,11048567,10101906,10101929,10101948,10101949,10618177,10618275,10618276,10618280,10967942,10618292,10618294,10618295,10618297,10838079,10838083,10838087,8613391,3234036,3234125,10838602,10838635,10838660,3234433,3234504,10619176,3234584,3234585,3234586,3234587,3234588,3234589,3235000,3235002,3235003,3235004,3235007,10995298,3235051,3235052,8614482,8614483,3232369,3232370,3232371,3232372,3232373,3232374,3232375,3232376,8541541,10836861,10836862,10836863,10836869,10836875,10617218,10837045,8612185,3232847,3232850,3232851,3232852,3232853,3232854,3232855,3232918,10617573,8905953,3233324,11045618,10951665,10615084,10615137,10615152,10615153,3230584,3230585,10620327,8570312,8570512,10615598,8540522,8610894,8904791,8904915,8904916,10616907,3232352,10562213,10562214,10562215,10562216,10562218,10562225,10562226,9189549,7059731,9197683,9197684,9197686,9197707,9197708,10122103,6666004,10562867,10611758,10609375,8862295,8862296,8862304,9188284,9188433,9188434,9188436,10610331,10558592,9164856,10561757,10561758,10561817,10561818,10561819,10561820,10561821,10561852,10561853,10561854,10561855,10561858,10564883,10613736,9165085,10561900,10613750,10561901,9165088,10561902,10561903,10561904,10561905,9165094,10561960,10561961,10561985,10561986,10562019,10562025,10562026,10562038,10562039,10562040,10562041,10562046,10562080,10562092,10610955,10513213,9169516,9169539,10517994,10517995,10514036,10514037,10514038,10514041,10514075,10514076,10514090,10514091,10514092,10514093,10516133,10516134,10516135,10516136,10516137,10516138,10516139,10516157,10516158,10516159,10516160,10516161,10516162,10516163,9162350,10516164,10516165,10516166,10516171,10516172,10516173,10516174,10516175,10516176,10514364,10514368,10514369,10514370,10514371,10514372,10514373,10514374,10514376,10514377,10514378,10514379,10514380,10514381,10514382,10514383,10514384,10514385,10514386,10514387,10514388,10514389,10514390,10514391,10514392,10514393,10514394,10514395,10514396,10514397,10514398,10514399,10514400,10514401,10514402,10514403,10514404,10514405,10514406,10514407,10514408,10514409,10514410,10514411,10514412,10514413,10514414,10514415,10514416,10514417,10514418,10514419,10514420,10514421,10514422,10514423,10514424,10514425,10514426,10514427,10514428,10514429,10514430,10514431,10514432,10514433,10514434,10512559,10514629,10516928,10514964,10514965,8861740,10515068,10515069,10515072,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,10515098,10515099,10515100,10515101,10515102,9192455,9192456,9192457,9192458,9192459,9192460,9192461,9192462,9192463,9192464,9192465,9192466,9192467,9192468,9192469,9192470,9192471,9192472,9192473,9192474,9192475,9192476,9192477,9192478,9192479,10418583,10418584,9193196,9193252,3963584,3963585,9207297,10123774,8563480,10159944,10159948,10159949,10159950,10159951,10159952,10159953,10159954,10159955,10159956,10159957,10159958,10159959,10893958,10175037,10175039,10175056,10884964,10171207,10171208,10171209,10885454,10885455,10885456,7000663,7000664,7000665,7000696,7000778,7000780,7000818,7000819,10153871,10153872,10173888,10627665,10627666,10627667,10627668,10161602,10161603,10161604,10630117,10630118,10172410,10172412,10172416,10172425,10172426,10172427,10172428,10172429,10172430,10172431,10172432,10172433,10172434,10162861,10162862,10631549,10882089,10631623,10631624,10586245,10586246,10586247,10586300,10586301,10586302,10586303,10586304,10586305,10586398,10586399,10586400,10586401,10586402,10586403,10586404,10586405,10586406,10586407,10586419,10586420,10586421,10586422,10586423,10586424,10586425,10586426,10586427,10586450,10586451,10586452,10580464,10566125,10566126,10566127,10566128,10566129,10587417,10590618,10590619,10590620,10581890,10581891,10581892,10579810,10579811,10579812,10579813,10579814,10579815,10579816,10527167,10527168,10527273,10525331,10525332,10525333,10525334,10527395,10527738,10527739,10527740,10527758,10537765,10537766,10537767,10527813,10527814,10527815,10527816,10527948,10527949,10527957,10527958,10527959,10527961,10528051,10528052,10528053,10528068,10528380,10546398,10546399,10546403,10546430,10546508,10546555,10546561,10522577,10522578,10522579,10528629,10546758,10536771,10536772,10536773,10536774,10536775,10536778,10536850,10536851,10536852,10536853,10536854,10536855,10536856,10536857,10536858,10536859,10536865,10536866,10536877,10536882,10536883,10546919,10546920,10546921,10546922,10546927,10546985,10539065,10539066,10539078,10539079,10421243,10421244,10422275,10422286,10420433,10420437,10505551,10505552,10422813,10422814,10422815,10422816,10506786,10497443,10497444,10497445,10497446,10497447,10476447,10476448) 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
ERROR: Unknown column 'p.products_specials' in 'order clause'