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
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
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
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
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
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
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
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
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
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
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
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