Rating
Converse
ACT
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=38007 or tblfeedback.strbusinessname='Converse' or tblfeedback.strbusinessname='Converse') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Converse
ACT
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=38007 or tblfeedback.strbusinessname='Converse' or tblfeedback.strbusinessname='Converse') AND tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 tblfeedback.active = 1 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 &%%semi%% Repairs' or tblfeedback.strbusinessname='Carapella Shoe Store & Repairs') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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'%%semi%%s Shoe Stores' or tblfeedback.strbusinessname='Judd's Shoe Stores') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15