Rating Vicki Miller Photography
Vicki Miller Photography
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=23724 or tblfeedback.strbusinessname='Vicki Miller Photography' or tblfeedback.strbusinessname='Vicki Miller Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating

Rating
Samantha Bennett Photography
Warwick QLD 4370
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=27435 or tblfeedback.strbusinessname='Samantha Bennett Photography' or tblfeedback.strbusinessname='Samantha Bennett Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Madelyn Holmes Photographics
Frenchville QLD 4701
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=26616 or tblfeedback.strbusinessname='Madelyn Holmes Photographics' or tblfeedback.strbusinessname='Madelyn Holmes Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Katrina Lehman Photography
Charleville QLD 4470
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=26661 or tblfeedback.strbusinessname='Katrina Lehman Photography' or tblfeedback.strbusinessname='Katrina Lehman Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Susan Mclaughlan Photography
Monto QLD 4630
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=38069 or tblfeedback.strbusinessname='Susan Mclaughlan Photography' or tblfeedback.strbusinessname='Susan Mclaughlan Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Capture That Photography
Highland Park QLD 4211
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=27146 or tblfeedback.strbusinessname='Capture That Photography' or tblfeedback.strbusinessname='Capture That Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Louise Wilson Photography
Wallumbilla QLD 4428
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=38550 or tblfeedback.strbusinessname='Louise Wilson Photography' or tblfeedback.strbusinessname='Louise Wilson Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lilyfern Photography
Toowoomba QLD 4350
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=21302 or tblfeedback.strbusinessname='Lilyfern Photography' or tblfeedback.strbusinessname='Lilyfern Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tom Hall Photography
Scarborough QLD 4020
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=27774 or tblfeedback.strbusinessname='Tom Hall Photography' or tblfeedback.strbusinessname='Tom Hall Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Inspired Focus Photography
Toowoomba QLD 4350
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=39908 or tblfeedback.strbusinessname='Inspired Focus Photography' or tblfeedback.strbusinessname='Inspired Focus Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
CRH Photography
Kingaroy QLD 4510
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=37640 or tblfeedback.strbusinessname='CRH Photography' or tblfeedback.strbusinessname='CRH Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ben Yew
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=25844 or tblfeedback.strbusinessname='Ben Yew' or tblfeedback.strbusinessname='Ben Yew') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Nicky Liz Photography
Beloela QLD 4715
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=25857 or tblfeedback.strbusinessname='Nicky Liz Photography' or tblfeedback.strbusinessname='Nicky Liz Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
ESP Family Photography
Charters Towers QLD 4820
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=27060 or tblfeedback.strbusinessname='ESP Family Photography' or tblfeedback.strbusinessname='ESP Family Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Photography by Jess Edwards
Clermont QLD 4721
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=24098 or tblfeedback.strbusinessname='Photography by Jess Edwards' or tblfeedback.strbusinessname='Photography by Jess Edwards') 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
Linda Kelso Photography
Charters Towers QLD 4820
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=26824 or tblfeedback.strbusinessname='Linda Kelso Photography' or tblfeedback.strbusinessname='Linda Kelso Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Treasure Pics
Kingaroy QLD 4610
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=26561 or tblfeedback.strbusinessname='Treasure Pics' or tblfeedback.strbusinessname='Treasure Pics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Scott Barkle
Pacific Pines QLD 4211
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=26858 or tblfeedback.strbusinessname='Scott Barkle' or tblfeedback.strbusinessname='Scott Barkle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Heart n Soul Photography
Gold Coast QLD 4211
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=26125 or tblfeedback.strbusinessname='Heart n Soul Photography' or tblfeedback.strbusinessname='Heart n Soul Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rob Bagnall Wedding Photography
Charters Towers QLD 4820
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=16485 or tblfeedback.strbusinessname='Rob Bagnall Wedding Photography' or tblfeedback.strbusinessname='Rob Bagnall Wedding Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sharon Keogh Photography
Warwick QLD 4370
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=16507 or tblfeedback.strbusinessname='Sharon Keogh Photography' or tblfeedback.strbusinessname='Sharon Keogh Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jan Brown Photography
Winton QLD 4735
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=16331 or tblfeedback.strbusinessname='Jan Brown Photography' or tblfeedback.strbusinessname='Jan Brown Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elvine Studios
Roma QLD 4455
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=16238 or tblfeedback.strbusinessname='Elvine Studios' or tblfeedback.strbusinessname='Elvine Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dalby-Jandowae Photo Service
Dalby QLD 4405
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=2851 or tblfeedback.strbusinessname='Dalby-Jandowae Photo Service' or tblfeedback.strbusinessname='Dalby-Jandowae Photo Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barr Shane Photographics
Warwick QLD 4370
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=2773 or tblfeedback.strbusinessname='Barr Shane Photographics' or tblfeedback.strbusinessname='Barr Shane Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Annette Frizzell
Oakey QLD 4401
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=16171 or tblfeedback.strbusinessname='Annette Frizzell' or tblfeedback.strbusinessname='Annette Frizzell') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sportraits
Nerang East QLD 4211
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=16526 or tblfeedback.strbusinessname='Sportraits' or tblfeedback.strbusinessname='Sportraits') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Panorama Photography
Port Douglas QLD 4871
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=18796 or tblfeedback.strbusinessname='Australian Panorama Photography' or tblfeedback.strbusinessname='Australian Panorama Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Malo Co Photographic Studios
Stanthorpe QLD 4380
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=16393 or tblfeedback.strbusinessname='Malo Co Photographic Studios' or tblfeedback.strbusinessname='Malo Co Photographic Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Milne Photography
Dalby QLD 4405
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=16411 or tblfeedback.strbusinessname='Milne Photography' or tblfeedback.strbusinessname='Milne Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Affordale Films
Warwick QLD 4370
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=2720 or tblfeedback.strbusinessname='Affordale Films' or tblfeedback.strbusinessname='Affordale Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Picturesque Photographics
Biloela QLD 4715
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=16462 or tblfeedback.strbusinessname='Picturesque Photographics' or tblfeedback.strbusinessname='Picturesque Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
John Ogle
Broken Hill NSW 2880
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=9954 or tblfeedback.strbusinessname='John Ogle' or tblfeedback.strbusinessname='John Ogle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Joshua Bollman Photographics
Mount Isa QLD 4825
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=16350 or tblfeedback.strbusinessname='Joshua Bollman Photographics' or tblfeedback.strbusinessname='Joshua Bollman Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Portrait of AN Angel
Nerang QLD 4211
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=16466 or tblfeedback.strbusinessname='Portrait of AN Angel' or tblfeedback.strbusinessname='Portrait of AN Angel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Julie Arthurs Photography
Warwick QLD 4370
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=16353 or tblfeedback.strbusinessname='Julie Arthurs Photography' or tblfeedback.strbusinessname='Julie Arthurs Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Affordable Films
Warwick QLD 4370
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=16168 or tblfeedback.strbusinessname='Affordable Films' or tblfeedback.strbusinessname='Affordable Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Charters Towers Photographics
Charters Towers QLD 4820
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=16201 or tblfeedback.strbusinessname='Charters Towers Photographics' or tblfeedback.strbusinessname='Charters Towers Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wayne J Gear Photographers
Broken Hill NSW 2880
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=2487 or tblfeedback.strbusinessname='Wayne J Gear Photographers' or tblfeedback.strbusinessname='Wayne J Gear Photographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brett Hanwright Photography
Kingaroy QLD 4610
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=2798 or tblfeedback.strbusinessname='Brett Hanwright Photography' or tblfeedback.strbusinessname='Brett Hanwright Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Naturalite Studio Photography
Warwick QLD 4370
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=16425 or tblfeedback.strbusinessname='Naturalite Studio Photography' or tblfeedback.strbusinessname='Naturalite Studio Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sean Payne
Kingaroy QLD 4610
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=16504 or tblfeedback.strbusinessname='Sean Payne' or tblfeedback.strbusinessname='Sean Payne') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Berry Photographics
Nerang QLD 4211
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=16188 or tblfeedback.strbusinessname='Berry Photographics' or tblfeedback.strbusinessname='Berry Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Annetta Frizzell
Oakey QLD 4401
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=2749 or tblfeedback.strbusinessname='Annetta Frizzell' or tblfeedback.strbusinessname='Annetta Frizzell') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
James Laws
Emerald QLD 4720
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=16330 or tblfeedback.strbusinessname='James Laws' or tblfeedback.strbusinessname='James Laws') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wayne Gear Photographers
Broken Hill NSW 2880
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=11964 or tblfeedback.strbusinessname='Wayne Gear Photographers' or tblfeedback.strbusinessname='Wayne Gear Photographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jim Sorley
Dalby QLD 4405
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=16337 or tblfeedback.strbusinessname='Jim Sorley' or tblfeedback.strbusinessname='Jim Sorley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Geoff Rayner Photographics
Stanthorpe QLD 4380
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=16272 or tblfeedback.strbusinessname='Geoff Rayner Photographics' or tblfeedback.strbusinessname='Geoff Rayner Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15