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 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
Atmosphere Mobile Disco Entertainment
Townsville QLD 4812
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=29001 or tblfeedback.strbusinessname='Atmosphere Mobile Disco Entertainment' or tblfeedback.strbusinessname='Atmosphere Mobile Disco Entertainment') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tony George Entertainment
Redlynch QLD 4870
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=29392 or tblfeedback.strbusinessname='Tony George Entertainment' or tblfeedback.strbusinessname='Tony George Entertainment') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Boosted Beats
Thuringowa Central QLD 4817
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=29556 or tblfeedback.strbusinessname='Boosted Beats' or tblfeedback.strbusinessname='Boosted Beats') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A Bright Nite Fireworks
Cairns City QLD 4870
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=26029 or tblfeedback.strbusinessname='A Bright Nite Fireworks' or tblfeedback.strbusinessname='A Bright Nite Fireworks') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Port Douglas Audio Visual
Port Douglas QLD 4877
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=27230 or tblfeedback.strbusinessname='Port Douglas Audio Visual' or tblfeedback.strbusinessname='Port Douglas Audio Visual') 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
Cairns Premier Entertainment
Cairns QLD 4870
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=25736 or tblfeedback.strbusinessname='Cairns Premier Entertainment' or tblfeedback.strbusinessname='Cairns Premier Entertainment') 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
Millennium Weddings
Earlville QLD 4870
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=21360 or tblfeedback.strbusinessname='Millennium Weddings' or tblfeedback.strbusinessname='Millennium Weddings') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
All Amusement Hire
Wulguru QLD 4811
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=16052 or tblfeedback.strbusinessname='All Amusement Hire' or tblfeedback.strbusinessname='All Amusement Hire') and year(getdate())-year(dtmadded)<=15
Rating
Angelene Bourne
Townsville QLD 4810
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=16057 or tblfeedback.strbusinessname='Angelene Bourne' or tblfeedback.strbusinessname='Angelene Bourne') and year(getdate())-year(dtmadded)<=15
Rating
Cairns Karaoke & Disco
Cairns QLD 4870
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=16077 or tblfeedback.strbusinessname='Cairns Karaoke & Disco' or tblfeedback.strbusinessname='Cairns Karaoke & Disco') and year(getdate())-year(dtmadded)<=15
Rating
Chalumeau De Trois
Gordonvale QLD 4865
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=16078 or tblfeedback.strbusinessname='Chalumeau De Trois' or tblfeedback.strbusinessname='Chalumeau De Trois') and year(getdate())-year(dtmadded)<=15
Rating
Charles
Townsville QLD 4810
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=16079 or tblfeedback.strbusinessname='Charles' or tblfeedback.strbusinessname='Charles') and year(getdate())-year(dtmadded)<=15
Rating
Del Arte
Cairns QLD 4870
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=16089 or tblfeedback.strbusinessname='Del Arte' or tblfeedback.strbusinessname='Del Arte') and year(getdate())-year(dtmadded)<=15
Rating
DV Groove
Yorkeys Knob QLD 4878
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=16092 or tblfeedback.strbusinessname='DV Groove' or tblfeedback.strbusinessname='DV Groove') and year(getdate())-year(dtmadded)<=15
Rating
Exclusive Music
Townsville QLD 4810
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=16094 or tblfeedback.strbusinessname='Exclusive Music' or tblfeedback.strbusinessname='Exclusive Music') and year(getdate())-year(dtmadded)<=15
Rating
Flute Excellence Studio-Jane Linstead
Brinsmead QLD 4870
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=16097 or tblfeedback.strbusinessname='Flute Excellence Studio-Jane Linstead' or tblfeedback.strbusinessname='Flute Excellence Studio-Jane Linstead') and year(getdate())-year(dtmadded)<=15
Rating
Greg Watson Harpist
Kuranda QLD 4872
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=16102 or tblfeedback.strbusinessname='Greg Watson Harpist' or tblfeedback.strbusinessname='Greg Watson Harpist') and year(getdate())-year(dtmadded)<=15
Rating
Lazers Entertainment
Townsville QLD 4810
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=16110 or tblfeedback.strbusinessname='Lazers Entertainment' or tblfeedback.strbusinessname='Lazers Entertainment') and year(getdate())-year(dtmadded)<=15
Rating
Maggie's Music
Cairns QLD 4870
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=16112 or tblfeedback.strbusinessname='Maggie's Music' or tblfeedback.strbusinessname='Maggie's Music') and year(getdate())-year(dtmadded)<=15
Rating
Marathon Four Piece Band
Annandale QLD 4814
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=16113 or tblfeedback.strbusinessname='Marathon Four Piece Band' or tblfeedback.strbusinessname='Marathon Four Piece Band') and year(getdate())-year(dtmadded)<=15
Rating
Metro Music
Garbutt QLD 4814
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=16115 or tblfeedback.strbusinessname='Metro Music' or tblfeedback.strbusinessname='Metro Music') and year(getdate())-year(dtmadded)<=15
Rating
Mick's Mobile Disco
Townsville QLD 4810
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=16116 or tblfeedback.strbusinessname='Mick's Mobile Disco' or tblfeedback.strbusinessname='Mick's Mobile Disco') and year(getdate())-year(dtmadded)<=15
Rating
Move 'N' Groove
Townsville QLD 4810
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=16118 or tblfeedback.strbusinessname='Move 'N' Groove' or tblfeedback.strbusinessname='Move 'N' Groove') and year(getdate())-year(dtmadded)<=15
Rating
New Wave Entertainment
Kirwan QLD 4817
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=16124 or tblfeedback.strbusinessname='New Wave Entertainment' or tblfeedback.strbusinessname='New Wave Entertainment') and year(getdate())-year(dtmadded)<=15
Rating
NQ Live on Stage
Townsville QLD 4810
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=16127 or tblfeedback.strbusinessname='NQ Live on Stage' or tblfeedback.strbusinessname='NQ Live on Stage') and year(getdate())-year(dtmadded)<=15
Rating
Pinky's
Townsville QLD 4810
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=16133 or tblfeedback.strbusinessname='Pinky's' or tblfeedback.strbusinessname='Pinky's') and year(getdate())-year(dtmadded)<=15
Rating
Poole's of Music
Townsville QLD 4810
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=16134 or tblfeedback.strbusinessname='Poole's of Music' or tblfeedback.strbusinessname='Poole's of Music') and year(getdate())-year(dtmadded)<=15
Rating
Sera-Jane
Townsville QLD 4810
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=16141 or tblfeedback.strbusinessname='Sera-Jane' or tblfeedback.strbusinessname='Sera-Jane') and year(getdate())-year(dtmadded)<=15
Rating
Talkin' Audio
Hermit Park QLD 4812
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=16145 or tblfeedback.strbusinessname='Talkin' Audio' or tblfeedback.strbusinessname='Talkin' Audio') and year(getdate())-year(dtmadded)<=15
Rating
Theme Magic
Smithfield QLD 4878
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=16146 or tblfeedback.strbusinessname='Theme Magic' or tblfeedback.strbusinessname='Theme Magic') and year(getdate())-year(dtmadded)<=15
Rating
Twisted Sisters The
Jensen QLD 4818
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=16148 or tblfeedback.strbusinessname='Twisted Sisters The' or tblfeedback.strbusinessname='Twisted Sisters The') and year(getdate())-year(dtmadded)<=15
Rating
Wedding Music Church & Reception
Douglas QLD 4814
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=16154 or tblfeedback.strbusinessname='Wedding Music Church & Reception' or tblfeedback.strbusinessname='Wedding Music Church & Reception') and year(getdate())-year(dtmadded)<=15
Rating
Paul James Mobile DJ
Gordonvale QLD 4865
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=18977 or tblfeedback.strbusinessname='Paul James Mobile DJ' or tblfeedback.strbusinessname='Paul James Mobile DJ') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Poole's of Music
Rising Sun QLD 4811
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=18979 or tblfeedback.strbusinessname='Poole's of Music' or tblfeedback.strbusinessname='Poole's of Music') and year(getdate())-year(dtmadded)<=15
Rating
Cairns Brass Inc
Parramatta Park QLD 4870
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=2382 or tblfeedback.strbusinessname='Cairns Brass Inc' or tblfeedback.strbusinessname='Cairns Brass Inc') and year(getdate())-year(dtmadded)<=15