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(7067937,4970409,10943592,10943593,7068112,7068113,10943628,7076123,7076127,7076128,4970520,4970521,7076286,7076288,7076289,7076290,7076291,7076292,7076293,7076294,4970670,4970675,4970733,7068401,7068522,8569517,8569524,4971081,10944265,8569733,4971143,7065832,7065836,7065837,7065947,4968320,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,7066178,7066348,7074350,7074355,10437559,7074632,8067927,8067931,7067302,7075323,7075484,7067586,7067766,6000119,6000194,6000195,6000196,6000197,6000198,6000199,7072150,7072286,10931829,10931901,10931961,10931962,10931963,10931964,7064652,7064733,7064771,10932792,10932793,10932797,10932798,10932799,10932800,10932801,10932802,10932806,10932807,10932808,10932809,10932810,7065430,10932960,10932963,10932964,10932965,10932966,10932967,10932968,10932975,10932979,4967985,7065695,4968076,4968077,4968078,7071265,7071266,7071808,7071810,10941045,10941046,10941047,10941118,7069788,10941691,10941692,10941693,10941695,10941701,10941704,10941716,10941757,10941758,10941759,10941760,10941763,10941764,10941765,10941766,10941769,10941773,10941776,10941782,10941783,10941948,10942027,10942100,8860395,8860418,8860419,8860420,10942401,10942410,7070749,7070757,7070761,10623065,10623165,10623166,10623167,10618277,10618279,10618280,10618369,10618370,8070180,10623493,10623507,10623508,10623665,10623714,10623728,10624134,10619150,10619175,8070909,8070910,10619384,10619385,10619386,10624555,10619835,10619840,10619842,10619843,10619854,10619865,10619872,10619874,10619875,10619885,10619886,10619887,10619889,10619891,10619892,10619894,10619906,10922500,10922501,10922505,10927506,10927507,10927508,10922511,10922512,10922513,10922514,10922518,10922520,10617107,10617118,10622146,10622266,10617322,10617329,10617331,10617332,10617335,10617336,10617340,10617341,10617343,10617344,10617345,10617346,10617347,10617348,10617349,10617350,10617351,10617352,10617353,10617354,10617359,10617367,10617371,10617373,10617374,10617375,10617376,10617378,10617379,10617380,10617381,10617382,10617383,10617385,10617386,10617387,10617388,10617389,10617390,10617391,10617392,10617393,10617394,10617395,10617396,10617397,10617398,10617399,10617400,10617401,10617402,10617403,10617404,10622405,10617405,10617406,10617407,10617408,10617409,10617410,10617411,10617412,10617413,10617414,10617415,10617416,10617417,10617418,10617419,10617420,10617421,10617422,10617423,10617426,10617430,10617433,10617436,10617437,10617446,10617447,10617448,10617449,10617452,10617456,10617457,10617458,10927986,10928008,10617512,10928029,10622672,10622673,10622674,10622675,10928302,10617955,10617957,10620172,10620186,10620187,10620188,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620207,10620208,10620254,10620255,10620256,10620257,10620258,10620259,10620301,10620302,10620303,10620309,10620335,10620336,10620337,10620923,10922135,10922136,10922137,10922138,10922143,10922256,10922257,10922258,10922259,10922260,10922269,10922270,10922271,10922272,10922273,10922274,10922275,10922277,10922282,10613962,10613963,10613964,10613965,10613966,10613967,10613968,10613969,10613970,10614057,10565258,10565296,10559321,10559322,10614182,10614221,10559498,10559609,10559622,10559626,10559627,10614495,10614496,10614500,10614501,10614503,10614504,10614505,10614520,10559703,10559704,10559706,10559711,10559712,10559722,10559723,10559724,10559725,10559726,10559744,10611969,10612022,10612025,10612062,10612086,10612097,10612102,10612106,10612107,10612136,10612293,10612294,10612295,10612380,10612381,10612938,10612943,10612960,10612961,10613017,10613093,10613097,10613099,10613105,10613107,10613108,10613109,10613112,10613115,10613117,10613137,10613143,10558297,10558298,10558299,10558300,10613162,10613175,10613176,10613191,10613192,10613215,10613343,10613369,10613372,10613392,10558596,10613475,10613483,10613513,10613514,10613547,10613696,10613738,10613739,10613740,10613958,10613959,10613960,10613961,10513118,10513119,10513386,10513561,10513563,10517670,10517789,10517796,10517797,10514018,10512530,10518658,10518661,10518668,10518669,10518675,10518676,10518677,10518678,10518679,10518680,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10512782,10515060,10515062,10515063,10515064,10515065,10515066,10417221,10417222,10417223,10417224,10417225,10416257,10419307,10417312,10417313,10417314,10417315,10416351,10416352,10416361,10416364,10416369,10416384,10416385,10416387,10416430,10416435,10419438,10419439,10416443,10417444,10417445,10419469,10419477,10419478,10419479,10419491,10419492,10419498,10419499,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10417534,10419536,10419537,10419538,10419568,10419668,10419671,10419672,10419673,10419674,10419675,10419677,10419678,10419679,10419680,10419687,10419689,10419690,10419694,10419695,10419703,10419704,10419706,10419708,10419709,10419710,10419713,10419714,10419715,10419717,10419719,10419731,10419736,10419737,10419744,10419745,10419746,10419747,10419802,10419803,10419804,10419805,10419806,10416807,10416808,10419808,10416809,10419809,10416810,10419823,10419824,10419825,10416826,10419826,10419827,10419837,10419838,10419839,10419840,10419894,10419898,10419899,10419900,10419904,10420039,10420045,10420046,10417053,10417054,10417055,10417056,10417057,10417058,10417059,10417060,10417061,10417062,10417063,10417064,10417065,10417066,10417067,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10417076,10417077,10417078,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10420091,10417092,10420092,10417093,10420093,10417094,10420094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10420102,10417103,10420103,10417104,10420104,10417105,10420105,10417106,10417107,10417108,10420108,10417109,10420109,10417110,10420110,10417111,10420111,10417112,10417113,10420113,10417114,10417115,10417116,10417117,10420117,10420118,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10420125,10417125,10420126,10417126,10420127,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10417143,10417144,10418145,10417145,10418146,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10417155,10417156,10417157,10417158,10417159,10417160,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10417212,10417213,10420213,10417214,10420214,10420215,10417215,10417216,10417217,10417218,10417219,10417220,10466954,10466961,10466962,10467005,10467068,10467092,10467094,10467095,10467096,10467098,10467100,10467102,10467103,10467105,10467115,10467120,10467121,10467123,10467124,10467130,10467131,10467137,10467138,10467139,10467140,10467141,10467147,10467148,10467149,10467150,10467159,10467172,10471172,10467173,10467407,10467431,10467432,10467435,10467441,10467442,10467461,10467472,10467473,10465680,10465684,10465685,10465690,10465693,10465698,10465699,10465704,10465705,10465706,10465709,10465710,10465762,10465763,10465764,10465765,10465776,10465794,10465816,10465817,10465818,10465820,10465828,10465832,10465833,10465834,10465837,10465839,10465840,10465841,10465847,10465850,10465862,10465864,10465867,10465870,10465871,10465872,10465873,10465874,10465875,10465876,10463879,10463880,10465882,10465883,10465884,10465885,10465888,10465889,10463889,10465890,10463890,10463891,10463892,10463893,10463894,10463896,10465899,10463900,10465901,10463901,10463902,10465903,10463903,10463904,10465905,10463906,10463908,10463909,10463910,10463911,10463912,10465914,10465918,10465919,10463923,10463924,10463925,10463926,10463928,10463929,10463948,10463949,10469949,10470084,10466209,10466216,10466217,10466218,10466219,10466221,10466223,10466224,10466227,10466228,10466234,10466237,10466238,10466239,10466242,10466273,10466305,10466306,10466307,10466310,10466311,10466312,10466319,10466340,10466341,10466342,10466355,10466366,10466367,10466379,10466381,10466382,10466383,10466385,10466386,10466387,10466388,10466389,10466406,10466407,10466408,10466409,10466410,10466411,10466415,10466416,10466417,10466418,10466419,10466420,10466421,10464425,10464426,10466428,10466436,10466437,10466445,10466451,10466453,10466454,10466455,10466469,10466470,10464581,10466845,10466846,10466850,10466857,10466858,10466859,10466861,10466862,10466863,10466864,10466865,10466866) 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'