Rating
Leven Luxury Limo's
Turners Beach TAS 7315
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=3491 or tblfeedback.strbusinessname='Leven Luxury Limo's' or tblfeedback.strbusinessname='Leven Luxury Limo's') and year(getdate())-year(dtmadded)<=15
Rating
S P Luxury Limousines
Ulverstone TAS 7315
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=3495 or tblfeedback.strbusinessname='S P Luxury Limousines' or tblfeedback.strbusinessname='S P Luxury Limousines') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bob Mason
Deloraine TAS 7304
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=3500 or tblfeedback.strbusinessname='Bob Mason' or tblfeedback.strbusinessname='Bob Mason') and year(getdate())-year(dtmadded)<=15
Rating
Classic Chauffeur Driven Jags
Burnie TAS 7320
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=3507 or tblfeedback.strbusinessname='Classic Chauffeur Driven Jags' or tblfeedback.strbusinessname='Classic Chauffeur Driven Jags') and year(getdate())-year(dtmadded)<=15
Rating
Sid's Limousine Services
Devonport TAS 7310
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=3519 or tblfeedback.strbusinessname='Sid's Limousine Services' or tblfeedback.strbusinessname='Sid's Limousine Services') and year(getdate())-year(dtmadded)<=15
Rating
Torquay Jaguar Wedding Cars
Devonport TAS 7310
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=3523 or tblfeedback.strbusinessname='Torquay Jaguar Wedding Cars' or tblfeedback.strbusinessname='Torquay Jaguar Wedding Cars') and year(getdate())-year(dtmadded)<=15
Rating
Purins
Port Sorell TAS 7307
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=5383 or tblfeedback.strbusinessname='Purins' or tblfeedback.strbusinessname='Purins') and year(getdate())-year(dtmadded)<=15
Rating
SP Luxury Limousines
Ulverstone TAS 7315
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=5384 or tblfeedback.strbusinessname='SP Luxury Limousines' or tblfeedback.strbusinessname='SP Luxury Limousines') and year(getdate())-year(dtmadded)<=15
Rating
Burnie/Wynyard Taxi's
Burnie TAS 7320
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=5387 or tblfeedback.strbusinessname='Burnie/Wynyard Taxi's' or tblfeedback.strbusinessname='Burnie/Wynyard Taxi's') and year(getdate())-year(dtmadded)<=15