Rating
Kombi Krew
Hobart TAS 7000
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=24247 or tblfeedback.strbusinessname='Kombi Krew' or tblfeedback.strbusinessname='Kombi Krew') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ultimate Wedding Car Hire
Lauderdale TAS 7021
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=3524 or tblfeedback.strbusinessname='Ultimate Wedding Car Hire' or tblfeedback.strbusinessname='Ultimate Wedding Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bass Stretch Limousines
Hobart TAS 7000
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=3499 or tblfeedback.strbusinessname='Bass Stretch Limousines' or tblfeedback.strbusinessname='Bass Stretch Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
City Cabs
Hobart TAS 7000
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=3505 or tblfeedback.strbusinessname='City Cabs' or tblfeedback.strbusinessname='City Cabs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Untouchables
Midway Point TAS 7171
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=3522 or tblfeedback.strbusinessname='The Untouchables' or tblfeedback.strbusinessname='The Untouchables') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Clark Classic Cars
New Town TAS 7008
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=3506 or tblfeedback.strbusinessname='Clark Classic Cars' or tblfeedback.strbusinessname='Clark Classic Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tasmanian Limousine Service
Sandy Bay TAS 7006
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=5385 or tblfeedback.strbusinessname='Tasmanian Limousine Service' or tblfeedback.strbusinessname='Tasmanian Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jaguar Wedding Cars
Sandfly TAS 7150
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=3490 or tblfeedback.strbusinessname='Jaguar Wedding Cars' or tblfeedback.strbusinessname='Jaguar Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bailey
Glenorchy TAS 7010
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=5381 or tblfeedback.strbusinessname='Bailey' or tblfeedback.strbusinessname='Bailey') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Touch of Class Wedding Cars
Glenorchy TAS 7010
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=3496 or tblfeedback.strbusinessname='A Touch of Class Wedding Cars' or tblfeedback.strbusinessname='A Touch of Class Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rolls Royce Wedding Service
Glenorchy TAS 7010
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=3518 or tblfeedback.strbusinessname='Rolls Royce Wedding Service' or tblfeedback.strbusinessname='Rolls Royce Wedding Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Special Wedding Vehicles
Howrah TAS 7018
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=3494 or tblfeedback.strbusinessname='Special Wedding Vehicles' or tblfeedback.strbusinessname='Special Wedding Vehicles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chauffeured Cars & Coaches
Cambridge TAS 7170
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=3504 or tblfeedback.strbusinessname='Chauffeured Cars &%%semi%% Coaches' or tblfeedback.strbusinessname='Chauffeured Cars & Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Untouchables The
Midway Point TAS 7171
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=5389 or tblfeedback.strbusinessname='Untouchables The' or tblfeedback.strbusinessname='Untouchables The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tasmanian Wedding Service
Sandy Bay TAS 7006
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=5386 or tblfeedback.strbusinessname='Tasmanian Wedding Service' or tblfeedback.strbusinessname='Tasmanian Wedding Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Richmond Horsedrawn Coaches
Richmond TAS 7025
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=3517 or tblfeedback.strbusinessname='Richmond Horsedrawn Coaches' or tblfeedback.strbusinessname='Richmond Horsedrawn Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rent A Classic Car
Hobart TAS 7000
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=3516 or tblfeedback.strbusinessname='Rent A Classic Car' or tblfeedback.strbusinessname='Rent A Classic Car') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gregory Omnibuses
Hobart TAS 7000
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=3509 or tblfeedback.strbusinessname='Gregory Omnibuses' or tblfeedback.strbusinessname='Gregory Omnibuses') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hobart Fairlanes
Hobart TAS 7000
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=5388 or tblfeedback.strbusinessname='Hobart Fairlanes' or tblfeedback.strbusinessname='Hobart Fairlanes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cadillac Limousines Tasmania
Sorell TAS 7172
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=3501 or tblfeedback.strbusinessname='Cadillac Limousines Tasmania' or tblfeedback.strbusinessname='Cadillac Limousines Tasmania') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Occasions Vintage Cars
Blackmans Bay TAS 7052
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=3497 or tblfeedback.strbusinessname='All Occasions Vintage Cars' or tblfeedback.strbusinessname='All Occasions Vintage Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tasmanian Limousine Service
Sandy Bay TAS 7005
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=3520 or tblfeedback.strbusinessname='Tasmanian Limousine Service' or tblfeedback.strbusinessname='Tasmanian Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Maxi Taxi Services
Hobart TAS 7000
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=3513 or tblfeedback.strbusinessname='Maxi Taxi Services' or tblfeedback.strbusinessname='Maxi Taxi Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
S.V.R. International Marketing
New Town TAS 7008
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=3489 or tblfeedback.strbusinessname='S.V.R. International Marketing' or tblfeedback.strbusinessname='S.V.R. International Marketing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bailey Peter
Glenorchy TAS 7010
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=3498 or tblfeedback.strbusinessname='Bailey Peter' or tblfeedback.strbusinessname='Bailey Peter') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Huon Limousine Services
Huonville TAS 7109
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=3510 or tblfeedback.strbusinessname='Huon Limousine Services' or tblfeedback.strbusinessname='Huon Limousine Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15