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
Griffin Alliance
Adelaide SA 5000
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=36351 or tblfeedback.strbusinessname='Griffin Alliance' or tblfeedback.strbusinessname='Griffin Alliance') 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
Entertainment Adelaide
Adelaide SA 5000
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=37528 or tblfeedback.strbusinessname='Entertainment Adelaide' or tblfeedback.strbusinessname='Entertainment Adelaide') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Down South DJs
Christies Beach SA 5165
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=35694 or tblfeedback.strbusinessname='Down South DJs' or tblfeedback.strbusinessname='Down South DJs') 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
Afterdark Entertainment
Renmark SA 5341
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=27456 or tblfeedback.strbusinessname='Afterdark Entertainment' or tblfeedback.strbusinessname='Afterdark Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Entertainment Adelaide
Adelaide SA 5000
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=37520 or tblfeedback.strbusinessname='Entertainment Adelaide' or tblfeedback.strbusinessname='Entertainment Adelaide') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Little Big Words
Adelaide SA 5095
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=26276 or tblfeedback.strbusinessname='Little Big Words' or tblfeedback.strbusinessname='Little Big Words') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Middleton Events
Adelaide SA 5001
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=24608 or tblfeedback.strbusinessname='Middleton Events' or tblfeedback.strbusinessname='Middleton Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Elevate Entertainment
Adelaide SA 5000
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=37879 or tblfeedback.strbusinessname='Elevate Entertainment' or tblfeedback.strbusinessname='Elevate Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Steve Locke Events
Adelaide SA 5000
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=26903 or tblfeedback.strbusinessname='Steve Locke Events' or tblfeedback.strbusinessname='Steve Locke Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kat Reynor
Adelaide SA 5000
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=26037 or tblfeedback.strbusinessname='Kat Reynor' or tblfeedback.strbusinessname='Kat Reynor') 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
Middleton Events
Adelaide SA 5000
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=22873 or tblfeedback.strbusinessname='Middleton Events' or tblfeedback.strbusinessname='Middleton Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Party Machine
Wattle Park SA 5066
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=6326 or tblfeedback.strbusinessname='Party Machine' or tblfeedback.strbusinessname='Party Machine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prosound Entertainment
Gawler SA 5118
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=6328 or tblfeedback.strbusinessname='Prosound Entertainment' or tblfeedback.strbusinessname='Prosound Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cantabile Singers
Magill SA 5072
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=6309 or tblfeedback.strbusinessname='Cantabile Singers' or tblfeedback.strbusinessname='Cantabile Singers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Entertainment People
Adelaide SA 5024
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=19225 or tblfeedback.strbusinessname='The Entertainment People' or tblfeedback.strbusinessname='The Entertainment People') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Meg Tucker
Kensington SA 5068
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=6322 or tblfeedback.strbusinessname='Meg Tucker' or tblfeedback.strbusinessname='Meg Tucker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Don Plenty
Unley SA 5061
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=6313 or tblfeedback.strbusinessname='Don Plenty' or tblfeedback.strbusinessname='Don Plenty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Bell Entertainment
Payneham SA 5070
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=6337 or tblfeedback.strbusinessname='Wedding Bell Entertainment' or tblfeedback.strbusinessname='Wedding Bell Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adelaide String Quartet & Ensembles
Brighton SA 5048
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=6305 or tblfeedback.strbusinessname='Adelaide String Quartet &%%semi%% Ensembles' or tblfeedback.strbusinessname='Adelaide String Quartet & Ensembles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Amicus Strings
Glen Osmond SA 5064
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=14971 or tblfeedback.strbusinessname='The Amicus Strings' or tblfeedback.strbusinessname='The Amicus Strings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prosound
Gawler SA 5118
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=19176 or tblfeedback.strbusinessname='Prosound' or tblfeedback.strbusinessname='Prosound') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Somers Entertainment
Adelaide SA 5000
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=19201 or tblfeedback.strbusinessname='Somers Entertainment' or tblfeedback.strbusinessname='Somers Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Messenger Music
O'Halloran Hill SA 5158
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=6324 or tblfeedback.strbusinessname='Messenger Music' or tblfeedback.strbusinessname='Messenger Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Entertainment People The
Semaphore Park SA 5019
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=6314 or tblfeedback.strbusinessname='Entertainment People The' or tblfeedback.strbusinessname='Entertainment People The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fine Music Ensembles
Mitcham SA 5062
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=6315 or tblfeedback.strbusinessname='Fine Music Ensembles' or tblfeedback.strbusinessname='Fine Music Ensembles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Distinctive Disc Jockeys
Salisbury SA 5108
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=6312 or tblfeedback.strbusinessname='Distinctive Disc Jockeys' or tblfeedback.strbusinessname='Distinctive Disc Jockeys') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Church Wedding Vocalist
North Plympton SA 5037
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=17299 or tblfeedback.strbusinessname='Church Wedding Vocalist' or tblfeedback.strbusinessname='Church Wedding Vocalist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Airplay Duo
Cumberland Park SA 5041
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=6307 or tblfeedback.strbusinessname='Airplay Duo' or tblfeedback.strbusinessname='Airplay Duo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Affordable Professional DJ
Rosslyn Park SA 5072
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=6306 or tblfeedback.strbusinessname='Affordable Professional DJ' or tblfeedback.strbusinessname='Affordable Professional DJ') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hilary O'Neill
Maylands SA 5069
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=6319 or tblfeedback.strbusinessname='Hilary O'%%semi%%Neill' or tblfeedback.strbusinessname='Hilary O'Neill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Singer The
Adelaide SA 5000
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=6338 or tblfeedback.strbusinessname='Wedding Singer The' or tblfeedback.strbusinessname='Wedding Singer The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Liesl Warner
Semaphore SA 5019
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=6320 or tblfeedback.strbusinessname='Liesl Warner' or tblfeedback.strbusinessname='Liesl Warner') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Stuart Alexander Entertainment
Greenacres SA 5086
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=6336 or tblfeedback.strbusinessname='Stuart Alexander Entertainment' or tblfeedback.strbusinessname='Stuart Alexander Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Memory Lane Strings
Beaumont SA 5066
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=6323 or tblfeedback.strbusinessname='Memory Lane Strings' or tblfeedback.strbusinessname='Memory Lane Strings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Garry Case School of Dancing
Joslin SA 5070
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=6316 or tblfeedback.strbusinessname='Garry Case School of Dancing' or tblfeedback.strbusinessname='Garry Case School of Dancing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Telegrams
Highbury SA 5089
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=6339 or tblfeedback.strbusinessname='Wedding Telegrams' or tblfeedback.strbusinessname='Wedding Telegrams') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Beautiful Sound
Adelaide SA 5000
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=6303 or tblfeedback.strbusinessname='A Beautiful Sound' or tblfeedback.strbusinessname='A Beautiful Sound') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adelaide Disc Jockeys
Parafield Gardens SA 5107
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=6304 or tblfeedback.strbusinessname='Adelaide Disc Jockeys' or tblfeedback.strbusinessname='Adelaide Disc Jockeys') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Detone Promotions
Athelstone SA 5076
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=6311 or tblfeedback.strbusinessname='Detone Promotions' or tblfeedback.strbusinessname='Detone Promotions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Quality ACTS
Hectorville SA 5073
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=6329 or tblfeedback.strbusinessname='Quality ACTS' or tblfeedback.strbusinessname='Quality ACTS') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Omni Entertainment
Oaklands Park SA 5046
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=6325 or tblfeedback.strbusinessname='Omni Entertainment' or tblfeedback.strbusinessname='Omni Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Little Tony Vocalist Entertainer
Modbury Heights SA 5092
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=6321 or tblfeedback.strbusinessname='Little Tony Vocalist Entertainer' or tblfeedback.strbusinessname='Little Tony Vocalist Entertainer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sound Connection The
Hope Valley SA 5090
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=6333 or tblfeedback.strbusinessname='Sound Connection The' or tblfeedback.strbusinessname='Sound Connection The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Specialty Tracks
Hectorville SA 5073
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=6334 or tblfeedback.strbusinessname='Specialty Tracks' or tblfeedback.strbusinessname='Specialty Tracks') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Occasions Entertainment
Dulwich SA 5065
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=6308 or tblfeedback.strbusinessname='All Occasions Entertainment' or tblfeedback.strbusinessname='All Occasions Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
SA Wedding & Party Entertainment
Fullarton SA 5063
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=6332 or tblfeedback.strbusinessname='SA Wedding &%%semi%% Party Entertainment' or tblfeedback.strbusinessname='SA Wedding & Party Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 54 Sort search results alphabetically