SELECT * FROM jobsnew WHERE (LO = 'Y' AND active = 'Y') and wlj = 'Y' and featuredjob != 'y' and company not like '%&%' and jobtitle not like '%&%' and jobtitle not like '%–%' group by jobtitle,company ORDER BY codeID DESC LIMIT 10 http://www.leisureopportunities.co.ukLeisure Opportunities: News and Jobs for the leisure industryen-usCopyright #thisyear#, The Leisure Media Co Ltd. All Rights Reserved.#today##today#Leisure Opportunities: Leisure jobs60 http://www.leisureopportunities.co.uk/LOemail/images/rssheader.gif http://www.leisureopportunities.co.uk http://www.worldleisurejobs.com/detail.cfm?pagetype=detail&subject=jobs&codeID=#jobs.codeID# http://www.worldleisurejobs.com/detail.cfm?pagetype=detail&subject=jobs&codeID=#jobs.codeID#Salary: #jobs.salary#, Location: #jobs.location#, Company: #jobs.company##pubdate#