Rating
Ed Harry
Hindmarsh SA 5007
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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ferrari Formal and Bridal (Tamworth NSW)
Tamworth NSW 2340
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=27784 or tblfeedback.strbusinessname='Ferrari Formal and Bridal (Tamworth NSW)' or tblfeedback.strbusinessname='Ferrari Formal and Bridal (Tamworth NSW)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
New England Hire Wear
Tamworth NSW 2340
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=10660 or tblfeedback.strbusinessname='New England Hire Wear' or tblfeedback.strbusinessname='New England Hire Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Bridal Showcase
Tamworth NSW 2340
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=1566 or tblfeedback.strbusinessname='The Bridal Showcase' or tblfeedback.strbusinessname='The Bridal Showcase') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blowes Menswear
Tamworth NSW 2340
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=8243 or tblfeedback.strbusinessname='Blowes Menswear' or tblfeedback.strbusinessname='Blowes Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15