It's pretty obvious the roosters are just a bunch of ill displined scumbags. BTW you don't receive penalties you actually have to do something wrong to give them away. Just goes to show the roosters will push the envelope in regards to onfield rules of the game, you could almost call them cheats ...
"Here's another East' 38-0 victory was the biggest against Canterbury since 1935!"Big deal, just about every other team in the NRL would have clobbered Canterbury last Friday night, they are the team most out of form ATM and running last.
PxA uploaded a new profile photo
@ratz_man I have a job on here??? When do I get paid? LOL Look I agree with people's criticism of this forum it's pretty poor since the changeover but I also think you need to make a start making threads and discussing RL topics.@harr thanks for the invite to the Broncos forum but at this stage I...
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 = 34000 AND (ISNULL(s.Result) OR NOT s.Result = -1) AND m.`Date` >= CURRENT_DATE GROUP BY `Date` ;