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
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
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
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
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
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
Western 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=17104 or tblfeedback.strbusinessname='Western Limousines' or tblfeedback.strbusinessname='Western 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
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
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
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
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
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
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
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
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
Gumgullie Carriages
Murphys 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=17065 or tblfeedback.strbusinessname='Gumgullie Carriages' or tblfeedback.strbusinessname='Gumgullie Carriages') 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. 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=1881 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
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
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
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
Global Limousines
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=2016 or tblfeedback.strbusinessname='Global Limousines' or tblfeedback.strbusinessname='Global Limousines') 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
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=17037 or tblfeedback.strbusinessname='Aprestige Rentals' or tblfeedback.strbusinessname='Aprestige Rentals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Black & White Cabs
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=1923 or tblfeedback.strbusinessname='Black &%%semi%% White Cabs' or tblfeedback.strbusinessname='Black & White Cabs') 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
Classic Elegance 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=1974 or tblfeedback.strbusinessname='Classic Elegance Limousines' or tblfeedback.strbusinessname='Classic Elegance Limousines') 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
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
Seqells 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=17094 or tblfeedback.strbusinessname='Seqells Limousine Service' or tblfeedback.strbusinessname='Seqells Limousine Service') 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
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
A Brisbane Motorcycle Tour
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=1875 or tblfeedback.strbusinessname='A Brisbane Motorcycle Tour' or tblfeedback.strbusinessname='A Brisbane Motorcycle Tour') 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
Barry's Classic Car Hire
Thorneside QLD 4158
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=1918 or tblfeedback.strbusinessname='Barry'%%semi%%s Classic Car Hire' or tblfeedback.strbusinessname='Barry's Classic Car Hire') 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
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
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
Elegant Wedding Car Hire
Balmoral QLD 4171
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=1981 or tblfeedback.strbusinessname='Elegant Wedding Car Hire' or tblfeedback.strbusinessname='Elegant Wedding Car Hire') 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 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
Bob Bone
Rochedale 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=1928 or tblfeedback.strbusinessname='Bob Bone' or tblfeedback.strbusinessname='Bob Bone') 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
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
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
Mystique 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=17111 or tblfeedback.strbusinessname='Mystique Limousines' or tblfeedback.strbusinessname='Mystique Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alpha Limousines
Geebung 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=17033 or tblfeedback.strbusinessname='Alpha Limousines' or tblfeedback.strbusinessname='Alpha Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 139 Sort search results alphabetically