Rating
Port Macquarie Wedding Car Hire
Wauchope NSW 2446
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=26345 or tblfeedback.strbusinessname='Port Macquarie Wedding Car Hire' or tblfeedback.strbusinessname='Port Macquarie Wedding Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roll up in style
Peakhurst NSW 2210
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=24777 or tblfeedback.strbusinessname='Roll up in style' or tblfeedback.strbusinessname='Roll up in style') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Felsch John
Ballina NSW 2478
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=1203 or tblfeedback.strbusinessname='Felsch John' or tblfeedback.strbusinessname='Felsch John') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
North Shore & Ace Nostalgic Wedding Cars
North Shore NSW 2444
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=1212 or tblfeedback.strbusinessname='North Shore &%%semi%% Ace Nostalgic Wedding Cars' or tblfeedback.strbusinessname='North Shore & Ace Nostalgic Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Rolls Royce Wedding Hire Cars
Port Macquarie NSW 2444
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=1297 or tblfeedback.strbusinessname='A Rolls Royce Wedding Hire Cars' or tblfeedback.strbusinessname='A Rolls Royce Wedding Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Superior Limousine
Port Macquarie NSW 2444
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=1305 or tblfeedback.strbusinessname='A Superior Limousine' or tblfeedback.strbusinessname='A Superior Limousine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All White Wedding Cars by Hertz
Port Macquarie NSW 2444
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=7809 or tblfeedback.strbusinessname='All White Wedding Cars by Hertz' or tblfeedback.strbusinessname='All White Wedding Cars by Hertz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ballina Lennox Head Hire Car Service
Ballina NSW 2478
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=8028 or tblfeedback.strbusinessname='Ballina Lennox Head Hire Car Service' or tblfeedback.strbusinessname='Ballina Lennox Head Hire Car Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Budget Rent A Car
Port Macquarie NSW 2444
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=8414 or tblfeedback.strbusinessname='Budget Rent A Car' or tblfeedback.strbusinessname='Budget Rent A Car') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cadillac Fleetwood Limousines
Ballina NSW 2478
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=8453 or tblfeedback.strbusinessname='Cadillac Fleetwood Limousines' or tblfeedback.strbusinessname='Cadillac Fleetwood Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Classic Jaguar
Coffs Harbour NSW 2450
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=8706 or tblfeedback.strbusinessname='Classic Jaguar' or tblfeedback.strbusinessname='Classic Jaguar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coffs Harbour Distinctive Bridal Cars
Coffs Harbour NSW 2450
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=8748 or tblfeedback.strbusinessname='Coffs Harbour Distinctive Bridal Cars' or tblfeedback.strbusinessname='Coffs Harbour Distinctive Bridal Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Distinctive Hire Cars
Arrawarra NSW 2456
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=9032 or tblfeedback.strbusinessname='Distinctive Hire Cars' or tblfeedback.strbusinessname='Distinctive Hire Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elle Limousines
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=9156 or tblfeedback.strbusinessname='Elle Limousines' or tblfeedback.strbusinessname='Elle Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Felsch
Ballina NSW 2478
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=9265 or tblfeedback.strbusinessname='Felsch' or tblfeedback.strbusinessname='Felsch') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hastings Bridal Cars
Port Macquarie NSW 2444
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=9628 or tblfeedback.strbusinessname='Hastings Bridal Cars' or tblfeedback.strbusinessname='Hastings Bridal Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Holiday Coast Wedding Cars
Hastings Point NSW 2489
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=9708 or tblfeedback.strbusinessname='Holiday Coast Wedding Cars' or tblfeedback.strbusinessname='Holiday Coast Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
JM & JM Scott-Irving
Goonellabah NSW 2480
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=9938 or tblfeedback.strbusinessname='JM &%%semi%% JM Scott-Irving' or tblfeedback.strbusinessname='JM & JM Scott-Irving') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
John Spencer
Port Macquarie NSW 2444
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=9958 or tblfeedback.strbusinessname='John Spencer' or tblfeedback.strbusinessname='John Spencer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kalang River Cadillacs
Coffs Harbour NSW 2450
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=10005 or tblfeedback.strbusinessname='Kalang River Cadillacs' or tblfeedback.strbusinessname='Kalang River Cadillacs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Koopmans
Port Macquarie NSW 2444
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=10099 or tblfeedback.strbusinessname='Koopmans' or tblfeedback.strbusinessname='Koopmans') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mountain Top Harness Horses
Dorrigo NSW 2453
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=10580 or tblfeedback.strbusinessname='Mountain Top Harness Horses' or tblfeedback.strbusinessname='Mountain Top Harness Horses') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
North Coast Wedding Coach Co
Woolgoolga NSW 2456
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=10721 or tblfeedback.strbusinessname='North Coast Wedding Coach Co' or tblfeedback.strbusinessname='North Coast Wedding Coach Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Old Time Chevs Wedding Car Hire
Mullumbimby NSW 2482
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=10772 or tblfeedback.strbusinessname='Old Time Chevs Wedding Car Hire' or tblfeedback.strbusinessname='Old Time Chevs Wedding Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tumbulgum Vintage Cars
Tumbulgum NSW 2490
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=11800 or tblfeedback.strbusinessname='Tumbulgum Vintage Cars' or tblfeedback.strbusinessname='Tumbulgum Vintage Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tweed Coast Limousines
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=11809 or tblfeedback.strbusinessname='Tweed Coast Limousines' or tblfeedback.strbusinessname='Tweed Coast Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tweed Limousines
Tweed Heads NSW 2485
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=11811 or tblfeedback.strbusinessname='Tweed Limousines' or tblfeedback.strbusinessname='Tweed Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wyndyarra Estate Horse Riding & Carriage Tours
Upper Orara NSW 2450
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=12098 or tblfeedback.strbusinessname='Wyndyarra Estate Horse Riding &%%semi%% Carriage Tours' or tblfeedback.strbusinessname='Wyndyarra Estate Horse Riding & Carriage Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Yesteryear Wedding Cars
Brushgrove NSW 2460
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=12113 or tblfeedback.strbusinessname='Yesteryear Wedding Cars' or tblfeedback.strbusinessname='Yesteryear Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15