SELECT DISTINCT town as name FROM link WHERE site = 'hort' AND country LIKE 'united-kingdom' AND country LIKE 'united-kingdom' AND state LIKE 'leicestershire' ORDER BY name ddcountry_united-kingdom/state_leicestershiress 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 'united-kingdom' AND state LIKE '%leicestershire%' ORDER BY `rating` ASC, `utitle` ASC
Hortic.com High on horticulture