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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Mackay Chauffeured Limousines
Mt 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=2060 or tblfeedback.strbusinessname='Mackay Chauffeured Limousines' or tblfeedback.strbusinessname='Mackay Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15