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,10845841,8838620,10988868,10988904,10988906,10988907,10988908,10988909,7076314,7076315,10940003,8838942,4970846,3229046,4970847,4970849,4970850,4970851,8621491,3229086,3229087,3229088,3229089,3229090,3229091,3229095,3229096,3229097,3229098,3229099,3229100,3229120,3229121,3229122,8621545,8621548,10950362,10950363,10950364,10950365,10950366,10950367,10950368,3229251,10944339,11041648,8575175,7074004,8621872,11041731,11041732,7066208,10847070,10847098,8622203,8622208,10951032,10951033,3229877,7074459,3229945,3229947,3229948,7066551,7066552,7066554,7066555,7066557,7066558,10951202,11042317,11042318,7074690,3230167,3230170,3230171,3230172,3230173,3230185,3230191,3230192,3230193,3230194,3230195,10951420,10951421,10437696,10460464,10460465,10951545,3227400,3227406,10929297,10844828,8573341,8573342,8837703,8837704,8837705,8837706,8837736,10929655,10929657,10929658,10962077,10962109,11040266,11040267,11040269,11001277,10929906,10962362,10962363,11001373,11001374,10845442,8573912,7075754,10939552,10939553,8065079,8065086,10103341,7064373,10960064,10999129,7072621,7072622,7072624,3899123,7072629,10103779,7201971,10986610,10986614,8065908,8065909,8065910,8065911,8065912,10960620,10999677,10843781,8572257,8619120,10961046,10961047,10961048,10961049,10961050,10961051,10961052,10961053,10844122,10961054,10961055,10961056,10961057,10961058,10961059,10961060,10961063,8837023,3227103,3227104,3227105,3227109,11013431,11013432,3227190,11013482,11013483,11013484,11013485,11013486,11013487,11013488,11013489,11013490,11013491,11013492,11013493,11013494,11013495,7073880,11048908,11010741,8616933,8910236,8910237,7200441,10841971,8910352,8617210,8617212,11049287,10842169,11037151,11037164,8910651,10943371,7071808,10998520,10998521,10998522,10998523,8064827,8064828,8835375,3655594,8614906,11034921,3235726,10941002,10840180,7198682,11035323,3656486,8072651,3656487,8072656,8072671,8072676,3236380,8072696,8909024,8564712,8072805,7070080,11022803,11022806,11022807,11022812,11022813,11022815,11022944,11022945,11022946,11022949,11022950,11022952,11022953,11022954,11022958,11022959,11022961,11022963,11022964,11022966,3656935,10971190,11048465,11036271,10997362,7070740,3233356,10954640,10954657,10954658,10954659,11019689,11019690,11019691,11019692,11019693,11032750,4936813,8612934,3233546,3233547,3233548,3233549,3233550,3233551,3233552,3233553,3233554,3233555,3233556,3233557,3233558,3233559,3233560,10837896,10967839,11032892,11032893,11032894,11032895,11032896,11032992,11032993,11032994,11032995,11032996,11032997,11032998,11032999,11033000,11033001,11033002,11033003,3233773,11033053,7196649,10955126,3233891,10623513,10623514,3234036,10994375,7197037,10994489,8906902,8906903,8906974,8906975,11046677,11046678,11046679,11046680,11046681,11046682,11046683,11046684,11046685,10838911,10619224,8071014,10619374,10839101,4938355,4938360,4938375,4938380,7197915,4938400,4938505,8614624,8614625,10621987,11005664,11005665,11005666,11005681,8541565,8541566,8541599,8611956,10992838,3232585,8541693,11044920,8905344,10837074,10954013,10954014,10954015,10954016,10954017,10954018,10927924,10928019,10954285,8905714,8542208,11006463,11006464,11006465,3233235,10617936,3233329,10617937,10617938,10615024,10615041,10425387,8570026,10615093,10920603,10920604,10615094,10920605,10990762,10990763,10920627,10425487,10925713,10620314,10620315,10620316,10620318,10615337,10920883,10920884,10920885,3231081,10926240,10926249,10848530,10926328,10930793,10991526,10991545,10921510,10921512,10616020,10952623,10426372,8610858,10921560,10952828,10952829,10952830,10952831,10926717,10926718,10921719,10926719,3231725,3231726,11044050,10621430,10621431,8577688,10616669,8611539,8611540,8577979,8577981,8577986,8611691,8611703,10427257,10927447,10953602,10953603,10611011,9189448,9165457,9213570,9213571,9213572,9213573,9213574,9213575,9213576,7059760,10562421,10562422,10611360,10714207,10121945,9205756,10121961,8864304,10611448,10611449,10611450,10611451,6670040,10562676,10562677,10562678,8864411,8864412,6666004,9214007,9214068,10122335,8864671,8864708,3962587,3962588,8861852,8861853,9187351,10119719,10119722,9211526,10119723,9211528,10119728,10119729,10557462,10557463,10557465,10557466,10557467,9195927,9211932,9171980,9196016,9196017,9196018,8862656,8862659,10612849,10612886,9172265,9172326,10613034,10610080,10610086,10613141,9220456,9164632,7018503,10121055,10121069,10121070,10121072,6677219,8863540,10117521,9161351,9161352,9161546,9193558,10125765,9185637,4974612,4974613,7023561,7023575,7023588,10513798,10513804,10513808,7023657,7023746,9162107,10118334,7023796,10118350,9170163,9186214,9170245,9170246,9170247,9170248,9170249,9170250,9170251,9170252,9170253,9170254,9178296,8551647,10556346,10556347,10556348,10556351,10556352,10556353,10556354,10556355,10556360,10556364,10556365,2809235,8551911,10118883,10118884,10118885,10118886,10118887,2809320,10118890,2809321,2809322,10118891,2809324,10516705,9170934,8552239,10518787,10518793,10518796,10518797,10518798,2809641,9179193,9187265,9187267,9187268,9187294,9160375,8918049,6672622,6672624,10415411,10116720,9184525,6672785,10415504,10415505,6672795,10416534,10419575,10419576,10419577,10419578,10419579,10419580,10419581,10419582,10419676,10419677,10419678,10419679,9160873,9208910,9208912,6673163,6673165,9168970,9168971,9168972,6673178,9168973,9168974,6673193,10416941,9161023,6673263,6673264,6673281,6673282,9209084,9209085,9209086,9209087,9185094,9185111,9185112,10420034,10117324,10417083,10417084,10419122,10125429,10417181,10417182,10417183,10417184,10417185,10417186,10417187,10417188,10417189,10417190,10417197,10417198,8864929,8864994,9206473,9206488,9206504,8865131,6670913,6670914,6670915,8549897,4971645,8550005,10471429,10471430,10471431,10471432,10471433,10471434,10471435,10471482,10471483,10471484,10471485,10471486,6666933,6671147,10463583,9175042,6667155,6667156,6667157,6667158,8916860,9175287,9183370,9183375,9183376,9183377,9183378,9183379,9183380,10464050,9191560,9207729,9199743,9199744,9199745,4972616,4972620,9207813,9207849,9207850,9175874,9175880,9167892,10116098,10116119,8551152,8551325,9168235,9168236,9168237,9168238,9168239,9168240,9184262,9168264,8917920,4973144,4973145,4973146,10883564,10883589,10888607,10883624,10883632,10169704,10169705,10946587,10946588,10946589,10946590,10159828,10159841,10888914,10888923,10884052,10884322,10894377,10628931,10894646,10894647,10170731,10170732,10155807,10155828,10155829,10879846,10629341,10629342,10879891,10879892,10879901,10879914,10874929,10875132,10885215,10171234,10156261,10156264,10885369,10885386,10183508,10158720,7001006,10168844,10887867,10887868,10887976,10883104,10888115,7001376,10883318,10893428,10630150,10630151,10890680,10890681,10890682,10890683,10890684,10890685,10890686,10171698,10890687,10890688,10890689,10890690,10890693,10890694,10176723,10176734,10181740,10181741,10161920,10171977,10171978,10171984,10177075,10949044,10949045,10949046,10949047,10949048,10949049,10949051,10949052,10949053,10625755,10625756,10625757,10625758,10625784,10625785,10625786,10625787,10625788,10625789,10625790,10949119,10162431,10162432,10162433,10162488,10187549,10631065,10187720,10187721,10187722,10187723,10187724,10187725,10876815,10187863,10187869,10187873,10187981,10887066,10877123,10877124,10631798,10163467,10601166,10586229,10601390,10586558,10589633,10598938,10598952,10598953,10598986,10598987,10598988,10598989,10598990,10598991,10598992,10598993,10598994,10598995,10598996,10598997,10598998,10598999,10599000,10599001,10599002,10590086,10644615,10644616,10590974,10582225,10567367,10567712,10567713,10567714,10567715,10567716,10588728,10585864,10579908,10585999,10543295,10521321,10521322,10541337,10541342,10541343,10541344,10541345,10541346,10541347,10541348,10541349,10541350,10541351,10541352,10541353,10541354,10541355,10529792,10529887,10529888,10532132,10532133,10532134,10532135,10530182,10530183,10530184,10530185,10530186,10534186,10530187,10534187,10530188,10530189,10530190,10530191,10534191,10530192,10530193,10534201,10534202,10542259,10542268,10542269,10542270,10542276,10542292,10542293,10542294,10528303,10528304,10528305,10538430,10528718,10530724,10530725,10538856,10538857,10538858,10522863,10538896,10538899,10538915,10520958,10520959,10520960,10520961,10520962,10520963,10520964,10520965,10541033,10541034,10541036,10421866,10420924,10482898,10482899,10483220,10483221,10483222,10483223,10483224,10483225,10483226,10483227,10483228,10492330,10492331,10492369,10492370,10477440,10496512,10481634,10481872,10481873,10481876,10478209,10478210,10478211,10478212,10478213,10478214,10476513,10485654,10485655,10485656,10485657,10485658,10472669,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'