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(4970673,4970684,4970700,4970729,4970730,4970731,4970732,4970733,4970734,4970735,4970746,4970759,8569559,7066003,7066004,7066005,7066006,7066007,7066008,7066009,7066010,7066127,7066184,7066185,7066186,7066260,8067913,8067941,10196378,10194848,10194856,10195014,10205054,8860327,8860360,8860361,8860362,8860363,8860384,8860435,10190187,10618178,10618179,10618180,10618181,10618277,10618303,10618329,10623494,10617057,10617169,10617170,10617171,10617172,10617218,10617219,10617220,10617221,10617222,10617223,10622258,10622259,10622260,10622261,10622262,10622263,10622264,10622265,10189361,10622270,10622272,10622273,10622274,10622275,10622276,10622277,10622278,10622279,10622280,10622281,10622282,10622283,10622284,10622285,10622286,10622287,10622288,10622289,10622290,10622291,10622292,10622293,10622294,10622295,10622296,10622297,10622298,10622299,10622300,10622301,10622302,10622303,10622304,10622305,10622306,10622307,10622308,10622309,10622310,10622311,10622312,10622313,10622314,10622315,10622316,10622317,10622318,10622319,10622320,10622321,10622322,10622323,10622324,10622325,10622326,10622327,10622328,10622329,10622330,10622331,10622332,10622333,10622334,10622335,10622336,10622337,10622338,10622339,10622340,10622341,10622342,10622343,10622344,10622345,10622346,10622347,10622348,10622349,10622350,10622351,10622352,10622353,10622354,10622355,10622356,10622357,10622358,10622359,10622361,10622362,10622363,10622364,10622366,10622367,10622369,10622371,10622372,10622373,10622374,10622376,10622378,10622379,10622380,10622381,10622384,10622385,10622386,10622387,10622388,10622389,10622390,10622391,10622392,10622393,10622394,10622395,10622396,10622397,10622398,10622399,10622400,10622403,10622405,10622407,10622408,10622410,10622411,10622417,10622418,10622420,10622422,10622423,10622425,10622426,10622431,10622432,10622433,10622434,10622435,10622436,10622437,10622438,10622439,10622440,10622442,10622443,10622444,10622446,10622447,10622448,10622449,10617449,10617450,10622457,10622458,10622459,10622461,10622464,10622465,10622466,10622467,10622468,10622469,10622470,10622471,10622472,10622473,10622474,10622475,10622476,10622477,10622478,10622479,10622480,10622481,10622482,10622483,10622484,10622485,10622486,10622487,10622488,10622489,10622490,10622491,10622492,10622493,10622494,10622495,10622496,10622497,10622498,10622499,10622500,10622501,10622502,10622503,10622504,10622505,10622506,10622507,10622509,10617509,10622510,10622511,10622512,10622513,10622514,10622516,10622518,10622519,10622520,10622521,10622523,10622524,10622526,10622527,10622528,10622529,10622530,10622531,10622534,10622535,10615014,10615037,10615062,10615083,10615231,10615268,10615269,10615290,10615527,10615528,10615529,10615530,10615531,10615532,10615533,10615534,10620654,10615897,10615898,10615967,10616050,10616052,10616062,10188389,10616420,10616542,10616543,10616544,10616545,10616546,10616547,10616548,10616549,10616550,10616695,10616859,10616888,10616932,10614048,9165540,10614216,10614220,10614282,10614284,10614285,10614323,10614371,10614556,10614557,10614558,10614752,10614821,10614846,10614857,10614858,10614859,10614860,10614861,10614862,10614863,10614864,10614887,6666259,10612042,10612108,10612109,10612110,10612111,10612112,10612113,10612114,10612115,10612116,10612117,10612118,10612119,10612120,10612121,10612122,10612123,10612124,10612125,10612126,10612127,10612128,10612129,10612130,10612131,10612132,10612133,10612134,10612135,10612136,10612137,10612138,10612139,10612140,10612141,10612142,10612143,10612144,10612145,10612146,10612147,10612148,10612149,10612150,10612151,10612152,10612153,10612154,10612155,10612156,10612157,10612158,10612159,10612160,10612161,10612162,10612163,10612164,10612165,10612166,10612167,10612168,10612169,10612170,10612171,10612172,10612173,10612174,10612175,10612176,10612177,10612178,10612179,10612180,10612181,10612182,10612183,10612184,10612185,10612186,10612187,10612188,10612189,10612190,10612191,10612192,10612193,10612194,10612195,10612196,10612197,10612198,10612199,10612200,10612201,10612202,10612203,10612204,10612205,10612206,10612207,10612208,10612209,10612210,10612211,10612212,10612213,10612214,10612215,10612216,10612217,10612218,10612219,10612220,10612221,10612222,10612223,10612224,10612225,10612226,10612227,10612228,10612229,10612230,10612231,10612232,10612233,10612234,10612235,10612236,10612237,10612238,10612239,10612240,10612241,10612242,10612243,10612244,10612245,10612246,10612247,10612248,10612249,10612250,10612251,10612252,10612253,10612254,10612255,10612256,10612257,10612258,10612259,10612260,10612261,10612262,10612263,10612264,10612265,10612266,10612267,10612268,10612269,10612270,10612271,10612272,10612273,10612274,10612275,10612276,10612277,10612278,10612279,10612280,10612281,10612282,10612283,10612284,10612285,10612286,10612287,10612288,10612289,10612290,10612291,10612292,10612293,10612294,10612295,10612296,10612345,10612346,10612424,10612479,8862513,8862514,8862515,8862516,8862517,8862535,8862536,8862537,10612821,10612822,10612884,10612886,10612888,10612898,10613023,10613028,10613119,10558292,10613245,10613355,10613356,10613357,10613358,10613359,10613360,10613361,10613362,10613363,10613364,10613365,10613366,10613367,10613368,10613476,10613477,10613486,10613654,10613698,10613699,10613784,7055500,7055501,7055502,7055503,7055504,7055505,7055506,7055507,7055530,9169377,9169378,9169429,7055654,10517536,9169748,10514102,10514103,10418251,10418256,10418258,9160337,9160341,9160342,10416265,9160343,10416266,9160347,9160348,10418270,10418272,10418274,10418276,10418278,10418280,10418295,9168395,9168396,9168397,9168398,9168399,9168400,9168401,9168402,9168403,9168404,9168405,9168406,9168407,9168408,9168409,9168410,9168411,9168412,9168413,9168414,9168415,9168416,9168417,9168418,9168419,9168420,9168421,9168422,10416344,9168423,9168424,9168425,9168426,9168427,9168428,9168429,9168430,9168431,9168432,9168433,9168434,9168435,9168436,9168437,9168438,9168439,9168440,9168441,9168442,9168443,9168444,9168445,9168446,9168447,9168448,9168449,9168450,9168451,9168452,10417374,9168453,9168454,10417376,9168455,9168456,10417378,9168457,9168458,9168459,9168460,9168461,9168462,9168463,9168464,9168465,9168466,9168467,9168468,9168469,9168470,9168471,10419394,9168472,9168473,10419395,10419396,9168474,9168475,9168476,9168477,9168478,9168479,9168480,9168481,9168482,9168483,9168484,9168485,9168486,9168487,9168488,9168489,9168490,9168491,9168492,9168493,9168494,10417466,10417467,10417468,10417469,10417470,10417471,10417472,10417473,10417474,10417475,10417476,10417477,10417478,10418488,10418490,10418492,10418493,10418495,10418496,10418497,10418498,10418499,10416640,10416641,10416642,10416643,10416644,10416645,10416646,10416647,10416648,10416649,10416650,9168729,10416651,10416652,10416653,10416654,10416655,10416656,10416657,10416658,10416659,10416660,10416661,10416662,10416663,10416664,10416665,10416666,10416667,10416668,10416669,10416670,10416671,10416672,10416673,10416674,10416675,10416676,10416677,10416678,10416679,10416680,10416681,10416682,10416683,10416684,10416685,10416686,10416687,10416688,10416689,10416690,10416691,10416692,10416693,10416694,10416695,10416696,10416697,10416698,10416699,10416700,10416701,10416702,10416703,10416704,10416705,10416706,10416707,10416708,10416709,10416710,10416711,10416712,10416713,10416714,10416715,10416716,10416717,10416718,10416719,9168875,10419802,10419803,10419804,10419805,10419806,10419807,10419808,10419809,10419810,10419811,10419812,10418864,10418865,10418866,10418867,10417017,10417019,10417021,10417023,10417026,10417027,10417029,10417030,10417031,10417034,10417036,10417037,10417038,9169180,9169181,9169182,10419104,9169183,9169184,10419107,9169233,10419210,10419211,10419212,10419213,10419214,10419215,10419216,10419217,10419218,10419219,10419220,10467067,10469504,10469505,10469506,10469507,10469508,10469509,10469510,10469511,10469512,9167265,10469858,9167320,9167321,10469931,9167787,10468364,10468443,10468444,10468445,10468446,10468447,10468448,10468449,10468450,10468451,10468452,10468453,10468454,10468455,10468456,10468457,10468458,10468459,10468460,10468461,10468462,10468463,10468464,10468465,10468466,10468467,10468468,10468469,10468470,10468471,10468472,10468473,10468474,10468475,10468476,10468477,10468478,10468479,10468480,10468481,10468482,10468483,10468484,10468485,10468486,10468487,10468488,10468489,10468490,10468491,10468492,10468493,10468494,10468495,10468496,10468497,10468498,10468499,10468500,10468501,10468502,10468503,10468504,10468505,10468506,10468507,10468508,10468509,10468510,10468511,10468512,10468513,10468514,10468515,10468516,10468517,10468518,10468519,10468520,10468521,10468522,10468529,10468870,10628150,10628322,10627773,10627930,10630114,10630191,10625214,10625239,10625240,10625241,10625372,10566135,10566136,10477143,10477144,10477204,10477680,10477681) 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'