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(8574123,8574124,8574129,8574130,8574177,8574178,7076082,7076083,9214849,10939947,10848612,10848613,10939950,10939981,10939982,10940000,7068658,7068659,7068660,7068661,7068680,7068682,7068688,7068706,10940335,7068713,10940348,8574929,8574949,8574950,8574969,8574970,8574987,8574994,8574996,8574997,8575137,8066947,8575157,8583474,8622052,8622053,8622054,8622055,9215896,9215897,10976971,10976972,10950917,11029236,11029237,11029238,8622404,10951353,10929568,10929576,10929592,8573927,8573980,7067878,7067879,7067880,7067883,4430581,8835521,8835522,7201298,3238482,3238499,10972776,8835584,11011899,11011900,11011901,10972912,10972913,10972928,8835733,10972929,8835755,8835771,8835788,8627959,8627965,8627972,8835818,8627977,8627982,8835849,8835856,8835879,8835880,8835894,8835895,10986323,10986324,10986325,10986326,10986327,10986328,10986329,10932145,10932146,10932147,8595555,10843731,8618965,5654762,8836971,8066590,7073698,8066757,8066771,8066772,8066773,8066796,8066818,8066819,3227263,10102102,10102143,8616856,10102193,10102212,10102213,10102250,10102325,10984994,10984995,10984996,10984997,10985012,10985013,10985026,10985027,10985028,10985029,10985044,11049271,10102521,10102526,10842154,10102539,10102554,10972119,10972125,10972126,4430182,4430221,4430222,10943305,10943306,4430401,11037510,11037511,4430468,4430483,4430489,8555901,8555902,8908062,7069017,7069018,10969731,8908117,7069061,8908118,8908119,8908120,8908121,8908122,8908123,8908124,8908125,8908126,8908127,10969763,10969764,10969765,10969766,10940749,10940757,10940772,10969843,10969844,7069221,7069244,7069245,7069246,7069258,7069309,7069326,8556299,8556309,7069411,7069412,7069418,10970102,10970103,7069421,7069422,10970133,10970134,10970135,11035194,11035195,11035196,11035197,11035198,11035201,10840505,10840509,10840510,10840511,10970489,10970490,10970562,10970563,10970564,10970565,10996686,10970882,10970914,10970995,10970996,10970997,10971140,10971141,10971142,10971143,10971144,11048715,10853277,10618277,11032937,10618292,11032973,11032974,11032975,11032976,11032977,11032978,11032979,11032980,11032981,8613141,8613146,10623482,11033142,11033143,11033144,11033145,7157002,11033146,7157003,8613333,8613350,8613410,8613411,11033282,11033327,11033328,11033329,11033330,11033331,11033332,11033333,11033334,11033335,11033336,11033337,11033338,10968607,3924337,10968637,10968646,8613802,8613828,8613929,8613952,8613968,8613992,3924820,10995114,10995115,3924824,3924826,3924845,3924847,3924851,8907604,8907605,10622004,10622005,10622006,10622028,10622040,10622041,10622047,10622054,10622059,7155582,7155598,7155686,7155693,7155697,7155698,7155708,7155709,7155710,7155711,7155724,7155725,8612107,10928235,10928236,10622907,10622908,10425386,3230579,10620235,10620236,10850687,10930737,7154410,7154418,10426488,8904216,8540679,10616202,10616203,8904272,10426586,8904339,8904340,8540886,8540995,10621515,9218147,8577683,8577684,10426882,10426883,8577717,8577731,8541143,8541149,10621722,10621723,3232238,3232240,3232246,3232247,3232249,10927440,3232323,8853192,8853212,8853213,8853214,9165411,9181417,9181421,9181423,9181424,9189471,10565331,10565332,10565333,10714022,8853446,8853472,8853473,10559477,10559478,8853503,8853504,8853534,8853535,8853559,8853560,8853574,10614555,6675609,9187507,9913805,9913806,9913848,9913933,9913989,6676046,9914249,10120295,9212118,10610020,9914715,10120724,10120725,10120728,10120729,10120730,10120737,9914750,9914751,10120752,10120762,9914773,8863106,8567093,8567098,9204887,9204889,8567412,8567438,8567439,8567441,8567442,8567443,3654239,3654274,8863589,8863711,8863812,10610953,9193486,8849319,8849320,9161770,9177781,7056362,8850354,8850356,8850381,8850382,8850383,8850483,8850494,8850498,6674952,10118951,2809388,6674966,8850615,8850616,6675080,6675081,7057077,6675384,6675415,6675449,6675450,6675451,9910581,10419320,10116694,10417435,10417436,6672772,6672869,6672877,9176700,9176742,9176886,8848760,8848761,8848762,8848763,8848764,9911163,10419898,6673273,6673274,9169195,10469489,6666919,9182927,9183258,4972135,9183336,10467960,10467961,10467968,10467969,8847276,8847277,8917176,8917177,4972444,10468185,10468199,10468200,10468201,10468202,10468203,4972485,4972486,4972487,8847491,8847492,8847493,8847494,10462302,10462303,10462304,9199727,9199728,8917703,8551219,8848032,8848033,8848034,8848035,10169491,8593574,8593575,10883570,10883591,10883592,10883637,10883660,10898698,10898699,10164853,10164854,10164855,10164856,8594133,8594143,8594144,8594145,8594146,10894146,8594158,8594159,8594170,8594171,8594172,8594173,10170228,10894220,10170234,10170235,10170236,10170255,10170263,10170264,10170265,10170266,10170280,10894279,10894280,10894281,10894282,10170309,10170310,10170341,10170342,10170343,10165347,10894355,10170374,10170375,10170376,10165376,10165377,10165378,10165379,10170395,10170412,10899404,10899405,10899409,10899410,10899414,10899420,10899422,10165440,10165441,10165442,10165443,10165444,10165445,10165446,10165447,10165448,10170471,10170472,10170473,10170503,10899494,10899521,10170555,10170556,10899545,10899546,10899547,10899562,10899563,10899564,10899565,10170590,10899579,10170591,10170592,10899600,10899613,10899620,10899635,10899641,10899642,10899646,10170671,10170672,10899667,10899668,10894679,10894698,10899790,10884793,10899800,10899840,10879845,10899853,10899854,10899862,10899897,10165909,10165953,10890007,10890008,10166040,10166041,10166042,10166043,10166044,10166045,10166046,10900349,10900350,7000970,10908028,10908029,10908030,10908031,10898182,10898183,10898184,10898211,10898233,10898234,10898304,10169334,10898467,10166618,10166619,10166620,10166621,10166782,10166783,10166802,10166809,10905868,10166882,10166923,10891025,10167129,10167168,10167169,10167170,10167186,10162245,10162257,10162258,10167302,10949105,10896375,10896386,10896395,10896396,10162622,10162623,10162624,10162625,10162626,10162627,10162628,10162629,10162630,10162647,10162648,10162737,10162747,10162773,10162774,10162775,10162776,10162817,10162818,10887096,10887224,10649312,10649313,10649333,10649334,10649366,10649367,10649392,10649393,10649394,10602201,10602206,10649429,10649430,10649504,10649505,10643546,10649735,10649884,10649899,10649977,10649992,10650012,10650013,10650014,10650015,10650016,10650024,10647388,10603693,10647957,10647983,10601710,10525194,10525195,10525196,10525207,10525208,10525212,10525235,10525236,10525237,10525238,10525239,10525240,10525241,10525242,10525243,10525244,10525245,10525246,10525271,10525272,10525274,10525275,10525276,10523335,10523336,10523337,10523338,10523339,10523340,10523341,10525370,10525371,10523432,10523433,10523495,10521565,10523633,10523634,10523635,10523636,10523637,10523638,10523651,10523652,10523653,10523657,10523790,10544162,10544163,10544164,10544165,10544166,10544167,10544168,10544169,10544170,10544171,10544172,10544173,10544174,10544175,10544176,10544177,10544178,10544179,10544180,10544181,10544182,10544183,10544184,10544185,10544186,10544187,10544188,10544189,10544190,10544191,10544192,10544193,10544194,10544195,10544196,10544197,10544198,10544199,10544200,10544201,10544202,10544203,10544204,10544205,10544206,10544207,10544208,10544209,10544210,10544211,10544212,10544213,10544214,10544215,10524272,10524273,10524274,10524275,10524276,10524277,10524278,10524279,10524280,10524281,10526292,10526293,10526294,10526295,10526296,10526297,10526298,10526299,10526300,10526301,10526302,10526303,10526304,10526305,10526306,10526307,10524308,10526308,10524309,10526309,10526310,10526311,10526312,10526313,10526314,10526315,10526316,10526317,10526318,10526319,10526320,10526321,10526322,10526323,10526324,10526325,10526326,10526327,10526328,10524377,10524378,10524379,10524380,10524381,10524382,10524383,10524384,10524385,10534398,10534399,10534400,10524409,10524430,10524431,10524432,10524433,10524434,10524435,10524436,10524524,10524607,10524609,10524610,10524611,10524612,10524613,10524614,10524615,10524616,10524617,10421130,10421200,10421205,10421213,10421218,10480980,10480981,10409463,10409464,10479120,10479121,10481138,10481139,10481140,10481141,10483142,10481142,10481143,10481144,10481145,10481146,10481147,10483150,10479159,10479160,10479161,10479162,10483179,10409609,10481361,10481362,10481363,10481364,10481365,10481366,10481367,10481368,10481369,10481370,10481371,10481372,10481465,10481488,10481511,10481512,10481592,10481593,10481594,10407947,10481689,10481690,10496748,10481810,10481811,10481812,10481813,10481844,10496846,10481870,10481871,10481900,10481901,10481981,10479992,10496996,10478005,10478042,10480049,10497049,10497088,10482092,10482093,10482094,10482095,10482096,10482097,10482103,10482104,10482105,10482106,10482107,10482116,10482117,10482118,10482119,10482120,10480314) 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'