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(8630784,8630935,8630938,8630939,8630940,8630941,8630942,8630944,8630945,8630946,8630947,8630948,8630949,8630950,8630951,8630952,8630953,8630954,8630955,8630956,8630957,8631809,8631829,8631830,8631831,8631832,8631833,8631834,8631835,8631836,8631837,8631901,8631902,8631903,8631904,8631905,8631906,8631907,8631908,8631909,8631910,8631911,8631912,8631913,8631914,8631915,8631916,8631917,8631918,8631920,8631921,8631922,8631923,8631924,8631925,8631926,8631927,8631928,8631929,8631930,8631931,8631932,8631933,8631934,8631935,8631936,8631937,8631938,8631939,8631940,8631941,8631942,8631943,8631944,8631945,8631946,8631947,8631948,8631949,8631950,8631951,8631952,8631953,8631954,8631955,8631956,8631957,8631958,8631959,8631960,8631961,8631962,8631963,8631964,8631965,8631966,8631967,8631968,8631969,8631970,8631971,8631972,8631973,8631974,8631975,8631976,8631977,8631978,8631979,8631980,8631981,8631982,8631983,8631984,8631985,8631986,8631987,8631988,8631989,8631990,8631991,8631992,8631993,8631994,8631996,8631997,8631998,8631999,8632000,8632001,8632002,8632003,8632004,8632005,8632006,8632007,8632008,8632009,8632010,8632011,8632012,8632013,8632014,8632015,8632016,8632017,8632018,8632019,8632020,8632021,8632022,8632023,8632024,8632025,8632026,8632027,8632028,8632029,8632030,8632031,8632032,8632033,8632034,8632035,8632036,8632037,8632038,8632039,8632040,8632041,8632042,8632043,8632044,8632045,8632046,8632047,8632048,8632049,8632050,8632051,8632052,8632053,8632054,8632055,8632056,8632057,8632058,8632059,8632060,8632061,8632062,8632063,8632064,8632065,8632066,8632067,8632068,8632069,8632070,8632071,8632072,8632073,8632074,8632075,8632076,8632077,8632078,8632079,8632080,8632081,8632082,8632083,8632084,8632085,8632086,8632087,8632088,8632089,8632090,8632091,8632092,8632093,8632094,8632095,8632096,8632097,8632098,8632099,8632100,8632101,8632102,8632103,8632104,8632105,8632106,8632107,8632108,8632109,8632110,8632111,8632112,8632113,8632114,8632115,8632116,8632117,8632118,8632119,8632120,8632121,8632122,8632123,8632124,8632125,8632126,8632127,8632128,8632129,8632130,8632131,8632132,8632133,8632134,8632135,8632136,8632137,8632138,8632139,8632140,8632141,8632142,8632143,8632144,8632145,8632146,8632147,8632148,8632149,8632150,8632151,8632152,8632153,8632154,8632155,8632156,8632157,8632158,8632159,8632160,8632161,8632162,8632163,8632164,8632165,8632166,8632167,8632168,8632169,8632170,8632171,8632172,8632173,8632174,8632175,8632176,8632177,8632178,8632179,8632180,8632181,8632182,8632183,8632184,8632185,8632186,8632188,8632189,8632200,8632201,8632206,8632207,8632208,8632209,8632210,8632211,8632212,8632213,8632214,8632215,8632216,8632217,8632218,8632219,8632220,8632221,8632222,8632223,8632224,8632225,8632226,8632227,8632228,8632229,8632230,8632231,8632232,8632233,8632234,8632235,8632236,8632237,8632238,8632239,8632240,8632242,8632243,8632244,8632245,8632247,8632249,8632250,8632251,8632253,8632254,8632255,8632256,8632257,8632258,8632259,8632260,8632261,8632262,8632263,8632264,8632265,8632266,8632267,8632268,8632269,8632271,8632272,8632273,8632274,8632275,8632276,8632277,8632278,8632279,8632280,8632281,8632282,8632283,8632284,8632285,8632286,8632287,8632288,8632289,8632290,8632291,8632292,8632293,8632294,8632295,8632296,8632297,8632298,8632299,8632300,8632301,8632302,8632304,8632305,8632306,8632307,8632308,8632309,8632310,8632311,8632313,8632314,8632315,8632316,8632317,8632318,8632319,8632320,8632321,8632322,8632324,8632325,8632326,8632327,8632328,8632330,8632331,8632333,8632334,8632335,8632336,8632337,8632338,8632339,8632340,8632341,8632342,8632344,8632345,8632346,8632347,8632348,8632349,8632350,8632351,8632353,8632354,8632355,8632356,8632357,8632358,8632359,8632360,8632361,8632362,8632363,8632364,8632365,8632366,8632367,8632368,8632369,8632370,8632371,8632372,8632373,8632374,8632375,8632376,8632377,8632378,8632379,8632498,8632499,8629590,8629593,8629597,8629598,8629600,8629604,8629605,8629606,8629614,8629617,8629618,8629619,8629620,8629621,8629622,8629636,8629643,8629644,8629651,8629653,8629656,8629658,8629660,8629664,8629665,8629666,8629667,8629668,8629669,8629671,8629683,8629684,8629685,8629686,8629688,8629689,8629694,8629695,8629696,8629697,8629698,8629699,8629700,8629701,8629702,8629703,8629704,8629710,8629711,8629712,8629713,8629766,8629767,8629768,8630175,8630176,8630178,8630179,8630180,8630181,8630182,8630183,8630184,8630185,10939432,8630510,8630511,7201404,8628040,8628097,8628098,8628099,8628100,8628106,8628107,8628108,8628109,8628110,8628111,8628112,8628113,8628114,8628115,8628116,8628117,8628406,8628407,8628408,8628409,8628410,8628411,8628412,8628413,8628414,8628415,8628416,8628418,8628419,8628420,8628423,8628425,8628426,8628427,8628428,8628429,8628430,8628431,8628432,8628433,8628434,8628435,8628436,8628437,8628438,8628440,8628441,8628442,8628443,8628444,8628445,8628446,8628447,8628448,8628449,8628450,8628451,8628453,8628454,8628455,8628456,8628457,8628458,8628459,8628460,8628461,8628462,8628463,8628464,8628465,8628466,8628468,8628469,8628470,8628471,8628472,8628473,8628474,8628475,8628476,8628477,8628478,8628479,8628480,8628481,8628482,8628483,8628484,8628485,8628753,8628754,8628755,8628756,8628757,8628758,8628759,8628760,8628761,8628762,8628763,8628764,8628765,8628766,8628767,8628768,8628769,8628770,8629281,8629351,8629352,8629353,8629354,8629429,8629430,8629472,8629478,8629479,8629480,8629481,8629482,8629544,8629545,8629546,8629547,8629548,8629549,8629550,8629551,8629552,8629555,8629556,8626835,8626836,8626837,8626838,8626839,8626847,8626848,8626849,8626850,8626851,8626852,8626853,8626854,8626855,8626856,8626857,8626858,8626859,8626860,8626861,8626862,8626863,8626864,8626865,8626866,8626867,8626868,8626869,8626870,8626871,8626872,8626873,8626874,8626875,8626876,8626877,8626878,8626879,8626880,8626881,8626882,8626883,8626884,8626885,8626886,8626887,8626888,8626889,8626890,8626891,8624696,8624697,8624698,8624708,8624709,8624710,8624711,8624712,8624713,8624714,8624715,8624716,8624717,8624718,8624719,8624720,8624721,8624722,8624723,8624724,8624725,8624727,8624728,8624729,8624730,8624731,8624732,8624733,8624734,8624735,8624736,8624737,8624738,8624739,8624740,8624741,8624742,8624743,8624744,8624745,8624746,8624747,8624748,8624749,8624750,8624752,8624753,8624754,8624755,8624756,8624757,8624758,8624759,8624760,8624761,8624762,8624763,8624764,8624765,8624817,8624818,8624819,8624820,8624821,8624822,8624823,8624824,8624825,8624826,8624827,8624828,8624829,8624830,8624831,8624832,8624833,8624834,8624835,8624836,8624837,8624838,8624839,8624840,8624841,8624842,8624843,8624844,8624845,8624846,8624847,8624848,8624849,8624850,8624851,8624852,8624853,8624854,8624855,8624856,8624857,8624858,8624859,8624860,8624861,8624862,8624863,8624864,8624865,8624866,8624867,8624868,8624869,8624870,8624871,8624872,8624873,8624874,8624875,8624876,8624877,8624878,8624879,8624880,8624881,8624882,8624883,8624884,8624885,8624886,8624887,8624888,8624889,8624890,8624891,8624892,8624893,8624894,8624895,8624896,8624897,8624898,8624899,8624900,8624901,8624902,8624903,8624904,8624905,8624906,8624907,8624908,8624909,8624910,8624911,8624912,8624913,8624914,8624915,8624916,8624917,8624918,8624919,8624920,8624921,8624922,8624928,8624929,8624930,8624931,8624933,8624936,8624937,8624938,8624939,8624940,8624941,8624942,8624943,8624946,8624947,8624948,8624949,8624950,8624951,8624952,8624953,8624954,8624955,8624956,8624957,8624958,8624959,8624962,8624963,8624964,8624965,8624966,8624967,8624968,8624969,8624970,8624971,8624972,8624974,8624975,8624976,8624977,8624979,8624980,8624981,8624982,8624983,8624984,8624986,8624987,8624988,8624989,8624990,8624991,8624992,8624993,8624994,8624995,8624996,8624997,8624998,8624999,8625000,8625001,8625002,8625003,8625004,8625005,8625006,8625007,8625008,8625009,8625010,8625011,8625012,3237346,7197270,7197275,7197279,7197281,3234503,3232801,3232879,10615568,10615569,10615570,7017415,7017416,10117655,9169551,10118051,6674254,10118419,10118550,10118551,9168795,9168796,9168797,9168283,10887864,10888443,10885527) 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'