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