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(10962744,7068154,7068307,10939962,7076356,7076357,7076358,7076359,10939987,7068367,10939998,7076391,4970718,10940172,4970766,8569553,8569554,8569703,10940411,10940412,7068829,10944316,8569899,8569900,10976659,10976660,10976661,7066097,7066098,7074161,8067212,7066285,7066287,7066288,7066290,7066360,4968630,4968631,4968632,7066421,7066422,7066428,4968644,7066429,7066431,7066436,7066438,7066439,7066444,7066445,4968664,7066449,4968665,4968666,4968667,7066452,7066453,7066454,7066455,7066456,7066457,7066458,7066459,7066460,7066461,7066463,7066464,7066465,7066469,10437415,7066776,7066806,7066807,7066833,7066834,7066835,7066919,7074951,10961636,7075000,7067008,8067926,8067930,10961818,10961819,10961820,10961843,10987874,10987875,10987876,10987877,10987878,10938828,4969549,10988068,10962090,10962091,10988253,10988368,10988369,7067685,10988370,10988371,10988372,10988373,10988374,10988375,10988376,10988377,10988378,10988379,10988380,10988381,10988382,10988383,10988384,10988385,10988386,10988387,10988388,10988389,10988390,10988391,10988392,10988393,10988394,10988395,10988396,10988397,10939379,7067819,10939463,10939466,7075859,7071957,7072014,10972722,10972728,10972856,10972866,10972951,7072270,7072272,7072276,10960063,10931766,7072443,7072445,7072446,7072447,10931814,7072504,7064526,10986251,10986252,10986253,7072570,10986255,10986268,10986269,10986270,7064589,7064590,7064596,7064599,7064601,7064602,7072610,10960338,10960339,7072670,7072676,10960376,10960377,10960378,10960379,7064711,7064712,7072712,7064715,7064717,7064718,7072718,7064721,7064722,7064723,7072811,7072914,7072969,8065999,10960735,10960736,10960737,10960738,10960739,10960740,10960741,10960742,10960743,10960744,10960745,10960746,10960747,10960748,10960749,10960750,10960751,10960757,10960758,10960759,10960760,10960761,10960762,10960763,10960764,10960765,10960766,10960767,10960768,10960769,7073127,7073227,7073335,7073336,7073337,7065353,10961082,10961083,7065412,7065414,7065416,10961220,10961308,10961309,10961310,10961315,7073694,10961502,10961503,10961504,10961505,10961506,10961507,7065880,7065893,7065894,7065895,7065896,7065898,7065899,7065900,10958717,10958722,10958725,10958726,10942738,10942754,7071194,11049124,7071225,7071226,11049128,11049140,11049144,11049273,11049283,11049302,11049382,7071527,10959252,10959253,5999932,5999933,5999934,5999935,5999936,5999938,5999943,7071706,8064692,10972405,7071777,7071778,7071928,10959613,7071929,3655629,3655630,3655631,3655632,3655633,3655634,3655659,3655662,3655665,3655667,3655670,3655672,3655674,3655675,10944607,10969906,10970003,10970004,10970021,10944757,10944758,7069437,7069457,10970259,10970260,10970261,3656233,7069707,7069708,3656280,7069712,7069713,7069714,7069715,8072733,8072734,8072735,8072736,8072737,3656696,3656697,8073009,8073010,8073012,8073014,10971015,10971016,10971214,10971215,11048496,11048497,11048498,11048499,11048500,11048501,11048502,11048503,11048532,7070650,10971337,7070718,11048654,8073519,10958472,11048693,10942482,7070871,11048772,10942512,10942513,10942514,10942516,10617988,10617989,10617990,10617991,10918521,10918522,10918523,10918524,10618035,10918667,10967848,10967849,10918704,10967859,10967860,10967861,10967862,10967863,10967864,10967865,10967866,10618220,10967945,10623330,10955014,10918876,10918877,10918878,10918879,10918880,10918881,10918882,10918883,10918929,10918930,10918931,10918932,10918933,10918934,10623424,10918935,10918936,10918937,10918940,10623486,10623487,10955211,10955212,10955213,10955214,10919268,10919269,10919270,10919271,10919272,10919273,10919274,10919295,10919296,10919297,10919298,10919306,10618915,10618916,10618917,10618918,10919601,10919602,8070859,8070882,8070884,10919851,10919854,10919914,10919915,10919918,10969157,10969158,10969159,10969160,10969161,10969162,10969277,10969278,10969279,10969280,10969281,10969282,10969283,10969284,10969285,10969286,10969287,10969288,10969289,10969290,10969291,10969292,10969293,10969294,10969295,10969296,10969297,10969298,10969299,10969300,10920186,10920187,10920188,10920189,10920190,10622035,10617196,10622256,10927873,10922912,10922913,10922914,10922915,10922916,10622411,10622412,10917986,10917987,10918029,10918040,10918041,10617536,10617537,10617545,10617583,10954280,10954281,10954284,10617639,10617640,10617641,10617642,10617644,10617645,10617646,10617647,10918160,10918161,10954310,10617654,10617655,10617656,10617657,10617658,10617659,10617660,10617661,10617662,10617663,10617664,10617666,10617667,10617668,10617669,10617670,10617671,10617672,10918361,10622907,10622908,10954589,10954590,10954591,10954592,8569917,10925480,8569920,10925481,8569922,8570170,10920762,10920763,10964947,8570285,10620360,10925877,10915949,10915950,10915951,10915952,10915953,10915954,10915955,10915956,10915957,10915958,10925986,10925987,10925988,10921100,10921267,10926350,10926351,10926352,10615845,10930780,10930781,10921548,10921642,10621137,10621138,10621139,10621140,10621141,10621142,10621143,10921767,10921768,10921769,10921770,10921771,10926840,10921898,10921899,10921900,10921925,10921926,10921927,10917175,10917176,10917177,10917178,10917179,10917180,10917181,10917182,10917183,10917184,10917185,10917186,10917187,10917188,10917189,10917190,10927415,8863825,10565197,10559289,7059732,7059751,7059752,7059753,10559694,10559695,10559696,10559697,10559699,6665996,6665997,10614785,10614806,10614807,10611961,8861872,8861910,7057623,7057631,10557346,10557347,10557348,10557349,10609293,10609294,10609318,10609319,10609321,10609322,10557511,10612506,7058023,10557721,10557722,10557723,10557724,10557725,10612583,7058151,8862601,10609859,10609860,10609861,10609862,10609863,10609864,10609867,10609868,10609869,10609870,10609874,10609914,10609915,10609925,10609926,10609927,8863123,8863259,10558562,10558563,10558616,10610507,10558661,10558662,10558663,10558664,10610657,10613759,10613760,10613761,10613762,10613763,10613764,10613765,10558973,10515119,10513120,10515120,10513121,10515121,10513122,10513123,10513124,10513125,10513126,10513127,10513128,10513129,10513130,10513131,10513132,10513133,4974202,10515251,10515252,10515253,10515254,10515255,10515256,10515257,10515258,10513311,10513312,10513313,10513314,10513315,10513316,10513317,10513335,10513336,10513337,7055699,7055700,7055704,7055705,7055714,10513405,7055761,4974487,10555493,4974644,4974645,7055988,10515724,10515725,10515726,10515727,10515728,10515729,10515730,7056161,10555836,7056195,10555842,10513916,7056328,10555997,10555998,10555999,10556000,10556001,10556002,10556003,10556004,10556005,10556006,10556007,10556008,10556009,10556010,10556011,10556012,10556013,10556014,10556015,10556058,10556059,10556060,10556061,10556062,7056421,10514101,10516140,10516141,10516177,10516178,10516179,10516180,10516181,10516182,7056959,2809652,7057198,7057252,7057314,7057315,7057316,7057317,7057318,7057319,7057320,7057321,7057322,7057323,7057324,7057325,7057326,7057327,10516983,7057447,10419364,10419365,10417465,4973515,4973516,4973517,4973518,4973519,4973520,4973521,4973522,4973523,8918334,4973770,4973771,4973772,10419882,10419884,10415949,10415959,10419969,10419970,10419971,10419972,10419973,10417063,10417126,10417127,10417196,4971490,10469289,10469290,10469291,10469292,10467450,10467451,10467452,10467453,10469532,10469577,10469593,10467609,10467610,10467611,10467612,10467623,10467624,10467625,10463678,4971978,4971979,4971980,10469751,10469829,10469830,8916965,8917030,10470004,10464078,10464079,10464080,10470127,10470128,8917250,8917252,8917257,8917259,10468221,10468228,10470242,4972614,4972615,8917450,8917533,8917536,8917537,8917538,8917542,8917543,8917544,8917545,10466531,10466532,10466533,10470670,10628075,10628121,10628122,10628235,10628329,10628341,10628344,10628345,10628449,10628513,10629486,10156355,10156356,10629926,10629927,10632131,10629979,10630004,10630062,10630102,10625152,10625153,10625154,10625155,10625156,10625157,10625158,10630857,10626375,10626378,10626379,10631731,10631880,10571440,10571476,10568653,10568654,10568655,10568656,10568657,10568658,10568659,10568660,10568661,10568662,10568686,10568687,10568688,10568689,10568690,10568691,10571850,10571851,10571852,10571853,10571854,10571855,10571856,10571857,10571858,10571859,10568904,10568905,10568925,10571928,10571929,10569570,10569931,10570137,10570138,10567547,10567548,10567549,10567550,10570658,10570659,10570660,10570661,10570662,10570663,10521271,10519863,10519864,10519865,10519866,10519867,10519868,10519869,10519870,10519871,10519872,10519873,10519874,10521901,10522391,10522392,10522393,10522399,10522476,10522477,10522478,10522479,10522480,10522481,10522482,10522483,10522484,10522485,10522486,10522487,10522488,10522489,10522490,10522491,10522492,10522493,10522494,10522495,10522496,10522497,10522498,10421278,10421482) 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'