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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 & B' or tblfeedback.strbusinessname='Mount Rascal B & B') 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's Bed & Breakfast' or tblfeedback.strbusinessname='Mrs Bee's Bed & Breakfast') and year(getdate())-year(dtmadded)<=15
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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 & Breakfast' or tblfeedback.strbusinessname='Warrawee Bed & Breakfast') and year(getdate())-year(dtmadded)<=15
1 - 7 of 7 Random Sort