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(8575084,8583477,8583569,8631892,8631893,8631894,8631895,8631896,8631897,3229967,8632283,8632284,8632285,8632286,8632287,8632288,8632289,8632290,8632291,8632292,8632293,8632294,8632295,8632296,8632297,8632298,8632299,8632300,8632301,8632302,8632303,8632304,8632305,8632306,8632307,8632308,8632309,8632310,8632311,8632312,8632313,8632314,8632315,8632316,8632317,8632318,8632319,8632320,8632321,8632322,8632323,8632324,8632325,8632326,8632327,8632328,8632329,8632330,8632331,8632332,8632333,8632334,8632335,8632336,8632337,8632338,8632339,8632340,8632341,8632342,8632343,8632344,8632345,8632346,8632347,8632348,8632349,8632350,8632351,8632352,8609701,10929238,10939187,8630289,8630290,8630291,8630292,8630293,8630294,10939397,10939398,7072068,8627808,8627809,8627810,8627811,8627812,8627813,8627814,8627815,8627816,8627817,8627818,10103438,8627955,8627956,8627962,8627963,8627968,8627969,8627973,8627974,8627978,8627979,7201630,7201740,7201756,7201912,8628494,8628495,8628496,8628497,8628498,8065838,8065839,8065840,7202701,7202702,8629354,8629401,8629403,3237370,3237371,3237391,3237392,10942755,7200584,7200585,8627010,8910582,8910583,7201001,8624786,8624787,8624788,8624789,8624790,8624791,8624836,8624837,8624838,8624839,8624840,8624841,8624842,8624843,8624844,8624845,8624846,8624847,8624848,8624849,8624850,8624851,8624852,8624853,8624854,8624855,8624856,8624857,8624858,8624859,8624860,8624861,8624862,8624863,8624864,8624865,8624866,8624867,8624868,8624869,8624870,8624871,8624872,8624873,8624874,8624875,8624876,8624877,8624878,8624879,8624880,8624881,8624882,8624883,8624884,8624885,8624886,8624887,8624888,8624889,8624890,8624891,8624892,8624893,8624894,8624895,8624896,8624897,8624898,8624899,8624900,8624901,8624902,8624903,8624904,8624905,8624906,8624907,8624908,8624909,8624910,8624911,8624912,8624913,8624914,8624915,8624916,8624917,8624918,8624919,8624920,8624921,8624922,7198680,7198712,7199030,8625444,8625445,8625446,8625447,8625448,8625449,8625450,8625451,8625452,8625453,8625454,8625455,8625458,8625459,8625460,8625461,10101478,10101493,10101532,10101537,11048386,11048387,11048388,11048389,11048446,10618330,10618331,10618332,11045997,10623508,8613322,3234985,3234986,3234987,8624326,8624327,8624328,8624329,8624330,8624331,8624332,8624333,8624334,8624335,8624336,8624337,8624338,8624339,8624445,8624446,10617016,10617031,10617048,10617049,10617050,10617108,10617114,10617123,10617124,10617134,10617135,10617136,10617137,10617145,10617146,10617148,10617149,10617154,10617155,10617156,10617157,10617158,10617159,10617162,10617163,10617164,10617165,10617166,8905300,10617500,10614978,10615141,10615230,10615269,10615335,10615371,10615385,10615386,10615387,10615439,10615483,3581864,3581866,3581871,10615555,10615556,10620565,10615568,10615569,10615570,10615604,10615615,10615647,3231150,10615950,10615952,10615953,10615954,10615955,10615967,10615971,10615972,10615979,10615980,8540595,8540612,8540613,8611238,8611282,8611287,8611329,8611342,10616655,10616704,10616718,10616888,10616911,10611012,10611048,10611053,10611054,10562213,10611064,10562214,10562215,10562216,10562218,10562225,10562226,10614078,10614079,10614085,10614086,10614089,10614106,10614107,10614108,10611126,10611179,10611183,10611184,10611185,10611186,10611187,10611188,10611189,10611190,10611191,10611192,10611251,10611305,10614374,10614465,10614466,10614467,10614468,10614469,10614470,10614475,10614476,10614485,10614486,10614488,10614489,10614492,10614588,10614624,10614632,10562867,10611721,10611764,10611774,10611813,10614894,10614895,10614896,10614913,8549451,10611981,10612168,10612169,10612191,10612192,10612194,10612195,10612196,10612197,10612198,10612201,10612267,10612273,10612320,10612321,10612328,10612757,10612763,10612765,10612766,10612782,10612895,10612896,10609998,10613019,10610046,10610120,10610167,10610168,10613378,8863242,10610398,10610399,10558592,10610486,10610492,10610493,10610497,10561757,10561758,10610658,10610671,10613693,10561852,10561853,10561858,10610709,10561903,10561904,10613754,10613768,10613804,10562038,10562039,10562040,10562041,10562080,10610958,7055465,7055466,10515113,7055467,10515114,7055468,7055469,7055470,9169380,10117693,10117694,10117697,10117741,10117742,10117743,10117744,10117745,10117746,10117747,10117748,10117749,10117750,10117751,10117893,10117894,10117895,10117917,9169846,9169848,6674149,10118191,10118207,10118252,10118253,10118254,10118255,6674267,10118397,10514036,10514037,10514038,10514041,10514075,10514076,10514090,10514091,10514092,10514093,10516133,10516134,10516135,10516136,10516137,10516138,10516139,10516157,10516158,10516159,10516160,10516161,10516162,10516163,10516164,10516165,10516166,10516171,10516172,10118556,10516173,10516174,10516175,10118559,10516176,10118561,10118562,10118563,10118564,10118565,10118566,10118567,10118591,10118592,10514364,10514368,10514369,10514370,10514371,10514372,10514373,10514374,10514376,10514377,10514378,10514379,10514380,10514381,10514382,10514383,10514384,10514385,10514386,7016227,10514387,7016228,10514388,7016229,10514389,7016230,10514390,7016231,10514391,7016232,10514392,7016233,10514393,7016234,10514394,7016235,10514395,7016236,10514396,7016237,10514397,7016238,10514398,7016239,10514399,7016240,10514400,7016241,10514401,7016242,10514402,7016243,10514403,7016244,10514404,7016245,10514405,7016246,10514406,7016247,10514407,7016248,10514408,7016249,10514409,7016250,10514410,7016251,10514411,7016252,10514412,7016253,10514413,7016254,10514414,7016255,10514415,7016256,10514416,10514417,10514418,10514419,10514420,10514421,10514422,10514423,10514424,10514425,10514426,10514427,10514428,10514429,10514430,10514431,10514432,10514433,10514434,10118921,10512559,10514964,10514965,10515067,10515068,10515069,10515072,10515087,10515088,10515089,10515090,10515091,10515092,10515093,10515094,10515095,10515096,10515097,10515098,10515099,10515100,10515101,10515102,6672553,6672554,6672555,6672557,9168513,9168514,9168516,9168518,9168546,9168563,9168568,9168571,9168573,9168574,9168576,9168577,9168578,9168579,9168580,9168582,9168584,9168585,9168587,9168589,9168591,9168593,9168595,9168596,9168598,9168609,9168614,9168615,9168617,9168619,10116819,10116820,9168629,9168631,9168632,9168637,9168643,10419566,10419567,9168653,9168659,9168703,9168707,9168880,10418806,10418811,10418815,10418816,10418818,10418819,10418826,10418828,10418829,9168929,10418855,10418857,10418858,10418862,10420084,10420085,10420086,10420087,10420088,10420089,10420090,10420091,10420092,10420093,10420094,10420095,10420096,10420097,10420098,10117427,10117428,7055464,10467115,8549993,8549994,10463592,10463827,10463896,10465899,10463906,10463923,9167381,9167737,10466340,10466347,10466406,10466413,10462424,10466427,10466443,10466446,10462475,10462486,10462508,10462509,10462537,10462540,10462581,10462617,10462627,9168157,9168158,9168159,9168160,9168161,9168162,9168163,9168164,10462756,9168219,9168221,9168222,9168223,9168224,9168225,9168226,9168227,9168228,10466854,10174688,10174689,10888930,10888977,10884280,10884281,10884282,10884283,10884284,10884285,10884286,10884287,10884288,10884289,10884290,10884291,10884292,10884293,10884489,10884533,10889938,10889961,10880203,10890206,10887521,10882617,10627295,10627296,10627297,10627298,10627299,10627300,10627301,10627302,10627303,10627304,10627305,10627306,10627307,10627308,10627309,10627310,10627311,10627312,10627313,10627314,10627315,10888011,10888012,10883020,10888323,10171537,10171538,10886071,10886080,10886082,10886158,10886180,10886183,10886250,10891382,10886623,10886678,10886694,10887088,10877373,10590618,10590619,10590620,10527167,10527168,10527273,10527395,10527738,10527739,10527740,10527758,10527813,10527814,10527815,10527816,10527958,10527959,10528068,10546398,10546399,10546403,10546430,10546484,10522577,10522578,10522579,10528629,10546758,10421238,10421239,10421240,10421241,10420247,10420248,10420249,10420250,10420251,10420252,10420253,10420254,10420255,10420256,10420257,10420258,10420259,10420260,10420261,10420262,10420263,10420264,10420265,10420266,10420267,10420268,10423448,10423449,10423450,10423451,10423452,10420455,10421552,10421553,10421554,10421555,10421556,10421557,10421558,10505543,10505551,10505553,10505554,10421679,10421681,10420750,10420751,10420752,10506786,10421048,10425085,10425086,10425087,10425088,10407236,10407237,10407238,10407239,10407240,10407241,10407242,10407247,10407248,10407249,10407250,10407251,10407252,10407253,10407304,10407305,10407736,10407737,10407920,10407921,10407933,10408046,10408047,10489211,10408766,10408767,10408819,10472536,10472537,10408972,10408981,10409051,10407060,10407061,10409072,10409073,10409074,10409075) 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'