Rating
Francesca Jewellery
Hobart TAS 7000
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=43082 or tblfeedback.strbusinessname='Francesca Jewellery' or tblfeedback.strbusinessname='Francesca Jewellery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tiffany
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=29489 or tblfeedback.strbusinessname='Tiffany' or tblfeedback.strbusinessname='Tiffany') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wild Laurel
online NSW 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=43856 or tblfeedback.strbusinessname='Wild Laurel' or tblfeedback.strbusinessname='Wild Laurel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Etsy
Australa WA 0000
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=35433 or tblfeedback.strbusinessname='Etsy' or tblfeedback.strbusinessname='Etsy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Heather McDowall
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=41521 or tblfeedback.strbusinessname='Heather McDowall' or tblfeedback.strbusinessname='Heather McDowall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Heather McDowall
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=41521 or tblfeedback.strbusinessname='Heather McDowall' or tblfeedback.strbusinessname='Heather McDowall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Julie Hebert Millinery
Orange NSW 2800
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=27584 or tblfeedback.strbusinessname='Julie Hebert Millinery' or tblfeedback.strbusinessname='Julie Hebert Millinery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brideshead Bridal Accessories
Lennox Head NSW 2478
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=1632 or tblfeedback.strbusinessname='Brideshead Bridal Accessories' or tblfeedback.strbusinessname='Brideshead Bridal Accessories') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Maxine's All Occasion Accessories
Murwillumbah NSW 2484
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=10425 or tblfeedback.strbusinessname='Maxine'%%semi%%s All Occasion Accessories' or tblfeedback.strbusinessname='Maxine's All Occasion Accessories') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Millinery Madness
Lismore NSW 2480
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=10505 or tblfeedback.strbusinessname='Millinery Madness' or tblfeedback.strbusinessname='Millinery Madness') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15