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(8583086,8583087,8583093,8583094,8583095,8583098,3229086,3229088,3229089,3229090,3229095,3229099,3229173,8575139,8575140,8575141,8575142,8575143,8575144,8575145,8575161,8575162,8575163,8575164,7066050,10950699,8583660,8583661,8583662,8583663,8583664,8583667,8583668,8583669,8583670,8583671,8583672,8583673,8583674,8583675,8583676,8583677,8583678,8583679,8583680,8583682,8583683,3230163,8573302,8573303,8573304,8573305,8573306,8573307,8573308,8595110,8595111,7201741,7201742,5654659,3227113,7200301,7200302,7200303,7200304,7200305,7200306,7200307,7200308,7200309,7200310,10944450,8613083,8613084,8613085,8613086,8613087,8613088,8613089,8613090,8613091,8907611,8907614,8907615,8907617,8907620,8907621,8907625,8907626,8907627,8907629,8907630,8907632,8907636,8907638,8907639,8907642,8907643,8907646,8907647,8907648,8907651,8907652,8907653,8907655,8907656,8907657,8907659,8907660,8907661,8907663,8907664,8907666,8907667,8907671,8907672,8907676,8907677,8907678,8907679,8907680,8907681,8907683,8907684,8907687,8907688,8907689,8907690,8907692,8907693,8907696,8907697,8907700,8907701,8907702,8907705,8907706,8907707,8907709,8907710,8541482,10617063,10617509,10615015,10620299,10620305,10615380,10615501,10615870,10615911,10615928,8904219,8904220,8904223,8904225,8904227,8904228,8904229,8904230,8904231,8904233,8904235,8904237,8904238,8904239,8904240,8904241,8904243,8904244,8904245,8904246,8904247,8904248,8904249,8904250,8904251,8904252,8904253,8904255,8904256,8904257,8904258,8904259,8904261,8904262,8904263,8904264,8904279,8904281,8904283,8904287,8904291,8904293,8904294,8904295,8904296,8904298,8904301,8904303,8904304,8904305,8904306,8904307,8904308,8904347,8904349,8904350,8904352,8904353,8904355,8904356,8904357,8904359,8904361,8904362,8904363,8904365,8904366,8904367,8904368,8904369,8904371,8904372,8904373,8904374,8904376,8904377,8904378,8904381,8904383,8904384,8904385,8904386,8904387,8904388,8904389,8904391,8904392,8904393,8904394,8904395,8904396,8904397,8904398,8904399,8904400,8904401,8904402,8904404,10921968,10616475,10616559,10616563,10616567,10616740,7155286,8853124,8853125,8853126,8853127,8853128,8853129,8853130,8853131,8853132,8853133,8853134,8853135,8853136,8853137,8853138,8853139,8853140,8853141,8853142,8853143,8853144,8853145,8853146,8853147,8853148,8853149,8853150,8853151,8853152,8853153,8853154,8853155,8853156,8853157,8853158,8853159,8853160,8853161,8853162,8853163,8853164,8853165,8853166,8853167,8853168,10614316,10614317,10614323,10614327,10614328,10614329,10614330,10611352,10614371,10614414,3962363,3962365,10614822,10611823,10611825,10611857,10611859,10611860,10611863,8851257,8851259,8851296,8851441,8851442,8851443,8851444,8851445,8851446,8851449,8851451,8862528,8851932,10610018,10613055,10613084,10610173,10610175,10610176,10610177,10610190,10610197,8567068,8567070,10610237,8567079,8567080,10610261,10610262,10613264,10610269,10610272,10610273,10610283,10610293,10610295,10610298,10610334,10610341,10610342,10610374,10610429,10610437,10610440,10610441,10613455,10610461,10610463,10610468,10610469,10610471,10610474,10613520,10613521,10610723,10610725,10610728,10610740,10610742,10610747,10610748,10610750,10610751,8853101,8853102,8853103,8853104,8853105,8853106,8853107,8853108,8853109,8853110,8853111,8853112,8853113,8853114,8853115,8853116,8853117,8853118,8853119,8853120,8853121,8853122,8853123,9169305,9169306,9169307,9169308,9169309,9169310,9169311,9169312,6674172,10118446,10118447,8850836,8850837,8850839,8850840,8850842,8850844,8850845,8850848,8850849,8850907,8850908,8850935,8850936,8851098,8851100,8851101,8851104,8851106,8851108,8851109,8851113,8851114,8848125,8848126,8848129,8848131,8848132,8848133,8848134,8848135,8848136,8848138,8848139,8848140,8848143,9160318,8848144,8848146,8848148,8848149,8848152,8848154,8848155,8848156,8848160,8848161,8848162,8848163,8848164,8848165,8848168,8848169,8848171,8848172,8848173,8848174,8848175,8848177,9168355,8848180,8848182,8848183,8848184,8848185,8848186,8848189,8848191,8848192,8848194,8848196,8848197,8848199,8848201,8848202,9168377,8848204,8848206,6672779,6672815,6672816,6672818,6672819,6672820,6672821,6672822,6672824,6672825,6672826,6672827,6672828,6672834,6672836,6672837,6672838,6672839,10418556,6672840,6672841,6672842,6672843,6672844,6672845,6672846,6672850,6672851,6672852,6672853,6672854,6672855,6672857,6672858,6672860,6672861,10418579,10418580,6672878,6672879,6672880,6672894,10415634,10415635,6672921,6672935,6672936,10417807,10417808,8848723,8848724,8848778,8848779,8848780,8848786,8848787,8848788,8848789,8848793,8848794,6673175,8848795,6673181,8848802,8848803,8848806,6673187,8848807,8848808,8848809,8848812,8848813,8848814,8848816,8848817,8848818,8848819,6673207,8848827,6673209,8848835,6673216,8848836,6673217,8848837,8848838,8848839,8848840,8848841,8848842,6673226,8848846,8848847,6673229,8848852,6673233,8848853,8848854,8848855,8848857,8848858,8848859,8848860,8848861,6673242,8848862,8848863,8848864,6673245,8848865,6673247,8848868,8848869,8848870,8848871,8848872,8848873,8848874,8848882,8848883,8848884,8848888,8848891,8848892,8848893,8848894,8848895,8848896,8848897,8848898,8848899,8848900,8848901,8848902,8848905,8848907,8848908,8848910,8848912,8848913,8848917,8848918,8848921,8549512,6670730,10469635,8847280,8847281,8847282,8847284,8847285,8847286,8847287,8847289,8847290,8847291,8847292,8847293,8847295,8847296,8847297,8847298,8847300,8847301,8847302,8847303,8847304,8847305,8847306,8847307,8847308,8847311,8847312,8847313,8847314,8847315,8847316,8847317,8847318,8847320,8847321,8847322,8847323,8847324,8847325,8847326,8847327,8847329,8847330,8847331,8847332,8847333,8847334,8847503,8847506,8847507,8847508,8847509,8847510,8847513,8847515,8847516,8847518,8847519,8847520,8847521,8847522,8847524,8847525,8847526,8847527,8847528,8847530,8847531,8847532,8847539,8847545,8847546,8847547,8847548,8847549,8847551,8847553,8847554,8847555,8847556,8847557,8847559,8847560,8847561,8847562,8847563,8847564,8847565,8847566,8847567,8847569,8847570,8847571,8847572,8847574,8847575,8847576,8847577,8847580,8847581,8847582,8847585,8847587,8847588,8847589,8847590,8847592,8847594,8847595,8847597,8847598,8847599,8847600,8847601,8847602,8847603,8847605,8847607,8847608,8847609,8847611,8847612,8847614,8847616,8847617,8847618,8848000,8848045,8848049,8848055,8848056,8848057,8848058,8848063,8848072,8848073,8848074,8848076,8848077,8848078,8848079,8848082,8848083,8848084,8848085,8848086,8848089,8848090,8848091,8848092,8848099,8848107,8848108,8848109,8848110,8848111,8848112,8848113,8848114,8848115,8848118,8848119,8848121,8848122,8848123,10883566,10883567,10883577,10883578,10883579,10883580,10883581,10883582,10883583,10883584,10883616,10883617,10883618,10883619,10883620,10883621,10883710,10883789,10165016,10894370,10884804,10887536,10887537,10887538,10887539,10887540,10887541,10887542,10885512,10625075,10625076,10625077,10885651,10625214,10625239,10625240,10625372,10625487,10162116,10162117,10162118,10887206,10887207,10887208,10887209,10887210,10887211,10887212,10887213,10887214,10887215,10887216,10887217,10887218,10887219,10887220,10887221,10887222,10602116,10602117,10602118,10643471,10647504,10647632,10409435,10409448,10409450,10477206,10477207,10496912,10496913,10496914,10496915,10496916,10496917,10496918,10496919,10496920,10496921,10496922,10496923,10496924,10496925,10496926,10496927,10496928,10496929,10496930,10496931,10496932,10496933,10477944,10477945,10477946,10477947,10477948,10477949,10477950,10477951,10477952,10477953,10477954,10496955,10477955,10496956,10477956,10496957,10477957,10496958,10477958,10496959,10477959,10496960,10477960,10496961,10477961,10496962,10477962,10496963,10477963,10496964,10477964,10496965,10477965,10496966,10477966,10496967,10477967,10496968,10477968,10496969,10477969,10496970,10477970,10496971,10477971,10496972,10477972,10496973,10477973,10496974,10477974,10496975,10477975,10496976,10477976,10496977,10477977,10496978,10477978,10496979,10477979,10477980,10477981,10477982,10477983,10477984,10477985,10477986,10477987,10477988,10477989,10477990,10477991,10477992,10477993,10477994,10477995,10477996,10477997,10477998,10477999,10478000,10478001,10478002,10497013,10497014,10497015,10497016,10497017,10497018,10497019,10497020,10497021,10497022,10497023,10497024,10497025,10497026,10497027,10497028,10497029,10497030,10497031,10410920) 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'