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
Whitsunday Hot Rods
Airlie Beach QLD 4802
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=38502 or tblfeedback.strbusinessname='Whitsunday Hot Rods' or tblfeedback.strbusinessname='Whitsunday Hot Rods') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Acacia Limousines Townsville
Currajong QLD 4812
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=1861 or tblfeedback.strbusinessname='Acacia Limousines Townsville' or tblfeedback.strbusinessname='Acacia Limousines Townsville') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hervey Bay Kombi
Hervey bay QLD 4655
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=42970 or tblfeedback.strbusinessname='Hervey Bay Kombi' or tblfeedback.strbusinessname='Hervey Bay Kombi') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kangnarra Stage Coach
Hervey Bay QLD 4655
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=2043 or tblfeedback.strbusinessname='Kangnarra Stage Coach' or tblfeedback.strbusinessname='Kangnarra Stage Coach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hervey Bay Limousine Service
Torquay QLD 4655
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=2029 or tblfeedback.strbusinessname='Hervey Bay Limousine Service' or tblfeedback.strbusinessname='Hervey Bay Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Olde Time Limousines
Hervey Bay QLD 4655
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=17087 or tblfeedback.strbusinessname='Olde Time Limousines' or tblfeedback.strbusinessname='Olde Time Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bow Tie Limousine & Tour Company
Pialba QLD 4655
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=18626 or tblfeedback.strbusinessname='Bow Tie Limousine &%%semi%% Tour Company' or tblfeedback.strbusinessname='Bow Tie Limousine & Tour Company') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Limousines
Garbutt QLD 4814
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=18637 or tblfeedback.strbusinessname='Classic Limousines' or tblfeedback.strbusinessname='Classic Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Queensland Limousines
Bundaberg QLD 4670
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=2095 or tblfeedback.strbusinessname='Queensland Limousines' or tblfeedback.strbusinessname='Queensland Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Capricorn Chauffeured Limousines
Rockhampton QLD 4700
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=17053 or tblfeedback.strbusinessname='Capricorn Chauffeured Limousines' or tblfeedback.strbusinessname='Capricorn Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kylindael Enterprises
Bundaberg QLD 4670
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=2051 or tblfeedback.strbusinessname='Kylindael Enterprises' or tblfeedback.strbusinessname='Kylindael Enterprises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Car Rentals
Maryborough QLD 4650
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=17055 or tblfeedback.strbusinessname='Classic Car Rentals' or tblfeedback.strbusinessname='Classic Car Rentals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Capricorn Chauffeured Limousines
Rockhampton QLD 4702
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=1960 or tblfeedback.strbusinessname='Capricorn Chauffeured Limousines' or tblfeedback.strbusinessname='Capricorn Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
VIP Jaguar
Mackay QLD 4740
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=2120 or tblfeedback.strbusinessname='VIP Jaguar' or tblfeedback.strbusinessname='VIP Jaguar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
KJ Carriages
Rockhampton QLD 4700
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=17075 or tblfeedback.strbusinessname='KJ Carriages' or tblfeedback.strbusinessname='KJ Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kangnarra Stage Coach Lines
Takura QLD 4655
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=17073 or tblfeedback.strbusinessname='Kangnarra Stage Coach Lines' or tblfeedback.strbusinessname='Kangnarra Stage Coach Lines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bundaberg Cab Co Pty Ltd
Bundaberg QLD 4670
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=1932 or tblfeedback.strbusinessname='Bundaberg Cab Co Pty Ltd' or tblfeedback.strbusinessname='Bundaberg Cab Co Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bundaberg Limousines
Bundaberg QLD 4670
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=17050 or tblfeedback.strbusinessname='Bundaberg Limousines' or tblfeedback.strbusinessname='Bundaberg Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A Classic Car Rentals
Tinana QLD 4650
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=1876 or tblfeedback.strbusinessname='A Classic Car Rentals' or tblfeedback.strbusinessname='A Classic Car Rentals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bow Tie Limousine & Tour Company
Hervey Bay QLD 4655
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=1929 or tblfeedback.strbusinessname='Bow Tie Limousine &%%semi%% Tour Company' or tblfeedback.strbusinessname='Bow Tie Limousine & Tour Company') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Colonial Royal Mail Coaches
Childers QLD 4660
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=1980 or tblfeedback.strbusinessname='Colonial Royal Mail Coaches' or tblfeedback.strbusinessname='Colonial Royal Mail Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mackay Chauffeured Limousines
Mount Pleasant QLD 4740
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=17079 or tblfeedback.strbusinessname='Mackay Chauffeured Limousines' or tblfeedback.strbusinessname='Mackay Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15