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
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
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
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
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
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
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
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
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
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
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
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
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
Yesteryear Chauffeured Vehicles
Mount Tamborine QLD 4272
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=17105 or tblfeedback.strbusinessname='Yesteryear Chauffeured Vehicles' or tblfeedback.strbusinessname='Yesteryear Chauffeured Vehicles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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