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` <> '7135f9ad5b7909f6710c0388a9bce848e86f7633' OR `f`.`filename` LIKE '%【首%' AND `f`.`seeds`+ifnull(`x`.`seeders`,0) > '0' AND `f`.`info_hash` <> '7135f9ad5b7909f6710c0388a9bce848e86f7633' ORDER BY `f`.`seeds`+ifnull(`x`.`seeders`,0) DESC LIMIT 10
|