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(10939566,8569518,10944076,10944077,10944078,10944079,4970994,8569809,8569810,8569811,8569812,8569813,8569814,8569815,10940462,8569816,10940463,10940464,8569817,8569818,10940466,8569819,10940467,8569820,8569821,10940468,10940469,8569822,10940470,10940471,10940472,10940473,10940474,10940475,10940476,10940477,10940478,10940479,10940480,10940481,10940482,10940483,10940484,10940485,10940486,10940487,10940488,10940489,10933323,8067952,8067953,8067954,8067955,8067956,8067957,8067958,8067959,8067960,8067961,8067962,8067963,8067964,8067965,8067966,8067967,8067968,8067969,8067970,8067971,8067972,8067973,8067974,8067975,8067976,8067977,8067978,8067979,8067980,8067981,8067982,8067983,8067984,8067985,8067986,8067987,8067988,8067989,8067990,8067991,8067992,8067993,8067994,8067995,8067996,8067997,8067998,8067999,8068000,8068001,8068002,8068003,7075113,8068004,8068005,8068006,8068007,8068008,8068009,8068010,8068011,8068012,8068013,8068014,8068015,8068016,8068017,8068067,8068068,8068069,8068070,8068071,8068072,8068073,8068074,8068075,8068076,8068077,8068078,8068079,8068080,8068081,8068082,8068083,8068084,8068085,8068086,8068087,8068088,8068089,8068090,8068091,8068092,8068093,8068094,8068095,8068096,8068097,8068098,8068099,8068100,8068101,8068102,8068103,8068104,8068105,8068106,8068107,8068108,8068109,8068110,8068111,8068112,8068113,8068114,8068115,8068116,8068117,8068118,8068119,8068120,8068121,8068122,8068123,8068124,8068125,8068126,8068127,8068128,8068129,8068130,8068131,8068132,8068133,8068134,8068135,8068136,8068137,8068138,8068139,8068140,8068141,8068142,8068143,8068144,8068145,8068146,8068147,8068148,8068149,8068150,8068151,8068152,8068153,8068154,8068155,8068156,8068157,8068158,8068159,8068160,8068161,8068162,8068163,8068164,8068165,8068166,8068167,8068168,8068169,8068170,8068171,8068172,8068173,8068174,8068175,8068176,10961970,8068177,10961971,8068178,10961972,8068179,10961973,8068180,10961974,8068181,10961975,8068182,8068183,8068184,8068185,8068186,8068187,8068188,8068189,8068190,8068191,8068192,8068193,8068194,8068195,8068196,8068197,8068198,8068199,8068200,8068201,8068202,8068203,8068204,8068205,8068206,8068207,8068208,8068209,8068210,8068211,8068212,8068213,8068214,8068215,8068216,8068217,8068218,8068219,8068220,8068221,8068222,8068223,8068224,8068225,8068226,8068227,8068228,8068229,8068230,8068231,8068232,8068233,8068234,8068235,8068236,8068237,8068238,8068239,8068240,8068241,8068242,8068243,8068244,8068245,8068246,8068247,8068248,8068249,8068250,8068251,8068252,8068253,8068254,8068255,8068256,8068257,8068258,8068259,8068260,8068261,8068262,8068263,8068264,8068265,8068266,8068267,8068268,8068269,8068270,8068271,8068272,8068273,8068274,8068275,8068276,8068277,8068278,8068279,8068280,4969606,8068281,8068282,4969607,8068283,4969608,4969609,8068284,4969610,8068285,8068286,4969611,8068287,4969612,4969613,8068288,8068289,4969614,8068290,8068291,8068292,8068293,8068294,8068295,8068296,8068297,8068298,8068299,8068300,8068301,8068302,8068303,8068304,8068305,8068306,8068307,8068308,8068309,8068310,8068311,8068312,8068313,8068314,8068315,8068316,8068317,8068318,8068319,8068320,8068321,8068322,8068323,8068324,8068325,8068326,8068327,8068328,8068329,8068330,8068331,8068332,8068333,8068334,8068335,8068336,8068337,8068338,8068339,8068340,8068341,8068342,8068343,8068344,8068345,8068346,8068347,8068348,8068349,8068350,8068351,8068352,8068353,8068354,8068355,8068356,8068357,8068358,8068359,8068360,8068361,8068362,8068363,8068364,8068365,8068366,8068367,8068368,8068369,8068370,8068371,8068372,8068373,8068374,8068375,8068376,8068377,8068378,8068379,8068380,8068381,8068382,8068383,8068384,8068385,8068386,8068387,8068388,8068389,8068390,8068391,8068392,8068393,8068394,8068395,8068396,8068397,8068398,8068399,8068400,8068401,8068402,8068403,8068404,8068405,8068406,8068407,8068408,8068409,8068410,8068411,8068412,8068413,8068414,8068415,8068416,8068417,8068418,8068419,8068420,8068421,8068422,8068423,8068424,8068425,8068426,8068427,8068428,8068429,8068430,8068431,8068432,8068433,8068434,8068435,8068436,8068437,8068438,8068439,8068440,8068441,8068442,8068443,8068444,8068445,8068446,8068447,8068448,8068449,8068450,8068451,8068452,8068453,8068454,8068455,8068456,10939199,10939200,8065208,8065209,8065210,8065211,8065212,8065213,8065214,8065215,8065216,8065217,8065218,8065219,8065220,8065221,8066218,8066219,8066220,8066221,8066222,8066223,8066224,8066225,8066226,8066227,8066228,8066229,8066230,8066231,8066232,8066233,8066234,8066235,8066236,8066237,8066238,8066239,8066240,8066241,8066242,8066243,8066244,8066245,8066246,8066247,8066248,8066249,8066250,8066251,8066252,8066253,8066254,8066255,8066256,8066257,8066258,8066259,8066260,8066261,8066262,8066263,8066264,8066265,8066266,8066267,8066306,8066307,8066308,8066309,8066310,8066311,8066312,8066313,8066314,8066315,8066316,8066317,8066318,8066319,8066320,8066321,8066322,8066323,8066324,8066325,8066326,8066327,8066328,8066329,8066330,8066331,8066332,8066333,8066334,8066335,8066336,8066337,8066338,8066339,8066340,8066341,8066342,8066343,8066344,8066345,8066346,8066347,8066348,8066349,8066350,8066351,8066352,8066353,8066354,8066355,8066356,8066357,8066358,8066359,8066360,8066361,8066362,8066363,8066364,8066365,8066366,8066367,8066368,8066369,8066370,8066371,8066372,8066373,8066374,8066375,8066376,8066377,8066378,8066379,8066380,8066381,8066382,8066383,8066384,8066385,8066386,8066387,8066388,8066389,8066390,8066391,8066392,8066393,8066394,8066395,8066396,8066397,8066398,8066399,8066400,8066401,8066402,8066403,8066404,8066405,8066406,8066407,8066408,8066409,8066410,8066411,8066412,8066413,8066414,8066415,8066416,8066417,8066418,8066419,8066420,8066421,8066422,8066423,8066424,8066425,8066426,8066427,8066428,8066429,8066430,8066431,8066432,8066433,8066434,8066435,8066436,8066437,8066438,8066439,8066440,8066441,7065465,7065466,7065467,7065468,10959236,10959237,10959238,10959239,10959240,10959241,8970209,7068961,7068962,7068963,7068964,7068965,7068966,7068967,7068968,7068969,7068970,7068971,7068972,7068973,10944493,11048321,11049749,11049750,11049751,10620106,10930647,10926259,10930754,10921666,10921667,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621243,10621244,10621245,10621246,10621247,10621248,10621249,10621250,10621251,10621252,10621253,10621254,10621255,10621256,10621257,10621258,10621259,10621260,10621261,10621262,10621263,10621264,10621288,10621289,10621290,10621291,10621292,10621293,10621294,10621295,10621296,10621297,10621298,10621299,10621300,10621301,10621302,10621303,10621304,10621305,10621306,10621307,10621308,10621309,10621310,10621311,10621312,10621313,10621314,10621315,10621316,10621317,10621318,10621319,10621320,10621321,10621322,10621323,10621324,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10621340,10621341,10621342,10621343,10621344,10621345,10621346,10621347,10621348,10621349,10621350,10621351,10621352,10621353,10621354,10621355,10621356,10621357,10621358,10621359,10612163,10612164,8862156,8862157,8862158,8862159,8862160,8862161,8862162,8863308,8863309,8863310,8863311,8863312,8863313,8863314,8863315,8863316,8863317,8863318,8863319,8863320,8863321,8863322,8863323,8863324,8863325,8863326,8863327,8863328,8863329,8863330,8863375,8863376,8863377,8863378,8863379,8863380,8863381,8863382,8863383,8863384,8863385,8863386,8863387,8863388,8863389,8863390,8863391,8863392,8863393,8863394,8863395,8863396,8863397,8863398,8863399,8863400,8863401,8863402,8863403,8863404,8863405,8863406,8863407,8863408,8863409,8863410,8863411,8863412,8863413,8863414,8863415,8863416,8863417,8863418,8863419,8863420,8863421,8863422,8863423,8863424,8863425,8863426,8863427,8863428,8863429,8863430,8863431,8863432,8863433,8863434,8863435,8863436,8863437,8863438,8863439,8863440,8863441,8863442,8863443,8863444,2809382,2809383,2809384,4972038,4972039,4972040,4972041,4972042,4972043,4972044,4972045,4972046,4972047,4972048,4972049,4972050,4972051,4972052,4972053,4972054,4972055,10466507,10466508,10466509,10466510,10466511,10466512,10466513,10466514,10466515,10466516,10466517,10466518) 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'