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(4970681,4970683,4970714,4970731,4970732,4970733,4970734,4970768,8569558,7065968,7065970,7065971,7065972,7065980,7065986,7066024,7066025,7066026,7066027,7066029,7066030,7066031,7066056,7066058,7066060,7066061,7066100,7066123,7066127,7066189,7066192,7066196,7066197,7066198,7066199,7066200,7066201,7066202,7066203,7066204,7066205,7066206,7066222,7066237,7066238,7066260,7066267,8067916,8067919,8067920,8067921,8067922,8067923,8067934,8067938,8067939,8067942,10939408,10939417,8065833,8065835,8065838,8065839,8065840,10960474,7065336,8970179,10958959,8861225,10959116,8860263,8860323,8860328,8860380,8860381,8860384,10618182,10618183,10618265,10618266,10618267,10618268,10618271,10618272,10618274,10618278,10618281,10618296,10618303,10618324,10618326,10623493,10623508,10616967,10616968,10616969,10927509,10927510,10927511,10927512,10927513,10927514,10927515,10617017,10617019,10617020,10617033,10617044,10617068,10617072,10617162,10617163,10617169,10617170,10617211,10617384,10617452,10617462,10954017,10954018,10622526,10614975,10614979,10614983,10614984,10614985,10614988,10614989,10614990,10614991,10614992,10614993,10614994,10614995,10614996,10615000,10615002,10620195,10620196,10620197,10620198,10620199,10620201,10615202,10620202,10615232,10615276,10615277,10615287,10615334,10615335,10615363,10615389,10615437,10615438,10615450,10615509,10615534,10615556,10615571,10615572,10615573,10615574,10615575,10615576,10615577,10615578,10615579,10615580,10615581,10615583,10615677,10615678,10615680,10615681,10615688,10615689,10615697,10615710,10615718,10615721,10615722,10615741,10615742,10615743,10615744,10615745,10615746,10615747,10615748,10615818,10615869,10615931,10615932,10615971,10615972,10615979,10615980,10616044,10616045,10616062,10616089,10616159,10616538,10616572,10616596,10616655,10616656,10616657,10616684,10616695,10616704,10616804,10616842,10616844,10616854,10616882,10616888,10616911,10616913,10610984,10610985,10614020,10614024,10614025,8863906,10614048,10611048,10614050,10611053,10611054,10614080,10611126,10611127,10611131,10611162,10611179,10611203,10614213,10614214,10611219,10611220,10611221,10611222,10614259,10611265,10611266,10614274,10614282,10614297,10611312,10614314,10611367,10611368,10611369,10611370,10614376,10614414,10614463,10614464,10614476,10614486,10614501,10614518,10614555,10559708,10559710,10614592,10614629,10611684,10611699,10611700,10611701,10611702,10611703,10611710,10611711,10611715,10611748,10614749,10614752,10611764,10611788,10611801,10611802,10611813,10611819,10611821,10611823,10611838,10611839,10611842,10614858,10614859,10614862,10614880,10614881,10614882,10614883,10614884,10614888,10614921,10614925,10611981,10611991,10611992,10611993,10611994,10611995,10611996,10611997,10611998,10611999,10612000,10612001,10612002,10612003,10612004,10612029,10609037,10609038,10609039,10609040,10609041,10609042,10609043,10609044,10609045,10609046,10609047,10609048,10609049,10609050,10612051,10609051,10609052,10609053,10609054,10609055,10609056,10609057,10609058,10609059,10609060,10609061,10609062,10609063,10609064,10609065,10609066,10609067,10609068,10612069,10609075,10612082,10612083,10609089,10612093,10609106,10612159,10612168,10612169,10609239,10612263,10612264,10612273,10609285,10612288,10612320,10612321,10609344,10609345,10609355,10612368,10609393,10612408,10612409,10612410,10612411,10612417,10609443,10609444,10612506,10612555,10612556,10612557,10612558,10609584,10612620,10609626,8862486,8862508,8862518,10609662,8862536,8862537,10609689,10612697,10612699,10612700,10612701,10612702,10612703,10609707,10609725,10612725,10609726,10609727,10609728,10609729,10612746,10612755,10612757,10612763,10612765,10612766,10612767,10609770,10612782,10609818,10609819,10612821,10612822,10612825,10609826,10612845,10612853,10612854,10612855,10612856,10612866,10609871,10609872,10609883,10609884,10609885,10612893,10612894,10612896,10612897,10612898,10612907,10612912,10612914,10612915,10612916,10612928,10612951,10609975,10609976,10609982,10609999,10610006,10613019,10613034,10613035,10613036,10610046,10610048,10610067,10613079,10613080,10613081,10613082,10610107,10613118,10613139,10613140,10558292,10613150,10613153,10613156,10613159,10613166,10610167,10610168,10613173,10613180,10613182,10613183,10613192,10613193,10613199,10613202,10613203,10613204,10613223,10610233,10613235,10613236,10613237,10613238,10613239,10613244,10613245,10613247,10613252,10613253,10613254,10613261,10610268,10610271,10613280,10613286,10610289,10613290,10613291,10613292,10613305,10610309,10613310,10613316,10613317,10610318,10610319,10610321,10610322,10613322,10610323,10613323,10610324,10613324,10610325,10613325,10610326,10610327,10610328,10610329,10610330,10610331,10610332,10610333,10613336,10613337,10613342,10613343,10613344,10613345,10613349,10613350,10610351,10610355,10610364,10613369,10613370,10613371,10613372,10613373,10613376,10613377,10613378,10613382,10610396,10610397,10610417,10613421,10613424,10613430,10613431,10613432,10613433,10613440,10613442,10613454,10610466,10613510,10613511,10613513,10613514,10613523,10613524,10613525,10613543,10613546,10613555,10613561,10613562,10613563,10613621,10613622,10613623,10613624,10613625,10613626,10613633,10613636,10613637,10613638,10613639,10613640,10613641,10613642,10613643,10613644,10613645,10613647,10613648,10613653,10613654,10613656,10613657,10613658,10613659,10613660,10613661,10613662,10613664,10613665,10613666,10613667,10613671,10613672,10613673,10613679,10613686,10613687,10613688,10613693,10613694,10613696,10613700,10613702,10613703,10613704,10613706,10613707,10613708,10613709,10610709,10613712,10613713,10613714,10613718,10613721,10610727,10613732,10610732,10613733,10613736,10613741,10610743,10613802,10613804,10613805,10613806,10610836,10613844,10610851,10610852,10610901,10610908,10610958,10515335,10418221,10418222,10418223,10418224,10419258,10419259,10416259,10419260,10419262,10416265,10416266,10416268,10416269,10419270,10416270,10416271,10416272,10416273,10416274,10416275,10417287,10419293,10417293,10419294,10416298,10415314,10418335,10418336,10415343,10415344,10417356,10419357,10417357,10419358,10417358,10419359,10417359,10419360,10417360,10419361,10419362,10417383,10417384,10417385,10417402,10417406,10417407,10417408,10419437,10419438,10419439,10416458,10416459,10416460,10416461,10416462,10416463,10416464,10419468,10416482,10416483,10416484,10416485,10416486,10416487,10416488,10418493,10418495,10418496,10418497,10418498,10418499,10417529,10417530,10417537,10415539,10415540,10415541,10415542,10417565,10416569,10416570,10416571,10417572,10416572,10416573,10416574,10416575,10416576,10416593,10416594,10416595,10416596,10416597,10416598,10416599,10416600,10416601,10416602,10416603,10416604,10416605,10416606,10416607,10416608,10417609,10416629,10416630,10416631,10416632,10416633,10417635,10417636,10416639,10419651,10419653,10419654,10419655,10419658,10419659,10419661,10419662,10419663,10419664,10419665,10415671,10415673,10415674,10415682,10415694,10415695,10415699,10417700,10415701,10415705,10415706,10415707,10415708,10415709,10415710,10415711,10415712,10415713,10415714,10416775,10416799,10416800,10416802,10416804,10416806,10416809,10419811,10416812,10416813,10416815,10416817,10416819,10416821,10415841,10418864,10415910,10415911,10415913,10415914,10418948,10418954,10418960,10417966,10416970,10418975,10417991,10418992,10419026,10417026,10417027,10417029,10417030,10419031,10417031,10417034,10417036,10417037,10417038,10418040,10418047,10416056,10419096,10419145,10419146,10419147,10418147,10418148,10418149,10418150,10419159,10416187,10416190,10416204,10416205,10416206,10419207,10416207,10419208,10416212,10416213,10418217,10418218,10418219,10418220,10420220,10462907,10462908,10462909,10468915,10468928,10468940,10471069,10471077,10471127,10469161,10469185,10469188,10469193,10469196,10469197,10469198,10469199,10469200,10469202,10469203,10469210,10469212,10469240,10469245,10469257,10469258,10469259,10469262,10469263,10469265,10467328,10467329,10467330,10467331,10467332,10467333,10469381,10469406,10469471,10469505,10469506,10469508,10469509,10469510,10467632,10467683,10467758,10467854,10469887,10469888,10469889,10469890,10469891,10469892,10469965,10469966,10470061,10470062,10470063,10470064,10470065,10470066,10470067,10470068,10470069,10470070,10470071,10470072,10470116,10470117,10470118,10470119,10470120,10470121,10470122,10470123,10470124,10470125,10470126,10470127,10470128,10470129,10470130,10470131,10470132,10470133,10470134,10470135,10470136,10470137,10470150,10470156,10470157,10470158,10470159,10470160,10470192,10470193,10470194,10470195,10470196,10470197,10470198,10470199,10470200,10470205,10468271,10468272,10468274,10468275,10468276,10468277,10468278,10464291,10468301,10468302,10468303,10468304,10468305,10468306,10468307,10468308,10468309,10468319,10468320,10468340,10464374,10468472,10468502,10468542,10468550,10468619,10470631,10470721,10470722,10470729,10470730) 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'