Rating
Move DJs
Perth WA 4000
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=26554 or tblfeedback.strbusinessname='Move DJs' or tblfeedback.strbusinessname='Move DJs') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Big Men Working
Albany WA 6330
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=29258 or tblfeedback.strbusinessname='Big Men Working' or tblfeedback.strbusinessname='Big Men Working') 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rastatrix
Busselton WA 6280
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=26189 or tblfeedback.strbusinessname='Rastatrix' or tblfeedback.strbusinessname='Rastatrix') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Smooth Music
Morley WA 6111
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=17669 or tblfeedback.strbusinessname='Smooth Music' or tblfeedback.strbusinessname='Smooth Music') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Audiowave Sound Entertainment
Bickley WA 6076
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=7206 or tblfeedback.strbusinessname='Audiowave Sound Entertainment' or tblfeedback.strbusinessname='Audiowave Sound Entertainment') and year(getdate())-year(dtmadded)<=15
Rating
Bad Baoyz DJ
Bunbury WA 6230
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=7207 or tblfeedback.strbusinessname='Bad Baoyz DJ' or tblfeedback.strbusinessname='Bad Baoyz DJ') and year(getdate())-year(dtmadded)<=15
Rating
Busselton Mobile Dj's
Busselton WA 6280
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=7210 or tblfeedback.strbusinessname='Busselton Mobile Dj's' or tblfeedback.strbusinessname='Busselton Mobile Dj's') and year(getdate())-year(dtmadded)<=15
Rating
Cloud Nine Professional D J Service
Lesmurdie WA 6076
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=7212 or tblfeedback.strbusinessname='Cloud Nine Professional D J Service' or tblfeedback.strbusinessname='Cloud Nine Professional D J Service') and year(getdate())-year(dtmadded)<=15
Rating
Combination Sounds
Kelmscott WA 6111
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=7213 or tblfeedback.strbusinessname='Combination Sounds' or tblfeedback.strbusinessname='Combination Sounds') and year(getdate())-year(dtmadded)<=15
Rating
Disc Jockey Association
Lesmurdie WA 6076
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=7216 or tblfeedback.strbusinessname='Disc Jockey Association' or tblfeedback.strbusinessname='Disc Jockey Association') and year(getdate())-year(dtmadded)<=15
Rating
Disc Jockey Association Inc
Lesmurdie WA 6076
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=7220 or tblfeedback.strbusinessname='Disc Jockey Association Inc' or tblfeedback.strbusinessname='Disc Jockey Association Inc') and year(getdate())-year(dtmadded)<=15
Rating
DJ Smart
Waroona WA 6215
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=7225 or tblfeedback.strbusinessname='DJ Smart' or tblfeedback.strbusinessname='DJ Smart') and year(getdate())-year(dtmadded)<=15
Rating
Fine Music
Gooseberry Hill WA 6076
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=7228 or tblfeedback.strbusinessname='Fine Music' or tblfeedback.strbusinessname='Fine Music') and year(getdate())-year(dtmadded)<=15
Rating
South West Fireworks
Bunbury WA 6230
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=7242 or tblfeedback.strbusinessname='South West Fireworks' or tblfeedback.strbusinessname='South West Fireworks') and year(getdate())-year(dtmadded)<=15