Rating
The Chapel at Gold Creek
Nicholls ACT 2913
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=27915 or tblfeedback.strbusinessname='The Chapel at Gold Creek' or tblfeedback.strbusinessname='The Chapel at Gold Creek') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
National Arboretum Canberra
Molonglo Valley ACT 2611
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=26700 or tblfeedback.strbusinessname='National Arboretum Canberra' or tblfeedback.strbusinessname='National Arboretum Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Park Hyatt Canberra
Yarralumla ACT 2600
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=27337 or tblfeedback.strbusinessname='Park Hyatt Canberra' or tblfeedback.strbusinessname='Park Hyatt Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Erindale Vikings Club
Wanniassa ACT 2903
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=29700 or tblfeedback.strbusinessname='Erindale Vikings Club' or tblfeedback.strbusinessname='Erindale Vikings Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kangaroo Valley Bush Retreat
Kangaroo Valley NSW 2577
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=25182 or tblfeedback.strbusinessname='Kangaroo Valley Bush Retreat' or tblfeedback.strbusinessname='Kangaroo Valley Bush Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St Christopher's Cathedral
Canberra ACT 2603
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=19202 or tblfeedback.strbusinessname='St Christopher'%%semi%%s Cathedral' or tblfeedback.strbusinessname='St Christopher's Cathedral') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15