DresSense Bridal (Brides Of Sydney) Reviews

select count(intrating) as reviews,round(avg(cast(intrating as float)),2) as rating from tblfeedback inner join tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID where (lngsupplierID=1807 or strbusinessname='DresSense Bridal (%%semi%%Brides Of Sydney)%%semi%%' or strbusinessname='DresSense Bridal (%%semi%%Brides Of Sydney)%%semi%%') and year(getdate())-year(dtmadded)<=15 and tblfeedback.active = 1