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
Shops 128-130 Balcony Level Adelaide Arcade 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
268 Morphett Street 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
35 Newton Road 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 &%%semi%% Repairs' or tblfeedback.strbusinessname='Carapella Shoe Store & Repairs') and year(getdate())-year(dtmadded)<=15
Rating
Cobbler Shop The
42 Adelaide Arcade 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
250 Pulteney Street 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
24 Acacia Street 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
Ground Level Shop 5G Rundle Mall <BR>Gays Arcade Adelaide Arcade 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
107 Jetty Road 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'%%semi%%s Shoe Stores' or tblfeedback.strbusinessname='Judd's Shoe Stores') and year(getdate())-year(dtmadded)<=15
Rating
So You Shoes
91 Melbourne Street 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