Page Time: 0.1380s

Memory: 6.4179 MB (Peak: 7.8434 MB)

Queries (27, time: 0.0227s, 16.4%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000214
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  2. SELECT thread.*
    	,
    		user.gender, user.avatar_date, user.gravatar,
    		NULL AS thread_read_date,
    		0 AS thread_reply_banned,
    		0 AS thread_is_watched,
    		'' AS draft_message, NULL AS draft_extra
    FROM xf_thread AS thread
    
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = thread.user_id)
    WHERE thread.thread_id = ?
    Params: 43556
    Run Time: 0.000535
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
    SIMPLEuserconstPRIMARYPRIMARY4const1 
  3. SELECT node.*, forum.*
    	,
    	permission.cache_value AS node_permission_cache,
    		NULL AS forum_read_date
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    	LEFT JOIN xf_permission_cache_content AS permission
    		ON (permission.permission_combination_id = 1
    			AND permission.content_type = 'node'
    			AND permission.content_id = forum.node_id)
    WHERE node.node_id = ?
    Params: 20
    Run Time: 0.000522
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  4. SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
    FROM EWRporta2_articles
    	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    WHERE EWRporta2_articles.thread_id = ?
    Params: 43556
    Run Time: 0.001458
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  5. SELECT EWRporta2_articles.*, EWRporta2_authors.*, xf_thread.*, xf_post.*, xf_user.*
    FROM xf_thread
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_articles ON (EWRporta2_articles.thread_id = xf_thread.thread_id)
    WHERE xf_thread.thread_id = ?
    Params: 43556
    Run Time: 0.000986
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_postconstPRIMARYPRIMARY4const1 
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLEEWRporta2_authorsconstPRIMARYPRIMARY4const0unique row not found
    SIMPLEEWRporta2_articlesconstPRIMARYPRIMARY4const0unique row not found
  6. SELECT post.*
    	,
    		bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
    		user.*, IF(user.username IS NULL, post.username, user.username) AS username,
    		user_profile.*,
    		user_privacy.*,
    		signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
    		session_activity.view_date AS last_view_date,
    		0 AS like_date
    		,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (1,2,4,5,6,7,8,10)) as positive_rating_count
    	
    		,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (14,11,12,13)) as negative_rating_count
    	
    		,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (3,9)) as neutral_rating_count
    	,
    pr_cache.rating_cache,
    pr2.rating
    FROM xf_post AS post
    
    		LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
    			(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = post.user_id)
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = post.user_id)
    		LEFT JOIN xf_user_privacy AS user_privacy ON
    			(user_privacy.user_id = post.user_id)
    		LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
    			(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
    		LEFT JOIN xf_session_activity AS session_activity ON
    			(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
    left join dark_postrating_post_cache pr_cache ON (post.post_id = pr_cache.post_id)
    left join dark_postrating pr2 on (post.post_id = pr2.post_id and pr2.user_id = 0)
    WHERE post.thread_id = ?
    	 AND (post.position >= 0 AND post.position < 25) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 43556
    Run Time: 0.002812
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 11Using where; Using filesort
    PRIMARYbb_code_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.post_id1 
    PRIMARYusereq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYuser_profileeq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYuser_privacyeq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYsignature_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.user_id1 
    PRIMARYsession_activityeq_refPRIMARYPRIMARY22packerfo_maindb.post.user_id,func1 
    PRIMARYpr_cacheeq_refPRIMARYPRIMARY4packerfo_maindb.post.post_id1 
    PRIMARYpr2eq_refpost_id_user_id,post_id_rating,user_id_ratingpost_id_user_id8packerfo_maindb.post.post_id,const1 
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
  7. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 43556
    Run Time: 0.000218
  8. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 43556
    Run Time: 0.001001
  9. SELECT thread.*
    	,
    		0 AS thread_reply_banned
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 43556
    Run Time: 0.000494
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
  10. SELECT node.*, forum.*
    	,
    	permission.cache_value AS node_permission_cache
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    	LEFT JOIN xf_permission_cache_content AS permission
    		ON (permission.permission_combination_id = 1
    			AND permission.content_type = 'node'
    			AND permission.content_id = forum.node_id)
    WHERE node.node_id = ?
    Params: 20
    Run Time: 0.000464
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  11. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 43556
    Run Time: 0.000161
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_ignore_threadrefuser_threaduser_thread8const,const1 
  12. SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
    FROM EWRporta2_articles
    	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    WHERE EWRporta2_articles.thread_id = ?
    Params: 43556
    Run Time: 0.001454
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  13. SELECT EWRporta2_articles.*, EWRporta2_authors.*, xf_thread.*, xf_post.*, xf_user.*
    FROM xf_thread
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_articles ON (EWRporta2_articles.thread_id = xf_thread.thread_id)
    WHERE xf_thread.thread_id = ?
    Params: 43556
    Run Time: 0.001414
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_postconstPRIMARYPRIMARY4const1 
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLEEWRporta2_authorsconstPRIMARYPRIMARY4const0unique row not found
    SIMPLEEWRporta2_articlesconstPRIMARYPRIMARY4const0unique row not found
  14. INSERT INTO xf_session_activity
    	(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
    VALUES
    	(?, ?, ?, ?, ?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE
    	ip = VALUES(ip),
    	controller_name = VALUES(controller_name),
    	controller_action = VALUES(controller_action),
    	view_state = VALUES(view_state),
    	params = VALUES(params),
    	view_date = VALUES(view_date),
    	robot_key = VALUES(robot_key)
    Params: 0, , , XenForo_ControllerPublic_Thread, Index, valid, thread_id=43556, 1461980238,
    Run Time: 0.000445
  15. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('freepro_menu_tickets', 'freepro_menu_schedule', 'freepro_menu_roster', 'freepro_menu_draft')
    Params: 1
    Run Time: 0.000200
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 4Using where
  16. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 492963, a:1:{i:0;s:349:"For those cap knowledgeable people, I have a question. Let's say that we don't end up using the $18 mil we have left under the cap, does that money roll over at all? Or is that going to be specifically used to help with the Arod/CM3 contract extensions? Sorry, but the cap is one aspect I don't really have a lot of info on. Thanks for any help.";}, 1458829234, 1461980238
    Run Time: 0.000984
  17. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 492975, a:1:{i:0;s:525:"Someone a little more knowledgeable than me on this might reply, but my understanding of the cap under the new CBA is that unused cap room does roll over to the next year. The $18M under the cap that is cited right now is not under the actual salary cap but under our own adjusted salary cap from having room left over last year. Probably if we have unused cap room, most of it will be used up on CM3/Rodgers extensions. I would guess they'll try to front-load whatever they can to try to ease the pain in future years.";}, 1458829234, 1461980238
    Run Time: 0.000946
  18. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 492984, a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:795:"Yes, a change in the new CBA is teams can carryover unused cap space. According to reports, the Packers rolled over about $7M into 2013 and that's part of the approximate $18M of cap room they currently have (BTW, I don't know if that's been adjusted for the savings on Hawk's contract). Another new feature of the CBA is teams have to spend 89% of the salary cap amount over the four year periods from 2013 - 2016 and from 2017-2020. IOW it's not a season by season requirement but a cumulative one. For example if the caps over the first four years were (just as an example) $130M, $135M, $145M, and $150M, teams will have had to spend $498.4M over that four year period (.89 x $560M). The carryover helps teams manage the cap and the minimum required spending helps players on "cheap" teams. ";}}}, 1458829234, 1461980238
    Run Time: 0.000842
  19. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 492990, a:5:{i:0;s:384:"The OP raises several questions which I have not seen anyone adequately answer. Here's what I'd like to know: 1) Cap carryover is optional. Teams must advise the league of their intent to do so. What are the benefits/incentives to not carrying over cap vs. actually doing so? We might deduce the answer to that question if we had the answers to the following questions: 2) If you ";i:1;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:5:"don't";}}i:2;s:587:" carryover cap, does that money go into a bank that can be used as carryover in subsequent years? Or is it permanently lost? 3) Can a team execute a partial carryover, or is it an all or nothing proposition? If it is a partial carry over, is the remainder permanently lost? 4) If you do carryover cap, but you don't use it in the current year, is it then available for carryover again to the next year? This touches on the OP question. 5) ThxJack noted the 89% minimum payout under the new CBA. The interesting thing is that the provision calls for 89% of the cap being paid out in";i:3;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:5:" cash";}}i:4;s:546:", as opposed to a cap hit of 89% of the cap. The question here is whether it's 89% of the base cap (e.g., $123 mil this year for all teams) or is it 89% of each particular team's cap including carryover (e.g., $130 mil for the Packers this season including the $7 mil carryover). Further, if the Packers $130 mil is used to calculate the 89%, is the $130 mil reduced to the extent not all of it is used. I sent an email to Seifert at ESPN suggesting he do a blog topic on this. If anybody wants to sent these to one our beat writers, feel free.";}, 1458829234, 1461980238
    Run Time: 0.000962
  20. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 492992, a:2:{i:0;s:484:"By the by, based on sportrac, we are $18 mil under the cap including the $7 mil carryover. That does not include any adjustment downward for Hawk. Restricted FA tender amounts are included for Shields and EDS (the cap could go up or down depending on whether they get signed by the Pack to longer term deals or get signed away). The figure does not include anything for Brad Jones if they happen to re-sign him. I think he's the last of our UFAs who's status is undetermined. ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:53:"http://www.spotrac.com/nfl/green-bay-packers/cap-hit/";}}}, 1458829234, 1461980238
    Run Time: 0.000871
  21. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 492996, a:1:{i:0;s:158:"Thanks for the info. These rules and clauses confuse the sh!t out of me. Almost have to have a business law degree to understand the details of this cap crap.";}, 1458829234, 1461980238
    Run Time: 0.000778
  22. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 493000, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"Oshkoshpackfan, post: 492996, member: 6906";s:8:"original";a:2:{i:0;s:52:"[quote="Oshkoshpackfan, post: 492996, member: 6906"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:158:"Thanks for the info. These rules and clauses confuse the sh!t out of me. Almost have to have a business law degree to understand the details of this cap crap.";}}i:1;s:250:" You're not alone. I see it more as behavioral economics than just a matter of rules. If you want to assess why people do what they do, or try to make predictions about what they will do, you need to understand their incentives and disincentives.";}, 1458829234, 1461980238
    Run Time: 0.000743
  23. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 493019, a:22:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:90:"All of the answers to your questions in the 4th post are in the link below, HardRightEdge:";}}i:1;s:1:" ";i:2;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:103:"http://images.nflplayers.com/mediaResources/files/PDFs/General/2011_Final_CBA_Searchable_Bookmarked.pdf";}}}}i:3;s:1:" ";i:4;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:179:"That's a link to a searchable copy of the current CBA. And it only takes 'em 318 pages to sort it all out! I'm not going to spend hours looking into this but from what I can tell:";}}i:5;s:3:" ";i:6;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:64:"1) I don't see an upside for teams not carrying over cap space. ";}}i:7;s:3:" ";i:8;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:82:"2) Here's what I believe is the only relevant passage on carrying over cap space: ";}}i:9;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:4:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:20:"Carrying Over Room. ";}}i:1;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:165:"A Club may "carry over" Room from one League Year to the following League Year by submitting notice in writing signed by the owner to the NFL no later than fourteen ";}}i:2;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:6:"(1 4) ";}}i:3;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:320:"days prior to the start of the next League Year indicating the maximum amount of Room that the Club wishes to carry over. The NFL shall promptly provide a copy of any such notice to the NFLP A. The amount of Room carried over will be adjusted downward based on the final Room available after the year-end reconciliation.";}}}}i:10;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:371:"(I assume year-end reconciliation has to do with bonuses likely to be achieved and bonuses unlikely to be achieved that were achieved as well as players being waived mid-season, etc.) Carry over is clearly optional since the word "may" is used but there's no mention of money not carried over surviving in any sense to I believe the answer to this is "permanently lost". ";}}i:11;s:3:" ";i:12;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:129:"3) From the language it looks like a team can do a partial carryover and again it looks to me like the rest is permanently lost. ";}}i:13;s:3:" ";i:14;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:231:"4) It looks to me like the answer is yes. For example if the Packers have $9M in cap room left at the close of this season (EXTREMELY unlikely) I think they can carry over $9M irrespective of the $7M carried over into this season. ";}}i:15;s:3:" ";i:16;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:54:"5) Here's the only language I found on this question: ";}}i:17;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:1:" ";}}}}i:18;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:28:"Minimum Team Cash Spending: ";}}i:1;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:326:"(a) For each of the following four-League Year periods, 201 3-201 6 and 2017-2020, there shall be a guaranteed Minimum Team Cash Spending of 89% of the Salary Caps for such periods (e.g., if the Salary Caps for the 2013-1 6 and 201 7-2020 are $100, 120, 130, and 150 million, respectively, each Club shall have a Minimum Team ";}}i:2;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:69:"Cash Spending for that period of $445 million (89% of $500 million)) ";}}}}i:19;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:235:"It doesn't spell it out clearly but this language "If the Salary Caps for the (two four-year periods)… each Club shall have a minimum…" indicates to me the CBA is referencing the cap figures not including specific team carry overs.";}}i:20;s:3:" ";i:21;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:166:"I encourage anyone to delve deeper into this - for the length of the agreement it seems unlikely these two excerpts would be the only pertinent ones on these issues. ";}}}, 1458829234, 1461980238
    Run Time: 0.000816
  24. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 493021, a:1:{i:0;s:21:"Downloaded and Grazie";}, 1458829234, 1461980238
    Run Time: 0.000858
  25. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 493048, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"ThxJackVainisi, post: 493019, member: 4300";s:8:"original";a:2:{i:0;s:52:"[quote="ThxJackVainisi, post: 493019, member: 4300"]";i:1;s:8:"[/quote]";}s:8:"children";a:19:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:90:"All of the answers to your questions in the 4th post are in the link below, HardRightEdge:";}}i:1;s:1:" ";i:2;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:103:"http://images.nflplayers.com/mediaResources/files/PDFs/General/2011_Final_CBA_Searchable_Bookmarked.pdf";}}}}i:3;s:1:" ";i:4;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:179:"That's a link to a searchable copy of the current CBA. And it only takes 'em 318 pages to sort it all out! I'm not going to spend hours looking into this but from what I can tell:";}}i:5;s:3:" ";i:6;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:64:"1) I don't see an upside for teams not carrying over cap space. ";}}i:7;s:3:" ";i:8;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:82:"2) Here's what I believe is the only relevant passage on carrying over cap space: ";}}i:9;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:371:"(I assume year-end reconciliation has to do with bonuses likely to be achieved and bonuses unlikely to be achieved that were achieved as well as players being waived mid-season, etc.) Carry over is clearly optional since the word "may" is used but there's no mention of money not carried over surviving in any sense to I believe the answer to this is "permanently lost". ";}}i:10;s:3:" ";i:11;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:129:"3) From the language it looks like a team can do a partial carryover and again it looks to me like the rest is permanently lost. ";}}i:12;s:3:" ";i:13;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:231:"4) It looks to me like the answer is yes. For example if the Packers have $9M in cap room left at the close of this season (EXTREMELY unlikely) I think they can carry over $9M irrespective of the $7M carried over into this season. ";}}i:14;s:3:" ";i:15;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:54:"5) Here's the only language I found on this question: ";}}i:16;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:235:"It doesn't spell it out clearly but this language "If the Salary Caps for the (two four-year periods)… each Club shall have a minimum…" indicates to me the CBA is referencing the cap figures not including specific team carry overs.";}}i:17;s:3:" ";i:18;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"Arial";s:8:"original";a:2:{i:0;s:12:"[FONT=Arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:166:"I encourage anyone to delve deeper into this - for the length of the agreement it seems unlikely these two excerpts would be the only pertinent ones on these issues. ";}}}}i:1;s:1587:" That's a nice piece of research, ThxJack. The only other passage I find that might be relevant is the definition of Salary Cap (see below). I find your reading quite plausible, but it begs the question why the carry over would be optional. If there is no advantage at any time for any team to forgo carry over, why require the formality of a letter requesting it? It just begs for fallout and turmoil of the fax malfunction variety or some like screw up. The union also would want carry over to be automatic since it would maximize cap spending. Perhaps there is an issue in your reading of the second quotation in your post that relates to question (5). "Salary Cap" is defined as "the absolute maximum amount of Salary that each Club may pay or be obligated to pay or provide to players or Player Affiliates...at any time during a particular league year...." Perhaps the 89% is calculated off of cap including carryover based on that definition? Then cheap teams would have an incentive to not carry over...teams would have a plausible choice they need to act upon. Under this reading, cheap teams could minimize their cash outlays by minimizing the cap value against which the 89% is calculated by not carrying over, while still having to pony up to 89% of the league base cap. Perhaps there are letters of understanding between the union and the owners that clarify these issues. An insiders perspective would be helpful. As far as the Packers are concerned, I agree with your reading that any unused carry over into one year could be in turn carried over to the next.";}, 1458829234, 1461980238
    Run Time: 0.001142
  26. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 493053, a:1:{i:0;s:184:"With contract extensions needing to be done for Clay Matthews and Aaron Rodgers unless you are going to play for peanuts don't expect for TT to make any real effort to sign anyone smh.";}, 1458829234, 1461980238
    Run Time: 0.000872
  27. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 493071, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"rodell330, post: 493053, member: 6676";s:8:"original";a:2:{i:0;s:47:"[quote="rodell330, post: 493053, member: 6676"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:184:"With contract extensions needing to be done for Clay Matthews and Aaron Rodgers unless you are going to play for peanuts don't expect for TT to make any real effort to sign anyone smh.";}}i:1;s:126:" Why does every new thread need to involve you "shaking your head" about your perceived methods of a very successful NFL GM?";}, 1458829234, 1461980238
    Run Time: 0.000489

Included Files (152, XenForo Classes: 62)

  1. index.php
  2. library/XenForo/Autoloader.php
  3. library/XenForo/Application.php
  4. library/Zend/Registry.php
  5. library/Lgpl/utf8.php
  6. library/Zend/Config.php
  7. library/config.php
  8. library/XenForo/FrontController.php
  9. library/XenForo/Dependencies/Public.php
  10. library/XenForo/Dependencies/Abstract.php
  11. library/Zend/Controller/Request/Http.php
  12. library/Zend/Controller/Request/Abstract.php
  13. library/Zend/Uri.php
  14. library/Zend/Controller/Response/Http.php
  15. library/Zend/Controller/Response/Abstract.php
  16. library/XenForo/Model/DataRegistry.php
  17. library/XenForo/Model.php
  18. library/Zend/Cache.php
  19. library/Zend/Cache/Backend/Memcached.php
  20. library/Zend/Cache/Backend/ExtendedInterface.php
  21. library/Zend/Cache/Backend/Interface.php
  22. library/Zend/Cache/Backend.php
  23. library/Zend/Cache/Core.php
  24. library/XenForo/CodeEvent.php
  25. library/XenForo/Options.php
  26. library/XenForo/Link.php
  27. library/XenForo/Template/Helper/Core.php
  28. library/FreePro/Listener.php
  29. library/bdTagMe/Listener.php
  30. library/bdTagMe/Helper/Template.php
  31. library/bdTagMe/ShippableHelper/Updater.php
  32. library/bdTagMe/Option.php
  33. library/sonnb/XenGallery/Listener.php
  34. library/EWRporta2/Listener/Init.php
  35. library/XenForo/Router.php
  36. library/XenForo/Route/Filter.php
  37. library/XenForo/Route/Interface.php
  38. library/XenForo/Route/ResponseSuffix.php
  39. library/XenForo/Route/Prefix.php
  40. library/XenForo/Route/Prefix/Threads.php
  41. library/XenForo/RouteMatch.php
  42. library/XenForo/ControllerPublic/Thread.php
  43. library/XenForo/ControllerPublic/Abstract.php
  44. library/XenForo/Controller.php
  45. library/ModerateCountry/RegisterListener.php
  46. library/EWRporta2/Widget/Listener/ArticlesMain.php
  47. library/Nobita/IgnoreThread/Listener.php
  48. library/Dark/PostRating/EventListener.php
  49. library/EWRporta2/Listener/Controller.php
  50. library/FreePro/XenForo/ControllerPublic/Thread.php
  51. library/Nobita/IgnoreThread/ControllerPublic/Thread.php
  52. library/sonnb/XenGallery/XenForo/ControllerPublic/Thread.php
  53. library/EWRporta2/ControllerPublic/Thread.php
  54. library/XenForo/Input.php
  55. library/XenForo/Session.php
  56. library/Zend/Db.php
  57. library/Zend/Db/Adapter/Mysqli.php
  58. library/Zend/Db/Adapter/Abstract.php
  59. library/Zend/Db/Select.php
  60. library/Zend/Db/Expr.php
  61. library/Zend/Db/Profiler.php
  62. library/Zend/Db/Statement/Mysqli.php
  63. library/Zend/Db/Statement.php
  64. library/Zend/Db/Statement/Interface.php
  65. library/XenForo/Helper/Ip.php
  66. library/XenForo/Visitor.php
  67. library/XenForo/Model/User.php
  68. library/ThemeHouse/JoinUserGroup/Listener/LoadClass.php
  69. library/ThemeHouse/Listener/LoadClass.php
  70. library/ThemeHouse/Listener/LoadClass/20150518.php
  71. library/Dark/TaigaChat/EventListener/Listener.php
  72. library/sonnbThreadMassActions/Listener.php
  73. library/EWRporta2/Listener/Model.php
  74. library/ThemeHouse/JoinUserGroup/Extend/XenForo/Model/User.php
  75. library/Dark/PostRating/Model/User.php
  76. library/bdTagMe/XenForo/Model/User.php
  77. library/sonnb/XenGallery/XenForo/Model/User.php
  78. library/EWRporta2/Model/User.php
  79. library/Zend/Db/Profiler/Query.php
  80. library/XenForo/Permission.php
  81. library/XenForo/Helper/Php.php
  82. library/XenForo/Phrase.php
  83. library/XenForo/Locale.php
  84. library/Sedo/DetectBrowser/Listener/Visitor.php
  85. library/Sedo/DetectBrowser/Helper/MobileDetect.php
  86. library/EWRporta2/Model/Perms.php
  87. library/ThemeHouse/JoinUserGroup/Listener/ControllerPreDispatch.php
  88. library/ThemeHouse/Listener/ControllerPreDispatch.php
  89. library/ThemeHouse/Listener/ControllerPreDispatch/20150911.php
  90. library/UnreadPostCount/Listener.php
  91. library/XenForo/ControllerHelper/ForumThreadPost.php
  92. library/XenForo/ControllerHelper/Abstract.php
  93. library/XenForo/Model/Thread.php
  94. library/Nobita/IgnoreThread/Model/Thread.php
  95. library/Dark/PostRating/Model/Thread.php
  96. library/sonnbThreadMassActions/Model/Thread.php
  97. library/UnreadPostCount/Model/Thread.php
  98. library/Dark/PostRating/Model.php
  99. library/XenForo/Model/Forum.php
  100. library/XenForo/Helper/String.php
  101. library/XenForo/Model/Post.php
  102. library/Dark/PostRating/Model/Post.php
  103. library/sonnbThreadMassActions/Model/Post.php
  104. library/EWRporta2/Model/Post.php
  105. library/EWRporta2/Model/Articles.php
  106. library/XenForo/Model/Attachment.php
  107. library/XenForo/Model/Node.php
  108. library/Nobita/IgnoreThread/Model/Node.php
  109. library/XenForo/Route/Prefix/Categories.php
  110. library/XenForo/Route/Prefix/Forums.php
  111. library/XenForo/ControllerResponse/View.php
  112. library/XenForo/ControllerResponse/Abstract.php
  113. library/Nobita/IgnoreThread/Model/IgnoreThread.php
  114. library/XenForo/Helper/Cookie.php
  115. library/XenForo/ViewRenderer/HtmlPublic.php
  116. library/XenForo/ViewRenderer/Abstract.php
  117. library/XenForo/Template/Public.php
  118. library/XenForo/Template/Abstract.php
  119. library/XenForo/ViewPublic/Thread/View.php
  120. library/XenForo/ViewPublic/Base.php
  121. library/XenForo/View.php
  122. library/EWRporta2/Listener/ViewPublic.php
  123. library/XenForo/BbCode/Parser.php
  124. library/XenForo/BbCode/Formatter/Base.php
  125. library/EWRporta2/Listener/BbCode.php
  126. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
  127. library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
  128. library/EWRporta2/BbCode/Formatter.php
  129. library/XenForo/ViewPublic/Helper/Message.php
  130. library/XenForo/BbCode/TextWrapper.php
  131. library/WhoHasVisited/Listener.php
  132. library/XenForo/Route/Prefix/Members.php
  133. library/bdTagMe/XenForo/Route/Prefix/Members.php
  134. library/Dark/TaigaChat/EventListener/NavigationTabs.php
  135. library/EWRporta2/Listener/NavTabs.php
  136. library/XenForo/Template/FileHandler.php
  137. library/XenForo/Helper/File.php
  138. internal_data/templates/S.7,L.1,thread_view.php
  139. library/SeparateStickyAndNormal/Listener.php
  140. library/EWRporta2/Listener/Template.php
  141. internal_data/templates/S.7,L.1,ignore_thread_tool.php
  142. library/XenForo/Route/Prefix/Posts.php
  143. library/XenForo/Model/Avatar.php
  144. internal_data/templates/S.7,L.1,dark_postrating_message_user_info.php
  145. internal_data/templates/S.7,L.1,dark_postrating.php
  146. internal_data/templates/S.7,L.1,bb_code_tag_quote.php
  147. library/XenForo/Helper/Criteria.php
  148. library/XenForo/Debug.php
  149. internal_data/templates/S.7,L.1,PAGE_CONTAINER.php
  150. library/FreePro/Helper.php
  151. internal_data/templates/S.7,L.1,EWRporta2_Navtabs.php
  152. library/XenForo/ViewRenderer/Json.php