Stuff

SELECT l.tag, t.tag, l.tagtype, l.item_id, l.longitude, l.latitude, t3.name as titleFROM locationtag as l, tag as t, tag as t2, venue as t3WHERE (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;