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
The White Collection
Auburn NSW 2144
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=29946 or tblfeedback.strbusinessname='The White Collection' or tblfeedback.strbusinessname='The White Collection') 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
Alan Pinkus 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=7767 or tblfeedback.strbusinessname='Alan Pinkus Shoes' or tblfeedback.strbusinessname='Alan Pinkus Shoes') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Amore Bridal Shoes
Carramar NSW 2163
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=1590 or tblfeedback.strbusinessname='Amore Bridal Shoes' or tblfeedback.strbusinessname='Amore Bridal Shoes') and year(getdate())-year(dtmadded)<=15
Rating
Bella's Bootz
Merrylands NSW 2160
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=1604 or tblfeedback.strbusinessname='Bella's Bootz' or tblfeedback.strbusinessname='Bella's Bootz') and year(getdate())-year(dtmadded)<=15
Rating
Eternity Bridal Shoes
Neutral Bay NSW 2089
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=17172 or tblfeedback.strbusinessname='Eternity Bridal Shoes' or tblfeedback.strbusinessname='Eternity Bridal Shoes') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Panache Bridal 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=10819 or tblfeedback.strbusinessname='Panache Bridal Shoes' or tblfeedback.strbusinessname='Panache Bridal Shoes') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tara Crystalle
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=4645 or tblfeedback.strbusinessname='Tara Crystalle' or tblfeedback.strbusinessname='Tara Crystalle') and year(getdate())-year(dtmadded)<=15