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(11027512,11027513,11027514,11027515,11027516,11027517,11027518,11027519,11027520,11027521,11027522,9214632,7076009,8838622,8621099,9214991,8631031,8574596,8574597,8574598,11002215,11002246,11002247,11002248,11002249,11002250,11002251,10940288,10940289,10940290,8621410,10940291,10989313,3229125,10940492,10940493,10846590,10871148,10976569,10976570,10976571,10976572,10976573,10976574,10976575,10976576,10976577,10976578,10976579,10976580,10976581,10976582,10976583,10976584,10976585,10976586,10976587,10976588,10976589,10976590,10976591,10976592,10976593,10976594,10976595,10976596,10976597,10976598,10976599,10976600,8631562,10976601,10976602,10976603,10976604,11002625,11041659,8631651,10846786,10950699,11002806,11002807,11002808,10950773,8631805,11002925,7074311,11003024,10849757,11003157,11003158,11003159,11003160,11003161,11003162,11003163,11003164,11003165,3229974,11003285,11003286,11003367,11003368,11003369,11003370,11003371,10860127,7074844,11039597,11039609,11039610,8629594,8629595,8629705,8629707,10844852,10844853,10498036,10498037,10498038,10498039,8591530,11040128,11040129,11040130,11040131,11040132,11040133,11040134,11040135,11040136,11040137,11040138,11040139,11040140,11040141,11040142,11040143,11040144,8068458,8068459,8068460,11027349,11027350,11027351,11027352,11027353,11027354,11027355,11027356,11027357,10873042,11037510,11037511,8617847,11024825,10103481,11025040,11025041,11025042,11025043,11025044,11025045,11025046,11025047,11025048,11025049,11025050,10986055,11038299,11038300,8595412,7202194,8066023,3899497,7202243,10104145,7202264,8560005,8560006,8560007,8560008,7073226,8066451,8066452,8066453,8066454,10961075,10961076,8560352,10859762,11039275,11039304,8560565,8560566,11039305,11039306,7073655,11039359,11039360,11000409,11000410,11000411,11000412,11000413,11000414,8558387,4430249,11021691,11034702,11034703,11021778,11021779,11021780,11021781,11021782,11021783,11021784,11021785,11021786,11021787,11021788,11021789,11021790,11034856,11035022,11035067,11035068,11035071,11035072,11035073,10863725,7198943,11022511,11022512,10864117,11035514,11035515,11035516,11035517,11035528,10996539,8625500,8625501,10996540,8625502,8625503,10840654,10840655,10840656,8615830,10840763,10840764,8564803,8564804,8564805,8625774,8625775,3656989,11023135,11023136,11023137,11023138,11023139,11023140,11023141,11023142,10942188,10942189,10942190,10856820,10841425,10997440,8612652,11006579,8612948,10967813,11019928,11019929,11019930,11019931,11019932,3233911,3233912,3233913,3233914,3234088,11020439,11020440,11033609,11033610,8613773,8613774,8613775,8613776,8613777,7157566,7157578,3924439,11033760,11033761,11020795,11020796,11020797,11020798,11020799,11020800,11020801,11020802,11020803,11020804,11034007,11008159,11008160,11008161,11034226,11034227,8624334,11005571,8541448,8541449,8541450,8541451,8541452,8541456,11005687,11031689,11031690,11031691,10427389,11005755,10837144,8578636,8578707,8578800,8542246,10460434,10460435,10460456,10460467,10460468,10460486,10460489,8609764,11029653,11029654,10460540,11029655,11029656,10620166,11003710,11003711,11003712,11003789,10990802,10990803,11029805,11029806,11029807,11029808,11029809,11029810,11029811,11029812,11029813,11003844,11003845,11003846,11003847,11003848,11003849,11003850,11004020,11004021,10850767,10850768,10850769,8633199,8633203,10991249,10991250,10991251,10991252,10991253,10991254,10991255,10991256,10991257,10991258,10991259,10991260,10991261,10991262,10991263,10991264,10991265,10926244,10926245,11004309,11004310,10848391,10848461,8633391,3231165,11004474,11043503,10616015,11004685,11004686,11004701,10426468,11004837,10616300,10621363,10621364,10621365,10621366,10621367,10965922,10965923,10979036,11005243,11031246,11031247,11031248,11031249,11031250,11005274,11005275,11005276,11005277,3232061,10565189,10614374,10559729,9206211,9206225,8864768,8864769,8864770,8864771,8864772,8864773,7058143,7058144,7058145,7058147,7058148,9212328,9212329,10610015,9220377,9220378,9220379,10610070,9220380,10610296,10610319,8567242,8567243,8567244,8567245,8567246,8567247,8567248,8863454,8863455,8863456,8863457,8863458,8863459,8863460,8863461,3654159,3654160,3654161,9197107,9197108,10515113,10515114,9169352,10428732,10117656,10117657,9177533,9201596,9209628,10126021,6674189,9210155,9179029,9179030,9179031,9179032,9179033,9179034,7024693,7024694,7024695,7024696,7024697,7024698,7024699,7024700,7024701,7024702,7024703,7024704,7024705,7024706,9211183,10515103,9168373,10124688,10124689,10417475,4973673,4973987,4973988,9193148,9201266,10417192,9182457,10122686,10467479,4972102,4972103,10123524,8917101,8917362,9207865,9207866,9207867,9207868,9175968,9207989,9207995,8551219,6668179,10888535,10628254,8593809,8593810,8593811,8593812,8593813,8593814,10179948,10179964,8069124,8069125,8069126,8069127,8069128,8069129,10910190,10910191,10910192,10910193,10186357,10186359,10186363,10186364,10186404,10885399,10168656,10168657,10168658,10168659,10168660,10168661,10168662,10168663,10168664,10168665,10632169,10897757,10897758,10897759,10897760,10897761,10897762,10897763,10897764,10897765,10897766,10908221,10627918,10910527,10896108,10896109,10177419,10949299,10949300,10949301,10949302,10949303,10949304,10949305,10949306,10949307,10949308,10911852,10911853,10911854,10911855,10911856,10911857,10911858,10911860,10887196,10631838,10649671,10649672,10649673,10649674,10649675,10649676,10608602,10584232,10584233,10584234,10584235,10584236,10590610,10590628,10590629,10590630,10590631,10587643,10587644,10604086,10654567,10585800,10585801,10585802,10585810,10585811,10585830,10585831,10585832,10585833,10585834,10585835,10585836,10585837,10585838,10585839,10585858,10585859,10585860,10585861,10585862,10580003,10580004,10601075,10601076,10601077,10541160,10541161,10541220,10541221,10541222,10541311,10541312,10521326,10541342,10541343,10541344,10541345,10541346,10541347,10541348,10541349,10541350,10541351,10541352,10541353,10541354,10541359,10541360,10543740,10543741,10543742,10543743,10543744,10548079,10548080,10548081,10548089,10548101,10548102,10548103,10548104,10548105,10548108,10548109,10548110,10548114,10540992,10540998,10541013,10541014,10541018,10541019,10541020,10541021,10541029,10541030,10541031,10541039,10541040,10541041,10508183,10508199,10509374,10422679,10407292,8562364,10488288,10411733,8563196,10496908,10414513,10495234,10495235,10495236,10495237,10714927,10476661) 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'