Showaheart you're on the right track with your theory, there have been a number of players in all Zones that wanted transfers to STRONGER Clubs, but alas once they found out that they probably wouldn't get picked in the Zone Team unless they stayed at their SMALLER Club they quickly changed their...
Well done to both the 16 & 18 Maroons yesterday, I'm quite sure that all the Lads would have enjoyed the experience but all the better with a win. Congratulations to ALL involved.
Where can one get a list of all the Teams that are competing out at Kingaroy in the 18's?
Crash91 all I know about Norths 5/8 (Logan) is that he is eligible for QLD selection, I know it's confusing, but according to my sources he is eligible. I actually don't know the player or his family and I don't know too much about players from CCC just know who to ask.
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 = 34830 AND (ISNULL(s.Result) OR NOT s.Result = -1) AND m.`Date` >= CURRENT_DATE GROUP BY `Date` ;