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(4970636,4970637,4970638,4970651,4970666,4970667,4970668,4970669,4970705,4970740,4970741,4970745,4970748,4970749,4970750,4970751,4970752,4970753,4970754,4970755,4970756,4970770,4970864,4970865,4970868,4970869,4970870,4970871,4970872,4970877,4970878,4970879,4970880,4970884,4970885,4970889,4970890,4970895,4970896,4970899,4970900,4970901,4970903,4970904,4970906,4970907,4970909,4970910,4970911,4970913,4970914,4970915,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970930,4970931,4970932,4970933,4970934,4970935,4970939,4970940,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970964,4970965,4970966,4970967,4970968,4970969,4970970,4970971,4970972,4970973,4970975,4970976,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4971034,4971035,4971036,4971057,4971058,4971070,4971071,4971072,4971128,4971129,4971130,4971131,4971132,4971133,4971134,4971135,4971136,4968218,4968228,4968229,4968320,4968327,4968336,4968341,4968565,4968860,4969530,4967027,4967028,4967029,4968121,8072313,8072768,8072769,8072770,8072771,8072772,8072901,8072902,8072903,8072904,8072905,8072906,8072907,8072908,8072909,8072910,8072911,8072912,8072913,8072914,8072915,8072916,8073006,8073049,8073053,8073495,8073496,8073497,8073498,8073499,8073500,8073501,8073502,8073503,8073504,8073505,8073506,8073507,8073508,8073509,8073510,8073511,8073512,8073513,8073514,8073515,8073516,8073517,8073518,8073519,8073520,8073521,8073522,8073523,8073524,8073525,8073526,10622968,10622971,10622972,10623003,10623060,10623355,10623449,10623493,10623652,10624234,10624235,10624237,10624247,10624249,10624896,10624897,10624953,10624955,10624956,10624957,10624958,10624960,10621982,10621986,10621989,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10622012,10622020,10622022,10622031,10622039,10622043,10622044,10622045,10622046,10622047,10622048,10622050,10622052,10622053,10622054,10622058,10622060,10622063,10622068,10622069,10622071,10622076,10622078,10622079,10622080,10622081,10622088,10622094,10622103,10622128,10622129,10622130,10622457,10622458,10622459,10622920,10622936,10622939,10622940,10622941,10622942,10622943,10622944,10622945,10622946,10622947,10622948,10622949,10622950,10619962,10619963,10619964,10619974,10619977,10619978,10620000,10620001,10620003,10620004,10620005,10620007,10620008,10620009,10620011,10620013,10620016,10620017,10620018,10620019,10620021,10620022,10620023,10620024,10620025,10620026,10620027,10620029,10620030,10620031,10620032,10620033,10620040,10620041,10620043,10620046,10620047,10620052,10620053,10620054,10620055,10620063,10620064,10620065,10620090,10620091,10620092,10620093,10620094,10620115,10620184,10620225,10620237,10620306,10620322,10620343,10620346,10620359,10620360,10620362,10620363,10620367,10620368,10620369,10620374,10620375,10620376,10620389,10620392,10620396,10620402,10620406,10620407,10620408,10620411,10620412,10620413,10620423,10620559,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10620661,10620662,10620663,10620664,10620665,10620666,10620667,10620668,10620669,10620670,10621078,10621279,10621426,10621477,10621662,10621705,10621731,10565154,10565185,10565221,10565222,10565272,10565273,10565274,10565275,10565276,10565277,10565296,10565299,10565300,10565926,10565939,10566005,10566056,10563692,10563923,10563924,10563925,10563926,10563927,10563928,10563929,10563930,10563931,10563932,10563933,10563934,10563935,10563936,10563937,10563938,10563939,10563940,10563941,10563942,10563943,10563944,10563945,10563946,10563947,10563948,10563949,10563950,10563951,10563952,10563953,10563954,10563955,10563956,10563957,10563958,10563959,10563960,10563961,10563962,10563963,10563964,10563965,10563966,10563967,10563968,10563969,10563970,10563971,10563972,10563973,10563974,10563975,10563976,10563977,10563978,10563979,10563980,10563981,10563982,10563983,10563984,10563985,10563986,10563987,10563988,10563989,10563990,10563991,10563992,10563993,10563994,10563995,10563996,10563997,10563998,10563999,10564000,10564001,10564002,10564003,10564004,10564005,10564006,10564007,10564008,10564009,10564010,10564011,10564012,10564013,10564014,10564015,10564016,10564017,10564018,10564019,10564020,10564021,10564022,10564023,10564024,10564025,10564026,10564027,10564028,10564029,10564030,10564031,10564032,10564033,10564034,10564035,10564036,10564037,10564038,10564039,10564040,10564041,10564042,10564043,10564044,10564045,10564046,10564047,10564048,10564049,10564050,10564051,10564052,10564053,10564054,10564055,10564056,10564057,10564058,10564059,10564060,10564061,10564062,10564063,10564064,10564065,10564066,10564067,10564068,10564069,10564070,10564071,10564072,10564073,10564074,10564075,10564076,10564077,10564078,10564079,10564080,10564081,10564082,10564083,10564084,10564085,10564086,10564087,10564088,10564089,10564090,10564091,10564092,10564093,10564094,10564095,10564096,10564097,10564098,10564099,10564100,10564101,10564102,10564103,10564104,10564105,10564106,10564107,10564108,10564109,10564110,10564111,10564112,10564113,10564114,10564115,10564116,10564117,10564118,10564119,10564120,10564121,10564122,10564123,10564454,10564653,10564654,10564671,10564713,10564714,10564766,10564767,10564768,10564769,10564805,10564825,10517227,10517228,10517229,10517230,10517231,10517232,10517233,10517234,10517235,10517321,10517322,10517323,10517327,10517451,10517452,10517453,10517454,10517455,10517456,10517457,10517458,10517459,10517460,10517461,10517462,10517463,10517464,10517465,10517466,10517467,10517468,10517469,10517470,10517471,10517472,10517473,10517474,10517475,10517476,10517477,10517478,10517479,10517480,10517481,10517482,10517483,10517484,10517485,10517486,10517487,10517488,10517489,10517490,10517491,10517492,10517493,10517494,10517495,10517496,10517497,10517498,10517499,10517500,10517501,10517502,10517503,10517504,10517505,10517506,10517507,10517508,10517509,10517510,10517511,10517512,10517513,10517514,10517515,10517516,10517517,10517518,10517519,10517520,10517521,10517522,10517523,10517524,10517525,10517526,10517527,10517563,10517564,10517565,10517566,10517567,10517568,10517633,10517754,10517755,10517756,10518616,10518617,10518979,10419252,10419277,10419415,10419416,10419448,10419477,10419478,10419479,10419491,10419492,10419501,10419502,10419503,10419505,10419506,10419507,10419508,10419511,10419512,10419513,10419514,10419516,10419517,10419518,10419519,10419520,10419524,10419525,10419526,10419536,10419537,10419542,10419553,10419554,10419583,10419694,10419739,10419802,10419803,10419804,10419805,10419806,10419808,10419809,10419839,10419840,10419958,10420009,10420010,10420091,10420092,10420093,10420094,10420105,10420117,10420118,10420119,10420120,10420121,10470912,10471029,10471116,10471163,10471176,10471177,10471178,10471179,10471180,10471181,10471182,10471183,10471184,10471185,10471186,10471187,10471188,10471189,10471190,10471191,10471192,10471193,10471194,10471195,10471196,10471197,10471198,10471199,10471200,10471201,10471202,10471203,10471204,10471205,10471206,10471207,10471208,10471209,10471210,10471211,10471212,10471213,10471214,10471215,10471216,10471217,10471218,10471219,10471220,10471221,10471222,10471223,10471224,10471225,10471226,10471227,10471228,10471229,10471230,10471231,10471232,10471233,10471234,10471235,10471236,10471237,10471238,10471239,10471240,10471241,10471242,10471243,10471244,10471482,10471483,10471484,10471485,10471486,10471487,10471489,10471490,10471491,10471492,10471493,10471494,10471495,10471496,10471497,10471498,10471499,10471500,10471501,10471502,10471503,10471504,10471505,10469908,10470084,10470114,10470116,10470118,10470119,10470120,10470121,10470122,10470123,10470125,10470127,10470130,10470133,10470229,10470230,10470232,10470233,10470235,10470237,10470238,10470240,10470242,10470250,10470251,10470252,10470253,10470254,10470255,10470257,10470260,10470261,10470268,10470270,10470275,10470277,10470280,10470281,10470282,10470283,10470292,10470297,10470300,10470301,10470304,10470306,10470309,10470310,10470313,10470314,10470315,10470316,10470319,10470322,10470323,10470325,10470326,10470327,10470330,10470331,10470332,10470335,10470338,10470340,10470343,10470370,10470373,10470375,10470376,10470378,10470379,10470383,10470387,10470389,10470393,10470398,10470400,10470403,10470404,10470408,10470410,10470412,10470414,10470416,10470419,10470420,10470421,10470422,10470424,10470426,10470429,10470431,10470433,10470435,10470437,10470439,10470441,10470444,10470446,10470447,10470448,10470449,10470450,10470451,10470452,10470453) 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'