Kill them all.
I agree with you HD, we are sooooooooooo close, 5% might be about right. But that 5% is so crippling it may as well be 100%.
Zef. commented on rleague.com users - comments, feedback and more info
One thing you should do is make everyone provide their provider email addy, not just Hotmail or any other anon mail. The old site had trouble at one stage with random trolls logging on under yahoo or whatever, posting all sorts of crap that could get the owners into trouble legally and then slink...
Zef. uploaded a new profile photo
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 = 33250 AND (ISNULL(s.Result) OR NOT s.Result = -1) AND m.`Date` >= CURRENT_DATE GROUP BY `Date` ;