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 Formalwear and Bridal
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=37566 or tblfeedback.strbusinessname='Ferrari Formalwear and Bridal' or tblfeedback.strbusinessname='Ferrari Formalwear and Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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