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(7067941,7068000,7068021,7068165,10939797,7068175,7068186,10943605,10943606,7068190,4970467,4970468,4970482,4970483,4970484,4970504,7068308,4970637,4970638,7068437,10944058,10944084,4970901,4970914,4970943,4970953,4970979,7068763,7068764,4971070,7068876,10944297,10944300,7068884,10944313,7068935,7066100,8067138,7066281,7066485,8067486,8067499,8067718,8067910,4969286,8068054,8068055,8068056,8068116,8068232,8068233,7067345,7067350,4969723,4969732,7067544,7067545,7067699,8068622,8068771,7064111,7064149,8065537,10932197,10932198,10932521,8066285,7065340,7065342,8066323,8066324,8066349,8066350,8066351,7065573,8066623,8066744,8066745,8066746,8066747,8066748,8066749,10942737,10942747,10942748,10942749,10943058,10943059,10943102,10943104,11049537,11049538,11049539,11049540,11049541,11049542,11049543,11049544,11049545,11049546,11049547,10943377,10943385,10943390,10943399,10943400,10943401,10943404,10943408,10943411,10943412,10943413,10943414,10943415,10940679,10944934,10941222,3656230,3656250,3656251,3656252,3656259,3656681,3656682,3656684,3656685,3656736,10941840,10941841,10942031,10942032,11048357,10942099,11048397,10942152,10942153,10942185,10942186,10942188,10942189,10942193,3657272,8073504,8073514,8073515,8073516,10942491,10918511,10918512,10918513,10918514,10928550,10918580,10928594,10928595,10928596,10928603,10918611,10928620,10928621,10928622,10928623,10928624,10928626,10928627,10928628,10928629,10928630,10928631,10928633,10928634,10928635,10928636,10928637,10928639,10928640,10928643,10928644,10928645,10928647,10928648,10928650,10928651,10928653,10928654,10928655,10928656,10928657,10928658,10928659,10928660,10928661,10928662,10928663,10928664,10928665,10928666,10928667,10928668,10928669,10928670,10918700,10918701,10918716,10918850,10918851,10918857,10918858,10918859,10918860,10918861,10918862,10918863,10918864,10918865,10918866,10919016,10919129,10919146,10919149,10919252,10919253,10919254,10919255,10919256,10919257,10919423,10919424,10919425,10919427,10919428,10919429,10919430,10919431,10919513,10919574,10919575,10919576,10919577,10919578,10919579,10919580,10919581,10919582,10919583,10919584,10919585,10919586,10919587,10919588,10919589,10919773,10919774,10919775,10919776,10919777,10919778,10919779,10919780,10919781,10919782,10919789,10919790,10919846,10919896,10919897,10919937,10920075,10920076,10920077,10920110,10925168,10920199,10920200,10920201,10920202,10925203,10920203,10920212,10925351,10925352,10925353,10925354,10925355,10925356,10925357,10925358,10925359,10925360,10925361,10925362,10925363,10925365,10925366,10920451,10920456,10920457,10920458,10920459,10920460,10920461,10920462,10917785,10922937,10922981,10922982,10922983,10622473,10918025,10918026,10918027,10918097,10918098,10918099,10928103,10918155,10918156,10928236,10918246,10918247,10918248,10918445,10918446,10920475,10920476,10920477,10920478,10920479,10920480,10920494,10620019,10925592,10620084,10620085,10620086,10620087,10620088,10620089,10620108,10620123,10620132,10620133,10620134,10620135,10620136,10620137,10920684,10920706,10920708,10920710,10920711,10920713,10920731,10920757,10920758,10920759,10620306,10920833,10920834,10920837,10920838,10920839,10920840,10920841,10920842,10920876,10920877,10920882,10920902,10920917,10920935,10920938,10920939,10920940,10920941,10920942,10920943,10920944,10920982,10921026,10921054,10921055,10921078,10921079,10921080,10921081,10921082,10921083,10921084,10916100,10921165,10921166,10921167,10921168,10921169,10921170,10921171,10926177,10926178,10921223,10921224,10921225,10921226,10921227,10921228,10921229,10921230,10921231,10921232,10926285,10926321,10921369,10921370,10921372,10921375,10921376,10921377,10921388,10921389,10921390,10921391,10921392,10921393,10921394,10921395,10921396,10921397,10921398,10921399,10921400,10921401,10921402,10921403,10921404,10921405,10921406,10921407,10921408,10921409,10921410,10921411,10921412,10921413,10921414,10921415,10921416,10921417,10921418,10921419,10921420,10921421,10921422,10921423,10921424,10921425,10921426,10921427,10921428,10921429,10921430,10921431,10921432,10921433,10921434,10921435,10921436,10921437,10921438,10921439,10921440,10921441,10921442,10921443,10921444,10921445,10921446,10921447,10921448,10921449,10921450,10921451,10921452,10921453,10921454,10921455,10921456,10921457,10921458,10921459,10921460,10921461,10921462,10921463,10921464,10921465,10921466,10921467,10921468,10921469,10921502,10921511,10921516,10921518,10921521,10921527,10921530,10621071,10921587,10921588,10921590,10621117,10621118,10621131,10921650,10921654,10921679,10926698,10921699,10926718,10926719,10926766,10921784,10921806,10927068,10927069,10621564,10917211,10917237,10621735,10621957,10565125,10565126,10559290,10565348,10559708,10611662,10611697,10614731,10614814,10611916,10566083,10611934,10611991,10557144,10557145,10557161,10557163,10563163,10557172,10557242,10612108,10557261,10563444,10563447,10563449,10563456,10563458,10563459,10563460,10563461,10563462,10563463,10557464,10563464,10563465,10563466,10563467,10557469,10557494,10557497,10557498,10557502,10557503,10557504,10557506,10557516,10609377,10609392,10563564,10563565,10563566,10563570,10557640,10557641,10557642,10612498,10557653,10612505,10563691,10563692,10557719,10557720,10557885,10557889,10557929,10557942,10612797,10564001,10564002,10564003,10564005,10564006,10564007,10564027,10564105,10564106,10564107,10564108,10564109,10564123,10609978,10558144,10558147,10558151,10610018,10610019,10558170,10558183,10558185,10558191,10610051,10613061,10613062,10613074,10613119,10558289,10558290,10558291,10613158,10558319,10613193,10613225,10564436,10564437,10564439,10564440,10610295,10610374,10610388,10564651,10564652,10564663,10564665,10564666,10564669,10564670,10564671,10564672,10564674,10564676,10613547,10558702,10613566,10564758,10558778,10558784,10610702,10558853,10610703,10610794,10610920,10610946,10610951,10511136,10511137,10511138,10511139,10511140,10511168,10511169,10511171,10511175,10511176,10511177,10511182,10555203,10511209,10511210,10511211,10511212,10511213,10513227,10513228,10511228,10513229,10511229,10513230,10511230,10513231,10511231,10513232,10517232,10511232,10517233,10511244,10511246,10511247,10511250,10511251,10511252,10511253,10517272,10517273,10517274,10517275,10517276,10511281,10511282,10511283,10511284,10511285,10511286,10511287,10511288,10511289,10511290,10511291,10511292,10511293,10511294,10511295,10511296,10511297,10511298,10511300,10511301,10511302,10511303,10511304,10511305,10511306,10511308,10511309,10511310,10511311,10511312,10511313,10511314,10511315,10511316,10511334,10511335,10511336,10511340,10511341,10511342,10511343,10511344,10511345,10511346,10511347,10511348,10511350,10511351,10511352,10511356,10511357,10511358,10511359,10511360,10511361,10511362,10511363,10511364,10511365,10511366,10511388,10511389,10511390,10511391,10511392,10513393,10511393,10513394,10511394,10513395,10511395,10511396,10511397,10511398,10511399,10511400,10511401,10511402,10511403,10511404,10511405,10511409,10511410,10511411,10511412,10511413,10511414,10511415,10511416,10511417,10511418,10511419,10511420,10511421,10511422,10511423,10511424,10511425,10511426,10511447,10511454,10511455,10511456,10511457,10511458,10511459,10511460,10511461,10511478,10517493,10517502,10517514,10513545,10513546,10513547,10555583,10555588,10517614,10517615,10517616,10513616,10511633,10555647,10555648,10517673,10517674,10517675,10517677,10517678,10517679,10511730,10511735,10511753,10511770,10511784,10511791,10511811,10511823,10511835,10513836,10513837,10511851,10511894,10511898,10511911,10511912,10511913,10511914,10511915,10511922,10511954,10513970,10513971,10511971,10513972,10513973,10511974,10513978,10513979,10511981,10511983,10511988,10511991,10513997,10514003,10512020,10512023,10514028,10514031,10514032,10514033,10512047,10512057,10556071,10556072,10512082,10514119,10514129,10514130,10514137,10514148,10514149,10512149,10514151,10514186,10514187,10514188,10514189,10514190,10514226,10514229,10556239,10514245,10514256,10514257,10514312,10514336,10514337,10514340,10514341,10514342,10556467,10556468,10514494,10514495,10514496,10514511,10514512,10514513,10514517,10512517,10514518,10514519,10514520,10514521,10514530,10514532,10514541,10514558,10514566,10556579,10556583,10556584,10518586,10518588,10518591,10514621,10514626,10514627,10514628,10514629,10514632,10514633,10514634,10514635,10514641,10514642,10518680,10556761,10556768,10556781,10556783,10512792,10512794,10556795,10512800,10512801,10512804,10512805,10512806,10512807,10556816,10556818,10556820,10556910,10556915,10556916,10556919,10556942,10556950,10556978,10557058,10557059,10416403,10416417,10416435,10415566,10415567,10419571,10419735,10419746,10419747,10416861,10416865,10419958,10419965,10420136,10463013,10471192,10463394,10463395,10463397,10463400,10463402,10463430,10463431,10463432,10463433,10463435,10463744,10465769,10469915,8563548,10462425) 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'