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
102 Barrack Street 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
Shop 24 Walter Road <BR>Morley Markets 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'%%semi%%s Shoe Repair' or tblfeedback.strbusinessname='Jon's Shoe Repair') and year(getdate())-year(dtmadded)<=15
Rating
Jon's Shoe Repair
Shop 105 Trinity Arcade 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'%%semi%%s Shoe Repair' or tblfeedback.strbusinessname='Jon's Shoe Repair') and year(getdate())-year(dtmadded)<=15
Rating
Matches Shoes
18 Ranger Road 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
Kiosk 3 Canning Highway <BR>Melville Plaza 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
Shop 46 The Park Centre 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
50 Howe St 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
Balcony Level Murray Street <BR>Raine Square 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'%%semi%%s Bridal Shoes' or tblfeedback.strbusinessname='Georgie's Bridal Shoes') and year(getdate())-year(dtmadded)<=15