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 canapes, 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.
Baker Boys 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=19755 or tblfeedback.strbusinessname='Baker Boys Band' or tblfeedback.strbusinessname='Baker Boys Band') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Baker Boys Band is different. High-energy music for your wedding.
The Famos & Co
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=46723 or tblfeedback.strbusinessname='The Famos &%%semi%% Co' or tblfeedback.strbusinessname='The Famos & Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A Queensland based music agency offering top-quality live musicians, duos, & DJs
Mattyboi Entertainment
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=41633 or tblfeedback.strbusinessname='Mattyboi Entertainment' or tblfeedback.strbusinessname='Mattyboi Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Colliers Entertainment Wedding DJ MC Photobooths
Wamuran QLD 4512
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=44585 or tblfeedback.strbusinessname='Colliers Entertainment Wedding DJ MC Photobooths' or tblfeedback.strbusinessname='Colliers Entertainment Wedding DJ MC Photobooths') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Cassidy Mackie Music
Hervey Bay QLD 4655
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=46537 or tblfeedback.strbusinessname='Cassidy Mackie Music' or tblfeedback.strbusinessname='Cassidy Mackie Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Chris Schick Acoustics
Rockhampton QLD 4700
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=43699 or tblfeedback.strbusinessname='Chris Schick Acoustics' or tblfeedback.strbusinessname='Chris Schick Acoustics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Joseph Maloney music
Theodore QLD 4719
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=25860 or tblfeedback.strbusinessname='Joseph Maloney music' or tblfeedback.strbusinessname='Joseph Maloney music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Fox
The Whitsundays, Airlie Beach QLD 4802
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=29678 or tblfeedback.strbusinessname='The Fox' or tblfeedback.strbusinessname='The Fox') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Light Em Up Fireworks
Bundaberg QLD 4670
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=42871 or tblfeedback.strbusinessname='Light Em Up Fireworks' or tblfeedback.strbusinessname='Light Em Up Fireworks') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Steve Jay Live Music
Gladstone QLD 4680
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=16142 or tblfeedback.strbusinessname='Steve Jay Live Music' or tblfeedback.strbusinessname='Steve Jay Live Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Powerwave Audio
Rockhampton QLD 4700
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=16135 or tblfeedback.strbusinessname='Powerwave Audio' or tblfeedback.strbusinessname='Powerwave Audio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hi-R Fidelity
Gladstone QLD 4680
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=16105 or tblfeedback.strbusinessname='Hi-R Fidelity' or tblfeedback.strbusinessname='Hi-R Fidelity') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
No Strings Attached
Gladstone QLD 4680
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=16126 or tblfeedback.strbusinessname='No Strings Attached' or tblfeedback.strbusinessname='No Strings Attached') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Weddings Party's Everything
Hervey Bay QLD 4655
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=16155 or tblfeedback.strbusinessname='Weddings Party'%%semi%%s Everything' or tblfeedback.strbusinessname='Weddings Party's Everything') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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'%%semi%% Audio' or tblfeedback.strbusinessname='Talkin' Audio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Blue Water Sound & Lighting
Mackay QLD 4740
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=16072 or tblfeedback.strbusinessname='Blue Water Sound &%%semi%% Lighting' or tblfeedback.strbusinessname='Blue Water Sound & Lighting') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Alicia Casey
Mackay QLD 4740
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=16051 or tblfeedback.strbusinessname='Alicia Casey' or tblfeedback.strbusinessname='Alicia Casey') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rule Music
Mackay QLD 4740
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=16138 or tblfeedback.strbusinessname='Rule Music' or tblfeedback.strbusinessname='Rule Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
No Strings Attached
Rockhampton QLD 4700
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=16125 or tblfeedback.strbusinessname='No Strings Attached' or tblfeedback.strbusinessname='No Strings Attached') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mackay Mobile Music
Mackay QLD 4740
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=16111 or tblfeedback.strbusinessname='Mackay Mobile Music' or tblfeedback.strbusinessname='Mackay Mobile Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
B & C Disco
Bundaberg QLD 4670
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=16060 or tblfeedback.strbusinessname='B &%%semi%% C Disco' or tblfeedback.strbusinessname='B & C Disco') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Billy the Mountain Entertainments & Video Productions
Yeppoon QLD 4703
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=16069 or tblfeedback.strbusinessname='Billy the Mountain Entertainments &%%semi%% Video Productions' or tblfeedback.strbusinessname='Billy the Mountain Entertainments & Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Beat & Rhythm
Gracemere QLD 4702
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=16063 or tblfeedback.strbusinessname='Beat &%%semi%% Rhythm' or tblfeedback.strbusinessname='Beat & Rhythm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Supreme Sounds
Point Vernon QLD 4655
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=18996 or tblfeedback.strbusinessname='Supreme Sounds' or tblfeedback.strbusinessname='Supreme Sounds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Focus on Weddings
Rockhampton QLD 4700
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=16098 or tblfeedback.strbusinessname='Focus on Weddings' or tblfeedback.strbusinessname='Focus on Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Party Wizards
Torquay QLD 4655
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=16131 or tblfeedback.strbusinessname='Party Wizards' or tblfeedback.strbusinessname='Party Wizards') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Garry O'Shea
Mackay QLD 4740
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=16099 or tblfeedback.strbusinessname='Garry O'%%semi%%Shea' or tblfeedback.strbusinessname='Garry O'Shea') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Boz Sundance Live Music
Gladstone QLD 4680
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=16074 or tblfeedback.strbusinessname='Boz Sundance Live Music' or tblfeedback.strbusinessname='Boz Sundance Live Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jungle Jim
Mackay QLD 4740
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=18954 or tblfeedback.strbusinessname='Jungle Jim' or tblfeedback.strbusinessname='Jungle Jim') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kennedy Amplifier Hire Service
Mackay QLD 4740
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=16108 or tblfeedback.strbusinessname='Kennedy Amplifier Hire Service' or tblfeedback.strbusinessname='Kennedy Amplifier Hire Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 &%%semi%% Reception' or tblfeedback.strbusinessname='Wedding Music Church & Reception') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Traxx Disco
Gladstone QLD 4680
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=16147 or tblfeedback.strbusinessname='Traxx Disco' or tblfeedback.strbusinessname='Traxx Disco') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Girls In Harmony
Mackay QLD 4740
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=16100 or tblfeedback.strbusinessname='Girls In Harmony' or tblfeedback.strbusinessname='Girls In Harmony') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
White Lightning Mobile Nightclub
Gladstone QLD 4680
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=16156 or tblfeedback.strbusinessname='White Lightning Mobile Nightclub' or tblfeedback.strbusinessname='White Lightning Mobile Nightclub') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15