SELECT DISTINCT state AS name FROM link WHERE country LIKE '%ireland%' AND searching LIKE '%construction%' ORDER BY name dd/theme_construction/country_republic-of-irelandss 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 '%construction%' AND `plants` LIKE '%stone%' ORDER BY `rating` ASC, `utitle` ASC
In - Eire.com, The un-official guide to Ireland
