Rating
Mana Ceremonies
Port Lincoln SA 5606
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=36225 or tblfeedback.strbusinessname='Mana Ceremonies' or tblfeedback.strbusinessname='Mana Ceremonies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Nicole Hancox
Port Lincoln SA 5606
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=26067 or tblfeedback.strbusinessname='Nicole Hancox' or tblfeedback.strbusinessname='Nicole Hancox') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rosa
Whyalla Stuart SA 5608
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=5872 or tblfeedback.strbusinessname='Rosa' or tblfeedback.strbusinessname='Rosa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Semmens
Arno Bay SA 5603
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=5876 or tblfeedback.strbusinessname='Semmens' or tblfeedback.strbusinessname='Semmens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Smith
Kimba SA 5641
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=5882 or tblfeedback.strbusinessname='Smith' or tblfeedback.strbusinessname='Smith') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rogan
Whyalla SA 5600
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=5871 or tblfeedback.strbusinessname='Rogan' or tblfeedback.strbusinessname='Rogan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jordan
Whyalla Norrie SA 5608
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=5836 or tblfeedback.strbusinessname='Jordan' or tblfeedback.strbusinessname='Jordan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Greenwood
Streaky Bay SA 5680
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=5823 or tblfeedback.strbusinessname='Greenwood' or tblfeedback.strbusinessname='Greenwood') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15