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