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(7201605,7201739,7201769,7201770,7201771,7201772,7201773,7201774,7201867,10198399,7076167,7201975,10198534,4970683,4970710,4970719,4970729,4970730,7202173,4970735,7202174,7202176,7202178,4970758,7202204,7202224,7202226,7202244,7202268,7202292,7202585,7202611,7202616,7202635,7202664,7202668,7202669,7202670,7202671,7065920,7065943,7065968,3227091,8837173,3227193,3227208,8837416,3227389,8837472,8837481,8573256,8573262,10200018,10200019,10200020,7200635,8067903,8067938,8067939,7200754,7200755,7200757,7200759,7200760,7200765,7200766,7200767,7200768,7200769,7200770,7200771,7200772,7200773,7200776,7200777,7200781,7200782,7200783,7200785,7200829,10102754,7200879,7201002,8835399,7201193,7201194,7201544,7201545,7201546,7201547,7201555,7201556,7201557,7201561,7198677,7198684,7198693,7198694,7198713,7198717,7198724,7198725,7198767,7198768,7198770,7198771,7198772,7198894,7198895,7198896,7072283,7072284,10221588,7199183,7199308,10840934,10195933,7199480,10101483,10101497,10101504,10101552,10101553,10101582,7199770,7199771,7199772,7199773,10196276,7199895,7199897,7200090,7200096,7200098,7200103,7200121,7200132,7200135,7200153,7200154,7200176,7200182,7200459,7200463,7200464,7200465,7200466,7200467,7200468,7200469,7200470,10100186,10194871,8908278,8905944,8905945,8905946,8905947,8905948,8905949,8905950,8906592,8906852,8906853,8906854,8906855,8906856,8906857,8906858,8906859,8906860,8860354,10838798,10838799,10838800,10838810,8860447,10838831,10838842,10838911,10838942,10838943,10838944,10838945,10838946,10838947,10838948,10838949,10838950,10838951,10838952,10229232,10229233,10618277,10618324,10426252,10426376,10426464,10426465,10426466,8611329,8611381,10616972,10617025,10617026,10617027,10617028,10617029,10617030,10617031,10617032,10617033,10617034,10617035,10617036,10617037,10617038,10617039,10617040,10617041,10617042,10617043,10617044,10617045,10617046,10617047,10617048,10617049,10617050,10617051,10617052,10617053,10617054,10617055,10617056,10617057,10617058,10617059,10617060,10617061,10617062,10617063,10617064,10617065,10617066,10617067,10617068,10617069,10617070,10617071,10617072,10617073,10617074,10617075,10617076,10617077,10617078,10617079,10617080,10617081,10617082,10617083,10617084,10617085,10617086,10617087,10617088,10617089,10617090,10617091,10617092,10617093,10617094,10617095,10617096,10617097,10617098,10617099,10617100,10617101,10617102,10617103,10617104,10617105,10617106,10617107,10617108,10617109,10617110,10617111,10617112,10617113,10617114,10617115,10617116,10617117,10617118,10617119,10617120,10617121,10617122,10617123,10617124,10617125,10617126,10617127,10617128,10617129,10617130,10617131,10617132,10617133,10617134,10617135,10617136,10617137,10617138,10617139,10617140,10617141,10617142,10617143,10617144,10617145,10617146,10617147,10617148,10617149,10617150,10617151,10617152,10617153,10617154,10617155,10617156,10617157,10617158,10617159,10617160,10617161,10617162,10617163,10617164,10617165,10617166,10617167,10617168,10617169,10617170,10617171,10617172,10617173,10617174,10617175,10617176,8575736,8575737,10617177,8575738,10617178,8575739,8575740,10622257,10617339,10622445,10617464,10615011,10615084,10615088,10615095,10615096,10615097,10615098,10615099,10615100,10615101,10615102,10615103,10615104,10615105,10615106,10615107,10615108,10615109,10615110,10615111,10615112,10615113,10615114,10615115,10615116,10615117,10615118,10615119,10615120,10615121,10615122,10615123,10615124,10615125,10615126,10615127,10615128,10615129,10615130,10615131,10615132,10615133,10615134,10615135,10615136,10615137,10615138,10615139,10615140,10615141,10615142,10615143,10615144,10615145,10615146,10615147,10615148,10615149,10615150,10615151,10615152,10615153,10615246,10615312,10615336,10615337,10615363,10615822,10615991,10616000,10616058,10616092,10616284,10616457,10616464,10616469,10616476,10616477,10616479,10616491,10616492,10616493,10616494,10616497,10616498,10616499,10616500,10616501,10616503,10616505,10616506,10616507,10616508,10616512,10616517,10616518,10616519,10616520,10616525,10616526,10616527,10616528,10616529,10616530,10616533,10616534,10616641,10616642,10616643,10616644,10616645,10431628,10616698,10431681,10616730,10616739,10431695,10616866,10616901,10616902,10616903,9165556,9165557,9165558,10714142,10714143,10714155,10714170,10714201,10614494,10614590,10614591,10614592,10614637,10614640,9182279,10611969,10612098,10612099,10612100,10612101,10612102,10612288,10612289,10612290,10612291,10612320,10612321,10612381,9211896,8862578,8862579,10557970,10612907,10612910,10612913,10612934,10612953,10612954,10612955,10612956,10612957,10613022,10120828,9172745,10613453,10613562,10613646,10613730,10613731,10613732,10613733,10613734,10613735,10613736,10613758,9173271,9169316,10117515,7055534,10117583,9169414,9169426,9169427,9169483,10515352,10117744,10515386,10515387,10515388,10515389,10515390,10515391,10515392,10515393,10515394,10117786,10117787,10117788,10515405,10117789,10515406,10117790,10515407,10117791,10515424,10515427,9169722,10118018,10118019,10118020,10118021,10118022,10118023,10118024,10118025,10118026,9169838,9169839,9169840,9169841,9169888,9169889,9169890,9169891,9169892,9169893,9169894,9169895,9169896,9169897,9169898,9169899,9169900,9169901,9169902,9169903,9169904,9169905,9169906,9169907,9169908,9169909,9169910,9169911,9169912,9169913,9169914,9169915,9169916,9169917,9169918,10118136,10118137,10118138,10118139,10118140,10118141,9169965,10118314,10118315,10118316,9210122,9210123,10118499,10118603,10118604,10118605,10118620,9178433,10118638,10118639,10118640,10118641,10118642,10118643,10118644,10118645,10118646,10118647,10118648,10118649,10118650,10118651,10118652,10118653,10118654,10118655,10118656,10513040,10513041,9168328,10419262,10416308,10416309,10416310,10416311,10416312,10416313,10416314,10416315,10416316,10416317,10416318,10416319,10416320,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10419364,10419365,10419366,10419367,10419368,10419369,10419370,10419371,10419372,10419373,10419374,10419375,10419376,10419377,10419378,10419379,10419380,10419381,10419382,10419383,10419384,10419385,10419386,10419387,10419388,10419389,10419390,10419391,10419392,10419393,10419394,10419395,10419396,10419397,9168509,10417474,10418487,10418488,10418489,10418490,10418491,10418492,10418493,10418494,10418495,10418496,10418497,10418498,10418499,10418500,10418501,10418502,10418503,10418504,10418505,10418506,9168727,9168736,9168806,9168807,9168808,9168809,9168810,9168811,9168812,9168813,9168814,10417017,10417018,10417019,10417020,10417021,10417022,10417023,10417024,10417025,10417026,10417027,10417028,10417029,10417030,10417031,10417032,10417033,10417034,10417035,10417036,10417037,10417038,10417039,10417040,10417041,10417042,10417043,10417044,10417045,10417046,10417047,10417048,10417049,10417050,10417051,10417052,9169254,9169270,9169271,9169272,7055441,9161289,10471168,10469288,9190717,8549996,8550002,8550003,8550004,8550058,8550065,10469572,3963323,8550213,8550214,10469639,10469640,8550253,8550254,8550255,10469853,10467890,10469903,10469904,10469905,10469906,10469907,10469963,10115642,4972394,4972395,4972396,4972397,10468301,10468302,10468303,10468304,10468305,10468306,10468307,10468308,10468309,10468310,10468311,10468312,10468313,10468314,10468315,10468316,10468317,10468318,10468319,10468320,9167778,10468522,9167948,9167952,9175979,9167987,9168099,4972999,9168217,9168218,9168219,9168220,9168221,9168222,9168223,9168224,9168225,9168226,9168227,9168228,9168229,9168230,9168231,9168232,10883491,10159549,10159550,10883663,10159919,10884073,10884074,10884075,10884076,10884122,10884336,10884437,10884444,10884445,10884446,10884447,10884448,10884449,10884450,10884451,10884452,10884453,10884454,10884455,10884456,10884457,10884458,10884459,10884460,10884461,10155735,10884799,10884800,10884801,10884802,10884803,10879916,10885044,10885045,10885046,10885047,10885048,10885049,10885050,10885051,10885052,10885053,10885054,10885055,10885056,10885057,10885058,10885059,10875089,10885147,10885148,10880250,10885344,10885345,10885364,10885365,10885366,10885367,10631994,10883029,10883030,10883031,10883032,10883033,10883034,10883035,10883036,10883037,10883038,10883039,10883040,10883041,10627776,10883318,10161605,10161771,10161834,10161837,10162015,10162016,10162017,10162018,10162019,10162020,10162155,10162156,10162234,10876828,10876830,10876831,10587412,10588689,10579823,10579841,10579842,10579843,10579844,10579845,10579846,10579847,10579848,10579849,10579850,10579851,10579852,10579853,10579854,10579855,10579856,10579857,10579858,10579859,10579860,10579861,10579862,10579863,10579864,10579865,10579866,10579867,10579868,10579869,10579870,10579871,10579872,10579873,10522840,10533057,10498366,10477687,10487108) 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'