When the Eels are flyin', they're electrifyin'!
Marcus1979What Lives scores TSQThere is a tab at the top of the page that says Live Scores. Gives up to dat information on games being played. It's a good feature of the site and I'm happy it's here. The rest of the site looks good...I just don't like what the forums have become. If they were lik...
I just checked out cricsim. Seems our old Rleaguers M_F and Boobidy are over there. Should provide a laugh.It's very much geared towards cricket though. The League section seems to be just one forum with no sub forums for each team and whatnot.Looks like the old Rleague - the VBulletin format fro...
Good thing it's not happening then xcde - you were going to lose anyway.
The heart?I was thinking right in the groin. I'm totally badass that way.
@Bandwagon - I log into LU as Fifty Metre Line. That name used to actually mean something though as my seats at Parra used to be directly in line with the 50m line. Such a shame we had to move seats. I'll head over there soon and check out how you guys are going with a different face.
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 = 27559 AND (ISNULL(s.Result) OR NOT s.Result = -1) AND m.`Date` >= CURRENT_DATE GROUP BY `Date` ;