Rating Goldbass Records DJ Services
Goldbass Records DJ Services
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=19507 or tblfeedback.strbusinessname='Goldbass Records DJ Services' or tblfeedback.strbusinessname='Goldbass Records DJ Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Professional DJ Hire, Perth, Broome, Margaret River & WA

Rating
Perth Wedding DJ
Perth WA 6000
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=29889 or tblfeedback.strbusinessname='Perth Wedding DJ' or tblfeedback.strbusinessname='Perth Wedding DJ') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Superior Sounds
Perth WA 6000
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=27569 or tblfeedback.strbusinessname='Superior Sounds' or tblfeedback.strbusinessname='Superior Sounds') 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
Tonita Photo and Video
Perth WA 6006
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=21949 or tblfeedback.strbusinessname='Tonita Photo and Video' or tblfeedback.strbusinessname='Tonita Photo and Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roadshow DJs & Events
Mt Hawthorn WA 6005
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=25303 or tblfeedback.strbusinessname='Roadshow DJs &%%semi%% Events' or tblfeedback.strbusinessname='Roadshow DJs & Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
CSM Weddings
Mandurah WA 6210
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=35796 or tblfeedback.strbusinessname='CSM Weddings' or tblfeedback.strbusinessname='CSM Weddings') 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
Holt Music DJ Services
Huntingdale WA 6110
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=20257 or tblfeedback.strbusinessname='Holt Music DJ Services' or tblfeedback.strbusinessname='Holt Music DJ Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Complete DJ
Osborne Park WA 6017
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=37441 or tblfeedback.strbusinessname='Complete DJ' or tblfeedback.strbusinessname='Complete DJ') 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
Me and the missus
Geraldton WA 6530
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=29628 or tblfeedback.strbusinessname='Me and the missus' or tblfeedback.strbusinessname='Me and the missus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roadshow DJ'S
Osborne Park WA 6017
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=7240 or tblfeedback.strbusinessname='Roadshow DJ'%%semi%%S' or tblfeedback.strbusinessname='Roadshow DJ'S') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Komodo Music
Perth WA 6000
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=37598 or tblfeedback.strbusinessname='Komodo Music' or tblfeedback.strbusinessname='Komodo Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Dinner Singer
Ellenbrook WA 6069
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=21713 or tblfeedback.strbusinessname='The Dinner Singer' or tblfeedback.strbusinessname='The Dinner Singer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Soul Sound DJ's
Perth WA 6000
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=26332 or tblfeedback.strbusinessname='Soul Sound DJ'%%semi%%s' or tblfeedback.strbusinessname='Soul Sound DJ's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jessie Gordon
WA
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=25642 or tblfeedback.strbusinessname='Jessie Gordon' or tblfeedback.strbusinessname='Jessie Gordon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Big Men Working
Albany WA 6330
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=29258 or tblfeedback.strbusinessname='Big Men Working' or tblfeedback.strbusinessname='Big Men Working') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Les Trois Amies
Myaree WA 6154
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=25566 or tblfeedback.strbusinessname='Les Trois Amies' or tblfeedback.strbusinessname='Les Trois Amies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Off The Wall Promotions
Perth WA 6000
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=38048 or tblfeedback.strbusinessname='Off The Wall Promotions' or tblfeedback.strbusinessname='Off The Wall Promotions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Full Noise DJs
Perth WA 6000
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=39782 or tblfeedback.strbusinessname='Full Noise DJs' or tblfeedback.strbusinessname='Full Noise DJs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Party Sounds
Perth WA 6000
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=35674 or tblfeedback.strbusinessname='Party Sounds' or tblfeedback.strbusinessname='Party Sounds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kemistry Sounds
Midland WA 6056
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=35690 or tblfeedback.strbusinessname='Kemistry Sounds' or tblfeedback.strbusinessname='Kemistry Sounds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Big Tommo Presents
Balcatta WA 6027
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=24391 or tblfeedback.strbusinessname='Big Tommo Presents' or tblfeedback.strbusinessname='Big Tommo Presents') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Probeat DJs Perth
Fremantle WA 6160
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=35965 or tblfeedback.strbusinessname='Probeat DJs Perth' or tblfeedback.strbusinessname='Probeat DJs Perth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Dinner Singer
Perth WA 6069
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=25312 or tblfeedback.strbusinessname='The Dinner Singer' or tblfeedback.strbusinessname='The Dinner Singer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Me & the Missus
Geraldton WA 6530
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=27115 or tblfeedback.strbusinessname='Me &%%semi%% the Missus' or tblfeedback.strbusinessname='Me & the Missus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Move DJs
Perth WA 4000
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=26554 or tblfeedback.strbusinessname='Move DJs' or tblfeedback.strbusinessname='Move DJs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
HI TEC Sounds W A
Scarborough WA 6019
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=7231 or tblfeedback.strbusinessname='HI TEC Sounds W A' or tblfeedback.strbusinessname='HI TEC Sounds W A') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Touch of Culture
Willetton WA 6155
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=7200 or tblfeedback.strbusinessname='A Touch of Culture' or tblfeedback.strbusinessname='A Touch of Culture') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Andromeda Sound & Video
Como WA 6152
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=7205 or tblfeedback.strbusinessname='Andromeda Sound &%%semi%% Video' or tblfeedback.strbusinessname='Andromeda Sound & Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Occasion Music
Myaree WA 6154
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=7203 or tblfeedback.strbusinessname='All Occasion Music' or tblfeedback.strbusinessname='All Occasion Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Power Music
Claremont WA 6010
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=17668 or tblfeedback.strbusinessname='Power Music' or tblfeedback.strbusinessname='Power Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cloud Nine Professional D J Service
Lesmurdie WA 6076
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=7212 or tblfeedback.strbusinessname='Cloud Nine Professional D J Service' or tblfeedback.strbusinessname='Cloud Nine Professional D J Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Power Music Productions
Claremont WA 6010
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=7238 or tblfeedback.strbusinessname='Power Music Productions' or tblfeedback.strbusinessname='Power Music Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Disc Jockey Association Inc
Dianella WA 6059
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=7221 or tblfeedback.strbusinessname='Disc Jockey Association Inc' or tblfeedback.strbusinessname='Disc Jockey Association Inc') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Doves for Hire
Redcliffe WA 6104
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=7226 or tblfeedback.strbusinessname='Doves for Hire' or tblfeedback.strbusinessname='Doves for Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sax In the City Duo
Willetton WA 6155
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=7241 or tblfeedback.strbusinessname='Sax In the City Duo' or tblfeedback.strbusinessname='Sax In the City Duo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Combination Sounds
Kelmscott WA 6111
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=7213 or tblfeedback.strbusinessname='Combination Sounds' or tblfeedback.strbusinessname='Combination Sounds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Superior Pyrotechnics
Padbury WA 6025
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=7243 or tblfeedback.strbusinessname='Superior Pyrotechnics' or tblfeedback.strbusinessname='Superior Pyrotechnics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Smooth Music
Morley WA 6111
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=17669 or tblfeedback.strbusinessname='Smooth Music' or tblfeedback.strbusinessname='Smooth Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Celebration Sounds
Ballajura WA 6066
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=7211 or tblfeedback.strbusinessname='Celebration Sounds' or tblfeedback.strbusinessname='Celebration Sounds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fine Music
Gooseberry Hill WA 6076
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=7228 or tblfeedback.strbusinessname='Fine Music' or tblfeedback.strbusinessname='Fine Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sweethearts Music
Leederville WA 6007
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=17671 or tblfeedback.strbusinessname='Sweethearts Music' or tblfeedback.strbusinessname='Sweethearts Music') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pavane & Galliard
Nollamara WA 6061
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=7235 or tblfeedback.strbusinessname='Pavane &%%semi%% Galliard' or tblfeedback.strbusinessname='Pavane & Galliard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Applause Entertainment
Willetton WA 6155
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=17663 or tblfeedback.strbusinessname='Applause Entertainment' or tblfeedback.strbusinessname='Applause Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Easterbrook Mary Organist
Viveash WA 6056
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=7227 or tblfeedback.strbusinessname='Easterbrook Mary Organist' or tblfeedback.strbusinessname='Easterbrook Mary Organist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Perth Pyrotechnics Pty Ltd
Alexander Heights WA 6064
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=7236 or tblfeedback.strbusinessname='Perth Pyrotechnics Pty Ltd' or tblfeedback.strbusinessname='Perth Pyrotechnics Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Da Doo Ron Ron
Mt Lawley WA 6050
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=17664 or tblfeedback.strbusinessname='Da Doo Ron Ron' or tblfeedback.strbusinessname='Da Doo Ron Ron') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Disc Jockey Association
Lesmurdie WA 6076
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=7216 or tblfeedback.strbusinessname='Disc Jockey Association' or tblfeedback.strbusinessname='Disc Jockey Association') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 74 Sort search results alphabetically