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(7067955,7067993,7068008,7068024,7068029,7068038,7076056,7076057,7076067,7076069,7076085,7076086,7076087,7076088,7076089,7076090,7076131,7076166,7076207,10939917,10939919,10939925,7076375,7076389,10940055,7068437,7068440,7068451,7068465,8569459,7068531,8569510,8569511,7068536,8569546,8569644,8569645,8569646,4971081,10944341,10944343,7065970,7065972,7065973,7066078,7066158,7074203,7074204,7074206,7074207,7074208,7066240,7066241,7066242,7066244,7066265,7074318,7074319,7074321,7074323,7066332,7074353,7074357,7074367,7074370,7066530,7066639,7066640,7066641,8067826,8067827,7066930,7066940,8067904,8067910,8067911,8067912,8067913,7067047,7067051,7067085,7067376,7075440,7075491,7067585,7067654,10939386,10939409,10939412,7067793,10939428,7067839,7067840,7067841,10939519,7075910,7075931,7064065,7064066,7064129,7064130,7064149,7064163,7064166,7064167,7064168,7064178,7064179,7064182,7064183,7064186,7064189,7064193,7072209,7064316,7064327,7064329,7064352,7064670,7065118,7065119,7073161,7073172,7073179,7065483,7065572,7065857,7065904,10942605,7071089,11049005,11049006,11049007,11049008,10942767,10942768,7071152,11049079,7071413,7071414,7071441,7071460,7071462,11049422,11049426,11049428,7071531,7071532,7071533,11049437,7071537,11049438,7071538,11049439,11049440,7071545,11049449,7071574,7071575,7071576,7071577,7071578,7071579,7071580,7071581,7071582,7071583,7071584,7071585,7071586,11049486,7071587,11049487,11049488,11049489,10943241,10943294,10943295,10943329,3655528,3655849,10944724,3655890,7069363,7069441,7069442,7069443,7069444,10944863,7069445,10944864,7069446,10944865,7069447,10944866,10944867,7069448,10944868,7069449,10944869,7069450,10944870,7069451,7069452,7069453,7069454,7069455,7069456,10944998,10944999,7069587,7069588,7069592,10945085,7069699,3656297,10941687,7070107,3656781,3656782,3656783,3656784,3656958,3656959,3656960,3656961,3656963,3656965,3656966,3656967,3656968,3656971,3656972,3656973,3656974,3656975,3656999,3657000,3657001,10942054,3657002,8073171,8073172,8073209,8073210,7070477,11048424,11048425,11048443,11048444,11048445,11048459,8073293,8073294,11048472,11048473,11048511,11048512,7070740,7070840,7070865,7070866,10622993,10622994,10622995,10622998,10622999,10623048,10623049,10623050,10623057,10623058,10623059,10623060,10623061,10623062,10618177,10618178,10618179,10618180,10618181,10618182,10618183,10618197,10618238,10618239,10928820,8070020,8070021,8070022,8070023,10623490,10623493,10623503,10623658,10927504,10927505,10927506,10927507,10622099,10622100,10622187,10622188,10622189,10622196,10622718,10622719,10622720,10928321,10928322,10928323,10622872,10622873,10622927,10622928,10622929,10622930,10622931,10622932,10622946,10622947,10622948,10622949,10622961,10619981,10620129,10620138,10620145,10620146,10620148,10620149,10620150,10620151,10620263,10620523,10620524,10620527,10620528,10620859,10621033,10621034,10614060,10611065,10614067,10611068,10614068,10611069,10614069,10611070,10611071,10614071,10611072,10611073,10611074,10611077,10611078,10611135,10611138,10611139,10611141,10611162,10559332,10559333,10559334,10614201,10611219,10611220,10614236,10611318,10611319,10614338,10614341,10614403,10614404,10614405,10614406,10559630,10614532,10614547,10559702,10614563,10614573,10611685,10614710,10614735,10614736,10614742,10611815,10614849,10614861,10611891,10611892,10611906,10611907,10611908,10611909,10611910,10611911,10611912,10611913,10611914,10611915,10611916,10611917,10611918,10611919,10611922,10611923,10611924,10611925,10611926,10611927,10611928,10611929,10611930,10611931,10611932,10611933,10611934,10611935,10611937,10611938,10611941,10611976,10611980,10611982,10611984,10611985,10611987,10611988,10611991,10611992,10611993,10611998,10611999,10612000,10612001,10612002,10612003,10612004,10612005,10612006,10612009,10612074,10612076,10612091,10612092,10612106,10612107,10612166,10612167,10612189,10612223,10612224,10612255,10612256,10612257,10609266,10609267,10609284,10609332,10609344,10609345,10609348,10609350,10609351,10609352,10612356,10609356,10609357,10609358,10609359,10609362,10609363,10609364,10609367,10609376,10609377,10609378,10609379,10609385,10609386,10609390,10609400,10609401,10563567,10609443,10609444,10557719,10557720,10609724,10609772,10609835,10609886,10612986,10612987,10612988,10612989,10612990,10609991,10612996,10612997,10612998,10612999,10613000,10613001,10613002,10613003,10613005,10613006,10613007,10613008,10610008,10613009,10610009,10610010,10613010,10613011,10613012,10610015,10613016,10613017,10610027,10610031,10613032,10613033,10613034,10613039,10613055,10613058,10613060,10613061,10613062,10613063,10613078,10613094,10610094,10613123,10613143,10613145,10613146,10558297,10613148,10558298,10613149,10558299,10558300,10613151,10558302,10613153,10613154,10613155,10558305,10558306,10613157,10613158,10613159,10613160,10613162,10613166,10613168,10613169,10613171,10613172,10613175,10613176,10613177,10613178,10613179,10613191,10613192,10613198,10613199,10613200,10613205,10613209,10613210,10613224,10613225,10613232,10613233,10613234,10613251,10613254,10613260,10613265,10613266,10613292,10610304,10610306,10610307,10610323,10613330,10613343,10610347,10610349,10610350,10610351,10610352,10610353,10613355,10610355,10613364,10610418,10613455,10610478,10610488,10613548,10610564,10613565,10613643,10613675,10613676,10613677,10613678,10613696,10613697,10613698,10613699,10610720,10613721,10610721,10613722,10610722,10610723,10610725,10610726,10610727,10610728,10610732,10610733,10613734,10610734,10613735,10610735,10610736,10613736,10610737,10610738,10613738,10610740,10610741,10610742,10610743,10610744,10610745,10610746,10610747,10610748,10610749,10610750,10610751,10610752,10610791,10610868,10610911,10610912,10610947,10513381,10513382,10513383,10513384,10513385,10513389,10513390,10513391,10513406,10513622,10517651,10517652,10517653,10514037,10514038,10512114,10512121,10512122,10512123,10512124,10512125,10512126,10512127,10512128,10512129,10512135,10512136,10512137,10512138,10512139,10512140,10512147,10514364,10514365,10514366,10514367,10512558,10512576,10512578,10512579,10512580,10512581,10512582,10512583,10512584,10512585,10512586,10512587,10512588,10512589,10512590,10512591,10512592,10512593,10512594,10512595,10512596,10512597,10512598,10512599,10512600,10512601,10512602,10512603,10512604,10512605,10512606,10512607,10512608,10512609,10512610,10512611,10512612,10518618,10512636,10512637,10512638,10512639,10512640,10512641,10512642,10512643,10512644,10512645,10512646,10512647,10512648,10512649,10512650,10512651,10512652,10512653,10512654,10512655,10512656,10512657,10512658,10512659,10512676,10512677,10512678,10512679,10512680,10512681,10512682,10512683,10512684,10512685,10512686,10512687,10512688,10512689,10512690,10512691,10512692,10512693,10512694,10512695,10512706,10512707,10512708,10512709,10512710,10512711,10512712,10512713,10512714,10512715,10512716,10512717,10512718,10512719,10512720,10512721,10512722,10512723,10512724,10512725,10512731,10512732,10512733,10512734,10512741,10512742,10512768,10512771,10512772,10512780,10514975,10514976,10514977,10514978,10514979,10514980,10514981,10514982,10514983,10514984,10514985,10514986,10514987,10514988,10514989,10514990,10514991,10514992,10514993,10514994,10514995,10514996,10514997,10514998,10514999,10515000,10515001,10515002,10515003,10515004,10515005,10515006,10515007,10515008,10515009,10515010,10515011,10515012,10515013,10515014,10515015,10515016,10515017,10515018,10515019,10515020,10515021,10515022,10515023,10515024,10515025,10515026,10515027,10515028,10515029,10515030,10515031,10515032,10515033,10515034,10515035,10515036,10515037,10515038,10515039,10515040,10515041,10515042,10513042,10515043,10515044,10515045,10515046,10515047,10515048,10515049,10515050,10515051,10515052,10515053,10515054,10515055,10515056,10515057,10515058,10515059,10415243,10415244,10415848,10415849,10415850,10415851,10415852,10415853,10415854,10415856,10415857,10415858,10415859,10415860,10415861,10415862,10415863,10415864,10415865,10415866,10415867,10415868,10415869,10415870,10415890,10415892,10415893,10415895,10415903,10416904,10415904,10416905,10415905,10416906,10415906,10415908,10416909,10416910,10416911,10416914,10416915,10415916,10416917,10415917,10415918,10416935,10416936,10416937,10416939,10416940,10419993,10420061,10420062,10416065,10416066,10416067,10416068,10416070,10416071,10416072,10416073,10416077,10416078,10416080,10416081,10416083,10416084,10416085,10416086,10416087,10416088,10416089,10416090,10416093,10416095,10416096,10416098,10416099,10416102,10416103,10416105,10416106,10416108,10416109,10416111,10467067,10471069,10471456,10471457,10471458,10471459,10471460,10471462,10471463,10471464,10471465,10471467,10467468,10471468,10467469,10467470,10467471,10462571,10462572,10462574,10462575,10462576,10470722) 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'