Rating
Stamford Plaza Brisbane
Brisbane QLD 4000
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=26321 or tblfeedback.strbusinessname='Stamford Plaza Brisbane' or tblfeedback.strbusinessname='Stamford Plaza Brisbane') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hotel Urban Brisbane
Brisbane QLD 4000
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=26532 or tblfeedback.strbusinessname='Hotel Urban Brisbane' or tblfeedback.strbusinessname='Hotel Urban Brisbane') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pacific Resort Cleveland
Cleveland QLD 4163
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=24954 or tblfeedback.strbusinessname='Pacific Resort Cleveland' or tblfeedback.strbusinessname='Pacific Resort Cleveland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Vacy Hall
Toowoomba QLD 4350
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=27550 or tblfeedback.strbusinessname='Vacy Hall' or tblfeedback.strbusinessname='Vacy Hall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Carlton Hotel
Brisbane QLD 4000
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=19011 or tblfeedback.strbusinessname='Carlton Hotel' or tblfeedback.strbusinessname='Carlton Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mrs Bee's Bed & Breakfast
Toowoomba QLD 4350
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=17157 or tblfeedback.strbusinessname='Mrs Bee'%%semi%%s Bed &%%semi%% Breakfast' or tblfeedback.strbusinessname='Mrs Bee's Bed & Breakfast') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mount Rascal B & B
Mt Rascal QLD 4350
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=19015 or tblfeedback.strbusinessname='Mount Rascal B &%%semi%% B' or tblfeedback.strbusinessname='Mount Rascal B & B') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Warrawee Bed & Breakfast
Scarborough QLD 4020
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=19020 or tblfeedback.strbusinessname='Warrawee Bed &%%semi%% Breakfast' or tblfeedback.strbusinessname='Warrawee Bed & Breakfast') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15