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 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
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
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
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
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
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 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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
Ballarat Wedding Cars
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 Wedding Cars' or tblfeedback.strbusinessname='Ballarat 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