What pisses me off is the fact that he is still going back to his normal club when mm is finished ,unlike some fake registration from clubs like easts and norths last year in cc where the kids did not play one second for those clubs in the normal season but played rugby union for their private s...
You can now add Lachlan foulds from norths on that list now
Just my opinion but selectors are more interested in picking attacking players ,everyone can attack but not everyone can defend
Normally I would agree with you johnny blaze but knowing these players the mother signs with the club who pays for fees ,boots etc even though one is a contract broncos player good luck norths dealing with the mother if her son doesn't get the ball all the time
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 = 29412 AND (ISNULL(s.Result) OR NOT s.Result = -1) AND m.`Date` >= CURRENT_DATE GROUP BY `Date` ;