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
Angels Shoes
Adelaide SA 5000
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=29215 or tblfeedback.strbusinessname='Angels Shoes' or tblfeedback.strbusinessname='Angels Shoes') 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
Adelaide Dancers Boutique
Adelaide SA 5000
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=6069 or tblfeedback.strbusinessname='Adelaide Dancers Boutique' or tblfeedback.strbusinessname='Adelaide Dancers Boutique') and year(getdate())-year(dtmadded)<=15
Rating
Carapella Shoe Store & Repairs
Campbelltown SA 5074
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=6070 or tblfeedback.strbusinessname='Carapella Shoe Store & Repairs' or tblfeedback.strbusinessname='Carapella Shoe Store & Repairs') and year(getdate())-year(dtmadded)<=15
Rating
Cobbler Shop The
Adelaide SA 5000
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=6071 or tblfeedback.strbusinessname='Cobbler Shop The' or tblfeedback.strbusinessname='Cobbler Shop The') and year(getdate())-year(dtmadded)<=15
Rating
DI Fabio Bros Pty Ltd
Adelaide SA 5000
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=6072 or tblfeedback.strbusinessname='DI Fabio Bros Pty Ltd' or tblfeedback.strbusinessname='DI Fabio Bros Pty Ltd') and year(getdate())-year(dtmadded)<=15
Rating
Foot
Seacliff SA 5049
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=6073 or tblfeedback.strbusinessname='Foot' or tblfeedback.strbusinessname='Foot') and year(getdate())-year(dtmadded)<=15
Rating
Glass Slipper The
Adelaide SA 5000
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=6074 or tblfeedback.strbusinessname='Glass Slipper The' or tblfeedback.strbusinessname='Glass Slipper The') and year(getdate())-year(dtmadded)<=15
Rating
Judd's Shoe Stores
Glenelg SA 5045
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=6075 or tblfeedback.strbusinessname='Judd's Shoe Stores' or tblfeedback.strbusinessname='Judd's Shoe Stores') and year(getdate())-year(dtmadded)<=15
Rating
So You Shoes
North Adelaide SA 5006
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=19473 or tblfeedback.strbusinessname='So You Shoes' or tblfeedback.strbusinessname='So You Shoes') and year(getdate())-year(dtmadded)<=15