Today is Monday

select title.id,title.`name` from title where title.id not in (select user_tag.tagid from user_tag ) 可以改为 select title.id,title.`name` from title left join user_tag on user_tag.tagid = title.id ...