SELECT distinct uid,count(id) as jobs_num FROM `zq_jobs_search` WHERE MATCH (`key`) AGAINST ("+audit1" IN BOOLEAN MODE) GROUP BY uid ORDER BY refreshtime desc,id desc LIMIT 0,15