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
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
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
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
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
Jean Heath's Wedding Showcase
Toukley NSW 2263
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=9899 or tblfeedback.strbusinessname='Jean Heath'%%semi%%s Wedding Showcase' or tblfeedback.strbusinessname='Jean Heath's Wedding Showcase') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jacq of All Shades
Terrigal NSW 2260
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=9864 or tblfeedback.strbusinessname='Jacq of All Shades' or tblfeedback.strbusinessname='Jacq of All Shades') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sam Buni
Killarney Vale NSW 2261
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=11280 or tblfeedback.strbusinessname='Sam Buni' or tblfeedback.strbusinessname='Sam Buni') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15