Rating
Pacific Resort Cleveland
128 Middle Street 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stamford Plaza Brisbane
Edward St & Margaret St 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Vacy Hall
135 Russell Street 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mrs Bee's Bed & Breakfast
11 Boulton Street 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 year(getdate())-year(dtmadded)<=15
Rating
Carlton Hotel
King George Square 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mount Rascal B & B
110 Ironbark Drive 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 year(getdate())-year(dtmadded)<=15
Rating
Warrawee Bed & Breakfast
9 Hobbs St 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 year(getdate())-year(dtmadded)<=15