I realise this thread is quite old, but I'm chasing a copy of this book myself - does anyone know where I can find one?
Hi folks, just chasing a bit of info on former World Cup forward Barry McTaggart. I am trying to track his career years; so far I have:1966: Gympie1967: ?1968: Norths (Brisbane)1969-72: Balmain1973: Wollongong (after a contract dispute)1974-76: Wynnum-ManlyI have reason to believe he spent at lea...
Hi, I just saw this response to my original listing - any help you could give me would be very greatly appreciated! I am after a detailed list of his playing career (i.e clubs that he played for and the years that he played there). If you could help me with that, please let me know. Cheers, Bi...
KHemsleyrulz shared the status
My bad, was trying to start discussion - computer has gone nuts
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 = 32297 AND (ISNULL(s.Result) OR NOT s.Result = -1) AND m.`Date` >= CURRENT_DATE GROUP BY `Date` ;