Rating
Julie Hebert Millinery
Orange NSW 2800
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27584 or tblfeedback.strbusinessname='Julie Hebert Millinery' or tblfeedback.strbusinessname='Julie Hebert Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jean Heath's Wedding Showcase
Toukley NSW 2263
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=9899 or tblfeedback.strbusinessname='Jean Heath'%%semi%%s Wedding Showcase' or tblfeedback.strbusinessname='Jean Heath's Wedding Showcase') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sam Buni
Killarney Vale NSW 2261
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=11280 or tblfeedback.strbusinessname='Sam Buni' or tblfeedback.strbusinessname='Sam Buni') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jacq of All Shades
Terrigal NSW 2260
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=9864 or tblfeedback.strbusinessname='Jacq of All Shades' or tblfeedback.strbusinessname='Jacq of All Shades') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15