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 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.
Rating Baker Boys Band
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
star ratingstar ratingstar ratingstar ratingstar rating
Baker Boys Band is different. High-energy music for your wedding.

Rating The Famos & Co
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

Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
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
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
Rating
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
Rating
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
Rating
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
Rating
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
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
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
Rating
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
Rating
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
Rating
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
Rating
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
Rating
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
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
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
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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
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
Rating
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
Rating
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
Rating
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
Rating
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
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
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
Rating
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
Rating
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
Rating
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
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 &%%semi%% Reception' or tblfeedback.strbusinessname='Wedding Music Church & Reception') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
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
Rating
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
Rating
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