SELECT * FROM jobsnew WHERE (LO = 'Y' AND active = 'Y') and featuredjob != 'y' and company not like '%&%' and jobtitle not like '%&%' group by jobtitle,company ORDER BY codeID DESC LIMIT 20 http://www.leisureopportunities.co.ukLeisure Opportunities Jobsen-usCopyright 2011, The Leisure Media Co Ltd. All Rights Reserved.#today##today#Leisure Opportunities Jobs60 http://www.leisureopportunities.co.uk/LOemail/images/rssheader.gif http://www.leisureopportunities.co.uk http://www.leisureopportunities.co.uk/detail.cfm?pagetype=detail&subject=jobs&sitecode=RSS&codeID=#jobs.codeID# http://www.leisureopportunities.co.uk/detail.cfm?pagetype=detail&subject=jobs&sitecode=RSS&codeID=#jobs.codeID##jobs.company#, #jobs.salary#, #jobs.location##pubdate#