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
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
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
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
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
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
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
Astra Chauffeured Limousines & Coaches of Australia
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=17038 or tblfeedback.strbusinessname='Astra Chauffeured Limousines &%%semi%% Coaches of Australia' or tblfeedback.strbusinessname='Astra Chauffeured Limousines & Coaches of Australia') 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=2032 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
Acacia Luxury Limousines
East Brisbane QLD 4169
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=1862 or tblfeedback.strbusinessname='Acacia Luxury Limousines' or tblfeedback.strbusinessname='Acacia Luxury Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vintage Car Hire QLD
Wynnum QLD 4178
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=17103 or tblfeedback.strbusinessname='Vintage Car Hire QLD' or tblfeedback.strbusinessname='Vintage Car Hire QLD') 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
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
Apex Chauffeured Limousines
Chermside West 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=17036 or tblfeedback.strbusinessname='Apex Chauffeured Limousines' or tblfeedback.strbusinessname='Apex Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Mustangs & Convertibles Hire Car Services
Loganholme QLD 4129
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=1976 or tblfeedback.strbusinessname='Classic Mustangs &%%semi%% Convertibles Hire Car Services' or tblfeedback.strbusinessname='Classic Mustangs & Convertibles Hire Car Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A All Cascades Chauffeured 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=17107 or tblfeedback.strbusinessname='A All Cascades Chauffeured Limousines' or tblfeedback.strbusinessname='A All Cascades Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lockyer Valley Luxury Cars
Laidley QLD 4341
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=2059 or tblfeedback.strbusinessname='Lockyer Valley Luxury Cars' or tblfeedback.strbusinessname='Lockyer Valley Luxury Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian National Limousines
Brisbane Airport QLD 4007
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=1914 or tblfeedback.strbusinessname='Australian National Limousines' or tblfeedback.strbusinessname='Australian National Limousines') 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
R R Hire Cars
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=2098 or tblfeedback.strbusinessname='R R Hire Cars' or tblfeedback.strbusinessname='R R Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sequells Limousine Service
Runcorn QLD 4113
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=2106 or tblfeedback.strbusinessname='Sequells Limousine Service' or tblfeedback.strbusinessname='Sequells Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Western Limousines
Dinmore QLD 4303
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=2121 or tblfeedback.strbusinessname='Western Limousines' or tblfeedback.strbusinessname='Western Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hughes Chauffeured Cars Limousines - Coaches
East Brisbane QLD 4169
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=2036 or tblfeedback.strbusinessname='Hughes Chauffeured Cars Limousines - Coaches' or tblfeedback.strbusinessname='Hughes Chauffeured Cars Limousines - Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Park Avenue 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=2088 or tblfeedback.strbusinessname='Park Avenue Limousines' or tblfeedback.strbusinessname='Park Avenue Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ambassador Limousines
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=1906 or tblfeedback.strbusinessname='Ambassador Limousines' or tblfeedback.strbusinessname='Ambassador 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=17026 or tblfeedback.strbusinessname='A Roadsters' or tblfeedback.strbusinessname='A Roadsters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alpha Limousines
Chermside 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=1905 or tblfeedback.strbusinessname='Alpha Limousines' or tblfeedback.strbusinessname='Alpha Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Chauffeured Limousines
Ferny Grove 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=17044 or tblfeedback.strbusinessname='Australian Chauffeured Limousines' or tblfeedback.strbusinessname='Australian 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
James Bond Limousines
Chermside West 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=17072 or tblfeedback.strbusinessname='James Bond Limousines' or tblfeedback.strbusinessname='James Bond Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bishop Limousines
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=1922 or tblfeedback.strbusinessname='Bishop Limousines' or tblfeedback.strbusinessname='Bishop Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abel 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=17030 or tblfeedback.strbusinessname='Abel Limousines' or tblfeedback.strbusinessname='Abel Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Five 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=2013 or tblfeedback.strbusinessname='Five Star Limousines' or tblfeedback.strbusinessname='Five Star Limousines') 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
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
Rolls for A Day
Highfields 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=17090 or tblfeedback.strbusinessname='Rolls for A Day' or tblfeedback.strbusinessname='Rolls for A Day') 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
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
HSV Statesman Limousines & Wedding Cars Australia Pty Ltd
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=17067 or tblfeedback.strbusinessname='HSV Statesman Limousines &%%semi%% Wedding Cars Australia Pty Ltd' or tblfeedback.strbusinessname='HSV Statesman Limousines & Wedding Cars Australia Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A. Aaegean Limousines
Upper Mt 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=1882 or tblfeedback.strbusinessname='A. Aaegean Limousines' or tblfeedback.strbusinessname='A. Aaegean Limousines') 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
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
A Heritage In Harness
Belmont QLD 4153
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=17025 or tblfeedback.strbusinessname='A Heritage In Harness' or tblfeedback.strbusinessname='A Heritage In Harness') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sunline Limousines
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=17098 or tblfeedback.strbusinessname='Sunline Limousines' or tblfeedback.strbusinessname='Sunline Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Limousines For All Occasions
Chermside West 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=2054 or tblfeedback.strbusinessname='Limousines For All Occasions' or tblfeedback.strbusinessname='Limousines For All Occasions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Global Limousines & Corporate 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=2017 or tblfeedback.strbusinessname='Global Limousines &%%semi%% Corporate Cars' or tblfeedback.strbusinessname='Global Limousines & Corporate Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hughes Chauffeured Cars Limousines-Coaches
East Brisbane QLD 4169
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=17069 or tblfeedback.strbusinessname='Hughes Chauffeured Cars Limousines-Coaches' or tblfeedback.strbusinessname='Hughes Chauffeured Cars Limousines-Coaches') 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
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
1 - 50 of 132 Sort search results alphabetically