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
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
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
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
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
Canadel Pty Ltd
Bridgeman Downs QLD 4035
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=17052 or tblfeedback.strbusinessname='Canadel Pty Ltd' or tblfeedback.strbusinessname='Canadel Pty Ltd') 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
Abel Limousines
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=1893 or tblfeedback.strbusinessname='Abel Limousines' or tblfeedback.strbusinessname='Abel Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Austlyn Corporate Cars
Hamilton Central 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=1912 or tblfeedback.strbusinessname='Austlyn Corporate Cars' or tblfeedback.strbusinessname='Austlyn Corporate Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Knight's Vintage Wedding Hire
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=17076 or tblfeedback.strbusinessname='Knight'%%semi%%s Vintage Wedding Hire' or tblfeedback.strbusinessname='Knight's Vintage Wedding Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
Queensland Prestige 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=2096 or tblfeedback.strbusinessname='Queensland Prestige Hire Cars' or tblfeedback.strbusinessname='Queensland Prestige Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
O'Connell's Carriages
Beaudesert QLD 4285
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=17086 or tblfeedback.strbusinessname='O'%%semi%%Connell'%%semi%%s Carriages' or tblfeedback.strbusinessname='O'Connell's Carriages') 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
Acacia Luxury Transport
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=1895 or tblfeedback.strbusinessname='Acacia Luxury Transport' or tblfeedback.strbusinessname='Acacia Luxury Transport') 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
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
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
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
A Classic Benz
Carina Heights 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=1859 or tblfeedback.strbusinessname='A Classic Benz' or tblfeedback.strbusinessname='A Classic Benz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Astra Limousines of Brisbane
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=17039 or tblfeedback.strbusinessname='Astra Limousines of Brisbane' or tblfeedback.strbusinessname='Astra Limousines of Brisbane') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A1 Limousines
Rochedale South QLD 4123
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=1873 or tblfeedback.strbusinessname='A1 Limousines' or tblfeedback.strbusinessname='A1 Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bayside Wedding Cars
Wellington Point QLD 4160
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=1919 or tblfeedback.strbusinessname='Bayside Wedding Cars' or tblfeedback.strbusinessname='Bayside Wedding Cars') 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
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
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=2027 or tblfeedback.strbusinessname='Heritage Limousines' or tblfeedback.strbusinessname='Heritage Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gumgullie Carriages
Murphy's Creek 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=1867 or tblfeedback.strbusinessname='Gumgullie Carriages' or tblfeedback.strbusinessname='Gumgullie Carriages') 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
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=1853 or tblfeedback.strbusinessname='Roadsters' or tblfeedback.strbusinessname='Roadsters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brisbane Luxury Limousines
Kedron QLD 4031
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=1864 or tblfeedback.strbusinessname='Brisbane Luxury Limousines' or tblfeedback.strbusinessname='Brisbane Luxury 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
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
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
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
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
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
Abel Limousine Service
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=1891 or tblfeedback.strbusinessname='Abel Limousine Service' or tblfeedback.strbusinessname='Abel Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A. Aaegean Chauffeur Limousines
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=1880 or tblfeedback.strbusinessname='A. Aaegean Chauffeur Limousines' or tblfeedback.strbusinessname='A. Aaegean Chauffeur Limousines') 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
A. Aachen's Classic Kenz Classic
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=1879 or tblfeedback.strbusinessname='A. Aachen'%%semi%%s Classic Kenz Classic' or tblfeedback.strbusinessname='A. Aachen's Classic Kenz Classic') 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
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
In Style Limousines & Wedding Cars
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=17070 or tblfeedback.strbusinessname='In Style Limousines &%%semi%% Wedding Cars' or tblfeedback.strbusinessname='In Style Limousines & Wedding Cars') 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
RR 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=17093 or tblfeedback.strbusinessname='RR Hire Cars' or tblfeedback.strbusinessname='RR Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Limousines for All Occasions Pty Ltd
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=17077 or tblfeedback.strbusinessname='Limousines for All Occasions Pty Ltd' or tblfeedback.strbusinessname='Limousines for All Occasions Pty Ltd') 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
HSV Statesman Limousines
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=18669 or tblfeedback.strbusinessname='HSV Statesman Limousines' or tblfeedback.strbusinessname='HSV Statesman Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
1 - 50 of 140 Sort search results alphabetically