Rating
Ballarat Classic Jags
Ballarat VIC 3350
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=583 or tblfeedback.strbusinessname='Ballarat Classic Jags' or tblfeedback.strbusinessname='Ballarat Classic Jags') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Macedon Ranges Limousines
Riddells Creek VIC 3431
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=14910 or tblfeedback.strbusinessname='Macedon Ranges Limousines' or tblfeedback.strbusinessname='Macedon Ranges Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Echuca Limo Tours
Echuca VIC 3564
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=18216 or tblfeedback.strbusinessname='Echuca Limo Tours' or tblfeedback.strbusinessname='Echuca Limo Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Clarendon Carriages
Ballarat VIC 3350
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=14874 or tblfeedback.strbusinessname='Clarendon Carriages' or tblfeedback.strbusinessname='Clarendon Carriages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ballarat Limousines
Ballarat VIC 3350
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=700 or tblfeedback.strbusinessname='Ballarat Limousines' or tblfeedback.strbusinessname='Ballarat Limousines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
J & L Catering
Bendigo VIC 3550
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=864 or tblfeedback.strbusinessname='J &%%semi%% L Catering' or tblfeedback.strbusinessname='J & L Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rolls Royce Hire
Ballarat VIC 3350
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=14927 or tblfeedback.strbusinessname='Rolls Royce Hire' or tblfeedback.strbusinessname='Rolls Royce Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bendigo Limousine Service
Golden Square VIC 3555
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=584 or tblfeedback.strbusinessname='Bendigo Limousine Service' or tblfeedback.strbusinessname='Bendigo Limousine Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bendigo Horse & Carriage Hire
Bendigo VIC 3550
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=711 or tblfeedback.strbusinessname='Bendigo Horse &%%semi%% Carriage Hire' or tblfeedback.strbusinessname='Bendigo Horse & Carriage Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic 57 Chev's
Riddell's Creek VIC 3431
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=767 or tblfeedback.strbusinessname='Classic 57 Chev'%%semi%%s' or tblfeedback.strbusinessname='Classic 57 Chev's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bendigo Wedding Car Hire
Bendigo VIC 3550
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=712 or tblfeedback.strbusinessname='Bendigo Wedding Car Hire' or tblfeedback.strbusinessname='Bendigo Wedding Car Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Echuca Prestige Wedding Cars
Echuca VIC 3564
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=802 or tblfeedback.strbusinessname='Echuca Prestige Wedding Cars' or tblfeedback.strbusinessname='Echuca Prestige Wedding Cars') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
LA Belle Limousine
Ballarat VIC 3350
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=891 or tblfeedback.strbusinessname='LA Belle Limousine' or tblfeedback.strbusinessname='LA Belle Limousine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Star Classic 57 Chev's
Riddells Creek VIC 3431
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=14852 or tblfeedback.strbusinessname='All Star Classic 57 Chev'%%semi%%s' or tblfeedback.strbusinessname='All Star Classic 57 Chev's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic 57 Chev Hire
Riddell's Creek VIC 3431
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=766 or tblfeedback.strbusinessname='Classic 57 Chev Hire' or tblfeedback.strbusinessname='Classic 57 Chev Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15