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,8836012,8618409,7076096,7068142,10103888,8618599,8618600,10198515,10943825,10104009,7076356,10943877,7076392,8569459,8569568,8569569,8618986,8619005,8619007,8569651,8619075,10944226,10251144,10251442,10251513,10251514,7066341,7066342,10251605,10251606,10251607,10251685,10251686,7074460,7074486,7074867,7074870,10249157,7067188,8835216,8835217,8835218,8835219,8835220,8835221,8835222,8835223,8835224,8835225,8835226,8835227,8835228,8835229,8835230,8835281,10236683,10236684,10236685,8617875,8617879,7067608,7075647,10103384,7067745,10249997,10247097,10247098,10273110,6000192,10195152,7064041,7064057,7064058,7064059,7064060,7064061,7064062,7064063,7064064,8564465,8615679,8564569,8564572,8564577,8564590,7064368,8564593,8615821,8615822,8615823,8075328,10195899,10101390,8616165,10932248,10196144,8565148,7064978,8616402,7065071,7065075,10196345,10101779,10101786,10196483,7073281,10102017,10102048,10102098,10196704,10248738,10222880,10194169,10285400,10285401,10246598,4938657,5999981,10931203,6000077,6000085,10273057,10944392,10944414,8612393,10944635,8578908,10944754,10283571,10283572,10283573,8612875,8612881,8613016,8613017,10941949,10284591,7070453,8907103,10232776,10284800,10284862,10942502,10432964,10229120,10229175,10229176,10229177,10229178,10229179,10229180,10229181,10229182,10229196,10928685,10928686,10928687,10928688,10928689,10928690,10928691,10928692,10928693,10928694,10928695,10433153,10433158,10190300,10433219,10928793,10433405,10281852,10203909,10203910,10203911,10203949,10203950,10203951,10203952,10203953,10203996,10203997,8577794,10619300,10619301,10619302,10619303,10619304,10619305,10243453,10243454,10243464,10243466,10624434,10204691,10204692,10204693,10204700,10204701,10204702,8578410,10619905,10927495,10927496,10927497,10927498,10432015,10432107,10432108,10432109,10228256,10215383,10215384,10432304,10927893,10927897,10927898,10927900,10927901,10927902,10927911,10927939,10927965,10927969,10927970,10927971,10280579,10280580,10228590,10228591,10228592,10228593,10928012,10228594,10228595,10228596,10228597,10432457,10228598,10228599,10228600,10228601,10228602,10928021,10928117,10928125,10928129,10928130,10928131,10617801,8576429,10202996,10622898,10202997,10202998,10622899,10622900,10622901,8576506,8576507,8573600,8573601,8573637,8573640,10615091,8837958,8573894,8570180,10925878,10925879,10926013,10926057,10926060,10926061,10926062,10926065,10926102,8570431,10926122,8570446,8570447,10926132,10926133,10926147,10926182,10926186,10930508,8838564,10200812,10239830,10926252,10926321,10930729,10930734,10616003,10926698,10188328,10926759,10926760,10188368,10188369,10188370,10188521,10188522,10188523,10188524,10188525,10188526,10431391,10201605,10201606,10227657,10201673,10201683,10927109,10922162,10616645,10922163,10922164,10922165,10922166,10922167,10922168,10927201,8575486,10927443,10927449,10927450,10927451,10927452,10927453,10927454,10927455,10927463,10927467,10927468,9189648,9189652,9189741,9189748,9173800,10614557,10614571,9181934,9174038,9174042,8864578,8864579,8864580,8864581,8864582,8864583,8864595,8864601,8864614,8864635,9214113,8864659,8864660,9174140,9214145,8864691,8864692,9174171,9174192,8864720,8864721,9198201,9174207,10566055,10566056,9174269,6666286,6666287,9190292,9187346,9187376,7057587,9171431,9179530,9179538,9179540,9211565,10563545,9171739,9179804,9179812,7058023,9211877,9195930,7017673,7017674,7017681,7017682,7017693,7017694,9164098,9212101,9172188,9172192,9188209,9188212,9172224,9188225,9204242,10613023,7058547,9188486,9188489,8863045,8863049,9188529,8863054,9188544,8863073,9188562,9188563,9188581,9188589,10613297,10613298,10613300,10613301,10613302,10613303,10613304,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,7056127,7056128,7056129,7056130,7056131,7056132,7056133,10511773,10511774,7056134,10511775,7056136,10511776,7056137,10511777,10511778,10511779,10511780,10511781,10511782,10511783,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,9170375,10516185,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,9160358,9160359,9160360,9160378,9160379,9160380,9160381,9160382,9160383,9160384,9160385,10419300,9160386,9160387,9160388,9160389,9160390,9160391,9160392,9160393,9160394,9160395,9160396,9160397,9160398,9160399,10416327,10417386,10419400,10417426,10419433,10419434,10416452,9160544,10416473,10416483,10416486,10417496,10417497,10419502,10419508,10419513,10419519,10418538,10418545,10419559,9160682,9168762,10418678,10418682,10418684,9168797,7054964,4973667,10419784,10419788,9184919,9161022,4974006,4974007,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,8550013,6666862,6666863,9198943,9198944,9206975,9199045,8550235,8550236,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,9175574,9167630,9167632,9199817,9207832,9199889,9199892,8917630,8917631,8917707,9176103,8917817,9192292,9176296,9160302,8593542,8593543,10164797,10628304,8593950,10628514,10160056,10155100,10175104,10175180,10175181,10175205,10175207,10628703,10628719,10628720,8594351,8594469,10175590,10180668,10875134,10875135,10875136,10875137,10875138,10875139,10875140,10875141,10875142,10875143,10875144,10875145,10875146,10875147,10875148,10875149,10875150,10875151,10875152,10875153,10875154,10875155,10875156,10875157,10875158,10875159,10875160,10875161,10875162,10875163,10875164,10875165,10875166,10875167,10875168,10875169,10875170,10875171,10875172,10875173,10875174,10875175,10875176,10875177,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,8593313,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,10654654,10654655,10654656,10654657,10654658,10654659,10654660,10654661,10654662,10654663,10654664,10654665,10654666,10654667,10654668,10654669,10654670,10654671,10654672,10654673,10654674,10654675,10173401,10580120,10580121,10580122,10580123,10580124,10580125,10580126,10580127,10586600,10589892,10584476,10584477,10567396,10567500,10579790,10579791,10568078,10568079,10568080,10568081,10568082,10537426,10521483,10521484,10521841,10521842,10529875,10530139,10534220,10534221,10534222,10534223,10538309,10534385,10534386,10532404,10538489,10522515,10522516,10522565,10532656,10532657,10538725,10520841,10520842,10520843,10520844,10520845,10520846,10520847,10520848,10538877,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'