Page Time: 0.8571s

Memory: 11.8372 MB (Peak: 13.2359 MB)

Queries (39, time: 0.0254s, 3.0%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000150
    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_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: 27267
    Run Time: 0.000451
    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.000299
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  4. 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.*,
    		signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
    		0 AS like_date, session.view_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
    	,
    pr2.rating, 
    	pr.*, post.post_id
    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_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 OUTER JOIN xf_session_activity AS session ON post.user_id = session.user_id
    LEFT JOIN dark_postrating pr2 ON (post.post_id = pr2.post_id and pr2.user_id = 0)
    LEFT JOIN (
    select 
    pivot_pr.post_id
    , sum(case when pivot_pr.rating = 1 then 1 else 0 end) dark_postrating_1_count
    , sum(case when pivot_pr.rating = 14 then 1 else 0 end) dark_postrating_14_count
    , sum(case when pivot_pr.rating = 2 then 1 else 0 end) dark_postrating_2_count
    , sum(case when pivot_pr.rating = 3 then 1 else 0 end) dark_postrating_3_count
    , sum(case when pivot_pr.rating = 4 then 1 else 0 end) dark_postrating_4_count
    , sum(case when pivot_pr.rating = 5 then 1 else 0 end) dark_postrating_5_count
    , sum(case when pivot_pr.rating = 6 then 1 else 0 end) dark_postrating_6_count
    , sum(case when pivot_pr.rating = 7 then 1 else 0 end) dark_postrating_7_count
    , sum(case when pivot_pr.rating = 8 then 1 else 0 end) dark_postrating_8_count
    , sum(case when pivot_pr.rating = 9 then 1 else 0 end) dark_postrating_9_count
    , sum(case when pivot_pr.rating = 10 then 1 else 0 end) dark_postrating_10_count
    , sum(case when pivot_pr.rating = 11 then 1 else 0 end) dark_postrating_11_count
    , sum(case when pivot_pr.rating = 12 then 1 else 0 end) dark_postrating_12_count
    , sum(case when pivot_pr.rating = 13 then 1 else 0 end) dark_postrating_13_count
    
    		
    from dark_postrating pivot_pr 
    use index (`post_id_rating`)
    left join xf_post pivot_post on (pivot_pr.post_id = pivot_post.post_id)
    where pivot_post.thread_id = 27267
    group by pivot_pr.post_id
    ) pr on (pr.post_id = post.post_id)
    
    
    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: 27267
    Run Time: 0.005611
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARY<derived5>system    0const row not found
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 24Using where; Using temporary; 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 
    PRIMARYsignature_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.user_id1 
    PRIMARYsessionALLPRIMARY   119 
    PRIMARYpr2eq_refpost_id_user_id,post_id_rating,user_id_ratingpost_id_user_id8packerfo_maindb.post.post_id,const1 
    DERIVEDpivot_postrefPRIMARY,thread_id_post_date,thread_id_positionthread_id_post_date4 176Using where; Using index; Using temporary; Using filesort
    DERIVEDpivot_prrefpost_id_ratingpost_id_rating4packerfo_maindb.pivot_post.post_id2Using index
    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
  5. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 27267
    Run Time: 0.000200
  6. UPDATE xf_session_activity
    SET xf_session_activity.view_count = xf_session_activity.view_count + 1
    WHERE ip = ? AND user_id = 0
    Params: 6¦‡Č
    Run Time: 0.001128
  7. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 27267
    Run Time: 0.001873
  8. SELECT thread.*
    	
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 27267
    Run Time: 0.000481
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
  9. 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.000509
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  10. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 27267
    Run Time: 0.000166
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_ignore_threadrefuser_threaduser_thread8const,const1 
  11. SELECT view_count
    FROM xf_session_activity
    WHERE ip = ? AND user_id = 0
    Params: 6¦‡Č
    Run Time: 0.000242
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityALLPRIMARY   119Using where
  12. 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, 6¦‡Č, 6¦‡Č, XenForo_ControllerPublic_Thread, Index, valid, thread_id=27267, 1409386332,
    Run Time: 0.000163
  13. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('Tickets', 'Schedule', 'Draft')
    Params: 1
    Run Time: 0.000145
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 3Using where
  14. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('offline')
    Params: 1
    Run Time: 0.000108
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY106const,const1 
  15. 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, 362362, a:2:{i:0;s:133:"Well it looks like it could be quite an extended off-season. More posts on who has the best helmets/uniforms/mascots/cheerleaders. ";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:34:"http://www.acmepackingcompany.com/";}}}, 1406210135, 1409386332
    Run Time: 0.000498
  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, 362363, a:1:{i:0;s:353:"The good ol' days are long gone behind us. There will never be any more "good ol' days." Why? Because back in the good ol' days, when football was still a new concept, it didn't get to be an all complicated BUSINESS like this. The men wanted to play football, so they played football. I dunno who is to blame for all this bull crap, but I don't like it.";}, 1406210135, 1409386332
    Run Time: 0.000389
  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, 362364, a:1:{i:0;s:28:"Edited title and made sticky";}, 1406210135, 1409386332
    Run Time: 0.000409
  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, 362365, a:2:{i:0;s:21:"Roger Goodell email ";i:1;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;s:1211:"Dear NFL Fan, When I wrote to you last on behalf of the NFL, we promised you that we would work tirelessly to find a collectively bargained solution to our differences with the players' union. Subsequent to that letter to you, we agreed that the fastest way to a fair agreement was for everyone to work together through a mediation process. For the last three weeks I have personally attended every session of mediation, which is a process our clubs sincerely believe in. Unfortunately, I have to tell you that earlier today the players' union walked away from mediation and collective bargaining and has initiated litigation against the clubs. In an effort to get a fair agreement now, our clubs offered a deal today that was, among other things, designed to have no adverse financial impact on veteran players in the early years, and would have met the players’ financial demands in the latter years of the agreement. The proposal we made included an offer to narrow the player compensation gap that existed in the negotiations by splitting the difference; guarantee a reallocation of savings from first-round rookies to veterans and retirees without negatively affecting compensation for rounds 2-7; ";i:1;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;s:38:"no compensation reduction for veterans";}}i:2;s:1309:"; implement new year-round health and safety rules; retain the current 16-4 season format for at least two years with any subsequent changes subject to the approval of the league and union; and establish a new legacy fund for retired players ($82 million contributed by the owners over the next two years). It was a deal that offered compromise, and would have ensured the well-being of our players and guaranteed the long-term future for the fans of the great game we all love so much. It was a deal where everyone would prosper. We remain committed to collective bargaining and the federal mediation process until an agreement is reached, and call on the union to return to negotiations immediately. NFL players, clubs, and fans want an agreement. The only place it can be reached is at the bargaining table. While we are disappointed with the union's actions, we remain steadfastly committed to reaching an agreement that serves the best interest of NFL players, clubs and fans, and thank you for your continued support of our League. First and foremost it is your passion for the game that drives us all, and we will not lose sight of this as we continue to work for a deal that works for everyone. Yours, Roger Goodell ";}}}, 1406210135, 1409386332
    Run Time: 0.000500
  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, 362366, a:1:{i:0;s:26:"Champs 2 years in a row!!!";}, 1406210135, 1409386332
    Run Time: 0.000675
  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, 362367, a:1:{i:0;s:215:"I had hoped for a resolution, it appears it's going to be harder than I thought. A lockout could come as early as a few hours. For the sake of this beloved game, may they reach some agreement that all can live with.";}, 1406210135, 1409386332
    Run Time: 0.000437
  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, 362368, a:1:{i:0;s:7:"Bummer.";}, 1406210135, 1409386332
    Run Time: 0.000470
  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, 362369, a:1:{i:0;s:260:"Can anyone with more knowledge on the situation (PackersRS?) explain to me how the players and the union have any sort of antitrust case against the NFL? It's not a monopoly, nor does it practice in a monopolistic manner. Isn't it technically non-profit too?";}, 1406210135, 1409386332
    Run Time: 0.000435
  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, 362370, a:1:{i:0;s:98:"Somebody explain to my poor brain just what decertification even means! I know what a lockout is.";}, 1406210135, 1409386332
    Run Time: 0.000743
  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, 362371, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:26:"greenandgold, post: 362370";s:8:"original";a:2:{i:0;s:36:"[quote="greenandgold, post: 362370"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:98:"Somebody explain to my poor brain just what decertification even means! I know what a lockout is.";}}i:1;s:102:" From what I understand, it means the union is dissolved so the players can individually sue the NFL.";}, 1406210135, 1409386332
    Run Time: 0.000453
  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, 362372, a:1:{i:0;s:159:"Congratulations to Roger Goodell, DeMaurice Smith, and the greedy owners for running the most popular sport in America into the ground. Absolutely disgusting.";}, 1406210135, 1409386332
    Run Time: 0.001148
  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, 362373, a:1:{i:0;s:119:"From what I seen Drew Brees say is that all the players wanted is for the owners to show what they make and that was it";}, 1406210135, 1409386332
    Run Time: 0.000441
  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, 362374, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:19:"Tecmo, post: 362372";s:8:"original";a:2:{i:0;s:29:"[quote="Tecmo, post: 362372"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:159:"Congratulations to Roger Goodell, DeMaurice Smith, and the greedy owners for running the most popular sport in America into the ground. Absolutely disgusting.";}}i:1;s:63:" So you don't think greedy PLAYERS had anything to do with it?";}, 1406210135, 1409386332
    Run Time: 0.000485
  28. 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, 362375, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"Incubes12, post: 362371";s:8:"original";a:2:{i:0;s:33:"[quote="Incubes12, post: 362371"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:100:"From what I understand, it means the union is dissolved so the players can individually sue the NFL.";}}i:1;s:53:" Which pretty much happened as soon as it was legal.";}, 1406210135, 1409386332
    Run Time: 0.000548
  29. 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, 362376, a:6:{i:0;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:28:"Goodell sure is a bullsitter";}}i:1;s:2:" ";i:2;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:66:"http://img.ed4.net/nfl/2011/predev/cops_56032_0102/1/img/cops1.gif";}}i:3;s:1209:" Dear NFL Fan, When I wrote to you last on behalf of the NFL, we promised you that we would work tirelessly to find a collectively bargained solution to our differences with the players' union. Subsequent to that letter to you, we agreed that the fastest way to a fair agreement was for everyone to work together through a mediation process. For the last three weeks I have personally attended every session of mediation, which is a process our clubs sincerely believe in. Unfortunately, I have to tell you that earlier today the players' union walked away from mediation and collective bargaining and has initiated litigation against the clubs. In an effort to get a fair agreement now, our clubs offered a deal today that was, among other things, designed to have no adverse financial impact on veteran players in the early years, and would have met the players’ financial demands in the latter years of the agreement. The proposal we made included an offer to narrow the player compensation gap that existed in the negotiations by splitting the difference; guarantee a reallocation of savings from first-round rookies to veterans and retirees without negatively affecting compensation for rounds 2-7; ";i:4;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;s:38:"no compensation reduction for veterans";}}i:5;s:1232:"; implement new year-round health and safety rules; retain the current 16-4 season format for at least two years with any subsequent changes subject to the approval of the league and union; and establish a new legacy fund for retired players ($82 million contributed by the owners over the next two years). It was a deal that offered compromise, and would have ensured the well-being of our players and guaranteed the long-term future for the fans of the great game we all love so much. It was a deal where everyone would prosper. We remain committed to collective bargaining and the federal mediation process until an agreement is reached, and call on the union to return to negotiations immediately. NFL players, clubs, and fans want an agreement. The only place it can be reached is at the bargaining table. While we are disappointed with the union's actions, we remain steadfastly committed to reaching an agreement that serves the best interest of NFL players, clubs and fans, and thank you for your continued support of our League. First and foremost it is your passion for the game that drives us all, and we will not lose sight of this as we continue to work for a deal that works for everyone. Yours, Roger Goodell";}, 1406210135, 1409386332
    Run Time: 0.000610
  30. 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, 362377, a:1:{i:0;s:125:"I don't think we can believe anyone involved. I'm sure nobody is giving the objective truth. And I wouldn't expect them to.";}, 1406210135, 1409386332
    Run Time: 0.000428
  31. 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, 362378, a:1:{i:0;s:341:"I believe Goodell over the players. Drew Brees tweeted that the players "don't want more money." That's a complete lie, as why else would you sue if you didn't want more money? Coming from a guy who couldn't beat a 7-9 team in the playoffs. Right now my full anger is at the players, because they made the move to decertify - not the owners.";}, 1406210135, 1409386332
    Run Time: 0.000488
  32. 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, 362379, a:1:{i:0;s:207:"DeMaurice Smith idolizes the old major league player's association union boss who engineered the players' strikes. I think he wanted this all along. That's why I have not spent any money on MLB since then.";}, 1406210135, 1409386332
    Run Time: 0.000397
  33. 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, 362380, a:4:{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:119:"From what I seen Drew Brees say is that all the players wanted is for the owners to show what they make and that was it";}}i:1;s:259:" Drew Brees is a liar. He said that the players don't want more money - even though they're going to sue for more money. I have no respect for someone who has used the tragedy in New Orleans for his personal glory. He hasn't "saved" the city of New Orleans. ";i:2;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:62:"So you don't think greedy PLAYERS had anything to do with it? ";}}i:3;s:430:" I think this one falls squarely on the shoulders of the players. They've had a propaganda plan out for months now with their "LET US PLAY" tag on Twitter, when the only ones not letting them play are themselves. Conspiracy theorists - such as Steelers fans - will blame the commissioner, as they always do, when their team loses. But the players have been planning this for a long time - they never intended to agree to anything.";}, 1406210135, 1409386332
    Run Time: 0.000489
  34. 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, 362381, a:1:{i:0;s:143:"Players gave full power to Owners in next CBA since no one will get a salary next year. Greed kills. Should have excepted the deal on the table";}, 1406210135, 1409386332
    Run Time: 0.001511
  35. 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, 362382, a:1:{i:0;s:936:"If I could wave a magic wand or somehow be in charge of it all here's what I would do: 1) Make each and every team a community owned non-profit like the Packers. 2) Get rid of unions for the players. 3) Have a set/fair salary for each player that they can live with (Say 2 mil a year.) But each player gets bonuses for how well they do. Example: After 10 TD passes the QB will then get an additional 5k for each one after that. Corner back gets 5 K after 3 INTs. A pick 6 will add on another 2 k. Something for each player. Win the SB. Automatic bonus for each player. Team wins X amount of games, coaches get a bonus too. I think it would add more incentive to the players ability and make the game even more exciting. They need to create something that will be fair to everyone involved so that this BS never happens again. Because the way the system is, every so often, we fans will have to put up with this now and again.";}, 1406210135, 1409386332
    Run Time: 0.000430
  36. 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, 362383, a:1:{i:0;s:52:"Stop making new threads when stuff is posted already";}, 1406210135, 1409386332
    Run Time: 0.000440
  37. 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, 362384, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"Guacamole, post: 362376";s:8:"original";a:2:{i:0;s:33:"[quote="Guacamole, post: 362376"]";i:1;s:8:"[/quote]";}s:8:"children";a:4:{i:0;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:66:"http://img.ed4.net/nfl/2011/predev/cops_56032_0102/1/img/cops1.gif";}}i:1;s:1209:" Dear NFL Fan, When I wrote to you last on behalf of the NFL, we promised you that we would work tirelessly to find a collectively bargained solution to our differences with the players' union. Subsequent to that letter to you, we agreed that the fastest way to a fair agreement was for everyone to work together through a mediation process. For the last three weeks I have personally attended every session of mediation, which is a process our clubs sincerely believe in. Unfortunately, I have to tell you that earlier today the players' union walked away from mediation and collective bargaining and has initiated litigation against the clubs. In an effort to get a fair agreement now, our clubs offered a deal today that was, among other things, designed to have no adverse financial impact on veteran players in the early years, and would have met the players’ financial demands in the latter years of the agreement. The proposal we made included an offer to narrow the player compensation gap that existed in the negotiations by splitting the difference; guarantee a reallocation of savings from first-round rookies to veterans and retirees without negatively affecting compensation for rounds 2-7; ";i:2;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;s:38:"no compensation reduction for veterans";}}i:3;s:1232:"; implement new year-round health and safety rules; retain the current 16-4 season format for at least two years with any subsequent changes subject to the approval of the league and union; and establish a new legacy fund for retired players ($82 million contributed by the owners over the next two years). It was a deal that offered compromise, and would have ensured the well-being of our players and guaranteed the long-term future for the fans of the great game we all love so much. It was a deal where everyone would prosper. We remain committed to collective bargaining and the federal mediation process until an agreement is reached, and call on the union to return to negotiations immediately. NFL players, clubs, and fans want an agreement. The only place it can be reached is at the bargaining table. While we are disappointed with the union's actions, we remain steadfastly committed to reaching an agreement that serves the best interest of NFL players, clubs and fans, and thank you for your continued support of our League. First and foremost it is your passion for the game that drives us all, and we will not lose sight of this as we continue to work for a deal that works for everyone. Yours, Roger Goodell";}}i:1;s:89:" Im merging this since I made a post with same letter and we are discussing this already";}, 1406210135, 1409386332
    Run Time: 0.000495
  38. 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, 362385, a:1:{i:0;s:328:"One more thing: I think the sports media has a vested interest in supporting the players. Think about it, how often are NFL owners interviewed? Maybe a couple times per season. Players are interviewed multiple times a week. So expect to continue to see more pro-player and anti-owner sentiment out of ESPN, local reporters, etc.";}, 1406210135, 1409386332
    Run Time: 0.000412
  39. 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, 362386, a:1:{i:0;s:2819:"to answer those asking what this all means, I will attempt to simplify it all: 1) The union : The union is a collective entity that reps the players as a whole. They are allowed to regulate reps(i.e. agents) who rep players in their best interests, and thus so, need to fit into a type that the union as a whole agrees upon (think of teachers, firemen, or policemen choosing who will be their insurance carrier) they must rule (vote on who this is, and as such, it is a "grouped decision by popular vote". This makes the players (NFLPA) a "unionized association". 2)"de-certification" of a union (i.e the NFLPA "breaking up") The effort that the NFLPA (or as is now known as the 'FORMER' NFLPA) is putting forth to no longer be known as a union. What this does is makes it an" individual worker" vs a company. This has several impacts. Workers who are non- unionized cannot be barred from their employment on regular circumstances without cause. Thus they cannot be "locked-out". The union did this as to prevent a work stoppage by the NFL team owners. This is why you will soon see headlines like " Peyton Manning et al vs the NFL et al and Tom Brady et al VS. NFL et al". This is a legal way to say " Manning and Brady vs the NFL owners". Being that the union is no longer certified, the players are free to go to court to prevent there jobs being "locked out". 3) what this does: the players are attempting to put statutes in place to show that there is collusion between owners to prevent the players from working (i.e. free agency or agreed upon rules of NFL owners to "lock out" players throughout the ranks of all 32 teams) Being that there is no union vs the "NFL" and "Owners", the owners would be violating the law in preventing the players from working (think of if McDonalds teamed up with BK,Rallys, KFC, Taco Bell, etc to prevent a single person from working, due to the fact that they all followed the same criteria). This would be illegal, monopolistic, and is exactly what the owners are about to run into. 4) What it all means now: Nothing. Outside of it all being a slap in the face for us fans, it is simply millionaires forcing billionaires to go to court. Nothing else. NFL football will be played, on time. All that being said, It is ridiculous that this has gone this far. I am happy that we won the SB as I would not want to be the Bears or the Eagles trying to put a team together with what is being put out. And do not think that this is a blip. There could very well be no football work until days before the regular season begins. This means no camps, no FA, no prep for 2011. Either way, its a pretty ****** thing to have happen. I am a bit soured on the process and the lengths that both sides have gone to in stopping the other "rich people" from taking the others money.";}, 1406210135, 1409386332
    Run Time: 0.000513

Included Files (172, XenForo Classes: 65)

  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/sonnb/XenGallery/Listener.php
  29. library/bdTagMe/Listener.php
  30. library/bdTagMe/Helper/Template.php
  31. library/BannedAvatar/Listener.php
  32. library/XenForo/Router.php
  33. library/XenForo/Route/Filter.php
  34. library/XenForo/Route/Interface.php
  35. library/XenForo/Route/ResponseSuffix.php
  36. library/XenForo/Route/Prefix.php
  37. library/XenForo/Route/Prefix/Threads.php
  38. library/EWRporta/Listener/Route.php
  39. library/EWRporta/Route/Thread.php
  40. library/XenForo/RouteMatch.php
  41. library/XenForo/ControllerPublic/Thread.php
  42. library/XenForo/ControllerPublic/Abstract.php
  43. library/XenForo/Controller.php
  44. library/ModerateCountry/RegisterListener.php
  45. library/MailChimp/Listener.php
  46. library/AddOnInstaller/Listener.php
  47. library/SportsNetwork/Listener.php
  48. library/EWRporta/Listener/Controller.php
  49. library/Dark/PostRating/EventListener.php
  50. library/Nobita/IgnoreThread/Listener.php
  51. library/Nobita/LimitGuestThreadPageView/Listener.php
  52. library/SportsNetwork/ControllerPublic/Thread.php
  53. library/EWRporta/ControllerPublic/Thread.php
  54. library/sonnb/XenGallery/XenForo/ControllerPublic/Thread.php
  55. library/Nobita/IgnoreThread/ControllerPublic/Thread.php
  56. library/Nobita/LimitGuestThreadPageView/ControllerPublic/Thread.php
  57. library/XenForo/Input.php
  58. library/XenForo/Session.php
  59. library/Zend/Db.php
  60. library/Zend/Db/Adapter/Mysqli.php
  61. library/Zend/Db/Adapter/Abstract.php
  62. library/Zend/Db/Select.php
  63. library/Zend/Db/Expr.php
  64. library/Zend/Db/Profiler.php
  65. library/Zend/Db/Statement/Mysqli.php
  66. library/Zend/Db/Statement.php
  67. library/Zend/Db/Statement/Interface.php
  68. library/XenForo/Helper/Ip.php
  69. library/XenForo/Visitor.php
  70. library/XenForo/Model/User.php
  71. library/Waindigo/JoinUserGroup/Listener/LoadClass.php
  72. library/Waindigo/Listener/LoadClass.php
  73. library/Waindigo/Listener/LoadClass/20131003.php
  74. library/Asp/OnlineStatus/Plugin/Plugin.php
  75. library/EWRporta/Listener/Model.php
  76. library/Dark/TaigaChat/EventListener/Listener.php
  77. library/sonnbThreadMassActions/Listener.php
  78. library/Waindigo/JoinUserGroup/Extend/XenForo/Model/User.php
  79. library/Dark/PostRating/Model/User.php
  80. library/sonnb/XenGallery/XenForo/Model/User.php
  81. library/bdTagMe/XenForo/Model/User.php
  82. library/Zend/Db/Profiler/Query.php
  83. library/XenForo/Permission.php
  84. library/XenForo/Phrase.php
  85. library/XenForo/Locale.php
  86. library/EWRporta/Model/Perms.php
  87. library/Waindigo/JoinUserGroup/Listener/ControllerPreDispatch.php
  88. library/Waindigo/Listener/ControllerPreDispatch.php
  89. library/Waindigo/Listener/ControllerPreDispatch/20140603.php
  90. library/Waindigo/Listener/Template/20140101.php
  91. library/Waindigo/Listener/TemplateHook/20130522.php
  92. library/Waindigo/Listener/TemplateCreate/20130522.php
  93. library/Waindigo/Listener/InitDependencies.php
  94. library/Waindigo/Listener/InitDependencies/20140401.php
  95. library/XenForo/Model/Session.php
  96. library/Dark/PostRating/Model/Session.php
  97. library/Dark/TaigaChat/Model/SessionOverride.php
  98. library/Nobita/LimitGuestThreadPageView/Model/Session.php
  99. library/XenForo/ControllerHelper/ForumThreadPost.php
  100. library/XenForo/ControllerHelper/Abstract.php
  101. library/XenForo/Model/Thread.php
  102. library/BannedAvatar/Helper.php
  103. library/Dark/PostRating/Model/Thread.php
  104. library/Nobita/IgnoreThread/Model/Thread.php
  105. library/Nobita/LimitGuestThreadPageView/Model/Thread.php
  106. library/sonnbThreadMassActions/Model/Thread.php
  107. library/Dark/PostRating/Model.php
  108. library/XenForo/Model/Forum.php
  109. library/XenForo/Helper/String.php
  110. library/XenForo/Helper/Discussion.php
  111. library/XenForo/Model/Post.php
  112. library/Asp/OnlineStatus/Model/AspPost.php
  113. library/EWRporta/Model/Post.php
  114. library/Dark/PostRating/Model/Post.php
  115. library/sonnbThreadMassActions/Model/Post.php
  116. library/Nobita/LimitGuestThreadPageView/Engine.php
  117. library/XenForo/Model/Attachment.php
  118. library/EWRporta/Model/Attachment.php
  119. library/XenForo/Model/Node.php
  120. library/Nobita/IgnoreThread/Model/Node.php
  121. library/XenForo/Route/Prefix/Categories.php
  122. library/XenForo/Route/Prefix/Forums.php
  123. library/XenForo/ControllerResponse/View.php
  124. library/XenForo/ControllerResponse/Abstract.php
  125. library/Nobita/IgnoreThread/Model/IgnoreThread.php
  126. library/XenForo/Helper/Cookie.php
  127. library/XenForo/ViewRenderer/HtmlPublic.php
  128. library/XenForo/ViewRenderer/Abstract.php
  129. library/XenForo/Template/Public.php
  130. library/XenForo/Template/Abstract.php
  131. library/XenForo/ViewPublic/Thread/View.php
  132. library/XenForo/ViewPublic/Base.php
  133. library/XenForo/View.php
  134. library/EWRporta/Listener/ViewPublic.php
  135. library/EWRporta/ViewPublic/Custom.php
  136. library/XenForo/BbCode/Parser.php
  137. library/XenForo/BbCode/Formatter/Base.php
  138. library/EWRporta/Listener/BbCode.php
  139. library/EWRporta/BbCode/Formatter.php
  140. library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
  141. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
  142. library/XenForo/ViewPublic/Helper/Message.php
  143. library/XenForo/BbCode/TextWrapper.php
  144. library/WhoHasVisited/Listener.php
  145. library/Waindigo/JoinUserGroup/Listener/TemplateCreate.php
  146. library/XenForo/Route/Prefix/Members.php
  147. library/bdTagMe/XenForo/Route/Prefix/Members.php
  148. library/EWRporta/Listener/NavTabs.php
  149. library/ExternalPages/Listeners/Navigation.php
  150. library/ExternalPages/Route/Prefix/En.php
  151. library/Dark/TaigaChat/EventListener/NavigationTabs.php
  152. library/XenForo/Template/FileHandler.php
  153. library/XenForo/Helper/File.php
  154. internal_data/templates/S.7,L.1,thread_view.php
  155. library/SeparateStickyAndNormal/Listener.php
  156. library/EWRporta/Listener/Template.php
  157. library/EWRporta/Model/Promotes.php
  158. library/Waindigo/JoinUserGroup/Listener/TemplateHook.php
  159. internal_data/templates/S.7,L.1,ignore_thread_tool.php
  160. internal_data/templates/S.7,L.1,page_nav.php
  161. library/XenForo/Route/Prefix/Posts.php
  162. library/XenForo/Model/Avatar.php
  163. internal_data/templates/S.7,L.1,RT_UserOnlineRibbon.php
  164. internal_data/templates/S.7,L.1,dark_postrating_message_user_info.php
  165. library/XenForo/ViewPublic/Helper/User.php
  166. library/XenForo/Model/UserField.php
  167. internal_data/templates/S.7,L.1,dark_postrating.php
  168. internal_data/templates/S.7,L.1,bb_code_tag_quote.php
  169. library/XenForo/Helper/Criteria.php
  170. library/XenForo/Debug.php
  171. internal_data/templates/S.7,L.1,PAGE_CONTAINER.php
  172. library/XenForo/ViewRenderer/Json.php