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(10930173,10930174,10930175,10447785,10448215,10448216,10448217,10448218,10448219,10448220,10448221,10448222,10448223,10448224,10448225,10448226,10448227,10448228,10448229,10448230,10868142,10868145,10437503,10872209,10872210,10845345,10845346,10845347,10845348,8558982,8558983,8558984,8558985,8558986,8558987,10103684,10103685,10103686,10103687,10103688,10103689,10103690,10103691,10103692,10103693,10103694,10103695,10986448,8618736,8618737,8618738,8618739,8618740,8618741,8618742,8618743,10932701,10932702,10932703,10932704,6665053,6665054,6665057,6665058,6665059,6665060,6665101,6665102,6665105,6665106,6665107,6665108,10942597,10942602,10942603,10942604,10942605,8861210,8861211,8861212,8861213,8861214,8861215,10842347,10842348,10842494,3235369,3235370,3235371,3235372,3235373,3235374,3235375,3235376,3235377,3235378,3235379,3235380,3235381,3235382,3235383,3235384,3235385,3235386,3235387,3235388,3235389,3235390,3235391,3235392,3235393,3235394,3655849,3655850,3655851,3655852,3655853,3655854,3655855,3655856,3655857,3655858,3655859,3655860,3655861,3655862,3655863,3655864,3655865,3655866,3655867,3655868,3655869,3655870,3655871,3655872,3655873,8564862,8073137,8073138,8073139,8073140,8073141,8073142,8073143,8073144,8073145,8073146,8073147,8073148,8073149,8073150,8073151,8073152,8073153,8073154,8073155,8073156,8073157,8073158,8073159,8073160,8073161,8073162,8073163,8073164,8073165,8073166,8073167,8073168,8073169,8073170,8073171,8073172,8073173,8073174,8073175,8073176,8073177,8073178,8073179,8073180,8073181,3926814,3926815,8565157,8565158,8565159,8565160,8565161,8565162,8565163,8565164,11010322,11010323,11010324,11010325,11010326,11010327,11010328,11010329,11010330,11010331,7156495,7156496,7156497,7156498,7156499,7156500,7156501,7156502,8614603,8614604,7155550,7155562,3232835,8576343,8576344,8576345,8576346,9217032,10952141,10952142,10952143,10952144,10952145,10930906,10714401,8568543,8568544,8568545,8568546,8568547,8568548,8568549,8568550,8568551,8568552,8568553,8568554,8568555,8568556,8565856,7058456,9220474,9220475,10564874,10564875,10564876,10564877,10564878,10564879,10564880,10564881,10564882,10660206,10660207,10660208,10660209,10660210,10660211,8592976,3285884,3285885,3285886,3285887,3285888,3285889,3651668,3651669,3651670,3651671,4973955,9198595,9198596,9198597,9198598,9198599,9198600,9198601,9198602,9198603,9198604,9198605,9198606,9198607,9198608,9198609,9198610,9198611,9198612,9198613,9198614,9198615,9198616,9198617,9198618,9198619,9198620,9198621,9198622,9198623,9198624,9198625,9198626,9198627,9198628,9198629,9198630,9198631,9198632,6679250,6679251,6679252,6679253,6679254,6679255,6679256,6679257,8917662,8917663,8917664,8917665,8917666,8917667,8917668,8917669,10628747,10628748,10628749,10628750,10628751,10628752,10628753,8594367,8594368,10175938,10175939,10175940,10175941,10175942,10175943,10175944,10175945,10175946,10175947,10175948,10175949,10175950,10175951,10175952,10175953,10175954,10175955,10175956,10175957,10175958,10175959,10175960,10175961,10175962,10175963,10175964,10175965,10175966,10175967,10175968,10175969,10175970,10175971,10175972,10175973,10175974,10175975,10175976,10175977,10175978,10175979,10175980,10175981,10175982,10175983,10175984,10175985,10175986,10175987,10175988,10175989,10175990,10175991,10175992,10175993,10175994,10175995,10175996,10175997,10175998,10175999,10176000,10176001,10176002,10176003,10176004,10176005,10176006,10176007,10176008,10176009,10176010,10176011,10176012,10176013,10176014,10176015,10176016,10176017,10176018,10176019,10176020,10176021,10176022,10176023,10176024,10176025,10176026,10176027,10176028,10176029,10176030,10176031,10176032,10176033,10176034,10176035,10176036,10176037,10176038,10176039,10176040,10176041,10176042,10176043,10176044,10176045,10176046,10176047,10176048,10176049,10176050,10176051,10176052,10176053,10176054,10176055,10176056,10176057,10176058,10176059,10176060,10176061,10176062,10176063,10176064,10176065,7001231,7001232,10911699,10911700,10911701,10911702,10911703,10911704,10911705,10911706,10911707,10911708,10911709,10911710,10911711,10911712,10911713,10911714,10652586,10652587,10652588,10652589,10652590,10652591,10652592,10652593,10420746,10420749,10483107,10483108,10483109,10483110,10483111,10483124,10490171,10490172,10490173,10490174,10490175,10490176,10490177,10490178,10490179,10490180,10490181,10490182,10490183,10490184,10490185,10490186,10490187,10490188,10490189,10490190,10490191,10490192,10490193,10490194,10490195,10490196,10490197,10490198,10490199,10490200,10490201,10490202,10490203,10490204,10490205,10490206,10490207,10490208,10490209,10490210,10490211,10490212,10490213,10477468,10477507,10473537,10473538,10473539,10473540,10473541,10473542,10473543,10473544,10473545,10473546,10473547,10473548,10473549,10473550,8563105,8563106,8563107,10715123,10715300) 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'