SELECT DISTINCT state AS name FROM link WHERE site = 'hort' AND country LIKE 'northern-ireland' AND searching LIKE '%plants-floral%' ORDER BY name dd/theme_plants-floral/country_northern-irelandss SELECT id AS code, u_r_l_title as utitle, u_r_l AS address, description_80 AS description FROM link WHERE `site` = 'hort' AND `country` LIKE 'northern-ireland' AND `searching` LIKE '%plants-floral%' ORDER BY `rating` ASC, `utitle` ASC
Hortic.com High on horticulture
