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(10198519,10198520,10198521,4970701,4970702,4970743,7065920,7065960,7066020,7066021,7066022,7066023,7066024,7066025,7066026,7066027,7066028,7066029,7066030,7066031,7066032,7066033,7066034,7066035,7066036,7066037,7066038,7066039,7066040,7066041,7066042,7066043,7066044,7066045,7066046,7066047,7066048,7066049,7066050,7066051,7066052,7066053,7066054,7066055,7066056,7066057,7066058,7066059,7066060,7066061,7066062,7066063,7066064,7066065,7066066,7066067,7066068,7066069,7066070,7066071,7066072,7066073,7066074,7066075,7066076,7066177,7066268,7066269,8573247,8573248,7074666,8834862,8067931,8910652,8908495,8908496,10234492,10234493,10234494,10234495,10234497,10234498,10234499,10234500,10234501,10196145,8565301,8565302,8910236,8910237,8910238,8910239,8910240,8910241,8910242,8910243,8910244,8910245,8910246,8834749,8834753,8907422,8907436,7070863,7070864,7071476,7071477,7071478,7071479,7071480,7071481,7071482,7071483,7071484,7071485,7071486,7071487,7071488,7071489,7071490,7071491,7071492,7071493,7071494,7071495,7071496,7071497,7071498,7071499,7071500,7071504,7071505,7071506,7071507,7071508,7071509,8905536,8905537,8905538,8905539,8905540,8905541,8905542,8905543,8905544,8905545,8905546,8905547,8905548,8905549,8905550,8905551,8905552,8905553,8905554,8905555,8905556,8905557,8905558,8905559,8905560,8905561,8905562,8905563,8905564,8905565,8905566,8905567,8905568,8905569,8905570,8905571,8905572,8905573,8905574,7069059,8905837,8905838,8905839,7069277,7069279,8905966,8906019,8906021,8906022,8906023,8906024,8906025,8906026,8860368,8860369,8860370,8860371,8860372,8860373,8860374,8860375,8860376,8860377,8860378,10618182,10618183,10623256,10623257,10229400,10204764,8905221,10619844,10617099,10617322,10622365,10622462,10622515,10928353,10614973,10614974,10614975,10615102,10615106,10615107,10615108,10615109,10615113,10615114,10615115,10615116,10615129,10615133,10615137,10615211,10615272,10615273,10615274,10615275,10615345,10615346,10615347,10615495,8838359,10615551,10615552,10615553,10615554,10615555,10615556,10615557,10615558,10615559,10615560,10615561,10615562,10615563,10615564,10615565,10615566,10615567,10615568,10615569,10615570,10615571,10615673,10279029,10279030,10616017,10930848,10930849,10616090,10616572,10616576,10616577,10616578,10188749,10188750,10431625,10431659,10431660,10431661,10431679,10431680,10431687,10614068,10559471,10559472,10559473,10559474,10559475,10614339,10614340,10614341,10614342,10614343,10614344,10614345,10614346,10614347,10614348,10614349,10614350,10614351,10614352,10614353,10614354,10614403,10614404,10614405,10614406,10614633,10614753,6666256,10611968,8861863,8861864,10612204,10612205,10612228,10612348,10612349,8862392,8862527,8862528,8862560,8862561,10612755,10612960,10612961,10612962,10612963,10612964,10612965,10612966,10612967,10612968,10612969,10612970,10612971,10612972,10612973,10612974,10612975,10612976,10612977,10612978,10612979,10612980,10612981,10612982,10612983,10612984,10612985,10612986,10612987,10612988,10612989,10612990,10612991,10612992,10612993,10612994,10612995,10612996,10612997,10612998,10612999,10613000,10613001,10613002,10613003,10613004,10613005,10613006,10613007,10613008,10613009,10613010,10613011,10613012,10613013,10613014,10613015,10613016,10613017,10613018,10613019,10613020,10613021,10613022,10613023,10613024,10613025,10613026,10613027,10613028,10613029,10613030,10613031,10613032,10613033,10613034,10613035,10613036,10613037,10613038,10613039,10613040,10613041,10613042,10613043,10613044,10613045,10613046,10613047,10613048,10613049,10613050,10613051,10613052,10613053,10613054,10613055,10613056,10613057,10613058,10613059,10613060,10613061,10613062,10613063,10613064,10613065,10613066,10613067,8862927,10613068,10613069,10613070,10613071,10613072,10613073,10613074,10613075,10613076,10613077,10613078,10613079,10613080,10613081,10613082,10613083,10613084,10613085,10613086,10613087,10613088,10613089,10613090,10613091,10613092,10613093,10613094,10613095,10613096,10613097,10613098,10613099,10613100,10613101,10613102,10613103,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613118,10613119,10613120,10613121,10613122,10613123,10613124,10613125,10613126,10613127,10613128,10613129,10613130,10613131,10613132,10613133,10613134,10613135,10613136,10613137,10613247,10613371,10613372,10613373,10613463,9189158,9189159,9189160,9189245,9189250,7055508,7055526,7055530,7055534,9169460,9169475,9169544,9169545,9169546,9169547,9169548,9169549,9169550,9169551,9169660,9169752,4974691,4974698,4974706,4974714,9169867,9169877,10516133,10516134,10516135,10516136,10516137,10516138,10516139,10516919,10516920,10416231,10416232,10416233,10416234,10416235,10416236,10416237,10416238,10416239,10416240,10416241,10416242,10416243,10416244,10416245,10416246,10416247,10416248,10416249,10416250,10416251,10416252,9168331,10418281,10417286,10417288,10419373,10419374,10417502,10417503,10417504,10417505,10417506,10417507,10417508,10417509,10417510,10417511,10417512,10417513,10417514,10417515,10417516,10417517,10417518,10417519,10417520,10417521,10417522,10417523,10417524,10417525,10417526,10417527,10417528,10417529,10417634,9168729,9168730,9168731,9168732,9168733,9168734,9168735,9168736,9168737,9168738,9168739,9168740,9168741,9168742,9168743,9168744,9168745,9168746,9168747,9168748,9168749,9168750,9168751,9168752,9168753,9168754,9168755,9168756,9168757,9168758,9168759,9168760,9168761,9168762,9168763,9168764,9168765,9168766,9168767,9168768,9168769,9168770,9168771,9168772,9168773,9168774,9168775,9168776,9168777,9168778,9168779,9168780,9168781,9168782,9168783,9168784,9168785,10418708,9168786,10418709,9168787,10418710,9168788,9168789,9168790,10417712,9168791,10417713,9168792,9168793,9168794,9168795,9168796,9168797,9168798,9168799,9168800,9168801,9168802,9168803,9168804,9168805,9168806,9168807,9168808,9168809,9168810,9168811,9168812,9168813,9168814,9168815,9168816,9168817,9168818,9168819,10416797,10419851,9168933,10418914,10418915,10418916,10418917,10418918,10418919,10419005,9169190,9169191,9169192,9169193,9169250,10468876,10468877,10468878,10468879,10468880,10468881,10468882,10468883,10468884,10468885,10468886,10468887,10468888,10468889,10468890,10468891,10468892,10468893,10468894,10468895,10468896,10468897,10468898,10468899,10468900,10468901,10468902,10468903,10468904,10468905,10468906,10468907,10468908,10468909,10468910,10468911,10468912,10468913,10468914,10469526,10469527,10469528,10469529,10469530,10469531,10469532,10469533,10469534,10469535,10469536,10469537,10469538,8916779,8916780,8916781,8916782,8916783,8916784,8916785,8916786,8916787,8916788,8916789,8916790,8916791,8916792,8916801,8916859,10469894,10468038,10468039,10468040,10468041,10468042,10468043,10468044,10468045,10468046,10468047,10468048,10468049,10468050,10468051,10468052,10468053,10468054,10468055,10468056,10468057,10468058,10468059,10468060,10468061,10468062,10468100,10468268,10468269,10468366,9167790,9167887,10468510,10468511,10468512,10468513,10468514,10468515,10468516,10468517,10470591,9168163,10468820,10468821,10468822,10468823,10468824,10468825,10468826,10468827,10468828,10468829,10468830,10468831,10468832,10468833,10468834,10468835,10468836,10468837,10468838,10468839,10468840,10468841,10468842,10468843,10468844,10468845,10468846,10468847,10468848,10468849,10468850,10468851,10468852,10468853,10468854,10468855,10468856,10468857,10468858,10468859,9168283,10468860,10468861,10468862,10468863,10468864,10468865,10468866,10468867,10468868,10468869,10468870,10468871,10468872,10468873,10468874,10468875,10170922,10626978,10153866,10627713,10627714,10627740,10161929,10161940,10162021,10162022,10625500,10162023,10625501,10162024,10625502,10162025,10162026,10162027,10162028,10162029,10630853,10631404,10631405,10631406,10631407,10631408,10631410,10631411,10626441,10631455,10631456,10580339,10580340,10533112,10533113,10533117,10533121,10533122,10533125,10533126,10521840,10521841,10521842,10521843,10534188,10534189,10534190,10534191,10534192,10534193,10534194,10534201,10534203,10530287,10530288,10530289,10530336,10534388,10536577,10536749,10536750,10536751,10536752,10527002,10533105,10533111,10498291,10421508,10421509,10421510,10421511,10421512,10488267,10486267,10486268,10488268,10488269,10486269,10488270,10486270,10488271,10486271,10488272,10486272,10488273,10486273,10488274,10486274,10488275,10486275,10486276,10486277,10486278,10486279,10486280,10486281,10486282,10486283,10486284,10486285,10486286,10486287,10486288,10486289,10486290,10486291,10486292,10486293,10486294,10486295,10486296,10486297,10486298,10486299,10476338,10476339,10476340,10476341,10476342,10476343,10476344,10476345) 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'