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(10930265,7076004,7076005,7076006,10962737,10962738,10962739,10962740,7076141,9215881,9215882,9215883,9215884,9215885,9215886,9215887,9215888,9215889,9215890,9215891,9215892,9215893,9215894,9215895,7066242,7066243,9215896,9215897,7066244,9215898,9215899,9215900,9215901,9215902,9215903,9215904,9215905,9215906,9215907,9215908,9215909,9215910,9215911,9215912,9215913,9215914,9215915,9215916,9215917,9215918,9215919,9215920,9215921,9215922,9215923,9215924,9215925,9215926,9215927,9215928,9215929,9215930,9215931,9215932,9215933,9215934,9215935,9215936,9215937,9215938,9215939,9215940,9215941,9215942,9215943,9215944,9215945,9215946,9215947,9215948,9215949,9215950,9215951,9215952,9215953,9215954,9215955,9215956,9215957,9215958,9215959,9215960,9215961,9215962,9215963,9215964,9215965,9215966,9215967,9215968,9215969,9215970,9215971,9215972,9215973,9215974,9215975,9215976,9215977,9215978,9215979,9215980,9215981,9215982,9215983,9215984,9215985,9215986,9215987,9215988,9215989,9215990,9215991,9215992,9215993,9215994,9215995,9215996,7074344,9215997,9215998,7074345,7074346,9215999,7074347,9216000,7074348,9216001,9216002,9216003,9216004,9216005,9216006,9216007,9216008,9216009,9216010,9216011,9216012,9216013,9216014,9216015,9216016,9216017,9216018,9216019,9216020,9216021,9216022,9216023,9216024,9216025,9216026,9216027,9216028,9216029,9216030,9216031,9216032,9216033,9216034,9216035,9216036,9216037,9216038,9216039,9216040,9216041,9216042,9216043,9216044,9216045,9216046,9216047,9216048,9216049,9216050,9216051,9216052,9216053,9216054,9216055,9216056,9216057,9216058,9216059,9216060,9216061,9216062,9216063,9216064,9216065,9216066,9216067,9216068,9216069,9216070,9216071,9216072,9216073,9216074,9216075,9216076,9216077,9216078,9216079,9216080,8575658,8575659,7066725,7066745,7067395,10929912,9214303,9214304,9214305,10962337,10962338,10962339,10962340,10962341,9214386,9214387,9214391,9214441,9214442,9214443,8627865,8627866,10843107,10843108,7201608,7201609,7201610,7201611,7201612,7201613,7201614,7201615,7201616,7201617,7201618,7201619,7201620,7201621,7201622,7201623,7201624,7201625,7201626,7201627,7201628,7201629,7201630,7201631,7201632,7201633,7201634,7201635,7201636,7201637,7201638,7201639,7201640,7201641,7201642,7201643,7201644,10843256,10843257,7072533,10960333,10843556,7202330,7202331,7202332,7202333,7202334,7202335,7073161,7073177,7073178,7073416,10104593,9794578,9794590,9794591,7065754,7065755,7065756,7065757,7065758,7065783,7065785,7065786,7065788,8629433,8629434,8629435,8629436,8629437,8629438,8629439,7065798,11036523,11036524,11036534,11036535,11036611,11036612,11036615,11036616,11036617,8910047,8910048,8910049,8910050,8910051,8910052,8910053,8910054,8910055,8910056,8910057,8910058,8910059,8910060,8910061,8910062,8910063,8910064,8910065,8910066,8910067,8910068,8910069,8910070,8910071,8910072,8910073,8910074,8910075,8910076,8910077,8910078,8910079,8910080,8910081,7071089,7071096,7200581,7071525,10842372,10102866,10102873,7198138,10995758,10995759,10995760,10995761,10995764,10995765,10995766,10995767,10995769,10995770,10995771,10995772,10995773,10995774,10995780,10995781,10995782,10995783,10995784,10995785,10995786,10995787,10995788,10995792,10995793,10995794,10995796,10995797,10995823,10995830,10995831,10995847,10995848,10995856,10995857,10995858,10995859,10995863,10995864,10995887,10995888,10995889,10995890,10995891,10995892,10996180,10996181,10996182,10996183,10996255,10996256,10996257,10996258,10996259,8615477,8615478,8615479,8615480,10942054,10841192,11010169,11010170,3233587,3233588,11045895,11045896,11045897,3924165,7197417,7197418,10995157,10995285,10995286,7197916,8634647,8634648,8634649,8634650,8634651,8541668,8541669,8541670,8541671,10992845,10992860,10992861,8541711,10617464,10993347,10993348,10928330,10615019,8540441,3231436,8611400,10616897,10614201,10614417,10609268,10609772,9188254,9220277,9220286,9220287,9220288,9188674,9915098,9915100,9205134,10118013,9912801,9913307,9913495,10428530,9917161,9917162,9917163,10123158,6667362,9191532,10116145,10627142,10183901,10172394,10172395,10172396,10172397,10172398,10172399,10172400,10172401,10172402,10172403,10172404,10172405,10626563,10602360,10606921,10603989,10651560,10651561,10536718,10536719,10508270,10486208,10486209,10486210,10486211,10486212,10486213,10486214,10486215,10486216,10486217,10486218,10486219,10486220,10486221,10486222,10486223,10486224,10486225,10486226,10486227,10486228,10486229,10486230,10486231,10486232,10486233,10486234,10486235,10486236,10486237,10486238,8562598,10486720,10486721) 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'