Born in Knowsley. Exiled to Melbourne.
It is mostly a cricket simming forum but the discussion doesn't revolve around cricket all that much. The rugby league discussion is pretty active but the membership is quite small.
It's because there is no appropriate translation for "Slippyfist"
Wow, nrlnew.com looks like a ghost town. A bunch of posts in early 2012 and none since.
Now is not the time for patient TS.Now is the time for impulsive decisions.
@Sydney.Raider It just needs to be an email that isn't free (like gmail, yahoo, hotmail). So you could use the one from your internet provider, a school one, a university one, a work one etcI think it is meant to prevent trolls and spamming on LU - although that hasn't actually worked at all
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 = 28044 AND (ISNULL(s.Result) OR NOT s.Result = -1) AND m.`Date` >= CURRENT_DATE GROUP BY `Date` ;