Rating
The Baker Boys Band
Melbourne VIC 3000
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=29010 or tblfeedback.strbusinessname='The Baker Boys Band' or tblfeedback.strbusinessname='The Baker Boys Band') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Matty Chaps
Melbourne VIC 3000
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=41039 or tblfeedback.strbusinessname='Matty Chaps' or tblfeedback.strbusinessname='Matty Chaps') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
In the Booth
Narangba QLD 4504
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=21211 or tblfeedback.strbusinessname='In the Booth' or tblfeedback.strbusinessname='In the Booth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
In the Booth
Narangba QLD 4504
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=21211 or tblfeedback.strbusinessname='In the Booth' or tblfeedback.strbusinessname='In the Booth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Music Man Mobile Disco
St Leonards TAS 7250
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=5298 or tblfeedback.strbusinessname='Music Man Mobile Disco' or tblfeedback.strbusinessname='Music Man Mobile Disco') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Megabeat Mobile Entertainment
Prospect TAS 7250
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=5294 or tblfeedback.strbusinessname='Megabeat Mobile Entertainment' or tblfeedback.strbusinessname='Megabeat Mobile Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Silverwood
Newstead TAS 7250
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=5302 or tblfeedback.strbusinessname='Silverwood' or tblfeedback.strbusinessname='Silverwood') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Powerage Mobile Music
Beaumaris TAS 7215
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=5301 or tblfeedback.strbusinessname='Powerage Mobile Music' or tblfeedback.strbusinessname='Powerage Mobile Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mike Wright
Riverside TAS 7250
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=5295 or tblfeedback.strbusinessname='Mike Wright' or tblfeedback.strbusinessname='Mike Wright') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Images of Bach
Riverside TAS 7250
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=5293 or tblfeedback.strbusinessname='Images of Bach' or tblfeedback.strbusinessname='Images of Bach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Darryn Victory
Newstead TAS 7250
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=5288 or tblfeedback.strbusinessname='Darryn Victory' or tblfeedback.strbusinessname='Darryn Victory') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15