Played all junior & senior football for the Norths Devils from around 1971 till 1990, coached in the Norths juniors from 1978 till about 1982 u/15,16,17's, coached & co-coached the Sandgate Brighton Gaters in the BSDRL from 2001 to 2008, 7 good seasons with the Gaters, co-coached the Dayboro Cowboys along with my good mate Brett Neilsen from the Gaters to a Premiership in 2009, helped out another good mate in Paul "Statsie" Dentie as a trainer with Pine Central Holy Spirit 2010, Coached the Samford Stags in Nth Open 1 2011. Have had a few stints as a trainer for the Sec Div Reps sides over the past few seasons u/22 u/20 & open grade. Was part of the Norths Devils/Melbourne Storm Development Programe for 3 seasons as a trainer with the Mixwell/Fogs & Qcup teams. Active member of the Coolum Surf Life Saving Club from 1973 till around 1988, still a social member at Coolum, member of the Westpac Helicopter Rescue Crew based at Moorochy Airport & the Noosa Jet Boat Rescue team back in the 80's.
Table 'rleague.tips' doesn't exist
SELECT m.`Date`, COUNT(1) as TipCount, COALESCE((SELECT ProductID FROM tip_comment c WHERE c.UserID = t.UserID AND c.`Date` = m.`Date` LIMIT 1),1) as ProductID, COALESCE((SELECT pc.Cost FROM purchasecosts pc INNER JOIN tip_comment tc ON pc.ProductID = tc.ProductID WHERE tc.UserID = t.UserID AND tc.`Date` = m.`Date` LIMIT 1), (SELECT Cost FROM purchasecosts WHERE ProductID = 1 LIMIT 1)) as ProductCost, (SELECT Comment FROM tip_comment c WHERE c.UserID = t.UserID AND c.`Date` = m.`Date` LIMIT 1) as Comments, COALESCE((SELECT ProfitGuarantee FROM tip_comment c WHERE c.UserID = t.UserID AND c.`Date` = m.`Date` LIMIT 1),0) as ProfitGuarantee FROM tips t INNER JOIN meeting m ON m.MeetingID = t.MeetingID INNER JOIN event e ON e.EventID = t.EventID AND NOT e.Status = 'closed' INNER JOIN selection s ON s.SelectionID = t.SelectionID WHERE m.Removed = 0 AND t.Removed = 0 AND t.UserID = 30885 AND (ISNULL(s.Result) OR NOT s.Result = -1) AND m.`Date` >= CURRENT_DATE GROUP BY `Date` ;