Error: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
Query: SELECT `f`.`id`, `f`.`info_hash`, `f`.`filename`, `f`.`size`, UNIX_TIMESTAMP(`f`.`data`) `added`, `f`.`seeds`+ifnull(`x`.`seeders`,0) `seeds`, `f`.`leechers`+ifnull(`x`.`leechers`,0) `leechers`, `f`.`category` FROM `files` `f` LEFT JOIN `xbt_files` `x` ON `x`.`info_hash`=`f`.`bin_hash` WHERE `f`.`filename` LIKE '%【高�%' AND `f`.`seeds`+ifnull(`x`.`seeders`,0) > '0' AND `f`.`info_hash` <> '1b02ad877120d2115e2901dcd844526fadb89fc5' OR `f`.`filename` LIKE '%【高�%' AND `f`.`seeds`+ifnull(`x`.`seeders`,0) > '0' AND `f`.`info_hash` <> '1b02ad877120d2115e2901dcd844526fadb89fc5' ORDER BY `f`.`seeds`+ifnull(`x`.`seeders`,0) DESC LIMIT 10
|