Rating
All Your Memories
Brisbane QLD 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=26919 or tblfeedback.strbusinessname='All Your Memories' or tblfeedback.strbusinessname='All Your Memories') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
J'adore Wedding Films and Photography
4/35-37 Huth St Gold Coast QLD 4210
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=25948 or tblfeedback.strbusinessname='J'%%semi%%adore Wedding Films and Photography' or tblfeedback.strbusinessname='J'adore Wedding Films and Photography') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wild Bunch Weddings
Noosa Heads QLD 4567
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=22501 or tblfeedback.strbusinessname='Wild Bunch Weddings' or tblfeedback.strbusinessname='Wild Bunch Weddings') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Fisheye Studio
Gold Coast QLD 4217
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=22875 or tblfeedback.strbusinessname='Fisheye Studio' or tblfeedback.strbusinessname='Fisheye Studio') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
NSI Productions
89 Tabilban St Burleigh Heads QLD 4220
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=23647 or tblfeedback.strbusinessname='NSI Productions' or tblfeedback.strbusinessname='NSI Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ray Lawler Studio
17 Carlyle Drive Currumbin QLD 4223
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=16159 or tblfeedback.strbusinessname='Ray Lawler Studio' or tblfeedback.strbusinessname='Ray Lawler Studio') and year(getdate())-year(dtmadded)<=15
Rating
A1 Video Productions
Runaway Bay QLD 4216
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=17114 or tblfeedback.strbusinessname='A1 Video Productions' or tblfeedback.strbusinessname='A1 Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Able Video & Multimedia
12 Barranbali Street Chevron Island QLD 4217
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=17117 or tblfeedback.strbusinessname='Able Video &%%semi%% Multimedia' or tblfeedback.strbusinessname='Able Video & Multimedia') and year(getdate())-year(dtmadded)<=15
Rating
AWB White Weddings
10 Marine Parade Southport QLD 4215
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=17124 or tblfeedback.strbusinessname='AWB White Weddings' or tblfeedback.strbusinessname='AWB White Weddings') and year(getdate())-year(dtmadded)<=15
Rating
Direction Video
Suite 19 93 Surf Parade<BR>Monterey Plaza Broadbeach QLD 4218
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=17134 or tblfeedback.strbusinessname='Direction Video' or tblfeedback.strbusinessname='Direction Video') and year(getdate())-year(dtmadded)<=15
Rating
Flashback Video Camera Hire
Carrara 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=17135 or tblfeedback.strbusinessname='Flashback Video Camera Hire' or tblfeedback.strbusinessname='Flashback Video Camera Hire') and year(getdate())-year(dtmadded)<=15
Rating
Digico Video Productions
17 James Cagney Close Parkwood QLD 4214
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=18648 or tblfeedback.strbusinessname='Digico Video Productions' or tblfeedback.strbusinessname='Digico Video Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
RPB Productions
Currumbin QLD 4223
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=18721 or tblfeedback.strbusinessname='RPB Productions' or tblfeedback.strbusinessname='RPB Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating