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 tblfeedback.active = 1 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 tblfeedback.active = 1 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'%%semi%%s Limousine Services' or tblfeedback.strbusinessname='Sid's Limousine Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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'%%semi%%s' or tblfeedback.strbusinessname='Leven Luxury Limo's') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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'%%semi%%s' or tblfeedback.strbusinessname='Burnie/Wynyard Taxi's') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15