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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
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