SELECT DISTINCT town as name FROM link WHERE country LIKE '%ireland%' AND country LIKE 'republic-of-ireland' AND state LIKE 'county-clare' ORDER BY name ddtheme_irish-photos/country_republic-of-ireland/state_county-claress 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 state LIKE '%county-clare%' AND `searching` LIKE '%irish-photos%' ORDER BY `rating` ASC, `utitle` ASC
In - Eire.com, The un-official guide to Ireland
