SELECT distinct uid,count(id) as jobs_num FROM `qs_jobs_search` WHERE MATCH (`key`) AGAINST ("+(city28_337_3014_0_0_0 city28_337_3014_0_0 city28_337_3014_0 city28_337_3014 city28_337 city28)" IN BOOLEAN MODE) GROUP BY uid ORDER BY refreshtime desc,id desc LIMIT 0,15