Home > Wedding Celebrants South Western

Wedding Celebrants South Western

81 result(s) found. RatingView Your Favorites List

Rating Sarahmonies
Sarahmonies
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=19930 or tblfeedback.strbusinessname='Sarahmonies' or tblfeedback.strbusinessname='Sarahmonies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Traditional or different, happy to go with the flow.
Rating
Meant For You
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=27330 or tblfeedback.strbusinessname='Meant For You' or tblfeedback.strbusinessname='Meant For You') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Michelle Cooke
Margaret River WA 6285
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=37633 or tblfeedback.strbusinessname='Michelle Cooke' or tblfeedback.strbusinessname='Michelle Cooke') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Great Southern Celebrants - Margie Ward
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=29259 or tblfeedback.strbusinessname='Great Southern Celebrants - Margie Ward' or tblfeedback.strbusinessname='Great Southern Celebrants - Margie Ward') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Alexis Woolhead
Bunbury WA 6230
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=29230 or tblfeedback.strbusinessname='Alexis Woolhead' or tblfeedback.strbusinessname='Alexis Woolhead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
2 reviews
Rating
Josephine Arnold Wedding Celebrant
Reinscourt WA 6280
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=22077 or tblfeedback.strbusinessname='Josephine Arnold Wedding Celebrant' or tblfeedback.strbusinessname='Josephine Arnold Wedding Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
2 reviews
Rating
Margaret River Elopements
Dunsborough WA 6281
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=27728 or tblfeedback.strbusinessname='Margaret River Elopements' or tblfeedback.strbusinessname='Margaret River Elopements') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Besley
Narrogin WA 6312
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=6742 or tblfeedback.strbusinessname='Besley' or tblfeedback.strbusinessname='Besley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cole
Denmark WA 6333
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=6761 or tblfeedback.strbusinessname='Cole' or tblfeedback.strbusinessname='Cole') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Argentino Loris
Safety Bay WA 6169
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=4456 or tblfeedback.strbusinessname='Argentino Loris' or tblfeedback.strbusinessname='Argentino Loris') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Briegel
York WA 6302
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=6747 or tblfeedback.strbusinessname='Briegel' or tblfeedback.strbusinessname='Briegel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harrison
Mount Nasura WA 6112
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=6794 or tblfeedback.strbusinessname='Harrison' or tblfeedback.strbusinessname='Harrison') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
David Nelson
Calista WA 6167
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=4493 or tblfeedback.strbusinessname='David Nelson' or tblfeedback.strbusinessname='David Nelson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
David
Calista WA 6167
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=6766 or tblfeedback.strbusinessname='David' or tblfeedback.strbusinessname='David') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Davies
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=6768 or tblfeedback.strbusinessname='Davies' or tblfeedback.strbusinessname='Davies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harrison Dorothy
Mt Nasura ACT 6112
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=4537 or tblfeedback.strbusinessname='Harrison Dorothy' or tblfeedback.strbusinessname='Harrison Dorothy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Reg Oakes
Mahogany Creek WA 6072
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=4591 or tblfeedback.strbusinessname='Reg Oakes' or tblfeedback.strbusinessname='Reg Oakes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Owen Davies
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=6824 or tblfeedback.strbusinessname='Owen Davies' or tblfeedback.strbusinessname='Owen Davies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
3 reviews
Rating
Margaret Kay Cole
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=4571 or tblfeedback.strbusinessname='Margaret Kay Cole' or tblfeedback.strbusinessname='Margaret Kay Cole') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dent Maggie
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=4497 or tblfeedback.strbusinessname='Dent Maggie' or tblfeedback.strbusinessname='Dent Maggie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Besley
Safety Bay WA 6169
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=6741 or tblfeedback.strbusinessname='Besley' or tblfeedback.strbusinessname='Besley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ellson, Peter Jeffrey
Pelican Point WA 6230
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=4506 or tblfeedback.strbusinessname='Ellson, Peter Jeffrey' or tblfeedback.strbusinessname='Ellson, Peter Jeffrey') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Annette Johnston
Donnybrook WA 6239
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=6733 or tblfeedback.strbusinessname='Annette Johnston' or tblfeedback.strbusinessname='Annette Johnston') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tieleman Wiebe & Associates
Bickley 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=4605 or tblfeedback.strbusinessname='Tieleman Wiebe &%%semi%% Associates' or tblfeedback.strbusinessname='Tieleman Wiebe & Associates') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Terri Kinsella
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=17586 or tblfeedback.strbusinessname='Terri Kinsella' or tblfeedback.strbusinessname='Terri Kinsella') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
1 stars
1 review
Rating
Carol Astbury
Hovea WA 6071
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=4482 or tblfeedback.strbusinessname='Carol Astbury' or tblfeedback.strbusinessname='Carol Astbury') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Smith Joy
Dunsborough WA 6281
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=4597 or tblfeedback.strbusinessname='Smith Joy' or tblfeedback.strbusinessname='Smith Joy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dobbin
Nannup WA 6275
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=6771 or tblfeedback.strbusinessname='Dobbin' or tblfeedback.strbusinessname='Dobbin') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jeff Munn
Armadale WA 6112
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=4544 or tblfeedback.strbusinessname='Jeff Munn' or tblfeedback.strbusinessname='Jeff Munn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Joyce Kate
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=6804 or tblfeedback.strbusinessname='Joyce Kate' or tblfeedback.strbusinessname='Joyce Kate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cole Marjorie
Denmark WA 6333
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=4487 or tblfeedback.strbusinessname='Cole Marjorie' or tblfeedback.strbusinessname='Cole Marjorie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shepherd Bill
Safety Bay WA 6169
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=4595 or tblfeedback.strbusinessname='Shepherd Bill' or tblfeedback.strbusinessname='Shepherd Bill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
O'Hara
York WA 6302
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=6822 or tblfeedback.strbusinessname='O'%%semi%%Hara' or tblfeedback.strbusinessname='O'Hara') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Owen Davies
Kelmscot 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=4583 or tblfeedback.strbusinessname='Owen Davies' or tblfeedback.strbusinessname='Owen Davies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
3 reviews
Rating
McCleary Gwen
Brunswick Junction WA 6224
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=4574 or tblfeedback.strbusinessname='McCleary Gwen' or tblfeedback.strbusinessname='McCleary Gwen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Iturbide T K
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=4543 or tblfeedback.strbusinessname='Iturbide T K' or tblfeedback.strbusinessname='Iturbide T K') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Loughton Peter
Kinross WA 6028
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=4566 or tblfeedback.strbusinessname='Loughton Peter' or tblfeedback.strbusinessname='Loughton Peter') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
O'Hara Tony
York WA 6302
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=4581 or tblfeedback.strbusinessname='O'%%semi%%Hara Tony' or tblfeedback.strbusinessname='O'Hara Tony') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Margaret Mc Kay
Darlington WA 6070
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=6814 or tblfeedback.strbusinessname='Margaret Mc Kay' or tblfeedback.strbusinessname='Margaret Mc Kay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sayers
Busselton WA 6280
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=6833 or tblfeedback.strbusinessname='Sayers' or tblfeedback.strbusinessname='Sayers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Joan Kent J P
Busselton WA 6280
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=6802 or tblfeedback.strbusinessname='Joan Kent J P' or tblfeedback.strbusinessname='Joan Kent J P') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Payton Coral
Bunbury WA 6230
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=4585 or tblfeedback.strbusinessname='Payton Coral' or tblfeedback.strbusinessname='Payton Coral') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jennifer Etherington
Dunsborough WA 6281
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=17582 or tblfeedback.strbusinessname='Jennifer Etherington' or tblfeedback.strbusinessname='Jennifer Etherington') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
4.67 stars
3 reviews
Rating
Brady Colleen
Wooroloo WA 6558
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=4469 or tblfeedback.strbusinessname='Brady Colleen' or tblfeedback.strbusinessname='Brady Colleen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wignall
Mundaring WA 6073
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=6849 or tblfeedback.strbusinessname='Wignall' or tblfeedback.strbusinessname='Wignall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Johnstone Peg
Manjimup WA 6258
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=4548 or tblfeedback.strbusinessname='Johnstone Peg' or tblfeedback.strbusinessname='Johnstone Peg') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shepherd
Safety Bay WA 6169
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=6835 or tblfeedback.strbusinessname='Shepherd' or tblfeedback.strbusinessname='Shepherd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mills Arthur
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=4577 or tblfeedback.strbusinessname='Mills Arthur' or tblfeedback.strbusinessname='Mills Arthur') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hill
Safety Bay WA 6169
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=6798 or tblfeedback.strbusinessname='Hill' or tblfeedback.strbusinessname='Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lawrence (Larry) Lockyear JP
Kalamunda 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=4560 or tblfeedback.strbusinessname='Lawrence (%%semi%%Larry)%%semi%% Lockyear JP' or tblfeedback.strbusinessname='Lawrence (Larry) Lockyear JP') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 81 Sort search results alphabetically