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(8630688,7076078,7076079,8630749,7076226,8631001,8569414,7068612,7068641,7068644,7068646,7068651,7068652,7068653,7068655,7068659,7068662,7068663,7068664,7068665,7068666,7068668,7068669,7068670,10940332,10940333,10940334,10940335,10940337,10940338,10940339,10940341,4971029,8631492,10976805,10976806,10976807,10976808,10976809,10976810,10976811,10976812,10976813,10976814,10976815,10976816,10976817,10976818,10976819,10976820,10976821,10976822,10976823,10976824,10976825,10976826,10976827,10976828,10976829,10976830,10976831,10976832,10976833,10976834,10976835,10976836,10976837,10976838,10976839,10976840,10976841,10976842,10976843,10976844,10976845,10976846,10976847,10976848,10976849,10976850,10976851,10976852,10976853,10976854,10976855,10976856,10976857,10976858,10976859,10976860,10976861,10976862,10976863,10976864,10976865,10976866,10976867,10976868,10976869,10976870,10976871,10976872,10976873,10976874,10976875,10976876,10976877,10976878,10976879,10976880,10976881,10976882,10976883,10976884,10976885,10976886,10976887,10976888,10976889,10976890,10976891,10976892,10976893,10976894,10976895,10976896,10976897,10976898,10976899,8067325,10849811,8622401,10951231,10951232,7066708,7066709,7066710,7066711,7066713,7066716,7066717,7066718,7066719,10929588,7075434,10962167,3238769,8835851,10843176,10843179,8836221,3899266,8836428,10999929,10999930,10999931,10999932,10999933,8595909,7073330,10104653,10104654,11000323,11000324,11000325,11000326,11000375,10984630,7070946,10984631,10984632,7070948,10984633,10984634,7070950,7070951,10984635,10984636,10984637,7070953,10984638,7070955,10984639,10984640,7070956,7070957,10984641,7070958,10984642,10984643,7070959,10984644,7070991,7071007,11048946,10102307,10102309,10102312,10102313,10102315,10102316,10102317,10102319,8626979,8834875,10842141,7071590,7071591,7071599,7071602,7071609,7071614,7071627,7071628,7071629,7071630,7071653,7071654,7071655,7071656,7071657,7071658,7071659,7071660,7071661,7071662,7071663,10943299,10943300,10943305,10943307,8835257,7071863,10103022,10103040,10103041,10940747,7069220,7069221,7069222,8615139,10940929,7069367,7069377,7069378,7069381,7069382,7069391,8615727,8615728,8615729,10983903,10983904,10983905,10983906,10983907,10983908,10983909,8557206,8557207,10996946,10996947,10996948,10996949,10996950,10996951,10996952,10996953,10996954,10996955,10996956,10996957,10996958,10996959,10996960,10996961,10996962,10996963,10996964,10996965,10996966,10996967,10996968,10996969,10996994,10996995,10996996,10996997,10996998,8557493,8557496,7070869,7070870,7070871,7070872,7070873,7070874,7070875,7070876,7070877,7070882,3233419,10993821,10993822,10993823,10993824,10993825,10993826,10993827,10993828,10993829,3923721,8613328,3924348,3924351,3924353,3924354,10982087,10982088,10982089,10982090,10982091,10982092,10982093,8614244,10982094,10982095,10982096,10982097,10982098,10982099,3924818,11047316,11047332,11047334,11047335,11047336,11047355,8907819,10619869,10619870,10619871,10622103,8541712,8541934,10622657,10622658,10622659,10622660,10622663,10622664,8542158,10928227,10928228,10928229,10928230,10928231,10928232,10928234,10928235,10928236,10622734,10622735,10622820,11045607,10951732,10425587,10425936,10848332,10848333,10848334,10848335,10848336,10952658,10992232,10992233,10992234,10992235,10992236,10992237,10992238,10992239,10992240,8541114,8541127,8541130,3232163,3232164,9181477,9181478,9181479,9181480,8853461,10714270,9189815,9189818,9189819,9189855,9189856,9189857,9189858,9189859,9189860,9189861,9189862,9189863,9189864,9189865,9189866,9189867,9189868,9189869,9189920,9189921,9189922,9189923,9189924,10122122,9189925,9189926,9189927,9189928,9189929,9189930,9189931,9189932,9189933,9189974,9189975,9189976,9189977,9189978,9214040,10122355,10122356,10122359,10122360,7057543,9171521,9171522,9171523,9171524,9171673,9171674,9171675,9171676,9171677,9171678,9171679,9171680,9171681,9171682,9171683,9171684,9171685,9171830,9211837,10609707,9212186,9212187,9212188,9212189,9914791,10120788,10120853,10120854,9180843,9180844,9180845,10513435,10513436,10513437,10513438,10513439,10513440,10513441,10513442,10513443,10513444,10513445,10513446,10513447,10513448,10513449,10513450,10513451,10513452,10513453,10513454,10513455,10513456,10513457,10513458,10513459,10513460,10513461,10513462,10513463,10513464,10513465,10513466,10513467,10513468,10513469,10513470,10513471,10513472,10513473,10513474,10513475,10513476,10513477,10513478,10513479,10513480,10513481,10513482,10513483,10513484,10513485,9177721,9177722,9177723,9177724,9177725,9177726,9177727,9177728,9177729,9177730,9177731,9177732,10126007,10126008,9186012,9186013,7056358,7056359,9178432,9178433,9178434,6674688,7056983,7056984,7056985,7056986,9186826,9186908,9186909,9186910,7057090,9186996,9186997,9186998,9186999,9187000,9187001,9187002,9187003,9187028,9187029,9187030,9187031,9187032,9187033,9187034,9187035,9187036,9187037,9187057,9187058,9187059,9187060,9171099,10512964,10512965,9187290,10463007,10463044,10463045,10467113,10467129,10467130,10471524,10471525,6667171,6667173,10463754,10465780,10463789,10463790,10463791,10465812,10465813,10465814,10465815,10465816,10465817,10465818,10465877,10465914,10464046,10464047,10466212,10466213,10462314,10466363,10466364,10466365,10466424,10466425,10462440,10462441,10462442,10468487,10462501,10462728,9192222,9192224,9192259,10466853,10466856,8593571,10903654,10903655,10903656,10903657,10903658,10903659,10903660,8594230,8594231,8594232,8594233,8594234,10899402,10899745,10884787,10884788,10884789,10884790,10884791,10890006,10905324,10627024,10627025,10627049,10627050,10627051,10627052,10627053,10627054,10627073,10627074,10627075,10627076,10627077,10627078,10627079,10908298,10908301,10906058,10886066,10906085,10906086,10906087,10906088,10891102,10891103,10891104,10906106,10906107,10906108,10906122,10906123,10906124,10896365,10626097,10897086,10897087,10897088,10897089,10897090,10897091,10897092,10897093,10897094,10897095,10897096,10649499,10650357,10525112,10525113,10525114,10525115,10525116,10525117,10525118,10525120,10533133,10533134,10533135,10533136,10533137,10533138,10539165,10539244,10539245,10539246,10539247,10539248,10539249,10539250,10539251,10539252,10539253,10539254,10539255,10539256,10539257,10539258,10539259,10539260,10539261,10539262,10539263,10539264,10539265,10539266,10539267,10539268,10539269,10539270,10539271,10539272,10539273,10539274,10539275,10539276,10539277,10539278,10539279,10539280,10539281,10539282,10539283,10539284,10539285,10539286,10539287,10539288,10539289,10539290,10539291,10539292,10539293,10539352,10539353,10539354,10539355,10539356,10539357,10539358,10539359,10539360,10539361,10539362,10539363,10539364,10539365,10539366,10539367,10539368,10539369,10539370,10539371,10539372,10539373,10539374,10539375,10539376,10539377,10523428,10523429,10523430,10523431,10523432,10523433,10523434,10523435,10523436,10523437,10533437,10523438,10533438,10523439,10533439,10523440,10533440,10523441,10533441,10523442,10533442,10523443,10533443,10523444,10533444,10523445,10533445,10523446,10533446,10523447,10533447,10523448,10533448,10523449,10533449,10523450,10523451,10523452,10529452,10523453,10529453,10523454,10529454,10539455,10523455,10523456,10539456,10539457,10523457,10539458,10523458,10539459,10523459,10539460,10523460,10539461,10539462,10539463,10539464,10539465,10539466,10539467,10539468,10539469,10539470,10539471,10539472,10539473,10539474,10539475,10539476,10539477,10539478,10529478,10539479,10529479,10539480,10529480,10539481,10529481,10539482,10529482,10539483,10529483,10539484,10529484,10539485,10529485,10539486,10529486,10539487,10529487,10539488,10529488,10539489,10529489,10539490,10539491,10539492,10539493,10533538,10533539,10533540,10533541,10533542,10533543,10533544,10533545,10533546,10533547,10533548,10533549,10533550,10533551,10533552,10533553,10533554,10533555,10533556,10533557,10533558,10533559,10533560,10533561,10533562,10533563,10533564,10533565,10533566,10533567,10533568,10533569,10533619,10533620,10533621,10533622,10533691,10533692,10533693,10533694,10524283,10524284,10524285,10524286,10524287,10524288,10524289,10524430,10524431,10524432,10524433,10524434,10524435,10524436,10526483,10532899,10532900,10525073,10525074,10525075,10547090,10547091,10547092,10547093,10547094,10547095,10525102,10480948,10480949,10407321,10486012,10486013,10479107,10486271,10486287,10486292,10486304,10486314,10486315,10486317,10486318,10486336,10481500,10481501,10481504,10481524,10481540,10481541,10481543,10481544,10481545,10475649,10486698,10486700,10486701,10486702,10486703,10496833,10496834,10496835,10496837,10496838,10496839,10496843,10496846,10481853,10481854,10481855,10481856,10481857,10481858,10481859,10481860,10481861,10481862,10481867,10485110,10485111) 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'