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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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