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(7076016,10988868,10988904,10988906,10988907,10988908,10988909,8630938,8630939,8630943,8838942,3228994,3228995,3229003,3229004,3229005,3229006,3229007,4970846,3229046,4970847,4970849,4970850,4970851,8621491,3229079,3229099,3229100,3229120,3229121,3229122,8621548,10950362,10950363,10950364,10950365,10950366,10950367,10950368,3229251,10944339,11041613,11041641,11041642,8575175,8621872,7066208,10847070,10847098,3229877,7074459,3229945,3229947,3229948,7066551,7066552,7066554,7066555,7066557,7066558,7074690,3230163,3230168,3230169,3230170,3230171,3230172,3230173,3230174,3230175,3230176,3230177,3230178,3230184,3230185,3230187,3230188,3230191,3230192,3230193,10951420,10951421,10437696,10951545,8619775,8619797,10929297,8573341,8573342,8837703,8837704,8837705,8837706,8837719,8837735,8837736,10929655,10929657,10929658,10962077,11040266,11040267,10929906,10962362,10845442,8573912,10939437,10939552,10939553,8911102,8911103,8594740,8065079,8065086,10103341,8594862,7064373,10960064,10999129,8595138,3899123,10103779,7201971,10986610,10986614,8065908,8065909,8065910,8065911,8065912,10960620,10999677,10843781,8572257,10961046,10961047,10961048,10961049,10961050,10961051,10961052,10961053,10844122,10961054,10961055,10961056,10961057,10961058,10961059,10961060,10961063,3227091,3227107,3227110,10844453,10844461,11013431,11013432,3227190,11013482,11013483,11013484,11013485,11013486,11013487,11013488,11013489,11013490,11013491,11013492,11013493,11013494,11013495,11048908,11010741,3927492,8910236,7200441,10841971,8910352,3927734,10842169,11037151,7200737,10943153,10943154,8910651,6000123,8064827,8064828,8908063,3655594,3925461,8614906,10940708,10995876,10995877,10995878,10995879,10941002,7198682,10996185,10996186,10996244,10996245,10996246,8072651,8072656,8072671,8072676,3236380,8072696,8909024,8615828,8564712,3926736,11036271,10841391,3927101,3927102,3927103,7070740,10841524,3927318,10954640,10954657,10954658,10954659,11032750,11032753,4936813,8612934,3233546,3233547,3233548,3233549,3233550,3233551,3233552,3233553,3233554,3233555,3233556,3233557,3233558,3233559,3233560,10837896,10967839,11032892,11032893,11032894,11032895,11032896,10623256,10623257,3923678,11032992,11032993,11032994,11032995,11032996,11032997,11032998,11032999,11033000,11033001,11033002,11033003,11033004,11033005,11033006,11033007,11033008,11033009,11033053,7196649,10955126,10623491,10623513,10623514,10994375,7157287,3924143,7197037,10994489,8906902,8906903,7157419,7157420,8906974,8906975,8071014,10839101,4938355,4938360,3925036,3925037,4938375,4938380,7197915,4938400,8614624,8614625,3232369,10621987,11005664,11005665,11005666,11005681,8541599,8611956,10992838,3232585,8541693,10837008,8905344,10837074,10927924,7156008,7156009,10954285,8905714,8542186,8542208,10993427,11006455,11006463,11006464,11006465,3233235,11006555,10617936,3233329,10617937,10617938,10614980,10615024,10615041,10425387,8570026,10920603,10615093,10920604,10615094,10920605,10920627,8632766,10425487,10615337,10926014,10926193,10926194,10926195,10926240,10930793,10991526,10991541,10991542,10991543,10991544,10991545,10952623,10426372,7154558,7154559,8610858,10952828,10952829,10952830,10952831,3231726,8633973,11044050,8577688,8577689,8577690,10616669,8611539,8611540,3232177,7155335,8577979,8577981,8634477,8611691,8611703,10427257,10927447,10953602,10953603,8853172,7019001,8853182,9189448,9165457,8853313,8853315,7059760,10562421,10562422,10611360,10714207,10121945,10121961,10611448,10611449,10611450,10611451,6670040,8864411,8864412,10565719,10565720,10565721,10565722,10565723,10565724,10565725,10565726,10565727,10565728,10565729,10565730,10565731,10565732,10565733,10565734,10565735,10565736,10565737,10565738,10565739,10565740,10565741,10565742,10565743,10565744,10565745,10565746,10565747,10565748,10565749,10565750,10565751,10565752,10565753,10565754,10565755,10565756,10565757,10565758,10565759,10565760,10565761,10565762,10565763,10565764,10565765,10565766,10565767,10565768,10565769,10565770,10565771,8853796,8568476,9214007,10565940,10565941,10565942,10122335,3962587,3962588,8861852,8861853,9187351,10119663,10119719,10119722,10119723,9211526,9211528,9211932,9196016,9196017,9196018,8862656,8862659,10612849,10612886,9172265,10613034,10610080,10610086,10613141,9220456,9164632,9188646,9188647,9188659,9188660,9188668,9188669,9188670,9188672,7018503,10121055,10121069,10121070,10121072,6677219,8863540,8567639,10117521,9161351,9161352,9161398,8849316,989919,9161546,9193558,10125765,9185637,4974612,4974613,7023561,7023575,7023588,8849788,8849793,8849794,7023657,8849837,8849876,7023746,9162107,7023796,10118350,9170163,9186214,9170245,9170246,9170247,9170248,9170249,9170250,9170251,9170252,9170253,9170254,9178296,8551647,2809235,8551911,10118883,10118884,10118885,10118886,10118887,2809320,2809321,10118890,2809322,10118891,2809324,9170934,8552239,8850823,8850824,8850825,8850826,8850827,8850829,8850830,8850832,2809641,8918049,6672622,6672624,10415411,10116720,9184525,6672785,10415505,6672795,10416534,6680840,10419575,10419576,10419577,10419578,10419579,10419580,10419581,10419582,9160873,8848723,8848724,8848725,8848726,8848727,8848728,8848729,8848730,8848731,8848732,6673163,6673165,9160967,6673178,6673193,10416941,9161023,6673263,6673264,6673281,6673282,9209084,9209085,9209086,9209087,9185094,9185111,9185112,10420034,10117324,6681337,6681338,10419122,10125429,10125430,8568813,8864929,8864946,9206473,9206488,9206504,8865131,8549816,6670913,6670914,6670915,8549897,8550005,10471429,10471430,10471431,10471432,10471433,10471434,10471435,10471482,10471483,10471484,10471485,10471486,6666933,6671147,6679201,10463583,6667155,6667156,6667157,6667158,8916860,9175287,10123512,9183370,9183375,9183376,9183377,9183378,9183379,9183380,9183389,6665650,8847267,8847268,10464050,8550676,9191560,9207570,10115834,8847469,8847470,8847472,9207710,8917360,9207729,9207730,9207731,4972616,4972620,9207812,9207813,9207814,9207841,9207842,9207843,9207844,9207845,9175874,9175880,9167892,10116098,10116119,8551152,8848001,8848002,8848003,8848004,9168235,9168236,9168237,9168238,9168239,9168240,9168264,4973144,4973145,4973146,10883564,10903576,10903577,10903578,10883589,10888607,10883624,10883632,10946587,10946588,10946589,10946590,10159828,10888914,10904076,10884322,10894377,10628931,10899507,10899536,10155828,10155829,10879846,10879891,10879892,10879901,10879914,10874929,10890089,10885215,10171234,10156261,10156264,10885386,10158720,7001006,10168844,10168845,10887867,10887868,10887976,10883104,10888115,10903145,10903161,10903168,10903169,10903170,10883318,10893428,10630150,10630151,10890680,10890681,10890682,10890683,10890684,10890685,10890686,10171698,10890687,10890688,10890689,10890690,10890693,10890694,10890695,10176723,10181740,10181741,10181800,10181801,10181802,10181803,10181804,10181805,10181806,10161920,10171977,10171978,10171984,10949044,10949045,10949046,10949047,10949048,10949049,10949051,10949052,10949053,10625755,10625756,10625757,10625758,10625784,10625785,10625786,10625787,10625788,10625789,10625790,10162431,10162432,10162433,10162488,10187549,10876815,10187863,10187869,10187873,10187981,10887066,10877123,10163467,10602162,10602178,10602182,10602184,10601390,10602685,10602717,10602718,10602719,10602727,10602728,10602738,10653128,10647294,10650418,10650419,10650420,10650421,10650422,10644615,10644616,10590974,10651309,10651316,10567367,10591385,10591386,10591387,10591409,10591410,10591422,10591423,10651501,10651502,10601503,10567712,10567713,10567714,10567715,10567716,10601689,10601690,10601691,10579908,10601770,10601772,10547182,10547183,10543295,10529887,10529888,10529889,10529890,10529907,10529968,10529969,10546012,10546035,10530077,10530078,10530088,10546104,10532132,10532133,10532134,10532135,10530152,10530182,10530183,10530184,10530185,10530186,10534186,10530187,10534187,10530188,10530189,10530190,10530191,10530192,10530193,10542259,10542268,10542269,10542270,10542276,10542292,10542293,10542294,10528303,10528304,10528305,10546408,10546409,10546427,10546428,10530724,10530725,10538856,10538857,10538896,10538899,10538915,10520958,10520959,10520960,10520961,10520962,10520963,10520964,10520965,10508280,10421866,10482898,10482899,10407307,10480983,10480984,10407492,10483220,10483221,10483222,10483223,10483224,10483225,10483226,10483227,10483228,10407585,10407592,10407601,10407618,10407646,10407675,10492330,10492331,10407684,10407692,10407693,10407704,10407708,10407718,10407728,10477440,10496512,10407894,10410105,10410113,10410118,10410279,10410280,10410281,10410282,10410283,10410284,10412531,10412666,10485654,10485655,10485656,10485657,10485658,10485686,10485687) 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'