Incorrect syntax near ')'.<br><br>SELECT tx_outgoingDomain FROM d_domain301Redirects WHERE yn_activated = 1 AND Replace(Replace(tx_incomingDomain,'http://',''),'www.','') = 'austinrose.co.uk/jobs/aca--acca-semi-senior-(1-2-years'-experience)--top-20-firm-1053.htm'