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
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 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
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
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
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
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
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=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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1 - 50 of 61 Sort search results alphabetically