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
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
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
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
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
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
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
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
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
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
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
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
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
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
Bel-Air Chauffeured Limousines
Hamilton 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=1920 or tblfeedback.strbusinessname='Bel-Air Chauffeured Limousines' or tblfeedback.strbusinessname='Bel-Air 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
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
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
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
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 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
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
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
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
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
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
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
Bj's Limousine's
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=17046 or tblfeedback.strbusinessname='Bj'%%semi%%s Limousine'%%semi%%s' or tblfeedback.strbusinessname='Bj's Limousine's') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1 - 50 of 132 Sort search results alphabetically