Rating
Dray Horse Shires
Maroon QLD 4310
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=25191 or tblfeedback.strbusinessname='Dray Horse Shires' or tblfeedback.strbusinessname='Dray Horse Shires') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Port Douglas Airport Shuttle
Port Douglas QLD 4871
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=2089 or tblfeedback.strbusinessname='Port Douglas Airport Shuttle' or tblfeedback.strbusinessname='Port Douglas Airport Shuttle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Emerald Taxi & Limousine Hire
Emerald QLD 4720
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=2011 or tblfeedback.strbusinessname='Emerald Taxi &%%semi%% Limousine Hire' or tblfeedback.strbusinessname='Emerald Taxi & Limousine Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sovereign Limousines
Pacific Pines QLD 4211
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=2111 or tblfeedback.strbusinessname='Sovereign Limousines' or tblfeedback.strbusinessname='Sovereign Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Red Gum Ridge Trail Rides
Stanthorpe QLD 4380
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=17088 or tblfeedback.strbusinessname='Red Gum Ridge Trail Rides' or tblfeedback.strbusinessname='Red Gum Ridge Trail Rides') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Formal Car Hire
Broken Hill NSW 2880
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=9335 or tblfeedback.strbusinessname='Formal Car Hire' or tblfeedback.strbusinessname='Formal Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Nautilus Chauffeured Limousines
Port Douglas QLD 4871
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=17084 or tblfeedback.strbusinessname='Nautilus Chauffeured Limousines' or tblfeedback.strbusinessname='Nautilus Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goldline Limousines
Nerang QLD 4211
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=2024 or tblfeedback.strbusinessname='Goldline Limousines' or tblfeedback.strbusinessname='Goldline Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Emerald Taxi Limousine
Emerald QLD 4720
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=17059 or tblfeedback.strbusinessname='Emerald Taxi Limousine' or tblfeedback.strbusinessname='Emerald Taxi Limousine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fred Potter & Son
Broken Hill NSW 2880
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=9365 or tblfeedback.strbusinessname='Fred Potter &%%semi%% Son' or tblfeedback.strbusinessname='Fred Potter & Son') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gold City Limousine Group
Nerang QLD 4211
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=2019 or tblfeedback.strbusinessname='Gold City Limousine Group' or tblfeedback.strbusinessname='Gold City Limousine Group') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dalrymple Carriage Hire
Allora QLD 4362
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=1866 or tblfeedback.strbusinessname='Dalrymple Carriage Hire' or tblfeedback.strbusinessname='Dalrymple Carriage Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15