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