Rating
David Jones
Sydney NSW 2000
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=26514 or tblfeedback.strbusinessname='David Jones' or tblfeedback.strbusinessname='David Jones') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
David Jones
Sydney NSW 2000
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=26514 or tblfeedback.strbusinessname='David Jones' or tblfeedback.strbusinessname='David Jones') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bootique Fashion Shoes
Perth WA 6000
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=17628 or tblfeedback.strbusinessname='Bootique Fashion Shoes' or tblfeedback.strbusinessname='Bootique Fashion Shoes') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jon's Shoe Repair
Morley WA 6062
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=7029 or tblfeedback.strbusinessname='Jon's Shoe Repair' or tblfeedback.strbusinessname='Jon's Shoe Repair') and year(getdate())-year(dtmadded)<=15
Rating
Jon's Shoe Repair
Perth WA 6000
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=7030 or tblfeedback.strbusinessname='Jon's Shoe Repair' or tblfeedback.strbusinessname='Jon's Shoe Repair') and year(getdate())-year(dtmadded)<=15
Rating
Matches Shoes
Yokine WA 6060
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=7031 or tblfeedback.strbusinessname='Matches Shoes' or tblfeedback.strbusinessname='Matches Shoes') and year(getdate())-year(dtmadded)<=15
Rating
Shoeman Multi-Service The
Melville WA 6156
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=7032 or tblfeedback.strbusinessname='Shoeman Multi-Service The' or tblfeedback.strbusinessname='Shoeman Multi-Service The') and year(getdate())-year(dtmadded)<=15
Rating
Shoeman Multi-Service The
East Victoria Park WA 6101
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=7033 or tblfeedback.strbusinessname='Shoeman Multi-Service The' or tblfeedback.strbusinessname='Shoeman Multi-Service The') and year(getdate())-year(dtmadded)<=15
Rating
Benelli Shoes
Osborne Park WA 6017
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=3674 or tblfeedback.strbusinessname='Benelli Shoes' or tblfeedback.strbusinessname='Benelli Shoes') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Georgie's Bridal Shoes
Perth WA 6000
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=3708 or tblfeedback.strbusinessname='Georgie's Bridal Shoes' or tblfeedback.strbusinessname='Georgie's Bridal Shoes') and year(getdate())-year(dtmadded)<=15