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(11001722,10447966,7068245,7068253,7068287,7068295,7068296,7076307,7068343,7068364,10940151,10940153,10940161,3229195,3229271,3229272,9215606,10976795,10976796,10976797,10976798,10976799,10976800,10976801,10976802,10976803,10976804,10868435,10849496,10849497,10868909,11042411,8629772,10987816,10987817,10987818,8573353,10962163,10962164,8630436,8617935,8911184,10103275,10103276,10842937,10843015,10843114,10843119,7072531,7072702,8911921,8911922,10960625,7073047,8066165,8066166,8595965,8595968,10859676,10859677,10974163,8560556,8560557,8560560,10974494,3237359,3237360,8557910,8557923,10984783,10984813,10102311,10842097,10842118,10102543,10857810,10985232,10985233,10985234,10985235,10985236,10102756,4430408,10943411,10959569,10940759,10970369,8615825,10983756,10941704,10941804,10941901,10941906,10941943,10941994,3236942,3236943,3236944,8616423,8616424,8616481,8616504,10984378,10984379,10984394,10942333,10984395,11048669,7070824,8557865,8557866,7196195,7196197,11045765,11045766,11045767,11045772,11045773,11045774,11045775,11045781,11045798,11045799,11045831,11045835,11045842,11045843,11045844,11045848,11045849,11045850,11045851,11045852,11045854,11045855,11045856,11045857,11045862,8613223,8613257,8613263,8613276,8613277,8613278,8613283,10623501,11007212,3924352,11046647,10968764,10968769,10968775,11046794,11046795,11046796,11046797,11046804,11046836,11046841,11046979,11046983,11046984,11046985,11046986,11046987,11046992,3924776,10982084,8614237,11047110,11047111,11047117,11047127,11047128,11047139,11047148,10995156,11047194,11047209,8555524,8555525,11047266,8555549,8555568,8555576,8555582,11047325,11047328,11047329,11047330,8907723,10982447,8555714,8555740,10992671,10992689,10992690,8541564,10617096,10992791,11044878,11044884,11044885,8541713,11044886,11044887,11044892,11044893,11044894,11044895,11044896,11044897,11044898,11044899,11044900,10992930,10992931,10993040,10993041,10993098,3922815,10993227,10993240,10993241,7156106,8905839,10993566,10993567,10993568,10993569,10993570,10993571,8576167,10615321,10615322,3230778,10920914,10926010,10926278,10930753,10991512,10952791,10426569,8540852,8540878,9218049,9218050,3231855,3231856,3231857,3232020,3232021,3232022,3232067,3232074,3232075,10992353,10992354,10992355,10614068,7019156,9181568,3654794,9213644,9213704,9213705,9213738,9181743,6669952,10611436,9213869,9213874,9213880,9181886,7019586,10122168,10122190,9182076,9182089,9182101,10122317,9182123,9182124,9182125,8549453,10119514,9211460,9211461,9211462,9211483,9195487,9195488,7025206,9203663,9203664,9203665,9203666,9171688,7025506,10120077,10120078,9211892,8862567,7025742,7025857,9172211,7025914,7025920,10609946,10609947,9204291,7026002,7026104,6676686,9914706,9188512,9196617,10613297,10610484,9915056,8852818,9189051,7018909,9177319,10125560,7023081,10515290,10117804,9185608,9185614,9185626,9193642,9185712,10513528,10513529,9177839,7023633,10126189,9210005,9210006,9210007,9210008,9186079,9186097,7056273,7056281,7056284,9186154,9194316,9194317,9194318,9186324,9186325,9186406,9186519,9186529,8850357,8850358,8850361,8850376,8850377,8850388,8850389,8850390,8850391,8850392,8850394,8850398,8850401,8850403,8850404,8850406,8850409,7024254,10556424,10556425,10556426,10556427,10556428,10556429,10556430,10556431,9178619,9186632,9186671,7056978,9186843,7057067,8850759,8850762,8850763,8850773,8850806,8850815,8850816,8850817,8850819,8850829,7024775,7024946,9187295,10124524,7014139,7014140,7022153,9192673,9192687,7022417,4973696,7014558,9193002,9193003,9193016,9177281,9161285,9916543,8864973,8865069,9206561,9206567,9190622,10122875,9206729,8854836,10123217,7020703,7021041,10462404,7021524,9207924,7021757,10164814,10908865,10908866,10159956,10174989,10170223,10170227,10170306,10170307,10170308,10170316,10170330,10889493,10170618,10170623,10165665,10170681,10170682,10170701,10899890,10899891,10905322,10186466,10183859,10174008,10908464,10908465,10908466,10166964,10167333,10896362,10167445,10167536,10187697,10896918,10902062,10168145,10183223,10631757,10631758,10183391,10602237,10602741,10650011,10598962,10598963,10598964,10598965,10598966,10598967,10598968,10598971,10599046,10587159,10584351,10653676,10581763,10603695,10603702,10599970,10599971,10603850,10600507,10607674,10601018,10601019,10586083,10586084,10586085,10577096,10553124,10553125,10553126,10553127,10553128,10553129,10553130,10553131,10553132,10553133,10553134,10553135,10553136,10553137,10523227,10523414,10523415,10523416,10523417,10523418,10523419,10523420,10523421,10523422,10523423,10523424,10523425,10523426,10523427,10537500,10537501,10537502,10537503,10537504,10537505,10529506,10537506,10529507,10537507,10531539,10531540,10531658,10531659,10541661,10541662,10541663,10531793,10531794,10531804,10531805,10531806,10531807,10531808,10531809,10531810,10531811,10531812,10531813,10531814,10531836,10531837,10531838,10531839,10531840,10529909,10529910,10529911,10529912,10529913,10529914,10531934,10531935,10529948,10529949,10529950,10529951,10529952,10529953,10529959,10529970,10530038,10530039,10530040,10530041,10530042,10530043,10530044,10530045,10530046,10532081,10532082,10532115,10532116,10532122,10532123,10532124,10532125,10532126,10532127,10532128,10532129,10530155,10530156,10534204,10532413,10532414,10532415,10532416,10522519,10522520,10538522,10530553,10530560,10530561,10532565,10532566,10532567,10532568,10532569,10532570,10532571,10532605,10532606,10532607,10532608,10532609,10532610,10532611,10532612,10532613,10532614,10532615,10532616,10532617,10532618,10532619,10532620,10532621,10532622,10524632,10524633,10524674,10524698,10524699,10530744,10530793,10540813,10540814,10528823,10528824,10524850,10532904,10532905,10530922,10530923,10530924,10530925,10530926,10530927,10530928,10530929,10530930,10530931,10532966,10548990,10530990,10548991,10548992,10548993,10533014,10533015,10533016,10533017,10533018,10533019,10533020,10533021,10533022,10533023,10533024,10533025,10533026,10533027,10533028,10533029,10533030,10533031,10533032,10533033,10533034,10533035,10533036,10533037,10533038,10533039,10533040,10533041,10533042,10533043,10533044,10533045,10533058,10533059,10533060,10533061,10533062,10533063,10533064,10533065,10533066,10533067,10533068,10533069,10533070,10533071,10533095,10533096,10509497,10509498,10509499,10509500,10509501,10509502,10509526,10510733,10510734,10510735,10509740,10509741,10510769,10510770,10510771,10510772,10510773,10507773,10508791,10508792,10510016,10510017,10508042,10495910,10495913,10495915,10495916,10495919,10495920,10481040,10481041,10481106,10483145,10477213,10486278,10486279,10486303,10486472,10481481,10481681,10414106,10414107,10481893,10479894,10481980,10481986,10407080,10407081,10407110) 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'