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 AES Online
AES Online
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=19867 or tblfeedback.strbusinessname='AES Online' or tblfeedback.strbusinessname='AES Online') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Awesome entertainers tailored for your wedding.
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
Kiss Entertainment
Cragieburn VIC 3064
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=29546 or tblfeedback.strbusinessname='Kiss Entertainment' or tblfeedback.strbusinessname='Kiss Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
CCM
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=29516 or tblfeedback.strbusinessname='CCM' or tblfeedback.strbusinessname='CCM') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lark Music
Melbourne VIC 3031
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=26900 or tblfeedback.strbusinessname='Lark Music' or tblfeedback.strbusinessname='Lark Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Paris by Night
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=22546 or tblfeedback.strbusinessname='Paris by Night' or tblfeedback.strbusinessname='Paris by Night') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mercury DJ Hire
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=37604 or tblfeedback.strbusinessname='Mercury DJ Hire' or tblfeedback.strbusinessname='Mercury DJ Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A to Z Disco Services
Mernda VIC 3754
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=25316 or tblfeedback.strbusinessname='A to Z Disco Services' or tblfeedback.strbusinessname='A to Z Disco Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wooshka Photobooths
Lara VIC 3212
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=26945 or tblfeedback.strbusinessname='Wooshka Photobooths' or tblfeedback.strbusinessname='Wooshka Photobooths') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Something To Talk About - The Band
Melbourne VIC 3006
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=21870 or tblfeedback.strbusinessname='Something To Talk About - The Band' or tblfeedback.strbusinessname='Something To Talk About - The Band') 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
The Bombastics
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=24241 or tblfeedback.strbusinessname='The Bombastics' or tblfeedback.strbusinessname='The Bombastics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Aaron Murray
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=36301 or tblfeedback.strbusinessname='Aaron Murray' or tblfeedback.strbusinessname='Aaron Murray') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jay Ess Events
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=29909 or tblfeedback.strbusinessname='Jay Ess Events' or tblfeedback.strbusinessname='Jay Ess Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Baker Boys
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=27659 or tblfeedback.strbusinessname='Baker Boys' or tblfeedback.strbusinessname='Baker Boys') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brentwood Acoustic Duo
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=20902 or tblfeedback.strbusinessname='Brentwood Acoustic Duo' or tblfeedback.strbusinessname='Brentwood Acoustic Duo') 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
Rutherford Entertainment
Port Melbourne VIC 3207
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=37559 or tblfeedback.strbusinessname='Rutherford Entertainment' or tblfeedback.strbusinessname='Rutherford Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Something Borrowed
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=28996 or tblfeedback.strbusinessname='Something Borrowed' or tblfeedback.strbusinessname='Something Borrowed') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The White Tree
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=24641 or tblfeedback.strbusinessname='The White Tree' or tblfeedback.strbusinessname='The White Tree') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Platinum Events
Brunswick VIC 3056
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=29887 or tblfeedback.strbusinessname='Platinum Events' or tblfeedback.strbusinessname='Platinum Events') 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=24212 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
Jimmy & Niki Entertainment
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=25572 or tblfeedback.strbusinessname='Jimmy &%%semi%% Niki Entertainment' or tblfeedback.strbusinessname='Jimmy & Niki Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ei8ht entertainment
Tarneit VIC 3029
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=26488 or tblfeedback.strbusinessname='Ei8ht entertainment' or tblfeedback.strbusinessname='Ei8ht entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chas D
Mornington VIC 3931
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=27845 or tblfeedback.strbusinessname='Chas D' or tblfeedback.strbusinessname='Chas D') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Melbourne DJ Services
Ashburton VIC 3147
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=26374 or tblfeedback.strbusinessname='Melbourne DJ Services' or tblfeedback.strbusinessname='Melbourne DJ Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Whiskey Gypsies
Rosebud VIC 3939
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=25802 or tblfeedback.strbusinessname='The Whiskey Gypsies' or tblfeedback.strbusinessname='The Whiskey Gypsies') 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
Music with Memories
Mount Evelyn VIC 3796
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=22725 or tblfeedback.strbusinessname='Music with Memories' or tblfeedback.strbusinessname='Music with Memories') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Swipe Right
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=36344 or tblfeedback.strbusinessname='Swipe Right' or tblfeedback.strbusinessname='Swipe Right') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Le Grand Style Weddings
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=25624 or tblfeedback.strbusinessname='Le Grand Style Weddings' or tblfeedback.strbusinessname='Le Grand Style Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Speechless
Mont Albert VIC 3127
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=13626 or tblfeedback.strbusinessname='Speechless' or tblfeedback.strbusinessname='Speechless') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Magnet
LowerPlenty VIC 3093
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=17799 or tblfeedback.strbusinessname='Magnet' or tblfeedback.strbusinessname='Magnet') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jazz Groups for Hire
Mount Waverley VIC 3149
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=13613 or tblfeedback.strbusinessname='Jazz Groups for Hire' or tblfeedback.strbusinessname='Jazz Groups for Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Melody Line
MontAlbert VIC 3127
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=17892 or tblfeedback.strbusinessname='The Melody Line' or tblfeedback.strbusinessname='The Melody Line') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wedding Songs
Fitzroy VIC 3065
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=13632 or tblfeedback.strbusinessname='Wedding Songs' or tblfeedback.strbusinessname='Wedding Songs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Well Said
Bulleen VIC 3105
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=13633 or tblfeedback.strbusinessname='Well Said' or tblfeedback.strbusinessname='Well Said') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classical & Celtic Music by Mesaja
Hawthorn VIC 3122
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=13596 or tblfeedback.strbusinessname='Classical &%%semi%% Celtic Music by Mesaja' or tblfeedback.strbusinessname='Classical & Celtic Music by Mesaja') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
AAA Function Bands
Albert Park VIC 3206
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=13580 or tblfeedback.strbusinessname='AAA Function Bands' or tblfeedback.strbusinessname='AAA Function Bands') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blake School of Music
Camberwell VIC 3124
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=13589 or tblfeedback.strbusinessname='Blake School of Music' or tblfeedback.strbusinessname='Blake School of Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
AA Focus Entertainment Consultants Pty Ltd
Essendon VIC 3040
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=13579 or tblfeedback.strbusinessname='AA Focus Entertainment Consultants Pty Ltd' or tblfeedback.strbusinessname='AA Focus Entertainment Consultants Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Take Two String Duo
Richmond VIC 3121
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=13627 or tblfeedback.strbusinessname='Take Two String Duo' or tblfeedback.strbusinessname='Take Two String Duo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
As Good As It Gets
Melbourne VIC 3041
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=17683 or tblfeedback.strbusinessname='As Good As It Gets' or tblfeedback.strbusinessname='As Good As It Gets') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stiletto Sisters
Prahran VIC 3181
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=5201 or tblfeedback.strbusinessname='Stiletto Sisters' or tblfeedback.strbusinessname='Stiletto Sisters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bandshop, Paul Shirley Trio
Malvern VIC 3144
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=18200 or tblfeedback.strbusinessname='Bandshop, Paul Shirley Trio' or tblfeedback.strbusinessname='Bandshop, Paul Shirley Trio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
In The Mood
Brunswick VIC 3056
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=17770 or tblfeedback.strbusinessname='In The Mood' or tblfeedback.strbusinessname='In The Mood') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Magnet Duo
Lower Plenty VIC 3093
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=18241 or tblfeedback.strbusinessname='Magnet Duo' or tblfeedback.strbusinessname='Magnet Duo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Bell Birds
Blackburn North VIC 3130
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=13631 or tblfeedback.strbusinessname='Wedding Bell Birds' or tblfeedback.strbusinessname='Wedding Bell Birds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 94 Sort search results alphabetically