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
Ulayna Aster
Main Beach QLD 4217
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=26465 or tblfeedback.strbusinessname='Ulayna Aster' or tblfeedback.strbusinessname='Ulayna Aster') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jarjorie Chapeaux
Main Beach QLD 4217
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=15096 or tblfeedback.strbusinessname='Jarjorie Chapeaux' or tblfeedback.strbusinessname='Jarjorie Chapeaux') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hats by the Hundred
Broadbeach QLD 4218
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=15094 or tblfeedback.strbusinessname='Hats by the Hundred' or tblfeedback.strbusinessname='Hats by the Hundred') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hats by the Hundred
Bundall QLD 4217
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=18663 or tblfeedback.strbusinessname='Hats by the Hundred' or tblfeedback.strbusinessname='Hats by the Hundred') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating