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(10962702,10962706,7068023,7068024,7068025,7068026,7068027,7068028,7068029,10962713,7068030,7068031,7068032,7068033,7068034,7068035,7068036,7068037,7068038,7068039,7068040,10943469,10943470,10943471,10943472,10943473,10943474,10943475,10943476,10943477,10943478,10943479,10943480,10943481,10943482,10943483,10943484,10943485,10943486,10943487,10943488,10943489,10943490,10943491,10943492,10943493,10943494,10943495,10943496,10943497,10943498,10943499,10943500,10943501,10943502,10943503,10943504,10943505,10943506,10943507,10943508,10943509,10943510,10943511,10943512,10943513,8569395,10940050,10940051,10940052,10940053,10940054,10940055,10940056,8838956,8839003,8583120,8583121,8583122,8583123,8583124,8583125,8583126,8583127,8583128,8583129,8583130,8067275,8067276,8067277,8067278,8622216,8609624,8609625,8609626,8609627,8609628,10938545,10938546,10938547,10938548,10938549,10938550,10938551,10938552,10938553,10938554,10938555,10938556,10938557,10938558,10938559,10938560,10938561,10938562,10938563,10938564,10938565,10938566,10938567,10938568,10938569,8067838,10938570,10938571,8067839,8067840,10938572,8067841,10938573,10938574,8067842,10938575,8067843,10938576,10938577,10938578,10938579,10938580,10938581,8573252,7072090,7072091,7064151,7064152,7064153,7064154,7064155,7064156,7064157,7064158,7064159,7064160,7064161,7064162,7064163,7064164,7064165,7064166,7064167,7064168,7064169,7064170,7064171,7064172,7064173,7064174,7064175,7064176,7064177,7064178,7064179,7064180,7064181,7064182,7064183,7064184,7064185,7064186,7064187,7064188,7064189,7064190,7064191,7064192,7064193,7064194,7064195,7064196,7064197,7064198,10973259,10973260,10973261,10973262,10973369,10932102,10932103,8572114,8572115,4967331,4967332,4967333,4967334,4967335,4967336,4967337,4967338,4967339,4967340,4967341,4967342,4967343,4967344,4967345,4967346,4967347,4967348,4967349,4967350,4967351,4967352,4967353,4967354,4967355,4967356,4967357,4967358,4967359,4967360,4967361,4967362,4967363,4967364,4967365,4967366,4967367,4967368,4967369,4967370,4967371,4967372,4967373,4967374,4967375,4967376,4967377,4967378,4967379,4967380,4967381,4967382,4967383,4967384,4967385,4967386,4967387,4967388,4967389,4967390,4967391,4967392,4967393,8066155,4967394,4967395,8066156,4967396,4967397,4967398,4967399,4967400,4967401,4967402,4967403,4967404,4967405,4967406,4967407,4967408,4967409,4967410,4967411,4967412,4967413,4967414,4967415,4967416,4967417,4967418,4967419,4967420,4967421,4967422,4967423,10102262,10102263,10102264,8064151,8064152,8064153,8064154,8064155,8064156,8064157,8064158,8064159,8064160,8064161,8064162,8064163,8064164,8064165,8064166,8064167,8064168,8064169,8064170,8064171,8064172,8064173,8064174,8064175,8064176,8064177,8064178,8064179,8064180,8064181,8064182,8064183,8064184,8064185,8064186,8064187,8064188,8064189,8064190,8064191,8064192,8064193,8064194,8064195,8064196,8064197,8064198,8064199,8064200,8064201,8064202,8064203,8064204,8064205,8064206,8064207,8064208,8064209,8064210,8064211,8064212,8064213,8064214,8064215,8064216,8064217,8064218,8064219,8064220,8064221,8064222,8064223,8064475,8835315,8835316,10998534,10998535,10998536,10998537,8835393,8563700,8563701,8563702,8563703,8563704,8563705,8563706,8563707,8563708,8563709,8563710,8563711,8563712,8563713,8563714,8563715,8563716,8563717,8563718,8563719,8563720,8563721,8563722,8563723,8563724,8563725,8563726,8563727,8563728,8563729,8563730,8563731,8563732,8563733,8563734,8563735,8563736,8563737,8563738,8563739,8563740,8563741,8563742,8563743,8563744,8563745,10100166,8563746,8563747,10100167,8563748,10100168,8563749,10100169,10100170,8563750,8563751,10100171,10100172,10100173,10100174,11047600,8564746,8564747,8564748,8564749,8564750,10101738,8834155,8834156,8834157,8834158,8834159,8834160,8834161,11049554,11049555,11049556,11049557,11049558,11049559,11049560,11049561,11049562,11049563,11049564,11049565,10101884,10101885,8613156,10927927,10927928,10926096,11043280,11043281,11043282,11043283,10991325,10926243,10953005,10953006,10953007,10953008,10953009,10953010,10953011,10953012,10953013,10953014,10953015,10953016,10953017,10953018,10953019,10953020,10953021,10953022,10953023,10953024,10953025,10953026,10953027,10953028,10953029,10953030,10953031,10953032,10953033,10953034,10953035,10953036,10953037,10953038,10953039,10953040,10953041,10953042,10953043,10953044,10953045,10953046,10953047,10953048,10953049,10953050,10953051,10953052,10953053,10953054,10953055,10953056,10953057,10953058,11044603,11044604,11044605,6665747,3962392,3962393,3962394,3962395,3962396,3962397,3962398,3962399,3962400,3962401,3962402,3962403,3962404,3962405,3962406,3962407,3962408,3962409,3962410,10612047,9211390,8863199,8863200,9193564,2809082,2809083,2809084,2809085,2809086,2809087,2809088,2809089,2809090,2809091,2809092,2809093,2809094,2809095,2809096,2809097,2809098,2809099,2809100,2809101,8861567,8861608,8861609,8861610,8861611,8861612,8861613,8861614,8861615,8861616,8861617,8861618,8861619,8861620,8861621,8861622,8861623,8861624,8861625,8861626,8861627,8861628,8861629,10416555,10419579,10419580,9160668,9160669,9160670,9160671,9160672,9160673,9160674,9160675,9160676,9160677,9160678,9160679,9160680,9160681,9160682,9160683,9160684,9160685,9160686,9160687,9160688,9160689,9160690,9160691,9160692,9160693,9160694,9160695,9160696,9160697,9160698,9160699,9160700,9160701,9160702,9160703,9160704,9160705,9160706,9160707,9160708,9160709,9160710,9160711,9160712,9160713,9160714,9160715,9160716,9160717,9160718,9160719,9160720,9160721,9160722,9160723,9160724,9160725,9160726,9160727,9160728,9160729,9160730,9160731,9160732,9160733,9160734,9160735,9160736,9160737,9160738,9160739,9160740,9160741,9177045,9177046,9177047,10419100,10462876,10462877,10462878,10462879,10462880,10462881,10462882,10462883,10462884,10462885,10462886,10462887,10462888,10462889,10462890,10462891,8549479,8549480,8549481,8549482,8549483,8549484,8549485,8549486,8865187,8916389,8916390,8916391,4971701,4971702,4971703,9175242,9191295,9191296,8917154,9175857,9175864,10462677,10462832,10462833,10462834,10462835,10462836,10462837,10462838,10462839,10462840,10462841,10462842,10462843,10462844,10462845,10462846,10462847,10462848,10462849,10462850,10462851,10462852,10462853,10462854,10462855,10462856,10462857,10462858,10462859,10462860,10462861,10462862,10462863,10462864,10462865,10462866,10462867,10462868,10462869,10462870,10462871,10462872,10462873,10462874,10462875,10159560,8069150,10626969,7000669,10626970,7000670,7000671,7000672,7000673,7000674,7000675,7000676,7000677,7000678,10945461,10945462,10945463,10945464,10945465,10945466,10945467,10945468,10945469,10945470,10945471,10945472,10945473,10945474,10945475,10945476,10945477,10945478,10945479,10945480,10945481,10945482,10945483,10945484,10945485,10945486,10945487,10945488,10945489,10945490,10945491,10945492,10945493,10945494,10945495,10945496,10945497,10945498,10945499,10945500,10945501,10945502,10945503,10945504,10945505,10945506,10945507,10945508,10945509,10945510,10945511,10945512,10945513,10945514,10945515,10945516,10945517,10945518,10945519,10945520,10945521,10945522,10945523,10945524,10945525,10945526,10945527,10945528,10945529,10945530,10945531,10945532,10945533,10945534,10945535,10945536,10945537,10154162,10154163,10154164,10154165,10154166,10154167,10154168,10154169,10154170,10154171,10154172,10154173,10154174,10154175,10154176,10154177,10154178,10154179,10154180,10154181,10154182,10154183,10154184,10154185,10154186,10154187,10154188,10154189,10154190,10154191,10154192,10154193,10154194,10154195,10154196,10154197,10154198,10154199,10154200,10154201,10154202,10154203,10154204,10154205,10154206,10154207,10154208,10154209,10154210,10154211,10154212,10154213,10154214,10154215,10154216,10154217,10154218,10154219,10154220,10154221,10154222,10154223,10154224,10154225,10154226,10154227,10154228,10154229,10154230,10154231,10154232,10154233,10154234,10154235,10154236,10154237,10154238,10154239,10154240,10154241,10154242,10154243,10154244,10154245,10154246,10154247,10154248,10154249,10154250,10154251,10154252,10154253,10154254,10154255,10154256,10154257,10875536,10875537,10875538,10875539,10875540,10875541,10875542,10875543,10875544,10875545,10875546,10875547,10875548,10187596,10631264,10949926,10949927,10949928,10173399,10173400,10173401,10173402,10173403,10173404,10173405,10173406,10173407,10173408,10945208,10173409,10173410,10173411,10173412,10587267,10587474,10587475,10587476,10588404,10588405,10420951,10478422,10478423,10478424,10478425,10478426,10476587,10476588) 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'