Rudolph

This one returns no results:

SELECT * FROM we_cr_people p WHERE 'wug' IN (SELECT name FROM we_cr_tags WHERE tableid = '17' AND itemid = p.id) LIMIT 100

This one has three results:

SELECT * FROM we_cr_people p WHERE EXISTS (SELECT * FROM we_cr_tags WHERE tableid = '17' AND itemid = p.id AND name = 'wug') LIMIT 100