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
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
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
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
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
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
Rating
Josie 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='Josie Arnold Wedding Celebrant' or tblfeedback.strbusinessname='Josie Arnold Wedding Celebrant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ellson
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=6780 or tblfeedback.strbusinessname='Ellson' or tblfeedback.strbusinessname='Ellson') 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
David Williams
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=4494 or tblfeedback.strbusinessname='David Williams' or tblfeedback.strbusinessname='David Williams') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dobbin Meryl G
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=4499 or tblfeedback.strbusinessname='Dobbin Meryl G' or tblfeedback.strbusinessname='Dobbin Meryl G') 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
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
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
Pilatti Phyllis JP
Collie WA 6225
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=4589 or tblfeedback.strbusinessname='Pilatti Phyllis JP' or tblfeedback.strbusinessname='Pilatti Phyllis JP') 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
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
Andrews Heather
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=4454 or tblfeedback.strbusinessname='Andrews Heather' or tblfeedback.strbusinessname='Andrews Heather') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gurney
Glen Forrest 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=6792 or tblfeedback.strbusinessname='Gurney' or tblfeedback.strbusinessname='Gurney') 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
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
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
Wignall Olga
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=4613 or tblfeedback.strbusinessname='Wignall Olga' or tblfeedback.strbusinessname='Wignall Olga') 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
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
Hill Allan
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=4541 or tblfeedback.strbusinessname='Hill Allan' or tblfeedback.strbusinessname='Hill Allan') 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
Besley Dawn
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=4465 or tblfeedback.strbusinessname='Besley Dawn' or tblfeedback.strbusinessname='Besley Dawn') 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
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
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
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
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
Rating
Lawrence Lockyear JP
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=4561 or tblfeedback.strbusinessname='Lawrence Lockyear JP' or tblfeedback.strbusinessname='Lawrence Lockyear JP') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kate Joyce
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=4551 or tblfeedback.strbusinessname='Kate Joyce' or tblfeedback.strbusinessname='Kate Joyce') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mc Cleary
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=6816 or tblfeedback.strbusinessname='Mc Cleary' or tblfeedback.strbusinessname='Mc Cleary') 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
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
Briegel Elza
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=4472 or tblfeedback.strbusinessname='Briegel Elza' or tblfeedback.strbusinessname='Briegel Elza') 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
Mills
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=6819 or tblfeedback.strbusinessname='Mills' or tblfeedback.strbusinessname='Mills') 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
Munn Jeff
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=4578 or tblfeedback.strbusinessname='Munn Jeff' or tblfeedback.strbusinessname='Munn Jeff') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brady
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=6744 or tblfeedback.strbusinessname='Brady' or tblfeedback.strbusinessname='Brady') 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
Ewers-Ferge
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=4511 or tblfeedback.strbusinessname='Ewers-Ferge' or tblfeedback.strbusinessname='Ewers-Ferge') 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
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
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
Dent
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=6769 or tblfeedback.strbusinessname='Dent' or tblfeedback.strbusinessname='Dent') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 81 Sort search results alphabetically