Rating
Kenz Classic Cars
Ashgrove QLD 4060
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=2048 or tblfeedback.strbusinessname='Kenz Classic Cars' or tblfeedback.strbusinessname='Kenz Classic Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Golden Gate Limousines
Brisbane QLD 4000
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=29484 or tblfeedback.strbusinessname='Golden Gate Limousines' or tblfeedback.strbusinessname='Golden Gate Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wheels to Weddings
Geebung QLD 4304
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=41007 or tblfeedback.strbusinessname='Wheels to Weddings' or tblfeedback.strbusinessname='Wheels to Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tic Tac Tours & Premier Limousines
Springwood QLD 4127
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=41268 or tblfeedback.strbusinessname='Tic Tac Tours &%%semi%% Premier Limousines' or tblfeedback.strbusinessname='Tic Tac Tours & Premier Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dray Horse Shires
Maroon QLD 4310
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=25191 or tblfeedback.strbusinessname='Dray Horse Shires' or tblfeedback.strbusinessname='Dray Horse Shires') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Over The Top
Queenstown QLD 9300
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=29933 or tblfeedback.strbusinessname='Over The Top' or tblfeedback.strbusinessname='Over The Top') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roaring Twenties Vintage Wedding Cars
Brighton QLD 4017
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=1214 or tblfeedback.strbusinessname='Roaring Twenties Vintage Wedding Cars' or tblfeedback.strbusinessname='Roaring Twenties Vintage Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
FM Exotics
Parkinson QLD 4115
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=43365 or tblfeedback.strbusinessname='FM Exotics' or tblfeedback.strbusinessname='FM Exotics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A Golden Roller
Coopers Plains QLD 4108
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=17024 or tblfeedback.strbusinessname='A Golden Roller' or tblfeedback.strbusinessname='A Golden Roller') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Limoso
Eagle Farm QLD 4009
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=35632 or tblfeedback.strbusinessname='Limoso' or tblfeedback.strbusinessname='Limoso') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brisbane Classics
Wavell Heights QLD 4012
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=1931 or tblfeedback.strbusinessname='Brisbane Classics' or tblfeedback.strbusinessname='Brisbane Classics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Campbell Chauffeured Limousines
Sunnybank QLD 4109
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=1865 or tblfeedback.strbusinessname='Campbell Chauffeured Limousines' or tblfeedback.strbusinessname='Campbell Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A. Roadsters
Newstead QLD 4006
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=1886 or tblfeedback.strbusinessname='A. Roadsters' or tblfeedback.strbusinessname='A. Roadsters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All White Classic Limousines
Wavell Heights QLD 4012
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=1904 or tblfeedback.strbusinessname='All White Classic Limousines' or tblfeedback.strbusinessname='All White Classic Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Austral Limousines
Coorparoo QLD 4151
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=17041 or tblfeedback.strbusinessname='Austral Limousines' or tblfeedback.strbusinessname='Austral Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Champagne Wedding Carriages
Waterford QLD 4133
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=1965 or tblfeedback.strbusinessname='Champagne Wedding Carriages' or tblfeedback.strbusinessname='Champagne Wedding Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Heritage Limousines
Toowoomba QLD 4350
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=1856 or tblfeedback.strbusinessname='Heritage Limousines' or tblfeedback.strbusinessname='Heritage Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
AAAA APrestige Rentals
Corinda QLD 4075
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=1888 or tblfeedback.strbusinessname='AAAA APrestige Rentals' or tblfeedback.strbusinessname='AAAA APrestige Rentals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Star Luxury Transport
Boondall QLD 4034
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=2114 or tblfeedback.strbusinessname='Star Luxury Transport' or tblfeedback.strbusinessname='Star Luxury Transport') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prestige Vehicle Hire
Northgate QLD 4013
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=1870 or tblfeedback.strbusinessname='Prestige Vehicle Hire' or tblfeedback.strbusinessname='Prestige Vehicle Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Golden Gate Limousines
Paddington QLD 4064
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=1858 or tblfeedback.strbusinessname='Golden Gate Limousines' or tblfeedback.strbusinessname='Golden Gate Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Awesome Car Rentals
Clontarf QLD 4019
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=1916 or tblfeedback.strbusinessname='Awesome Car Rentals' or tblfeedback.strbusinessname='Awesome Car Rentals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Golden West Limousines
Toowoomba Mail Centre QLD 4352
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=2022 or tblfeedback.strbusinessname='Golden West Limousines' or tblfeedback.strbusinessname='Golden West Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abel Limousine Service
Kippa-ring QLD 4021
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=17029 or tblfeedback.strbusinessname='Abel Limousine Service' or tblfeedback.strbusinessname='Abel Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Silvey's Limousine Service
Ipswich QLD 4305
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=2109 or tblfeedback.strbusinessname='Silvey'%%semi%%s Limousine Service' or tblfeedback.strbusinessname='Silvey's Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Canadel Pty Ltd
Bridgeman Downs QLD 4032
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=1959 or tblfeedback.strbusinessname='Canadel Pty Ltd' or tblfeedback.strbusinessname='Canadel Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
National Car Rental
Brisbane QLD 4006
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=2067 or tblfeedback.strbusinessname='National Car Rental' or tblfeedback.strbusinessname='National Car Rental') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Affinity Bus & Limos
Brisbane QLD 4000
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=1897 or tblfeedback.strbusinessname='Affinity Bus &%%semi%% Limos' or tblfeedback.strbusinessname='Affinity Bus & Limos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Bayside Limousine Service
Capalaba QLD 4157
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=1874 or tblfeedback.strbusinessname='A Bayside Limousine Service' or tblfeedback.strbusinessname='A Bayside Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Chauffeured Limousines
Stafford QLD 4053
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=1913 or tblfeedback.strbusinessname='Australian Chauffeured Limousines' or tblfeedback.strbusinessname='Australian Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brisbane Carriage Co The
Upper Kedron QLD 4055
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=1863 or tblfeedback.strbusinessname='Brisbane Carriage Co The' or tblfeedback.strbusinessname='Brisbane Carriage Co The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rent A Limo
Toowoomba QLD 4350
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=2101 or tblfeedback.strbusinessname='Rent A Limo' or tblfeedback.strbusinessname='Rent A Limo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
M & M Limousines
Upper Mount Gravatt QLD 4122
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=17078 or tblfeedback.strbusinessname='M &%%semi%% M Limousines' or tblfeedback.strbusinessname='M & M Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ambassador Limousine Hire
Carindale QLD 4152
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=17034 or tblfeedback.strbusinessname='Ambassador Limousine Hire' or tblfeedback.strbusinessname='Ambassador Limousine Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mystique Chauffeured Limousines
Strathpine QLD 4500
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=17082 or tblfeedback.strbusinessname='Mystique Chauffeured Limousines' or tblfeedback.strbusinessname='Mystique Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
American Legends Motorcycle Adventure Tours
Moorooka QLD 4105
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=17108 or tblfeedback.strbusinessname='American Legends Motorcycle Adventure Tours' or tblfeedback.strbusinessname='American Legends Motorcycle Adventure Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Royal Limousines
Brisbane QLD 4000
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=17092 or tblfeedback.strbusinessname='Royal Limousines' or tblfeedback.strbusinessname='Royal Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Aaegean Classique Limousines
Capalaba QLD 4157
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=17106 or tblfeedback.strbusinessname='A Aaegean Classique Limousines' or tblfeedback.strbusinessname='A Aaegean Classique Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
American 50's Convertible, Hot Rods & Classic Car
Cornubia QLD 4130
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=1907 or tblfeedback.strbusinessname='American 50'%%semi%%s Convertible, Hot Rods &%%semi%% Classic Car' or tblfeedback.strbusinessname='American 50's Convertible, Hot Rods & Classic Car ') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A. Atlantis Corporate & Wedding Cars
Brisbane QLD 4000
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=1887 or tblfeedback.strbusinessname='A. Atlantis Corporate &%%semi%% Wedding Cars' or tblfeedback.strbusinessname='A. Atlantis Corporate & Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
CC Limousine Service
Shailer Park QLD 4128
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=1962 or tblfeedback.strbusinessname='CC Limousine Service' or tblfeedback.strbusinessname='CC Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Campbell Chauffeured Limousines
Sunnybank Hills QLD 4109
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=17051 or tblfeedback.strbusinessname='Campbell Chauffeured Limousines' or tblfeedback.strbusinessname='Campbell Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Queensland Corporate Cars
Spring Hill QLD 4004
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=2091 or tblfeedback.strbusinessname='Queensland Corporate Cars' or tblfeedback.strbusinessname='Queensland Corporate Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Century Limousines
Brisbane QLD 4000
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=17054 or tblfeedback.strbusinessname='Century Limousines' or tblfeedback.strbusinessname='Century Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shendan Limousine Services
Chapel Hill QLD 4069
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=2107 or tblfeedback.strbusinessname='Shendan Limousine Services' or tblfeedback.strbusinessname='Shendan Limousine Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abel Limousines
Redcliffe QLD 4020
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=1892 or tblfeedback.strbusinessname='Abel Limousines' or tblfeedback.strbusinessname='Abel Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Century Limousines & Coaches
Brisbane QLD 4000
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=1963 or tblfeedback.strbusinessname='Century Limousines &%%semi%% Coaches' or tblfeedback.strbusinessname='Century Limousines & Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Four Star Limousines
The Gap QLD 4061
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=2015 or tblfeedback.strbusinessname='Four Star Limousines' or tblfeedback.strbusinessname='Four Star Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
HSV Statesman Limousines & Wedding Cars Australia
Shailer Park QLD 4128
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=2034 or tblfeedback.strbusinessname='HSV Statesman Limousines &%%semi%% Wedding Cars Australia' or tblfeedback.strbusinessname='HSV Statesman Limousines & Wedding Cars Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A. Aaegean Limousines
Capalaba QLD 4157
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=1883 or tblfeedback.strbusinessname='A. Aaegean Limousines' or tblfeedback.strbusinessname='A. Aaegean Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 133 Sort search results alphabetically