Rating
Flayr
NSW
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=38132 or tblfeedback.strbusinessname='Flayr' or tblfeedback.strbusinessname='Flayr') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glad all over
Carrum VIC 3197
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=44130 or tblfeedback.strbusinessname='Glad all over' or tblfeedback.strbusinessname='Glad all over') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pink Gloss Makeup
Mornington VIC 3931
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=25194 or tblfeedback.strbusinessname='Pink Gloss Makeup' or tblfeedback.strbusinessname='Pink Gloss Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Shizu wellness spa
Mornington VIC 3931
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=17855 or tblfeedback.strbusinessname='Shizu wellness spa' or tblfeedback.strbusinessname='Shizu wellness spa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Generation
Mornington VIC 3931
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=17762 or tblfeedback.strbusinessname='Hair Generation' or tblfeedback.strbusinessname='Hair Generation') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15