Rating
Envoy Chauffeured
Canberra ACT 2600
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=25925 or tblfeedback.strbusinessname='Envoy Chauffeured' or tblfeedback.strbusinessname='Envoy Chauffeured') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Valley Limousines
Sheppard ACT 2620
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=29285 or tblfeedback.strbusinessname='Valley Limousines' or tblfeedback.strbusinessname='Valley Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Australia Wide Limousine Reservation Service
Canberra ACT 2601
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=3893 or tblfeedback.strbusinessname='Australia Wide Limousine Reservation Service' or tblfeedback.strbusinessname='Australia Wide Limousine Reservation Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A-Z Equine
Gunning NSW 2581
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=1311 or tblfeedback.strbusinessname='A-Z Equine' or tblfeedback.strbusinessname='A-Z Equine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fun Motorcycle Tours
Canberra ACT 2601
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=3896 or tblfeedback.strbusinessname='Fun Motorcycle Tours' or tblfeedback.strbusinessname='Fun Motorcycle Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vintage Car Rentals
Canberra ACT 2601
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=3886 or tblfeedback.strbusinessname='Vintage Car Rentals' or tblfeedback.strbusinessname='Vintage Car Rentals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kam Ling (Golden Bell)
Nicholls ACT 2913
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=3898 or tblfeedback.strbusinessname='Kam Ling (%%semi%%Golden Bell)%%semi%%' or tblfeedback.strbusinessname='Kam Ling (Golden Bell)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ACT Courtesy Car Service
Florey ACT 2615
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=3891 or tblfeedback.strbusinessname='ACT Courtesy Car Service' or tblfeedback.strbusinessname='ACT Courtesy Car Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Capital Carriages
Yass NSW 2582
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=8505 or tblfeedback.strbusinessname='Capital Carriages' or tblfeedback.strbusinessname='Capital Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A.C.T. Tops
Flynn ACT 2615
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=3882 or tblfeedback.strbusinessname='A.C.T. Tops' or tblfeedback.strbusinessname='A.C.T. Tops') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Keir's Horse Drawn Victorian Carriages
Dickson ACT 2602
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=3899 or tblfeedback.strbusinessname='Keir'%%semi%%s Horse Drawn Victorian Carriages' or tblfeedback.strbusinessname='Keir's Horse Drawn Victorian Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dappo Lodge Horse Drawn Carriages
Canberra ACT 2601
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=5651 or tblfeedback.strbusinessname='Dappo Lodge Horse Drawn Carriages' or tblfeedback.strbusinessname='Dappo Lodge Horse Drawn Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hughes Chauffeured Cars
Pialligo ACT 2609
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=19133 or tblfeedback.strbusinessname='Hughes Chauffeured Cars' or tblfeedback.strbusinessname='Hughes Chauffeured Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
B Ronning
Goulburn NSW 2580
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=8006 or tblfeedback.strbusinessname='B Ronning' or tblfeedback.strbusinessname='B Ronning') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hughes Chauffeured Cars Limousines & Coaches
Pialligo ACT 2609
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=5652 or tblfeedback.strbusinessname='Hughes Chauffeured Cars Limousines &%%semi%% Coaches' or tblfeedback.strbusinessname='Hughes Chauffeured Cars Limousines & Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jags for You
Canberra ACT 2601
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=3884 or tblfeedback.strbusinessname='Jags for You' or tblfeedback.strbusinessname='Jags for You') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jags for You
Theodore ACT 2905
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=5653 or tblfeedback.strbusinessname='Jags for You' or tblfeedback.strbusinessname='Jags for You') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vintage & Jag Car Hire
Canberra ACT 2601
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=3903 or tblfeedback.strbusinessname='Vintage &%%semi%% Jag Car Hire' or tblfeedback.strbusinessname='Vintage & Jag Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Southern Cross Chauffeured Limousines
Kambah ACT 2902
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=3885 or tblfeedback.strbusinessname='Southern Cross Chauffeured Limousines' or tblfeedback.strbusinessname='Southern Cross Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Canberra Limousines
Fyshwick ACT 2609
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=3889 or tblfeedback.strbusinessname='Canberra Limousines' or tblfeedback.strbusinessname='Canberra Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ACT Luxury Chauffeur Drive
Canberra ACT 2601
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=3892 or tblfeedback.strbusinessname='ACT Luxury Chauffeur Drive' or tblfeedback.strbusinessname='ACT Luxury Chauffeur Drive') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A1 Classic Rentals
Calwell ACT 2905
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=19022 or tblfeedback.strbusinessname='A1 Classic Rentals' or tblfeedback.strbusinessname='A1 Classic Rentals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hughes Chauffeured Cars, Limousines & Coaches
Pialligo ACT 2609
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=3890 or tblfeedback.strbusinessname='Hughes Chauffeured Cars, Limousines &%%semi%% Coaches' or tblfeedback.strbusinessname='Hughes Chauffeured Cars, Limousines & Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prestige Jags
Canberra ACT 2601
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=3901 or tblfeedback.strbusinessname='Prestige Jags' or tblfeedback.strbusinessname='Prestige Jags') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ACT Tops
Flynn ACT 2615
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=5649 or tblfeedback.strbusinessname='ACT Tops' or tblfeedback.strbusinessname='ACT Tops') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Horse-Drawn Carriages of Canberra
Downer ACT 2602
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=3888 or tblfeedback.strbusinessname='Horse-Drawn Carriages of Canberra' or tblfeedback.strbusinessname='Horse-Drawn Carriages of Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Claudes Classic Cars
Manuka ACT 2603
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=3895 or tblfeedback.strbusinessname='Claudes Classic Cars' or tblfeedback.strbusinessname='Claudes Classic Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A-Z Equine
Gunning ACT 2620
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=5650 or tblfeedback.strbusinessname='A-Z Equine' or tblfeedback.strbusinessname='A-Z Equine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chauffered Chevrolets
Melba ACT 2615
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=3894 or tblfeedback.strbusinessname='Chauffered Chevrolets' or tblfeedback.strbusinessname='Chauffered Chevrolets') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
John Filler's Black Bentley
Weston Creek ACT 2611
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=3897 or tblfeedback.strbusinessname='John Filler'%%semi%%s Black Bentley' or tblfeedback.strbusinessname='John Filler's Black Bentley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wild Weddings Canberra
Canberra ACT 2601
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=3887 or tblfeedback.strbusinessname='Wild Weddings Canberra' or tblfeedback.strbusinessname='Wild Weddings Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Keir's Canberra Park Riding School
Dickson ACT 2602
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=5654 or tblfeedback.strbusinessname='Keir'%%semi%%s Canberra Park Riding School' or tblfeedback.strbusinessname='Keir's Canberra Park Riding School') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
National Capital Limousines
Dickson ACT 2602
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=3900 or tblfeedback.strbusinessname='National Capital Limousines' or tblfeedback.strbusinessname='National Capital Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ACE Limousines
Nicholls ACT 2913
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=5648 or tblfeedback.strbusinessname='ACE Limousines' or tblfeedback.strbusinessname='ACE Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Arrive In Style Classic Jaguar Hire Cars
Fadden ACT 2904
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=3883 or tblfeedback.strbusinessname='Arrive In Style Classic Jaguar Hire Cars' or tblfeedback.strbusinessname='Arrive In Style Classic Jaguar Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Stewart Limousines
Florey ACT 2615
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=3902 or tblfeedback.strbusinessname='Stewart Limousines' or tblfeedback.strbusinessname='Stewart Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15