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(8630595,8630602,8630609,8630616,8630621,8630629,8630633,8630634,8630638,8630644,8630645,8630649,8630650,8630655,10861437,10861438,4970675,8631119,3229285,10862167,10862168,10862169,10862170,10862171,10862172,10862173,10862174,10862175,10862176,10862177,10862178,10862179,10862180,10862181,10862182,10862183,8631622,8631623,8631624,8631625,8631630,8631635,8631636,7066178,10862681,10862737,10990291,3230230,8632573,8632574,10860327,10860413,10860414,10860518,10860534,10861126,8630517,8630524,8630530,8630542,8630555,8630561,8630568,8630575,8627590,8627596,7201319,10866362,10866548,10866563,10866564,10866566,10866567,10866568,10866569,10866570,10866572,10866574,10866581,10866582,10866583,10866584,10866585,10866586,10866587,10866588,10866589,10866590,10866591,10866592,10866593,10866594,10866595,10866596,10866597,10866598,10866599,10866600,10866601,7201901,7201959,10960474,8628490,8628491,8628492,8628493,8065853,10859192,10859193,10859194,10859259,10859260,7202524,7202643,9794589,7202769,10857225,10865236,10865238,10865239,8626807,8626808,8626812,7200458,7200470,7200528,10857690,8627068,8627150,8627163,8627176,7200779,8627188,8910604,8910605,8627206,7200904,10865954,10865955,10866015,8627425,8627426,8627427,8627430,8627431,8627432,8627433,8627436,8627437,8627438,8627441,8627442,8627530,8627536,8627537,8627538,8627539,8627540,8627541,8627546,8627547,8627548,8627549,7201153,7201154,7201155,8627560,8627561,8627562,8627563,8627567,8627568,8627569,8627570,10863546,10863547,10863548,10863549,10863550,10863551,10863552,10863553,10863554,10863555,10863556,10863557,10863558,10863559,10863560,10863561,10863562,10863563,10863564,10863565,10863566,10863567,10863568,10863569,10863570,10863571,10863572,10863573,10863574,10863575,10863576,10863577,10863578,10863579,10863580,10863581,10863582,10863583,10863584,10863585,10863586,10863587,10863588,10863589,10863590,10863591,10863592,10863593,10863594,10863595,10863596,10863597,10863598,10863599,10863600,10863601,10863602,10863603,10863604,10863605,10863606,10863607,10863608,10863609,10863610,10863611,10863612,10863613,10863614,10863615,10863616,10863617,10863618,10863619,10863620,10855620,10863621,10855621,10863622,10863623,10863624,10863625,10863626,10863627,10863628,10863629,10863630,10863631,10863632,10863633,10863634,10863635,10863636,10863637,10863638,10863639,10863640,10863641,10863642,10863643,10863644,10863645,10863646,10863647,10863648,10863649,10863650,10863651,10863652,10863653,10863654,10863655,10863656,10863657,10863658,10863659,10863660,10863661,10863662,10863663,10863664,10863665,10863666,10863667,10863668,10863669,10863670,10863671,10863672,10863673,10863674,10863675,10863676,10863677,10863678,10863679,10863680,10863681,10863682,10863683,10863684,10863685,10863686,10863687,10863688,7198684,7198685,7198694,7198696,7198723,7198724,7198728,7198729,7198730,7198733,7198737,7198742,7198743,7198744,7198745,7198746,7198747,7198749,7198759,7198760,7198762,7198765,7198766,7198769,7198770,7198772,8625268,10863979,8625385,10856140,10864306,10101491,10101492,10864787,7199768,10864817,11048460,11048461,11048462,10857141,3923597,3923670,3923671,7196891,7196892,3234662,7197796,7197800,7197802,7197804,7197805,7197807,7197809,8624449,8541521,8905250,8905252,10617323,10617324,10617326,10617336,10617337,10617338,10617378,10617399,10617426,10622428,8905717,8905718,8905822,8632619,8632622,8632684,8632685,8632716,3230564,3230565,3230566,10620195,10620196,10620197,10620198,10620199,10615363,3581896,8633203,8633204,8633205,8633206,8633207,8633208,8633209,10615710,10615721,10615722,10615822,10615823,10851160,10616005,8540613,8633987,8634103,8634105,8634106,8634109,8611455,8634443,8904857,10610966,10610967,10610975,10610977,10610978,8853216,8853227,10614220,10611444,10611466,10614501,10614503,10614504,10614505,10119836,10609355,10612381,7058247,7058248,7058249,7058250,8566587,8566596,8566611,8566612,8851990,10612916,10612931,10612937,10612938,10612941,10612942,10612943,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017957,7017958,7017959,7017960,7017961,7017962,7017963,7017964,7017965,7017966,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,10610046,8852323,8567072,10610233,8567073,10613369,10613421,10613514,10613524,10610729,10610730,10613732,10610739,10610954,10610958,6673506,6673524,9169356,6673563,7055541,7055546,989982,7055836,9169695,9912057,9169937,9169942,6674152,9912204,6674256,10118247,10118248,6674307,6674312,6674326,9912457,8850095,10118606,10118607,10118608,10118678,9178490,9178492,8850512,8552227,9913278,9913354,9913356,9913359,10427682,9168366,9168367,10416298,9910593,10419370,10415373,10415374,10417385,10419469,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10419481,10419482,10419483,10419484,10418543,10418545,10418546,6672904,10417633,6672960,9168817,6673089,6673125,6673126,10415873,10415874,10415875,10415876,10415877,10415878,10415879,10415880,10415881,10415882,10415883,10415884,10415885,10415886,8848820,6673317,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10418109,10417110,10418110,10417111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10418141,10417141,10417142,10417143,10417144,10417145,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,9169233,10417155,10417156,10417157,10417158,10417159,10417160,10419169,10469245,8550097,9168101,9168102,10470721,10470722,10427666,10427667,10883625,10888637,10888638,10888639,10888640,10888641,10888642,10888655,10888656,10888839,10889052,10884075,10884081,10884082,10884084,10884086,10884088,10884089,10884094,10889776,10879926,10890106,10890110,10890114,10890115,10890116,10890119,10890122,10890127,10890128,10890129,10890130,10890148,10890161,10890173,10885350,10887546,10882916,10883143,10627712,10883358,10883359,10883378,10883392,10883396,10883397,10883398,10885867,10886918,10167934,10168012,10882061,10602705,10647703,10601687,10601693,10545356,10545357,10545358,10545371,10545372,10545373,10508593,10508594,10508595,10508596,10508597,10498867,10411253,10411283,10413714,10413715,10413716,10410783,10410784,10410793,10414814,10415131) 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'