SELECT a.*
FROM `#__content` AS `a`
LEFT JOIN `#__categories` AS `b` ON (`a`.`catid` = `b`.`id`)
WHERE (`b`.`id` = '35' OR `b`.`parent_id` = '35') AND `a`.`catid` NOT IN (22,26,27,29) AND `a`.`state` = '1'
ORDER BY a.title
Testimonials
See what our clients say about your local branch
Talk to at Customer Services
Get your property valued
Looking to sell or let your property? Get a free property valuation from one of our experts.
Work out potential mortgage repayments and stamp duty costs to see how the scheme could work for you. Please note, these calculators are for general interest only and must not be relied on. Speak to our Start Financial Services team for further information and advice.