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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Colonial Carriages
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=17056 or tblfeedback.strbusinessname='Colonial Carriages' or tblfeedback.strbusinessname='Colonial Carriages') 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
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
A. About Town Limousines
Cleveland QLD 4163
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=1884 or tblfeedback.strbusinessname='A. About Town Limousines' or tblfeedback.strbusinessname='A. About Town Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Keller Luxury 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=2046 or tblfeedback.strbusinessname='Keller Luxury Cars' or tblfeedback.strbusinessname='Keller Luxury Cars') 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
Northside Motorcycle Tours
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=2077 or tblfeedback.strbusinessname='Northside Motorcycle Tours' or tblfeedback.strbusinessname='Northside Motorcycle Tours') 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
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
Affordable Chauffeured Limousines Gold Coast
Southport QLD 4125
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=1898 or tblfeedback.strbusinessname='Affordable Chauffeured Limousines Gold Coast' or tblfeedback.strbusinessname='Affordable Chauffeured Limousines Gold Coast') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
A. All Cascades Chauffeured Limousines
Brisbane QLD 4001
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=1885 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
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
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
LA Limo
Woolloongabba QLD 4102
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=1854 or tblfeedback.strbusinessname='LA Limo' or tblfeedback.strbusinessname='LA Limo') 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
A Aaaegean Chauffeur 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=17022 or tblfeedback.strbusinessname='A Aaaegean Chauffeur Limousines' or tblfeedback.strbusinessname='A Aaaegean Chauffeur 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
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
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
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
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
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
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
Quigley's Horse Drawn Carriages
Withcott 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=1871 or tblfeedback.strbusinessname='Quigley'%%semi%%s Horse Drawn Carriages' or tblfeedback.strbusinessname='Quigley's Horse Drawn Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brunel Worldwide Chauffeur Drive
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=17049 or tblfeedback.strbusinessname='Brunel Worldwide Chauffeur Drive' or tblfeedback.strbusinessname='Brunel Worldwide Chauffeur Drive') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Irene's Limousines Service
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=2041 or tblfeedback.strbusinessname='Irene'%%semi%%s Limousines Service' or tblfeedback.strbusinessname='Irene's Limousines Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Black & White Limousines
Everton Park 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=1926 or tblfeedback.strbusinessname='Black &%%semi%% White Limousines' or tblfeedback.strbusinessname='Black & White Limousines') 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
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
Bajuware Services
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=1917 or tblfeedback.strbusinessname='Bajuware Services' or tblfeedback.strbusinessname='Bajuware Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 137 Sort search results alphabetically