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(10943434,10943435,8838564,7076096,7068142,10943825,7076356,10943877,7076392,8569459,8569568,8569569,8569651,10944226,10950444,8575486,7066341,7066342,8067413,10951078,7074460,7074486,10951170,10951171,10951172,10990261,8584182,8584183,8584184,10951362,8609588,8609589,8609590,8609591,10938480,10938481,8609640,7074867,7074870,7067188,8573600,8573601,8573637,8573640,8837958,11001159,7067608,7075647,8573894,7067745,10962439,6000192,11011625,7064041,7064057,7064058,7064059,7064060,7064061,7064062,7064063,7064064,11011878,10103384,11011941,11011942,10960013,11012027,11012028,11012029,7064368,11012102,11012103,8075328,10960173,8836012,10960352,10986441,10103888,10960468,10932248,10104009,8065976,8065977,8065978,8065979,8065980,8066011,8066012,8066013,8066040,7064978,10960675,7065071,7065075,7073281,10102017,8063957,8063958,8063959,8063960,8063961,8063962,8063963,8063964,8063965,8063966,8063967,8063968,8063969,8063970,8063971,8063972,8063973,8063974,8063975,8063976,8063977,8063978,8063979,8063980,8063981,8063982,11010597,10102048,10102098,10959242,5999981,8835216,8835217,8835218,8835219,8835220,8835221,8835222,8835223,8835224,8835225,8835226,8835227,8835228,8835229,8835230,10931203,8835281,6000077,10998482,10998483,10998484,6000085,10944392,10944414,4938657,3655793,10944635,10944754,3656301,11009338,8564465,8564569,8564572,8564577,3656564,8564590,8564593,11009751,10941949,11035922,10101390,11035974,8565148,7070453,3657275,10958283,10101779,10101786,10942502,10967569,10967570,10967571,10967572,10967573,11045700,11045701,11045702,10928685,10928686,10928687,10928688,10928689,10928690,10928691,10928692,10928693,10928694,10928695,10928793,11007204,10968240,10968241,10968242,10968249,10968250,10968251,11046633,11007728,11007729,8907103,11046804,10619300,10619301,10619302,10619303,10619304,10619305,11046866,10994881,10624434,11046996,11046997,11047337,11047338,10619905,10927495,10927496,10927497,10927498,10966674,10966675,10966676,8578410,10927893,10927897,10927898,10927900,10927901,10927902,10927911,10927939,10927965,10927969,10927970,10927971,10928012,10928021,10928117,10928125,10928129,10928130,10928131,10617801,10954389,8578908,10622898,10622899,10622900,10622901,10951511,10615091,10990771,8570180,11042902,11042903,10925878,10925879,8576429,8576506,8576507,10926013,10991043,10991044,10991045,10991046,10991047,10991048,10991049,10991050,10991051,10991052,10952022,10926057,10926060,10926061,10926062,10926065,11004114,11004115,11004125,11004127,10926102,8570431,10926122,8570446,8570447,10926132,10926133,10926147,10926182,10926186,10952166,10930508,10952217,10952222,10926252,10965289,10965290,10952284,10926321,10965356,10965366,10930729,10930734,10991481,10952466,10991533,10991534,10991535,10991536,10991537,10991538,10991539,10991540,10616003,10991554,10926698,10926759,10926760,10978805,10978806,10952832,10952833,10952834,10952835,10952836,10952837,10927109,10616645,10922162,10922163,10922164,10922165,10922166,10922167,10922168,10927201,8577794,10927443,10927449,10927450,10927451,10927452,10927453,10927454,10927455,10927463,10927467,10927468,10611254,9189648,9189652,10611342,9189741,9189748,10611431,10611456,9173800,10611519,10614557,10614571,9181934,9174038,9174042,8864578,8864579,8864580,8864581,8864582,8864583,8864595,8864601,8864614,9214113,8864635,8864659,8864660,9174140,9214145,8864691,8864692,9174171,9174192,8864720,8864721,9198201,10611865,9174207,10566055,10566056,9174269,6666286,6666287,9190292,9187346,9187376,7057587,9171431,9179530,9179538,9179540,9211565,10563545,9171739,9179804,9179812,7058023,9211877,9195930,7017673,7017674,9164098,9212101,9172188,9172192,9188209,9188212,9172224,9188225,9204242,10613023,7058547,10610125,9188486,9188489,8863045,8863049,9188529,8863054,9188544,8863073,9188562,9188563,9188581,9188589,10613297,10613298,10613300,10613301,10613302,10613303,10613304,10610367,9204771,9204772,9204773,9196801,9196803,9196804,9196816,9196838,9196944,9196945,9189028,9197033,9189048,9197068,9205136,9189148,9189149,9189152,9189155,9189156,9189157,9189158,9189159,9189161,9189162,9189165,9189166,9189250,9189268,9189284,9189287,9189288,9189292,9169375,10511214,10511215,10511216,10511217,10511218,10511284,10511285,9161481,9161482,9161487,10511328,10511329,10511343,10511344,10511345,10511346,10511347,10511348,10511369,9185582,9185601,9185633,10511467,10511468,10511469,10511492,10511550,10511551,10511552,10511553,10511554,10511555,10511556,10511557,10511558,10511559,10511560,10511561,10511562,10511563,10511564,10511565,10511566,10511567,10511568,10511569,10511671,10511672,10511673,10511674,10511675,10511676,7056083,7056084,7056123,7056124,7056125,7056126,10511773,10511774,7056127,7056128,10511775,7056129,10511776,7056130,10511777,7056131,10511778,7056132,10511779,7056133,10511780,7056134,10511781,10511782,7056136,10511783,7056137,10511784,10511785,10511786,10511787,10511788,10511789,10511790,10511791,10511792,10511793,10511794,10511795,10511796,10511797,10511798,10511799,10511800,10511801,10511802,10511803,10511804,10511805,10511806,9170000,9170093,9170094,9202097,9210163,9170188,9170189,10512046,10512047,10512048,10512049,9170298,10512142,10514166,10516185,9170375,10514236,2809070,2809071,10514293,10514294,10514313,10514314,10514320,10514321,10514351,9186565,9202566,9202625,9202644,9170649,9186658,10514500,10514501,9178705,9178852,9178853,9178854,9186898,9178905,10512735,10512754,9171005,9179118,7057329,8861748,8861764,9187293,9160302,10415256,10415264,10415265,9160358,9160359,9160360,9160378,10419300,9160379,9160380,9160381,9160382,9160383,9160384,9160385,9160386,9160387,9160388,9160389,9160390,9160391,9160392,9160393,9160394,9160395,9160396,9160397,9160398,9160399,10416327,10417386,10415390,10415391,10419400,10417426,10419433,10419434,10416452,9160544,10416473,10415475,10416483,10416486,10417496,10417497,10419502,10419508,10419513,10419519,10418538,10418545,10419559,9160682,10415663,10415667,10415673,10418678,10418682,10418684,9168762,9168797,7054964,4973667,10419784,10419788,10415801,10415808,9184919,10415877,10415889,9161022,4974006,4974007,10416120,10416121,10416176,10416177,10416184,10416185,10416192,8864938,4971345,4971346,4971347,4971348,4971349,4971350,4971351,4971352,9182502,9182503,10467082,4971377,4971378,4971379,8865052,9174561,9174587,9166645,9166646,9166647,9174661,10467239,9166703,9166804,6666862,6666863,9198943,9198944,9206975,9199045,10469699,10469700,10469701,10469777,10469778,10469779,8916862,8916863,6667235,9199271,9191293,9207297,9191300,9167309,9207327,9199336,9199346,8917075,8917084,8917085,9175463,8917120,8917121,8917122,8917123,9175521,8563421,9175574,9167630,9167632,8563595,9199817,9207832,9199889,9199892,10462555,10462556,10462557,10462558,10462559,10462560,8917630,10462561,8917631,10462562,10462563,10462564,10462565,10462566,10462567,8917707,9176103,8917817,9192292,9176296,10164797,10628304,10628514,10160056,10155100,10175104,10175180,10175181,10175205,10175207,10628703,10628719,10628720,10175590,10180668,10168528,10178536,10168580,10632083,10163608,10627106,10627107,10627108,10627303,10627304,10163856,10163857,10163858,10163859,10163860,10163861,10163862,10163863,10163864,10163865,10163866,10163867,10163868,10163869,10163870,10163871,10163872,10163873,10163874,10153908,10153909,10153910,10153911,10153912,10153913,10153914,10153915,10153916,10153917,10153918,10153919,10153920,10153921,10153922,10153923,10153924,10153925,10163939,10183996,10627927,10630033,10630034,10630035,10630036,10630037,10630100,10176646,10176647,10176648,10176692,10176693,10630187,10630188,10161954,10177113,10177118,10177124,10177125,10177166,10177167,10177168,10162281,10177289,10177290,10177291,10177292,10177293,10177294,10177295,10177296,10182310,10945143,10945144,10945145,10945146,10945147,10945148,10945149,10945150,10945151,10945152,10945153,10945154,10945155,10945156,10945157,10945158,10945159,10945160,10945161,10945162,10945163,10945164,10173401,10580120,10580121,10580122,10580123,10580124,10580125,10580126,10580127,10586600,10589892,10584476,10584477,10567396,10567500,10579790,10579791,10568078,10568079,10568080,10568081,10568082,10521483,10521484,10521841,10521842,10529875,10530139,10534220,10534221,10534222,10534223,10534385,10534386,10532404,10522515,10522516,10522565,10532656,10532657,10520841,10520842,10520843,10520844,10520845,10520846,10520847,10520848,10531028,10529066,10529067,10533102,10533105,10533106,10422357,10420420,10423459,10423478,10423532,10421969,10422028,10422047,10423096,10483055,10483064,10483135,10477365,10477452,10486604,10486611,10486612,10476338,10476343,10476349,10476350,10487525,10472575,10472592,10482602,10482603) 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'