SELECT l.tag, t.tag, l.tagtype, l.item_id, l.longitude, l.latitude, t3.name as title
FROM locationtag as l, tag as t, tag as t2, venue as t3
WHERE (t.tag like 'the%' AND t2.tag like 'wynd%')
AND (l.item_id = t.item_id AND t.item_id = t3.id AND t2.item_id = t3.id AND t2.item_id = l.item_id)
AND t.tagtype = '4'
LIMIT 10;