Rating
Deluxe Kombi Service
Moffat Beach QLD 4551
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=25976 or tblfeedback.strbusinessname='Deluxe Kombi Service' or tblfeedback.strbusinessname='Deluxe Kombi Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kombis on the Coast
Kingscliff NSW 2487
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=38400 or tblfeedback.strbusinessname='Kombis on the Coast' or tblfeedback.strbusinessname='Kombis on the Coast') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Vintage Wagen
QLD
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=25727 or tblfeedback.strbusinessname='Vintage Wagen' or tblfeedback.strbusinessname='Vintage Wagen') 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
Tic Tac Tours & Premier Limousines
Springwood QLD 4127
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=41268 or tblfeedback.strbusinessname='Tic Tac Tours &%%semi%% Premier Limousines' or tblfeedback.strbusinessname='Tic Tac Tours & Premier Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A Special Occassion
Gold Coast QLD 4207
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=35856 or tblfeedback.strbusinessname='A Special Occassion' or tblfeedback.strbusinessname='A Special Occassion') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chris...Jen Designs
Woongoolba QLD 4207
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=1971 or tblfeedback.strbusinessname='Chris...Jen Designs' or tblfeedback.strbusinessname='Chris...Jen Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Limousines Hot Line
Bundall QLD 4217
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=2056 or tblfeedback.strbusinessname='Limousines Hot Line' or tblfeedback.strbusinessname='Limousines Hot Line') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Colonial Coach Company
Upper Coomera QLD 4210
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=1979 or tblfeedback.strbusinessname='Colonial Coach Company' or tblfeedback.strbusinessname='Colonial Coach Company') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Graham's Chevrolet Hire
Paradise Point QLD 4216
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=17064 or tblfeedback.strbusinessname='Graham'%%semi%%s Chevrolet Hire' or tblfeedback.strbusinessname='Graham's Chevrolet Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Diamond Limousines
Palm Beach QLD 4221
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=18647 or tblfeedback.strbusinessname='Diamond Limousines' or tblfeedback.strbusinessname='Diamond Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sovereign Limousines
Pacific Pines QLD 4211
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=2111 or tblfeedback.strbusinessname='Sovereign Limousines' or tblfeedback.strbusinessname='Sovereign Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Affordable Chauffeured Limousines Gold Coast
Southport QLD 4215
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=17031 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
Good as Gold Limousines
Broadbeach QLD 4218
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=2026 or tblfeedback.strbusinessname='Good as Gold Limousines' or tblfeedback.strbusinessname='Good as Gold Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Accent Luxury Limousines
Currumbin Waters QLD 4223
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=18612 or tblfeedback.strbusinessname='Accent Luxury Limousines' or tblfeedback.strbusinessname='Accent Luxury Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hughes Chauffeured Cars Limousines & Coaches
Bundall QLD 4217
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=17068 or tblfeedback.strbusinessname='Hughes Chauffeured Cars Limousines &%%semi%% Coaches' or tblfeedback.strbusinessname='Hughes Chauffeured Cars Limousines & Coaches') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mudgeeraba Limousines
Mudgeeraba QLD 4213
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=2065 or tblfeedback.strbusinessname='Mudgeeraba Limousines' or tblfeedback.strbusinessname='Mudgeeraba Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Five Star
Surfers Paradise QLD 4217
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=17061 or tblfeedback.strbusinessname='Five Star' or tblfeedback.strbusinessname='Five Star') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Affordable Excellence Weddings Australia
Coolangatta QLD 4225
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=17032 or tblfeedback.strbusinessname='Affordable Excellence Weddings Australia' or tblfeedback.strbusinessname='Affordable Excellence Weddings Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Palms Limousines
Currumbin QLD 4223
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=2081 or tblfeedback.strbusinessname='Palms Limousines' or tblfeedback.strbusinessname='Palms Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Affordable Limousines
Ashmore City QLD 4214
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=18613 or tblfeedback.strbusinessname='Affordable Limousines' or tblfeedback.strbusinessname='Affordable Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prestige Limousines (Gold Coast) Pty Ltd
Southport QLD 4215
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=1869 or tblfeedback.strbusinessname='Prestige Limousines (%%semi%%Gold Coast)%%semi%% Pty Ltd' or tblfeedback.strbusinessname='Prestige Limousines (Gold Coast) Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jaguar Limousine Service
Southport QLD 4215
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=17071 or tblfeedback.strbusinessname='Jaguar Limousine Service' or tblfeedback.strbusinessname='Jaguar Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gold City Limousine Group
Nerang QLD 4211
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=2019 or tblfeedback.strbusinessname='Gold City Limousine Group' or tblfeedback.strbusinessname='Gold City Limousine Group') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gold Class Limousines
Southport QLD 4215
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=4647 or tblfeedback.strbusinessname='Gold Class Limousines' or tblfeedback.strbusinessname='Gold Class Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Worldwide Limousines
Surfers Paradise QLD 4217
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=2122 or tblfeedback.strbusinessname='Worldwide Limousines' or tblfeedback.strbusinessname='Worldwide Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gold Sovereign Carriage Co
Burleigh Heads QLD 4220
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=17062 or tblfeedback.strbusinessname='Gold Sovereign Carriage Co' or tblfeedback.strbusinessname='Gold Sovereign Carriage Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Five Star
Neranwood QLD 4213
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=2012 or tblfeedback.strbusinessname='Five Star' or tblfeedback.strbusinessname='Five Star') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cadillac Security Service
bundall QLD 4217
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=1956 or tblfeedback.strbusinessname='Cadillac Security Service' or tblfeedback.strbusinessname='Cadillac Security Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ABC Chauffeured Limousine(s) Pty Ltd
Broadbeach QLD 4218
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=1890 or tblfeedback.strbusinessname='ABC Chauffeured Limousine(%%semi%%s)%%semi%% Pty Ltd' or tblfeedback.strbusinessname='ABC Chauffeured Limousine(s) Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Airport Limousines
Southport QLD 4215
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=1899 or tblfeedback.strbusinessname='Airport Limousines' or tblfeedback.strbusinessname='Airport Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Accent Luxury Limousines
Currumbin QLD 4223
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=1896 or tblfeedback.strbusinessname='Accent Luxury Limousines' or tblfeedback.strbusinessname='Accent Luxury Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Colonial Coach Co
Upper Coomera QLD 4209
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=17057 or tblfeedback.strbusinessname='Colonial Coach Co' or tblfeedback.strbusinessname='Colonial Coach Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Colonial Horse Drawn Carriages
Canungra QLD 4275
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=18638 or tblfeedback.strbusinessname='Colonial Horse Drawn Carriages' or tblfeedback.strbusinessname='Colonial Horse Drawn Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roadsters
Coolangatta QLD 4225
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=17089 or tblfeedback.strbusinessname='Roadsters' or tblfeedback.strbusinessname='Roadsters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Limousine Hot Line
Bundall QLD 4217
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=2052 or tblfeedback.strbusinessname='Limousine Hot Line' or tblfeedback.strbusinessname='Limousine Hot Line') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chevron Limousines
Chevron Island QLD 4217
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=1970 or tblfeedback.strbusinessname='Chevron Limousines' or tblfeedback.strbusinessname='Chevron Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prestige Limousines
Southport QLD 4215
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=18715 or tblfeedback.strbusinessname='Prestige Limousines' or tblfeedback.strbusinessname='Prestige Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Regal Limousines
Runaway Bay QLD 4216
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=2100 or tblfeedback.strbusinessname='Regal Limousines' or tblfeedback.strbusinessname='Regal Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elle Limousines
Burleigh Heads QLD 4220
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=2009 or tblfeedback.strbusinessname='Elle Limousines' or tblfeedback.strbusinessname='Elle Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Moore's
Hope Island QLD 4212
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=17110 or tblfeedback.strbusinessname='Moore'%%semi%%s' or tblfeedback.strbusinessname='Moore's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mustang Magic
Broadbeach QLD 4218
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=17081 or tblfeedback.strbusinessname='Mustang Magic' or tblfeedback.strbusinessname='Mustang Magic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Cadillac Limousines
Coolangatta QLD 4225
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=17043 or tblfeedback.strbusinessname='Australian Cadillac Limousines' or tblfeedback.strbusinessname='Australian Cadillac Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
United Chauffeured Limousines
Gold Coast Mail Centre QLD 4217
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=17101 or tblfeedback.strbusinessname='United Chauffeured Limousines' or tblfeedback.strbusinessname='United Chauffeured Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Royal Limousines
Coolangatta QLD 4225
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=17091 or tblfeedback.strbusinessname='Royal Limousines' or tblfeedback.strbusinessname='Royal Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blue Bayou Luxury Limousines
Runaway Bay QLD 4216
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=1927 or tblfeedback.strbusinessname='Blue Bayou Luxury Limousines' or tblfeedback.strbusinessname='Blue Bayou Luxury Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Stewart's Clydesdales & Carriages
Beenleigh QLD 4207
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=17097 or tblfeedback.strbusinessname='Stewart'%%semi%%s Clydesdales &%%semi%% Carriages' or tblfeedback.strbusinessname='Stewart's Clydesdales & Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ABC Chauffeured Limousine (S) Pty Ltd
Broadbeach QLD 4218
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=17027 or tblfeedback.strbusinessname='ABC Chauffeured Limousine (%%semi%%S)%%semi%% Pty Ltd' or tblfeedback.strbusinessname='ABC Chauffeured Limousine (S) Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Keith Dufty Limousines
Palm Beach QLD 4221
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=2044 or tblfeedback.strbusinessname='Keith Dufty Limousines' or tblfeedback.strbusinessname='Keith Dufty Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Palms Limousines
Surfers Paradise QLD 4217
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=2084 or tblfeedback.strbusinessname='Palms Limousines' or tblfeedback.strbusinessname='Palms Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 59 Sort search results alphabetically