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(8838345,8068881,7076014,7076124,7076125,7076126,8838681,8838682,8838683,8838684,8838685,8838686,8838687,8838688,8838689,8838690,8838691,8838692,8838693,8838694,8838695,8838696,8838697,8838698,8838699,8838700,8838701,8838702,8838703,8838704,8838705,8838706,8838707,8838708,8838709,8838710,8838711,8838712,8838713,8838714,8838715,8838716,8838717,8838718,8838719,8838720,8838721,8838722,8838723,8838724,8838725,8838726,8838727,8838728,8838729,8838730,8838731,8838732,8838733,8838734,8838735,8838736,8838737,8838738,8838739,8838740,8838741,8838742,8838743,8838744,8838745,8838746,8838747,8838748,8838749,8838750,8838751,8838752,8838753,8838754,8838755,8838756,8838757,8838758,8838759,8838760,8838761,8838762,8838763,8838764,8838765,8838766,8838767,8838768,8838769,8838770,8838771,8838772,8838773,8838774,8838775,8838776,8838777,7076289,8838778,8838779,8838780,8838781,8838782,8838783,8838784,8838785,8838786,8838787,8838788,8838789,8838790,8838791,8838792,8838793,8838794,8621143,8621146,8574503,7076329,7076333,7076342,7076344,7076346,7076347,7076355,8569695,8621702,8621703,8621704,8621705,8621706,8621707,8621708,8621709,8621710,8621711,8621712,8621713,8621714,8621715,8621716,8621717,8621718,8621719,8621720,8621721,8621722,8621723,8621724,8621725,8621726,8621727,8621728,8621729,8621730,8621731,8621732,8621733,8621734,8621735,8621736,8621737,8621738,8621739,8621740,8621741,8621742,8621743,8621744,8621745,8621746,8621747,8621748,8621749,8621750,8621751,8621752,8621753,8621754,8621755,8621756,8621757,8621758,8621759,8621760,8621761,8621762,8621763,8621764,8621765,8621766,8621767,8621768,8621769,8621770,8621771,8621772,8621773,8621774,8621775,8621776,8621777,8621778,8621779,8621780,8621781,8621782,8621783,8621784,8621785,8621786,8621787,8621788,8621789,8621790,8621791,8621792,8621793,8621794,8621795,8621796,8621797,8621798,8621799,8621800,8621801,8621802,8621803,8621804,8621805,8621806,8621807,8621808,8621809,8621810,8621811,8621812,8621813,8621814,8621815,8621816,8621817,8621818,8621819,8621820,8621821,8621822,8621823,8621824,8621825,8621826,8621827,8621828,8621829,10951052,10951053,10951054,10951055,10847241,10847242,10847243,10847244,10847245,11042278,11042279,11042280,11042281,11042282,11042283,11042284,11042285,11042286,11042287,11042288,11042289,11042290,11042291,11042292,11042293,11042294,11042295,11042296,11042297,11042298,11042299,11042300,11042301,11042302,11042303,11042304,11042305,11042306,11042307,11042308,8622459,11042309,8622460,11042310,8622461,11042311,8622462,11042312,8622463,11042313,8622464,8622465,11042314,8622466,11042315,11042316,8622467,11042317,11042318,11042319,11042320,11042321,11042322,11042323,11042324,11042325,11042326,11042327,11042328,11042329,11042330,11042331,11042332,11042333,11042334,11042335,11042336,11042337,11042338,11042339,11042340,11042341,11042342,11042343,11042344,11042345,11042346,11042347,11042348,11042349,11042350,11042351,11042352,11042353,11042354,11042355,11042356,11042357,11042358,11042359,11042360,11042361,11042362,11042363,11042364,11042365,11042366,8067754,10951359,7074734,7074735,7066748,8067829,8067830,7066782,8573098,8573102,7066926,7066927,8573106,7066939,8573126,8573134,8573136,8573139,8573148,8573149,8573150,8573153,8573160,8573161,8573162,8573163,8573165,8573166,8573171,8573179,8573181,8573182,8573184,8573185,8573186,8573419,8573420,8573421,10962019,8573618,7067453,7067552,7067553,7067554,7067555,10447604,10962432,10962433,10962441,8835512,8835531,8835532,8835533,8835534,8835535,8835541,8835583,8835590,8835599,8835638,8835639,8835642,10843156,8075333,8075334,8075335,8075336,8911582,8572118,8572122,8572129,10104660,10104810,10104812,10104817,10104818,10104831,10104832,10104833,7070848,10943079,10102508,8834873,8910476,10943183,8861420,10998411,10839637,10100238,10945086,10840519,3656717,3656718,3656719,3656720,3656721,3656722,3656723,3656724,3656725,3656726,3656727,10840925,3657273,8860499,8860500,10101728,7070813,7070814,8579068,8579069,8579070,8579071,10623057,10928678,10928679,11045717,11045718,11045719,11045720,11045721,11045722,11045723,10618389,10618390,10618391,10618392,10967968,11045969,10967969,10967970,11045970,10967971,11045971,11045972,10967972,10967973,10967974,10968060,11007188,11007189,11007190,11007191,8907077,8907078,8907079,8907080,8907488,8907489,11047320,11047321,10427430,10427431,8612037,8612038,11045035,10837253,8612640,8622742,10965393,10965394,10965395,10965396,10965397,10926783,10926784,10926785,10562112,10562113,10562114,9189586,7059792,7059846,7059851,7059853,7059855,7059861,7059864,9213737,10714222,10559707,9214023,9214024,10611896,10611897,7057482,10119575,7057717,7057718,7057719,9211883,9211904,9172173,8862708,8862709,9212316,8862910,8862911,9172560,10558585,10562108,10562109,10562110,10562111,7055832,7055834,9209946,9170174,10514029,10514030,10516185,10516186,10516187,10516188,9163046,10512904,9179124,9187264,10419267,10419270,8918274,8918275,8918326,9184780,9208889,9208890,9208891,9208892,9208893,9208894,9208895,9208896,9208897,9208898,9208899,9208900,9208901,9208902,9208903,9208904,9208905,9208906,9208907,9208908,9208909,9208910,9208911,9208912,9208913,9208914,9208915,9208916,9208917,9208918,9208919,9208920,9208921,9208922,9208923,9208924,9208925,9208926,9208927,9208928,9208929,9208930,9208931,9208932,9208933,9208934,9208935,9208936,9208937,9208938,9208939,9208940,9208941,9208942,9208943,9208944,9208945,9208946,9208947,9208948,9208949,9208950,9208951,9208952,9208953,9208954,9208955,9208956,9208957,9208958,9208959,9208960,9208961,9208962,9208963,9208964,9208965,9208966,9208967,9208968,9208969,9208970,9208971,9208972,9208973,9208974,9208975,9208976,9208977,9208978,9208979,9208980,9208981,9208982,9208983,9208984,9208985,9208986,9208987,9208988,9208989,9208990,9208991,9208992,9208993,9208994,9208995,9208996,9208997,9208998,9208999,9209000,9209001,9209002,9209003,9209004,9209005,9209006,9209007,9209008,9209009,9209010,9209011,9209012,9209013,9209014,9209015,9209016,9209017,6666527,6666528,9182542,6666549,6666550,6666551,6666552,6666553,6666554,6666555,9166623,9166624,6666805,6666827,6666828,6666924,9175070,9175071,9175072,9175073,9199074,9175074,9175075,9175076,9175077,9175078,8550547,8550549,8563378,6668241,8593519,8594395,10874952,10171141,10631994,10632248,10632249,10945605,10945606,10945607,10945608,10945609,10945611,10945612,10945624,10945625,10945626,10945627,7001399,7001400,7001401,10161612,10881151,10162244,10949057,10626145,10187694,10187695,10187696,10187697,10187698,10187699,10187700,10187701,10187702,10187703,10187704,10187705,10187706,10187707,10187708,10187709,10187710,10187711,10187712,10187713,10187714,10187715,10187716,10187717,10187718,10187719,10187720,10187721,10187722,10187723,10187724,10187725,10187726,10187727,10187728,10187729,10187730,10187731,10187732,10187733,10187734,10187735,10187736,10187737,10187738,10187739,10187740,10187741,10187742,10187743,10187744,10187745,10187746,10187747,10187748,10187749,10187750,10187751,10187752,10187753,10187754,10187755,10187756,10187757,10187758,10187759,10187760,10187761,10187762,10187763,10187764,10187765,10187766,10187767,10187768,10187769,10187770,10187771,10187772,10187773,10187774,10187775,10187776,10187777,10187778,10626257,10187779,10187780,10187781,10187782,10187783,10187784,10187785,10187786,10187787,10187788,10187789,10187790,10172791,10187791,10187792,10187793,10187794,10187795,10187796,10187797,10187798,10187799,10187800,10187801,10187802,10172826,10631367,10187997,10188045,10188046,10188047,10188048,10188049,10188263,10188264,10188265,10188266,10590504,10590505,10585994,10585995,10585996,10585997,10585998,10585999,10586000,10586001,10586002,10586003,10586004,10586005,10586006,10586007,10586008,10586009,10586010,10586011,10586012,10586013,10586014,10586015,10586016,10586017,10586018,10586019,10586020,10586021,10586022,10586023,10586024,10586025,10586026,10586027,10586028,10586029,10586030,10586031,10586032,10586033,10586034,10586035,10586036,10586037,10586038,10586039,10586040,10586041,10586042,10586043,10586044,10586045,10586046,10586047,10586048,10586049,10586050,10586051,10586052,10586053,10586054,10586055,10586056,10586057,10586058,10586059,10586060,10525331,10525332,10525333,10525334,10521347,10521348,10521349,10521350,10534186,10534187,10534188,10538357,10538358,10538528,10420313,10420314,10420315,10420316,10420317,10420318,10420319,10420320,10420321,10420322,10420323,10420324,10420325,10420326,10422383,10424875,10424066,10477108) 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'