Rating The Hip Stars Band
The Hip Stars Band
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=27820 or tblfeedback.strbusinessname='The Hip Stars Band' or tblfeedback.strbusinessname='The Hip Stars Band') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
From your ceremony to your canapés, right through to the very last song on the dance floor with all your friends and family. We provide the best kind of music that suits you at amazing prices, without compromising on quality and service.

Rating
Wal Nielson
Maryborough QLD 4650
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=26775 or tblfeedback.strbusinessname='Wal Nielson' or tblfeedback.strbusinessname='Wal Nielson') 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
Allstar Disc Jockeys
Maroochydore QLD 4556
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=25825 or tblfeedback.strbusinessname='Allstar Disc Jockeys' or tblfeedback.strbusinessname='Allstar Disc Jockeys') 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
Cut a Rug
Mapleton QLD 4560
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=25957 or tblfeedback.strbusinessname='Cut a Rug' or tblfeedback.strbusinessname='Cut a Rug') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rockin U Wild
Maroochydore QLD 4558
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=16137 or tblfeedback.strbusinessname='Rockin U Wild' or tblfeedback.strbusinessname='Rockin U Wild') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Till Dawn
Maryborough QLD 4650
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=27436 or tblfeedback.strbusinessname='Till Dawn' or tblfeedback.strbusinessname='Till Dawn') AND tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Offenbach Trio
Yandina QLD 4561
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=19009 or tblfeedback.strbusinessname='The Offenbach Trio' or tblfeedback.strbusinessname='The Offenbach Trio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Oz Music Entertainments
Nambour QLD 4560
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=16129 or tblfeedback.strbusinessname='Oz Music Entertainments' or tblfeedback.strbusinessname='Oz Music Entertainments') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Hits DJ Service
BliBli QLD 4560
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=19005 or tblfeedback.strbusinessname='All Hits DJ Service' or tblfeedback.strbusinessname='All Hits DJ Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
High Noon
Maryborough QLD 4650
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=16104 or tblfeedback.strbusinessname='High Noon' or tblfeedback.strbusinessname='High Noon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Andrew Blundell
Noosa Heads QLD 4567
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=16055 or tblfeedback.strbusinessname='Andrew Blundell' or tblfeedback.strbusinessname='Andrew Blundell') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bagpipes
Buderim QLD 4556
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=16062 or tblfeedback.strbusinessname='Bagpipes' or tblfeedback.strbusinessname='Bagpipes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coastal Entertainment
Bli Bli QLD 4560
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=16082 or tblfeedback.strbusinessname='Coastal Entertainment' or tblfeedback.strbusinessname='Coastal Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abstract Lighting
Deception Bay QLD 4508
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=16050 or tblfeedback.strbusinessname='Abstract Lighting' or tblfeedback.strbusinessname='Abstract Lighting') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Father & Son Musical Duo
Kallangur QLD 4503
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=16096 or tblfeedback.strbusinessname='Father &%%semi%% Son Musical Duo' or tblfeedback.strbusinessname='Father & Son Musical Duo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Hits DJ Service
Bli Bli QLD 4561
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=18902 or tblfeedback.strbusinessname='All Hits DJ Service' or tblfeedback.strbusinessname='All Hits DJ Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ethereal Studios
Kallangur QLD 4503
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=16093 or tblfeedback.strbusinessname='Ethereal Studios' or tblfeedback.strbusinessname='Ethereal Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Johns
Wurtulla QLD 4575
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=16107 or tblfeedback.strbusinessname='Johns' or tblfeedback.strbusinessname='Johns') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15