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
Black Cherry 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=44115 or tblfeedback.strbusinessname='Black Cherry Events' or tblfeedback.strbusinessname='Black Cherry Events') 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
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
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
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
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
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
The Neopolitans
Naracoorte SA 5271
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=41640 or tblfeedback.strbusinessname='The Neopolitans' or tblfeedback.strbusinessname='The Neopolitans') 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
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
Avid Entertainment
Adelaide 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=44190 or tblfeedback.strbusinessname='Avid Entertainment' or tblfeedback.strbusinessname='Avid Entertainment') 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
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
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
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
Adelaide String Duo
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=44046 or tblfeedback.strbusinessname='Adelaide String Duo' or tblfeedback.strbusinessname='Adelaide String Duo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Look Hear 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=43680 or tblfeedback.strbusinessname='Look Hear Entertainment' or tblfeedback.strbusinessname='Look Hear Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Josh Phillips Music
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=43749 or tblfeedback.strbusinessname='Josh Phillips Music' or tblfeedback.strbusinessname='Josh Phillips Music') 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
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
Double Trouble 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=43272 or tblfeedback.strbusinessname='Double Trouble Entertainment' or tblfeedback.strbusinessname='Double Trouble Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
All about her
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=42988 or tblfeedback.strbusinessname='All about her' or tblfeedback.strbusinessname='All about her') 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
Dave Milne Roadshow
Morphett Vale SA 5162
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=5904 or tblfeedback.strbusinessname='Dave Milne Roadshow' or tblfeedback.strbusinessname='Dave Milne Roadshow') 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
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 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
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
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
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
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
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
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
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
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
Rating
Rhapsody II
Morphett Vale SA 5162
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=6330 or tblfeedback.strbusinessname='Rhapsody II' or tblfeedback.strbusinessname='Rhapsody II') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Clarinettes The
Prospect SA 5082
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=6310 or tblfeedback.strbusinessname='Clarinettes The' or tblfeedback.strbusinessname='Clarinettes The') 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
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
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
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
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
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
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
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
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
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
Harp for All Occasions
Eden Hills SA 5050
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=6317 or tblfeedback.strbusinessname='Harp for All Occasions' or tblfeedback.strbusinessname='Harp for All Occasions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 62 Sort search results alphabetically