SELECT DISTINCT country as name FROM link WHERE country LIKE '%ireland%' AND searching LIKE '%sport%' ORDER BY name ddss
SELECT `id` AS code, `u_r_l_title` as utitle, u_r_l AS address, `description_80` AS description FROM link WHERE `country` LIKE '%ireland%' AND `searching` LIKE '%sport%' AND `plants` LIKE '%driving%' ORDER BY `rating` ASC, `utitle` ASC In - Eire.com, The un-official guide to Ireland