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(7067862,10988614,10988615,10988616,10988617,10988618,10988619,10988620,10988621,10988622,10988623,10988624,10988625,10988626,10988627,10988628,7076024,7076048,10943611,10943612,10943613,10943614,10943615,10943616,10943617,7076336,4970677,7068432,7068435,7068436,7068437,7068438,7068439,7068440,7068441,7068442,7068443,7068444,10940248,10940249,10940250,10940251,10940252,10940253,10940254,8569560,8569561,8569562,10989392,10976499,10933260,4968183,7065876,7065894,4968293,4968295,8067042,4968426,10990006,10990007,10990008,10990009,10990012,10990014,10990015,10437286,4968677,11029039,10990201,10990217,7074550,7074551,7074552,10437533,10437534,10990280,10990287,10990293,10990303,10990317,10990318,10990319,10990320,10990321,10990322,10990323,10990373,4969042,4969043,4969044,4969045,4969046,4969047,4969048,4969049,4969050,10964458,4969134,10974538,10974540,10987577,10974586,10974588,10974589,10938682,10938683,10938684,10938697,10974687,4969385,10974947,10938999,10939000,10939001,7067311,7067312,7067313,10962119,10962121,10962122,7067490,7067498,7067507,10939299,7067615,10939378,10975406,10975421,8064910,8064976,8065128,7072151,7064226,7064345,7064346,7064347,7064348,7064349,7064350,7064351,7064352,7072486,10973238,10960323,10960324,10960325,10960326,10960327,10960328,10960329,7064646,10960330,10960331,10960332,10960334,10960335,10960354,8065921,7065094,10932635,7065215,7065216,7065217,7073275,10987050,10987051,10987052,10987053,10987054,10987055,10987056,10987057,10987058,10987059,10987060,10987061,10987062,10987063,10987064,10987065,10987066,10987067,10987068,10987069,10987070,10987071,10987072,10987073,10987074,10987075,10987076,10987077,10987078,10987079,7065525,10961267,10961268,10961269,4967950,4967951,4967952,4967953,4967954,4967955,4967956,4967957,4967958,4967959,4967960,4967961,4967962,4967963,4967964,4967965,4967966,4967967,4967968,4967969,4967970,4967971,4967972,4967973,4967974,4967975,4967976,4967977,4967978,4967979,10987356,10987360,10987361,10933155,10933156,10958516,8970182,8860769,8860853,8860854,8860855,8860856,11010707,11010709,11010710,11010728,10942783,8064177,8861024,10958828,10958829,10958830,10958831,10958832,10958833,10958834,7071150,10958835,10958836,10958837,10958838,10958839,10958840,10958841,10958842,10958843,10985136,10985137,10998225,8064613,8064614,8064615,8064616,8064617,8064618,8064619,8064620,8064621,8064622,8064623,8064624,8064625,8064626,8064627,8064628,8064629,8064630,8064631,8064632,8064633,8064634,8064635,8064636,8064637,8064638,8064639,8064640,8064641,8064642,7071573,8064643,8064644,8064645,8064646,7071578,10944485,10944486,10944487,10940789,10940916,10956975,10956977,10956978,10956979,10956980,10956981,10956983,10944915,10944916,10944917,10944918,10944919,10941159,10941160,10941161,10941162,10941163,10941164,7069453,7069654,3656424,3656425,3656426,3656427,3656428,3656429,3656430,3656431,3656432,3656433,3656434,3656435,3656436,3656437,10957459,10941527,10941528,10941529,10941530,10941531,10941532,10941533,8072688,8072689,8072690,8072691,8072692,7069869,10941596,10941597,10941598,7069902,7069903,7069904,7069905,10996714,10957812,10957813,10957814,10957815,10957816,10957817,10957818,10957819,10957820,10957821,7070301,7070302,7070303,7070304,7070305,7070306,7070307,8860225,8860226,7070399,7070400,10958179,10942273,11010322,10942455,8970064,11006618,11006680,10918694,10623218,10623219,11006817,11006818,10618294,11006843,10968099,10618637,10623677,11007273,11007294,11007295,10994307,10968372,10624209,10624210,10624211,10624212,10624213,10624214,10624215,11007753,10624216,10981801,10619361,10624572,10624573,10624574,10995153,11021349,11021358,10953530,10953555,10953556,10953557,10953558,10953559,10953560,10953561,10953562,10953563,10953564,10953565,10953566,10953567,10953568,10953569,10922616,10966893,10966894,10953900,10966958,10966959,10927982,10927986,10967133,10967134,10967135,10967136,10967137,10967138,10617732,10967273,10622771,8569842,10990575,8569867,10990576,10990577,10990578,10964617,10964618,10964619,10964621,11016639,11016640,11016641,11016642,11016643,11016644,8569985,8569986,10915725,10915726,10915727,10615254,10615332,10615359,10615592,10615594,10615595,10615596,10620852,10620853,10620854,10620855,10620856,10930690,10615926,10930747,10930748,10978792,10978800,10952981,10952982,8863903,7059688,10559342,10559343,10559344,10559349,10559350,10614221,8864100,8864101,8864138,9189629,7059860,7059885,8864305,8864412,9173928,9173943,9165975,9165976,6666221,9174243,9174244,10611916,10614931,10614932,10611934,10611965,10611966,8861833,8861834,8861835,8861836,8861837,8861838,8861839,8861840,8861841,8861842,8861843,9163434,10563293,8862051,10609320,10609402,9163894,8862467,8862468,8862561,10609717,10609724,9164075,10609820,9180199,9180200,9180201,7058597,10610097,9172440,10613127,7058633,7058678,10613247,10610261,10610262,9164607,9164608,10610297,9188688,9188689,7058855,7058862,8863277,10564599,10613467,9188812,9172870,9164876,9165019,9165020,9165021,9165022,9165023,9165024,9165025,9165026,9165140,10613857,9169404,7055580,9177451,9177452,9177453,9177454,9177455,9177456,9177457,10513324,9185833,9161912,9161936,10516068,10516069,9162319,2809146,9170580,2809510,2809512,2809518,10512760,7057231,10518888,10518894,10518901,10518902,10512938,10512940,10512942,10512943,7057359,7057360,7057361,7057362,7057363,7057364,7057365,7057366,7057367,8861733,8917968,9176333,9176334,9176335,9176336,9176337,9168369,10418294,10415297,10415299,10419312,10419327,10417342,10415387,10416405,4973403,4973432,10419571,10419586,10419587,9176800,10418841,10418842,9184941,9184942,9184943,9184944,9184945,9184946,9184947,9184948,9184949,9184950,9184951,7055235,10417023,10417034,4973980,10418117,7055382,10418143,10418144,10416148,10416149,10416155,10417158,9161261,9161262,9161263,9161264,9161265,9161266,9161267,9161268,9161269,9161270,9161271,9161272,9161273,9161274,9161275,9161276,9161277,9161278,9161292,10468907,10464931,10464932,10470946,10470947,10471248,10465358,10465359,10465360,10465361,10465362,10465363,9166787,10465364,10465365,10465366,10465367,10463472,10463473,10463474,10463475,10463476,10463477,10463478,10463479,10463480,10463481,10463482,10463483,10463484,10463485,10463486,10463487,10463488,10463489,10463490,10463491,10463492,10463493,9174916,10463494,10463495,10463496,10463497,10463498,6666943,9174955,9174961,9174995,6667015,10469634,6667094,8916748,6667109,9167170,9167171,9167172,9167173,9167174,9167248,9167278,8916993,8563365,8563366,8563367,10464136,10470143,9167568,9167569,10464169,9167610,9167611,4972492,4972526,8917375,9167964,4972830,4972831,4972832,8917663,8917675,9168034,9176241,4973095,4973096,8917898,8917899,8917900,8917901,4973130,4973131,10154546,10154556,10164756,10628282,10628285,10154969,10628637,10155193,10155473,10155489,10155493,10155496,10155513,10155514,10155515,10155516,10155517,10155518,10155519,10155520,10155521,10155522,10160523,10155523,10155524,10155525,10155526,10155527,10155528,10155529,10155530,10155531,10155532,10155533,10155534,10155535,10155536,10155537,10155538,10155539,10155540,10155541,10155542,10155543,10155544,10155545,10155546,10155556,10155685,10165838,10165839,10155991,10155992,10166307,10156336,10171432,10171433,10171434,10171435,10166438,10158554,10632045,10158773,10158826,10158929,10164103,10159122,10159123,10159124,10159125,10159126,10159127,10159128,10159129,10159130,10159131,10159132,10159133,10159134,10159135,10159136,10159137,10159138,10159139,10159140,10159141,10159142,10159143,10159169,10159182,10159201,10159230,10159238,10159247,10159260,10159283,10159319,10159342,10159369,10161761,10166816,10625455,10625456,10625457,10625458,10625459,10625460,10625461,10625462,10625463,10625464,10161987,10625465,10625466,10625467,10625468,10625469,10162159,10162342,10162508,10162509,10167582,10162765,10162766,10631383,10631384,10631438,10631476,10158046,10158364,10158380,10631955,10631956,10631959,10574470,10580617,10580618,10580619,10580620,10580621,10580622,10580623,10580624,10580625,10580626,10580627,10580628,10580629,10580630,10580631,10580632,10580633,10580634,10569729,10569730,10569731,10519408,10519409,10519410,10519411,10528455,10529030,10529031,10529032,10529033,10529034,10529035,10420365,10424459,10420481,10421668,10421669,10421670,10421671,10421672,10421673,10422700,10423769,10423770,10421835,10421017,10425035,10421050,10480892,10480893,10472912,10476915,10478943,10476949,10474971,10474972,10473208,10481247,10479278,10475321,10481463,10475513,10475514,10475515,10475516,10475517,10475518,10475519,10475520,10475521,10475522,10475523,10475524,10475525,10475526,10475701,10475786,10473963,10472355,10476545,10476629,10476630) 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'