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
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=37959 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
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
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
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
Fleetwood Limousines
Labrador 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=2014 or tblfeedback.strbusinessname='Fleetwood Limousines' or tblfeedback.strbusinessname='Fleetwood Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
United Chauffeured Limousines
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=17102 or tblfeedback.strbusinessname='United Chauffeured Limousines' or tblfeedback.strbusinessname='United Chauffeured 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
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
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
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
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
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
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
Australia Wide Limousine Reservation Service
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=17042 or tblfeedback.strbusinessname='Australia Wide Limousine Reservation Service' or tblfeedback.strbusinessname='Australia Wide Limousine Reservation Service') 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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Goldline Limousines
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=2024 or tblfeedback.strbusinessname='Goldline Limousines' or tblfeedback.strbusinessname='Goldline Limousines') 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
Calais Carriages
Tallai 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=1957 or tblfeedback.strbusinessname='Calais Carriages' or tblfeedback.strbusinessname='Calais Carriages') 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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
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
A Roadsters Gold Coast
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=1878 or tblfeedback.strbusinessname='A Roadsters Gold Coast' or tblfeedback.strbusinessname='A Roadsters Gold Coast') 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
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
star ratingstar ratingstar ratingstar ratingstar rating
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
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 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
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
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
Gold Coast Limousines
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=2020 or tblfeedback.strbusinessname='Gold Coast Limousines' or tblfeedback.strbusinessname='Gold Coast Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
Classique 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=1977 or tblfeedback.strbusinessname='Classique Limousines' or tblfeedback.strbusinessname='Classique 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
1 - 50 of 59 Sort search results alphabetically