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(7067937,7067938,10873361,8630760,8574526,10989095,8583487,8583489,8067028,10868341,10868342,10868343,10849457,10849459,10849491,8631857,10849503,8583694,10950953,10862614,8583904,8622317,3229961,10951201,10990291,8609602,10951435,10869388,8629755,10869415,10869416,10869417,10869418,10869419,10869420,10844948,10844949,10844950,10844951,10844952,10844953,10844954,10929474,10844955,10860543,10860579,10860580,10860581,8629940,10860591,10860604,10860758,10860759,10860760,10860761,10860762,8630195,8630304,10962442,10962443,10962444,10870116,10985701,8559069,8559070,8559071,10866452,10866509,10842998,10866544,10866545,10866573,10866574,7201565,8595057,8559383,8559384,8559385,8628102,8628103,10103590,10103592,10103593,10103594,8618358,8618368,10866839,10866846,10866855,8911744,3899211,7201959,8628417,8628595,10986741,10986742,10986743,10986744,10986745,8628805,7202498,7202499,7202500,7202501,5654627,5654682,5654697,5654698,8629417,10860148,10860149,10860176,8629558,11010648,11010649,10102114,10102115,8616850,8626811,10865584,10865585,8910462,10102682,10865941,5999954,5999955,5999956,5999957,5999958,5999959,5999960,5999961,5999962,5999963,5999964,5999965,5999966,5999967,5999968,5999969,8558636,8558637,8558638,8558639,8558640,10857982,8558641,8558642,8558643,8558644,8558645,8558646,8558647,8558648,8558649,10857998,8558679,8558680,8558681,8558682,8558683,8558684,8558685,8558686,8558687,8558688,8558689,8558690,8558691,8558692,8558693,8558694,8558695,8558696,10858038,8558697,10858039,10858040,8558698,10858041,8558699,8558700,8558701,8558702,8558703,8558704,10858046,8558705,8558706,8558707,11011447,8558708,8558709,8558710,8558711,8558712,8558713,8558714,8558715,8558716,8558717,8558718,8558719,8558720,8558721,8558722,8558723,8558724,8558725,10858095,10858099,10858150,8624652,8624656,8624658,7198385,7198389,8908277,8615063,8624933,8624934,8624935,8624944,8624950,8624951,10855603,8624964,8624965,8624976,8624977,8624978,8624985,8624986,8625024,8625033,8625034,8625043,8625044,8625045,8625055,10941055,10941056,10941057,10941058,7198700,7198701,8908519,7198725,7198727,7198743,7198757,7198760,7198765,7198766,11009236,11009277,8556652,11009412,8625431,10941765,11035945,11035946,7199573,7199574,10841105,11048307,8626104,8626188,8626396,8626397,8626398,7196203,7196207,7196230,8613073,8613074,8613135,10853635,7196913,7196915,7196918,10623707,10623708,10623709,10623710,10623711,10623712,10623713,3234106,10623714,10623715,7196959,7196974,8613583,10838521,10838537,10838540,3924202,3924203,3924204,3924205,8906886,10968571,10968572,10968573,10968574,10854225,3234731,3234732,3234733,3234734,8907433,8555379,8907618,7197810,8907622,7197811,8907624,7197813,10624633,8907670,8907703,3925059,8624380,10855058,10855067,10619903,10852283,10852285,8541521,10852371,10852372,10852373,11044800,11044807,11044808,11044809,11044810,11044811,11044812,11044813,8905251,8905262,10852587,10617330,10617380,10617406,10617407,10617408,10617418,10617419,10617420,10617421,10617424,10617451,3232902,3232903,3232904,3232909,3232910,10853147,10425350,10615025,10615026,8576183,10425387,10425388,10425389,10425392,3230564,10850435,10425551,10615258,10620309,10620310,10620311,10620312,10620313,10850685,10850720,10850738,10850743,10850751,10952100,8633124,3581899,3581900,3581905,3581906,3581907,3581908,3581909,8633546,10426340,10991707,8540576,8540577,10952888,10616332,8611258,8611259,8611459,8611466,8611467,8904798,8634442,8634447,8634456,8634457,8634480,8634481,10852126,10610963,10610965,8853177,8853179,8853180,8853316,8853320,8853325,8853340,8853342,8853353,8853357,8853358,8853368,8853369,8853385,8853386,8853389,8853390,10611250,9197722,9197752,10614415,10559609,10611469,10611472,10611479,8853688,8853689,9197868,9197869,10611583,10611856,9190260,9211551,9211552,10612381,9195921,9171922,10609706,8851990,7017820,7017821,7017822,7017823,10120380,10612939,9212318,10610095,7058620,8567055,8567056,8567057,8567058,8567059,8567060,8567061,9914889,10613369,7018485,10613505,10121136,10121137,10121138,10117529,8849319,8849320,8849321,10515309,8849322,8849323,8849329,8849330,8849332,7055723,6673803,9169695,9161731,9912235,6674326,9912423,10118675,10118827,9178746,8850596,9178777,10516613,9913100,9913193,8848128,8848130,6672514,8848137,8848142,8848145,10415242,8848147,8848151,8848153,10416257,8848166,8848167,8848170,8848176,8848179,10427734,8848181,8848188,8848190,9168366,9168367,8848198,9160374,8848200,10416349,9176428,9176429,10416352,10416354,10419453,10419470,10419476,10419482,10419491,10419492,10419527,9176782,9176783,9176784,9176785,10419710,10419717,10419732,10418817,10418824,10418836,10428361,8848916,10417077,10417084,10417095,10417099,10417106,10417109,10419110,10417114,10417125,10417129,10417133,10417136,10419166,10419168,10419171,10419175,10419177,10463029,10467134,8549890,10469343,4971644,10463392,10463393,10463402,7020664,9175040,9199071,9199072,6667087,10463745,10463748,10463749,10463766,10463782,10463783,10465792,10463795,10463796,10465822,10465824,10465829,10465854,10465855,10465858,10465865,10465866,10465878,10465879,10465892,10463895,10463905,10465906,8550628,9183524,9183525,9183526,9191563,8847552,10462325,10466337,8847615,10466369,10466371,10466374,10466377,10466392,10466393,10466394,4972673,4972674,4972675,10466399,10466402,10466412,10462429,10462444,10462445,10462456,10466456,10462473,10462506,10462507,10462511,10462520,10462606,10462608,8848001,8848005,8848007,8848009,8848010,8848013,8848015,8848017,8848019,8848020,8848026,8848027,8848032,8848038,8848041,8848042,8848051,8848059,8848061,8848064,8848066,8848069,8848075,8848080,8848081,8848088,8848093,8848100,8848101,8848102,8848117,8848120,10883585,10883586,10903588,10883589,10883590,10883591,10883592,10883593,10883596,10884082,10884083,10894115,10175148,10894643,10894644,10894645,10890103,10890154,10890156,10890173,10171191,10176232,10171291,10171292,10632010,10632012,10632013,10632014,10632018,10632052,7000845,10632189,10627321,7001080,10887930,10887931,10883045,10900908,10900909,10900910,10900911,10900912,10900913,10900914,10900915,10900916,10886206,10886207,10886208,10886209,10886210,10891654,10891655,10631419,10631439,10631440,10168028,10168032,10887096,10887097,10173118,10907292,10882356,10882358,10568306,10568307,10568308,10568309,10568310,10602160,10568311,10568312,10602162,10602163,10602164,10602165,10602166,10602167,10602169,10602170,10602172,10602175,10602177,10602178,10602180,10602181,10602186,10602188,10602193,10646620,10598564,10598590,10598591,10598592,10602704,10598861,10602722,10602723,10602724,10602725,10602726,10602727,10602728,10602729,10602730,10602731,10602732,10647338,10650485,10650486,10606801,10567683,10567684,10567688,10591777,10579820,10601705,10549118,10548440,10539066,10421538,10421540,10421543,10421576,10421595,10421596,10421597,10421598,10422599,10420831,10420921,10420922,10420923,10425031,10425032,10425033,10424033,10425034,10425035,10425036,10425037,10425038,10425039,10425040,10425041,10425042,10425043,10425044,10425045,10425046,10425047,10425048,10425049,10425050,10425051,10425052,10425053,10425055,10508036,10407228,10407229,10407232,10413269,10411284,10411285,10409352,10483073,10483080,10483081,10483082,10409619,10409620,10409622,10483411,10483412,10483413,10483414,10483415,10483416,10483417,10483418,10411839,10486566,10486568,10411929,10407946,10411966,10407991,10407998,8562984,8562985,8562986,10496719,10408164,10410271,10410277,10486952,10493047,10412469,10414519,10414534,10414535,10478206,10478207,10412568,10412584,10412618,10412619,10412620,10412621,10412626,10493296,10493299,10493300,10414652,10414661,10414669,10412674,10412679,10414682,10414686,10414687,10414688,10414690,10414705,10408707,10414714,10476375,10414720,10412720,10414733,10414749,10414750,10414758,10414759,10414762,10414766,10414767,10410769,10414770,10414771,10414774,10408774,10414824,10408826,10408828,10414838,10414849,10410913,10406982,10406985,10406987,10406988,10406989,10406990,10406991,10406992,10409045,10407077,10407087) 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'