Rating
Lace and Love
Melbourne VIC 3000
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=25848 or tblfeedback.strbusinessname='Lace and Love' or tblfeedback.strbusinessname='Lace and Love') 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
Siren Shoes
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=27819 or tblfeedback.strbusinessname='Siren Shoes' or tblfeedback.strbusinessname='Siren 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
Santino Shoes
341 High St Preston VIC 3072
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=320 or tblfeedback.strbusinessname='Santino Shoes' or tblfeedback.strbusinessname='Santino Shoes') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Alan Pinkus
265 Little Bourke St Melbourne VIC 3000
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=89 or tblfeedback.strbusinessname='Alan Pinkus' or tblfeedback.strbusinessname='Alan Pinkus') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
City Vogue Shoe Covering
Room 15 Level 7 37 Swanston Street Melbourne VIC 3000
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=149 or tblfeedback.strbusinessname='City Vogue Shoe Covering' or tblfeedback.strbusinessname='City Vogue Shoe Covering') and year(getdate())-year(dtmadded)<=15
Rating
Evans Leather Restorations
Shop 50 & Kiosk 4 Royal Arcade Melbourne VIC 3000
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=186 or tblfeedback.strbusinessname='Evans Leather Restorations' or tblfeedback.strbusinessname='Evans Leather Restorations') and year(getdate())-year(dtmadded)<=15
Rating
Adawn
25 Renou Rd Wantirna South VIC 3152
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=4668 or tblfeedback.strbusinessname='Adawn' or tblfeedback.strbusinessname='Adawn') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Xiomara
1065 High St Armadale VIC 3143
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=17916 or tblfeedback.strbusinessname='Xiomara' or tblfeedback.strbusinessname='Xiomara') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating