SELECT id, url, title, description, phone, category,town,level,lat,lon FROM dir_pages WHERE accepted = 'y' AND (title LIKE '%Land's End%' OR keywords LIKE '%Land's End%' OR description LIKE '%Land's End%' OR url LIKE '%Land's End%') UNION SELECT id, url, name AS title, short_desc AS description, telephone AS phone, type AS category,town, level,lat,lon FROM `accommodation` WHERE `town` LIKE '%Land's End%' OR `village` LIKE '%Land's End%' ORDER BY level DESC ,title ASC LIMIT 0,12