SELECT DISTINCT state AS name FROM link WHERE site = 'hort' AND country LIKE 'australian' AND searching LIKE '%agriculture%' ORDER BY name dd/theme_agriculture/country_australianss 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 'australian' AND `searching` LIKE '%agriculture%' ORDER BY `rating` ASC, `utitle` ASC
Hortic.com High on horticulture
