Rating
Townsville Limousines
Townsville QLD 4810
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=2118 or tblfeedback.strbusinessname='Townsville Limousines' or tblfeedback.strbusinessname='Townsville Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mareeba Taxi
Mareeba QLD 4880
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=2062 or tblfeedback.strbusinessname='Mareeba Taxi' or tblfeedback.strbusinessname='Mareeba Taxi') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Melville's Pioneer Farm
Townsville QLD 4810
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=2063 or tblfeedback.strbusinessname='Melville'%%semi%%s Pioneer Farm' or tblfeedback.strbusinessname='Melville's Pioneer Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
North Queensland Limousines
Holloways Beach QLD 4878
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=2071 or tblfeedback.strbusinessname='North Queensland Limousines' or tblfeedback.strbusinessname='North Queensland Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
North Queensland Limousines
Holloways Beach QLD 4878
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=2075 or tblfeedback.strbusinessname='North Queensland Limousines' or tblfeedback.strbusinessname='North Queensland 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
Hughes Limousines
Townsville QLD 4810
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=2037 or tblfeedback.strbusinessname='Hughes Limousines' or tblfeedback.strbusinessname='Hughes Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
International Limousines
Cairns North QLD 4870
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=2040 or tblfeedback.strbusinessname='International Limousines' or tblfeedback.strbusinessname='International Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Acacia Luxury Limousines
Cairns QLD 4870
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=1894 or tblfeedback.strbusinessname='Acacia Luxury Limousines' or tblfeedback.strbusinessname='Acacia Luxury Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Astra Cairns Limousines
Cairns QLD 4870
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=1909 or tblfeedback.strbusinessname='Astra Cairns Limousines' or tblfeedback.strbusinessname='Astra Cairns Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian National Limousines Pty Ltd
Portsmith QLD 4870
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=1915 or tblfeedback.strbusinessname='Australian National Limousines Pty Ltd' or tblfeedback.strbusinessname='Australian National Limousines Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
PR Limousine Services
Townsville QLD 4810
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=1857 or tblfeedback.strbusinessname='PR Limousine Services' or tblfeedback.strbusinessname='PR Limousine Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Acacia Limousines Townsville Pty Ltd
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 Pty Ltd' or tblfeedback.strbusinessname='Acacia Limousines Townsville Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Australian National Limousines Pty Ltd
Cairns North QLD 4870
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=17045 or tblfeedback.strbusinessname='Australian National Limousines Pty Ltd' or tblfeedback.strbusinessname='Australian National Limousines Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Andalusian Cairns Horse Carriages
Cairns QLD 4870
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=17035 or tblfeedback.strbusinessname='Andalusian Cairns Horse Carriages' or tblfeedback.strbusinessname='Andalusian Cairns Horse Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Black & White Limousines
Cairns North QLD 4870
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=17047 or tblfeedback.strbusinessname='Black &%%semi%% White Limousines' or tblfeedback.strbusinessname='Black & White Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Confetti Convertibles
Townsville QLD 4810
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=17058 or tblfeedback.strbusinessname='Confetti Convertibles' or tblfeedback.strbusinessname='Confetti Convertibles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Horseful Carriage Services
Atherton QLD 4883
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=17066 or tblfeedback.strbusinessname='Horseful Carriage Services' or tblfeedback.strbusinessname='Horseful Carriage Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Memories Limousines
North Ward QLD 4810
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=17080 or tblfeedback.strbusinessname='Memories Limousines' or tblfeedback.strbusinessname='Memories Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Nautilus Chauffeured Limousines
Cairns QLD 4870
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=17083 or tblfeedback.strbusinessname='Nautilus Chauffeured Limousines' or tblfeedback.strbusinessname='Nautilus Chauffeured Limousines') 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
Stanley Hall
Townsville QLD 4810
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=17096 or tblfeedback.strbusinessname='Stanley Hall' or tblfeedback.strbusinessname='Stanley Hall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Melvilles Pioneer Farm
Townsville QLD 4810
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=17109 or tblfeedback.strbusinessname='Melvilles Pioneer Farm' or tblfeedback.strbusinessname='Melvilles Pioneer Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Acacia 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=18611 or tblfeedback.strbusinessname='Acacia Limousines' or tblfeedback.strbusinessname='Acacia 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
Andalusian Carns Horse Carriages
Cairns QLD 4870
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=1908 or tblfeedback.strbusinessname='Andalusian Carns Horse Carriages' or tblfeedback.strbusinessname='Andalusian Carns Horse Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Big Event Bus Charters
Manunda QLD 4870
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=1921 or tblfeedback.strbusinessname='Big Event Bus Charters' or tblfeedback.strbusinessname='Big Event Bus Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Black & White Limousines
Portsmith QLD 4870
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=1924 or tblfeedback.strbusinessname='Black &%%semi%% White Limousines' or tblfeedback.strbusinessname='Black & White Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15