Alfie's Army

Soccer

Speakeasy Soccer
Spring 2024

Spring 2024
Overall Team Skill Ratings

Striking

Passing

Ball Handling

Speed

Stamina

Defense

Goalkeeping

    Team Roster

    Player

    Striking
    Passing
    Ball Handling
    Speed
    Stamina
    Defense
    Goalkeeping
    JoshA
    | CB, DEF, G
    Rookie

    D
    D
    D
    Selyna11
    | S, AM, CF
    Rookie Muhcray

    B
    C
    N
    Emil
    | AM, CB, CF
    Rookie

    A
    A
    N
    navgh77
    | AM, DM, CB

    B
    B
    D
    gracieelizabethr
    | CF
    Rookie

    D
    D
    N
    7439sawyerl@gmail.com
    | W, DEF, S
    Coach

    C
    C
    D
    jschalch
    | DM, AM, DEF
    Rookie

    C
    C
    D
    Muhcray
    | W, S, CF

    B
    C
    D
    Corey Seltenright
    | AM, S, CB
    Rookie

    B
    B
    N
    Jdten7
    | DM, W, AM
    Rookie

    B
    C
    D
      964
      Array
      (
          [team_id] => 964
          [sport_id] => 9
          [league_id] => 0
          [division_id] => 
          [wins] => 0
          [losses] => 0
          [wins_all] => 0
          [losses_all] => 0
          [fullname] => Alfie's Army
          [shortname] => 
          [abbr] => 
          [fullmascot] => 
          [shortmascot] => 
          [url] => team-liam-soccer-1715737601
          [logo_id] => 9983
          [court_id] => 0
          [color_id] => #ff0505
          [max_roster_size] => 15
          [gallery_id] => 0
          [approved] => 1
          [active] => 1
          [current_roster_size] => 10
          [owner_id] => 9102
          [public] => 1
          [chat_room_id] => 0
          [personal] => 0
          [deleted] => 0
          [invite_code] => 
          [featured_bg] => 6542
          [color_id_2] => #000000
          [color_id_3] => #000000
          [description] => 
          [shirt_color] => 
          [jersey_img] => 0
          [jersey_img_away] => 0
          [leagues] => 1
          [thumb] => /files/gallery/misc/thumbs/alfies-army_recjoe1716234379.png
          [large] => /files/gallery/misc/alfies-army_recjoe1716234379.png
          [alt] => League
          [name] => Alfie's Army
          [sport_name] => Soccer
          [sport_icon] => fa-solid fa-futbol
          [sport_url] => soccer
          [gameimage] => 
          [roster] => 1
          [earnings] => -
          [group_type] => teams
          [teamorg] => 
          [link] => /team/team-liam-soccer-1715737601/
          [image] => Array
              (
                  [id] => team-liam-soccer-1715737601
                  [thumb] => /files/gallery/misc/thumbs/alfies-army_recjoe1716234379.png
                  [large] => /files/gallery/misc/alfies-army_recjoe1716234379.png
                  [alt] => League
                  [link] => /team/team-liam-soccer-1715737601/
              )
      
          [label] => team
          [game] => All Games
          [tools] => Array
              (
                  [score] => 
                  [homelink] => /team/team-liam-soccer-1715737601/
                  [homelink_type] => teams
              )
      
          [featured_bg_img] => https://leaguejoe.com/files/gallery/misc/default-green_recjoe1704996203.webp
          [settings] => 
          [perm_team_level] => 0
          [perm_team_name] => Guest
          [perm_team_score] => 0
          [score] => 0
          [games] => 10
          [sponsors] => 0
          [reports] => 0
      )
      
      PEAK MEMORY: 2.84 MiB
      MEMORY USAGE AFTER: 2.11 MiB

      Debug Information


      Request Variables

      var = team

      varb = team-liam-soccer-1715737601

      vara =

      varc =

      vard =

      vare =

      Debug Messages

      Site ID: 1

      Sub Domain:

      Domain: netstuffersdev1.com

      Site name: LeagueJoe

      Template: lj

      SECURETOKEN: 1bfd22dbc2503d143c0b4befed3d450f

      Login Type:

      BASE:: team

      FULL LINK:: team/team-liam-soccer-1715737601

      Page ID: 49

      Page ID:: 49

      Page Template:: lj

      Template Layout:: default

      Headers: : Loading page header code

      Active Blocks: Array ( [0] => [1] => 1 [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => 1 )

      Block Types: Array ( [0] => [1] => Array ( [0] => module ) [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => Array ( [0] => module ) )

      Element ID: Array ( [0] => [1] => Array ( [0] => 5 ) [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => Array ( [0] => 5 ) )

      Admin Login Level: :

      Admin Login Level: :

      Footer: : Loading page footer code


      Session Variables

      securetoken = 1bfd22dbc2503d143c0b4befed3d450f
      fullstate =


      Cookie Variables

      fikker-61vm-nk2N = MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E


      Server Variables

      USER = leaguejo_dev
      HOME = /home/leaguejo_dev
      SCRIPT_NAME = /index.php
      REQUEST_URI = /team/team-liam-soccer-1715737601/
      QUERY_STRING = var=team&varb=team-liam-soccer-1715737601
      REQUEST_METHOD = GET
      SERVER_PROTOCOL = HTTP/1.1
      GATEWAY_INTERFACE = CGI/1.1
      REDIRECT_QUERY_STRING = var=team&varb=team-liam-soccer-1715737601
      REDIRECT_URL = /team/team-liam-soccer-1715737601/
      REMOTE_PORT = 61197
      SCRIPT_FILENAME = /home/leaguejo_dev/public_html/index.php
      SERVER_ADMIN = support@aod.net
      CONTEXT_DOCUMENT_ROOT = /home/leaguejo_dev/public_html
      CONTEXT_PREFIX =
      REQUEST_SCHEME = https
      DOCUMENT_ROOT = /home/leaguejo_dev/public_html
      REMOTE_ADDR = 52.14.27.122
      SERVER_PORT = 443
      SERVER_ADDR = 162.248.190.150
      SERVER_NAME = netstuffersdev1.com
      SERVER_SOFTWARE = Apache
      SERVER_SIGNATURE =
      PATH = /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
      HTTP_HOST = netstuffersdev1.com
      HTTP_REFERER = https://netstuffersdev1.com/team/team-liam-soccer-1715737601
      HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
      HTTP_COOKIE = fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E
      HTTP_USER_AGENT = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
      HTTP_ACCEPT = */*
      proxy-nokeepalive = 1
      SSL_TLS_SNI = netstuffersdev1.com
      HTTPS = on
      SCRIPT_URI = https://netstuffersdev1.com/team/team-liam-soccer-1715737601/
      SCRIPT_URL = /team/team-liam-soccer-1715737601/
      UNIQUE_ID = Z0B4xdXtGKo7Io3KWprrOQAAAMw
      REDIRECT_STATUS = 200
      REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
      REDIRECT_HTTPS = on
      REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/team/team-liam-soccer-1715737601/
      REDIRECT_SCRIPT_URL = /team/team-liam-soccer-1715737601/
      REDIRECT_UNIQUE_ID = Z0B4xdXtGKo7Io3KWprrOQAAAMw
      FCGI_ROLE = RESPONDER
      PHP_SELF = /index.php
      REQUEST_TIME_FLOAT = 1732278469.0074
      REQUEST_TIME = 1732278469


      SQL Queries


      Total Queries: 122
      Total Execution Time: 36.4251ms
      Avg Execution Time:0.29856639344262ms

      QUERY(1.4148ms) - INSERT INTO security_log (domain,username, log_date, log_time, method, page, ip, address, browser, getvars, postvars, sessionvars,badlogin,userlogin,timestamp) VALUES ('.netstuffersdev1.com','','2024-11-22', '12:27:49', 'GET', '/team/team-liam-soccer-1715737601/', '52.14.27.122', 'https://netstuffersdev1.com/team/team-liam-soccer-1715737601' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhekhBMjNwZU5TNWFoU1FHVmJoQ2pEWUQvMzIrRWlvWWFZZ1B3ZEhpZmRYOERTdFp2LzZRbWRwZHpQZU9qYjg3Q1drQ2JNK3A4aHlkUXcvdnh3VXhraTY=','0','','1732278469') ON DUPLICATE KEY UPDATE `ip`=`ip`

      QUERY(1.6561ms) - SELECT SQL_CACHE `end_timestamp` FROM `security_locks` WHERE ((`who`='52.14.27.122' && `which`='IP'))

      QUERY(0.1471ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/team/team-liam-soccer-1715737601/'

      QUERY(0.236ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='team/team-liam-soccer-1715737601' ORDER BY `domain`='1' DESC,`domain` ASC

      QUERY(0.2489ms) - SELECT SQL_CACHE `id`,`layout`,`light`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='team' ORDER BY `domain`='1' DESC,`domain` ASC

      QUERY(0.1249ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay`,`customize` FROM `pages` WHERE `id`='49'

      QUERY(0.149ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='userprofiles'

      QUERY(0.176ms) - SELECT * FROM userprofiles_config

      QUERY(0.1841ms) - SELECT SQL_CACHE `name` FROM `states` WHERE `abbr`='' LIMIT 0,1

      QUERY(0.1659ms) - SELECT SQL_CACHE title,metakeys,metadescript,seomodule,seotitlefield,seodescfield,seotitletable,seodesctable,urllinkfield FROM pages WHERE `id`='49' && `domain`='1'

      QUERY(0.144ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.134ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.5119ms) - SELECT COUNT(*) FROM `teams` LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `leagues` ON (`teams`.`league_id` = `leagues`.`league_id`) LEFT JOIN `teams_players` ON (`teams`.`team_id` = `teams_players`.`team_id`) LEFT JOIN `sports` ON (`teams`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `gamephoto` ON (`sports`.`logo_id` = `gamephoto`.`photo_id`) INNER JOIN `teams_privacy` ON (`teams`.`team_id` = `teams_privacy`.`team_id`) WHERE `teams`.`url` = 'team-liam-soccer-1715737601'

      QUERY(0.742ms) - SELECT SQL_CACHE `teams`.*,(SELECT COUNT(`team_id`) FROM `league_teams` WHERE `league_teams`.`team_id`=`teams`.`team_id`) AS `leagues`,`photo`.`thumb_url` AS `thumb`,`photo`.`img_url` AS `large`,`photo`.`title` AS `alt`,`leagues`.`name`,`teams_players`.`player_id`,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`gamephoto`.`img_url` AS `gameimage`,`teams_privacy`.`public`,`teams_privacy`.`roster` FROM `teams` LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `leagues` ON (`teams`.`league_id` = `leagues`.`league_id`) LEFT JOIN `teams_players` ON (`teams`.`team_id` = `teams_players`.`team_id`) LEFT JOIN `sports` ON (`teams`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `gamephoto` ON (`sports`.`logo_id` = `gamephoto`.`photo_id`) INNER JOIN `teams_privacy` ON (`teams`.`team_id` = `teams_privacy`.`team_id`) WHERE `teams`.`url` = 'team-liam-soccer-1715737601' GROUP BY `teams`.`team_id`

      QUERY(0.221ms) - SELECT `team_id`, `league_id` FROM `league_teams` WHERE `league_id` = 0 AND `season_id` = 0 AND `team_id` = 964 LIMIT 1

      QUERY(0.1221ms) - SELECT SQL_CACHE `img_url` FROM `photo` WHERE `photo_id`=6542 LIMIT 0,1

      QUERY(0.231ms) - SELECT COUNT(`player_id`) FROM `teams_players` WHERE `team_id`=964 && quit=0

      QUERY(0.1171ms) - SELECT * FROM `teams_settings` WHERE `team_id`=964

      QUERY(0.17ms) - SELECT SQL_CACHE * FROM `teams_cache` WHERE `team_id`=964 && `updated`>=(NOW() - INTERVAL 60 MINUTE) LIMIT 0,1

      QUERY(0.1431ms) - SELECT * FROM `teams_merch_settings` WHERE `team_id`=964 LIMIT 0,1

      QUERY(0.3119ms) - SELECT COUNT(`game_id`) FROM `games` WHERE (`home_team_id`=964||`away_team_id`=964) && `cancelled`=0

      QUERY(0.159ms) - SELECT COUNT(`sponsor_id`) FROM `teams_sponsors` WHERE `team_id`=964

      QUERY(2.1489ms) - SELECT COUNT(`player_id`) FROM `teams_players_scouting_reports` WHERE `team_id`=964

      QUERY(0.164ms) - INSERT INTO `teams_cache` (`team_id`,`products`,`sponsors`,`reports`) VALUES ('964',0,0,0) ON DUPLICATE KEY UPDATE `team_id`='964',`products`=0,`sponsors`=0,`reports`=0

      QUERY(0.227ms) - SELECT SQL_CACHE `code` FROM `page_headers` WHERE (`domain`=1||domain_global=1) && (`include` LIKE '%:49:%' || (`global`=1 && `exclude` NOT LIKE '%:49:%') ) ORDER BY `id` ASC

      QUERY(0.1311ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='UTC'

      QUERY(0.2301ms) - SELECT count(`league_id`) FROM `league_players` WHERE `player_id`=''

      QUERY(0.2019ms) - SELECT SQL_CACHE `block_id`,`element_id`,`function_id`,`type` FROM `blocks` WHERE `page_id`='49' ORDER BY `order` ASC

      QUERY(0.221ms) - SELECT `abbr`,`name` FROM `states` WHERE `active`=1 ORDER BY `name` ASC

      QUERY(0.124ms) - select SQL_CACHE codename,classname,scriptname from modules WHERE `id`='5'

      QUERY(0.1502ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.1311ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.1359ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.1061ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.1261ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

      QUERY(0.1578ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.2019ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='userprofiles'

      QUERY(0.1271ms) - SELECT * FROM userprofiles_config

      QUERY(0.1578ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='draft'

      QUERY(0.129ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.607ms) - SELECT COUNT(*) FROM `teams` LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `leagues` ON (`teams`.`league_id` = `leagues`.`league_id`) LEFT JOIN `teams_players` ON (`teams`.`team_id` = `teams_players`.`team_id`) LEFT JOIN `sports` ON (`teams`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `gamephoto` ON (`sports`.`logo_id` = `gamephoto`.`photo_id`) INNER JOIN `teams_privacy` ON (`teams`.`team_id` = `teams_privacy`.`team_id`) WHERE `teams`.`url` = 'team-liam-soccer-1715737601'

      QUERY(0.8502ms) - SELECT SQL_CACHE `teams`.*,(SELECT COUNT(`team_id`) FROM `league_teams` WHERE `league_teams`.`team_id`=`teams`.`team_id`) AS `leagues`,`photo`.`thumb_url` AS `thumb`,`photo`.`img_url` AS `large`,`photo`.`title` AS `alt`,`leagues`.`name`,`teams_players`.`player_id`,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`gamephoto`.`img_url` AS `gameimage`,`teams_privacy`.`public`,`teams_privacy`.`roster` FROM `teams` LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `leagues` ON (`teams`.`league_id` = `leagues`.`league_id`) LEFT JOIN `teams_players` ON (`teams`.`team_id` = `teams_players`.`team_id`) LEFT JOIN `sports` ON (`teams`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `gamephoto` ON (`sports`.`logo_id` = `gamephoto`.`photo_id`) INNER JOIN `teams_privacy` ON (`teams`.`team_id` = `teams_privacy`.`team_id`) WHERE `teams`.`url` = 'team-liam-soccer-1715737601' GROUP BY `teams`.`team_id`

      QUERY(0.21ms) - SELECT `team_id`, `league_id` FROM `league_teams` WHERE `league_id` = 0 AND `season_id` = 0 AND `team_id` = 964 LIMIT 1

      QUERY(0.1299ms) - SELECT SQL_CACHE `img_url` FROM `photo` WHERE `photo_id`=6542 LIMIT 0,1

      QUERY(0.2801ms) - SELECT COUNT(`player_id`) FROM `teams_players` WHERE `team_id`=964 && quit=0

      QUERY(0.139ms) - SELECT * FROM `teams_settings` WHERE `team_id`=964

      QUERY(0.206ms) - SELECT SQL_CACHE * FROM `teams_cache` WHERE `team_id`=964 && `updated`>=(NOW() - INTERVAL 60 MINUTE) LIMIT 0,1

      QUERY(0.1371ms) - SELECT * FROM `teams_merch_settings` WHERE `team_id`=964 LIMIT 0,1

      QUERY(0.386ms) - SELECT COUNT(`game_id`) FROM `games` WHERE (`home_team_id`=964||`away_team_id`=964) && `cancelled`=0

      QUERY(0.154ms) - SELECT COUNT(`sponsor_id`) FROM `teams_sponsors` WHERE `team_id`=964

      QUERY(2.2151ms) - SELECT COUNT(`player_id`) FROM `teams_players_scouting_reports` WHERE `team_id`=964

      QUERY(0.1919ms) - INSERT INTO `teams_cache` (`team_id`,`products`,`sponsors`,`reports`) VALUES ('964',0,0,0) ON DUPLICATE KEY UPDATE `team_id`='964',`products`=0,`sponsors`=0,`reports`=0

      QUERY(0.1619ms) - SELECT `season_id` FROM `league_teams` WHERE `team_id`=964

      QUERY(0.1311ms) - SELECT `league_id` FROM `league_seasons` WHERE `season_id`=254 LIMIT 0,1

      QUERY(0.551ms) - SELECT SQL_CACHE `leagues`.*,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`photo`.`img_url`,`photo`.`photo_id` AS `league_logo_id`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,(SELECT COUNT(*) FROM `league_teams` WHERE `league_id`=`leagues`.`league_id`) AS `teams` FROM `leagues` INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`leagues`.`venue_id` = `venues`.`venue_id`) WHERE `leagues`.`league_id` = '133' LIMIT 0,1

      QUERY(0.165ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=9

      QUERY(0.561ms) - SELECT SQL_CACHE `league_seasons`.*,`league_seasons`.`url` AS season_url,`photo`.`img_url`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date`,`league_dates`.`manual_date_display` FROM `league_seasons` LEFT JOIN `photo` ON (`league_seasons`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_seasons`.`league_id` = '133' and `league_seasons`.`season_id` = '254' ORDER BY `league_dates`.`start_date` ASC

      QUERY(0.159ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=9

      QUERY(0.17ms) - SELECT SQL_CACHE `zone_name` FROM `zone` WHERE `zone_id`=1026 LIMIT 0,1

      QUERY(0.2279ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit`,`total_pay_required` FROM `league_custom_content` WHERE `league_id`=133 && `season_id`=254 LIMIT 0,1

      QUERY(0.232ms) - SELECT SQL_CACHE `allow_couples`,`disable_standings`,`type`,`groups`,`group_size`,`divisions`,`schedule_type`,`allow_alts`,`show_schedule_level` FROM `league_schedule_options` WHERE `league_id`=133 && `season_id`=254 LIMIT 0,1

      QUERY(0.2761ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=133 && `season_id`=254 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

      QUERY(0.195ms) - SELECT SQL_CACHE `enabled` FROM `league_merch` WHERE `season_id`=254 LIMIT 0,1

      QUERY(0.1528ms) - SELECT * FROM `teams_privacy` WHERE `team_id`=964

      QUERY(0.149ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

      QUERY(0.1531ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.1891ms) - SELECT `league_id`,`season_id` FROM `league_teams` WHERE `team_id`=964

      QUERY(0.536ms) - SELECT SQL_CACHE `leagues`.*,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`photo`.`img_url`,`photo`.`photo_id` AS `league_logo_id`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,(SELECT COUNT(*) FROM `league_teams` WHERE `league_id`=`leagues`.`league_id`) AS `teams` FROM `leagues` INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`leagues`.`venue_id` = `venues`.`venue_id`) WHERE `leagues`.`league_id` = '133' LIMIT 0,1

      QUERY(0.155ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=9

      QUERY(0.5491ms) - SELECT SQL_CACHE `league_seasons`.*,`league_seasons`.`url` AS season_url,`photo`.`img_url`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date`,`league_dates`.`manual_date_display` FROM `league_seasons` LEFT JOIN `photo` ON (`league_seasons`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_seasons`.`league_id` = '133' and `league_seasons`.`season_id` = '254' ORDER BY `league_dates`.`start_date` ASC

      QUERY(0.175ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=9

      QUERY(0.108ms) - SELECT SQL_CACHE `zone_name` FROM `zone` WHERE `zone_id`=1026 LIMIT 0,1

      QUERY(0.18ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit`,`total_pay_required` FROM `league_custom_content` WHERE `league_id`=133 && `season_id`=254 LIMIT 0,1

      QUERY(0.1669ms) - SELECT SQL_CACHE `allow_couples`,`disable_standings`,`type`,`groups`,`group_size`,`divisions`,`schedule_type`,`allow_alts`,`show_schedule_level` FROM `league_schedule_options` WHERE `league_id`=133 && `season_id`=254 LIMIT 0,1

      QUERY(0.1991ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=133 && `season_id`=254 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

      QUERY(0.186ms) - SELECT SQL_CACHE `enabled` FROM `league_merch` WHERE `season_id`=254 LIMIT 0,1

      QUERY(0.3011ms) - SELECT count(player_id) AS `player`,`coach`,`access`,`team_player_id` AS `tpi` FROM `teams_players` WHERE `team_id`='964' && `player_id`='' && `quit`=0 ORDER BY `season_id` DESC

      QUERY(0.1242ms) - select SQL_CACHE codename,classname,scriptname from modules WHERE `id`='5'

      QUERY(0.119ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.1159ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.1171ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.113ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.1109ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

      QUERY(0.1051ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.1321ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='userprofiles'

      QUERY(0.1321ms) - SELECT * FROM userprofiles_config

      QUERY(0.1321ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='draft'

      QUERY(0.128ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.1349ms) - SELECT * FROM `teams_privacy` WHERE `team_id`=964

      QUERY(0.2048ms) - SELECT * FROM `team_strength` WHERE `team_id`=964 && `season_id`=254

      QUERY(0.1981ms) - SELECT * FROM `team_strength` WHERE `team_id`=964 && `season_id`=254

      QUERY(0.3021ms) - SELECT SQL_CACHE `attribute`.`attribute_id`,`attribute`.`name`,`attribute`.`description`,`attribute`.`url`,`attribute`.`icon`,`attribute`.`min`,`attribute`.`max` FROM `attribute` WHERE `attribute`.`sport_id` = '9' and `attribute`.`active` = '1' ORDER BY `attribute`.`fieldorder` asc

      QUERY(0.1199ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='sports'

      QUERY(0.102ms) - SELECT SQL_CACHE * FROM sports_config

      QUERY(0.1271ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='teams'

      QUERY(0.1161ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.1349ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

      QUERY(0.108ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.1819ms) - SELECT `position_id`,UPPER(`abbr`) AS `abbr` FROM `sports_positions` WHERE `sport_id`=9

      QUERY(0.1369ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='133' && `season_id`='254'

      QUERY(0.772ms) - SELECT SQL_CACHE `teams`.`url`,`teams`.`team_id`,`teams`.`fullname`,`teams`.`personal`,`teams`.`owner_id`,(SELECT `player_id` FROM `teams_players` WHERE `team_id`=`teams`.`team_id` && `access`=4 LIMIT 0,1) AS `coach_id`,`league_teams`.`league_teams_id`,`league_teams`.`league_id`,`league_teams`.`season_id`,`league_teams`.`ready`,`users`.`user_url`,`users`.`username`,`users`.`first_name`,`users`.`last_name`,`photo`.`thumb_url` FROM `teams` INNER JOIN `league_teams` ON (`teams`.`team_id` = `league_teams`.`team_id`) LEFT JOIN `users` ON (`teams`.`owner_id` = `users`.`id`) LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) WHERE `teams`.`approved` = '1' and `teams`.`active` = '1' and `league_teams`.`deleted` != '1' and `teams`.`personal` = '0' and `league_teams`.`league_id` = '133' and `league_teams`.`season_id` = '254' ORDER BY `teams`.`fullname` desc

      QUERY(0.1528ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=965 && `league_id`='133' && `season_id`='254'

      QUERY(0.15ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=963 && `league_id`='133' && `season_id`='254'

      QUERY(0.186ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=966 && `league_id`='133' && `season_id`='254'

      QUERY(0.164ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=964 && `league_id`='133' && `season_id`='254'

      QUERY(4.1621ms) - SELECT SQL_CACHE `users`.`rookie`,`users`.`id`,`users`.`username`,`users`.`first_name`,`users`.`last_name`,`users`.`avatar_id`,`users`.`gender`,`users`.`user_url`,`users`.`level`,`users`.`confirmed`,`users`.`phone_number`,`users`.`email`,`users`.`approved`,`users`.`noemail`,`teams_players`.`player_id`,`teams_players`.`alternate`,`teams_players`.`coach`,`teams_players`.`paid`,`teams_players`.`couple`,`teams_players`.`couple_uname`,`teams_players`.`first_name` AS `manual_first_name`,`teams_players`.`last_name` AS `manual_last_name`,`teams_players`.`email` AS `manual_email`,`league_players`.`league_players_id`,`league_players`.`ready`,`league_players`.`season_id`,`league_players`.`created`,`league_players`.`package_id`,`league_players`.`closed`,`league_players`.`moretime`,`league_players`.`player_id`,`league_players`.`league_id`,`league_players`.`alternate`,`league_players`.`coach`,`league_players`.`paid`,`league_players`.`couple`,`league_players`.`couple_uname`,`league_players`.`access`,`league_players`.`nosalary`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=32 LIMIT 0,1) AS `stamina`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=33 LIMIT 0,1) AS `goalkeeping`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=34 LIMIT 0,1) AS `speed`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=35 LIMIT 0,1) AS `passing`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=36 LIMIT 0,1) AS `striking`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=37 LIMIT 0,1) AS `defense`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=38 LIMIT 0,1) AS `dribble`,(SELECT `salary` FROM `draft_scouting_reports` WHERE `draft_scouting_reports`.`player_id`=`league_players`.`player_id` && `draft_scouting_reports`.`season_id`=`league_players`.`season_id` ORDER BY `lock` DESC LIMIT 0,1) AS `salary`,(SELECT `injury` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=1 && `sports_positions`.`sport_id`=9 ORDER BY `season_id`=254 DESC LIMIT 0,1) AS `injury`,(SELECT `abbr` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=1 && `sports_positions`.`sport_id`=9 ORDER BY `season_id`=254 DESC LIMIT 0,1) AS `primary`,(SELECT `abbr` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=2 && `sports_positions`.`sport_id`=9 ORDER BY `season_id`=254 DESC LIMIT 0,1) AS `secondary`,(SELECT `abbr` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=3 && `sports_positions`.`sport_id`=9 ORDER BY `season_id`=254 DESC LIMIT 0,1) AS `tertiary`,(SELECT `thumb_url` FROM `photo` WHERE `photo_id`=`users`.`avatar_id`) AS `avatar` FROM `users` INNER JOIN `teams_players` ON (`users`.`id` = `teams_players`.`player_id`) INNER JOIN `league_players` ON (`users`.`id` = `league_players`.`player_id`) WHERE `league_players`.`season_id` = '254' and `teams_players`.`team_id` = '964' and `teams_players`.`quit` = '0' ORDER BY `users`.`last_name` ASC LIMIT 0,500

      QUERY(0.237ms) - SELECT * FROM `attribute` WHERE `sport_id`=9 ORDER BY `fieldorder` ASC

      QUERY(0.1531ms) - SELECT `name`,`abbr` FROM `sports_positions` WHERE `sport_id`=1

      QUERY(0.3672ms) - SELECT `player_id` AS coach_id,`team_id`,`users`.`username`,`users`.`user_url`,`img_url` FROM `teams_players` INNER JOIN `users` ON `player_id`=`id` INNER JOIN `photo` ON `photo_id`=`avatar_id` WHERE `teams_players`.`team_id`=964 && (`coach`=1 || `access`=4 || `access`=5 || `access`=6) ORDER BY `access` DESC

      QUERY(0.123ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='userprofiles'

      QUERY(0.1328ms) - SELECT * FROM userprofiles_config

      QUERY(0.3831ms) - SELECT SQL_CACHE `users`.*,`cart_customers`.`customer_id` FROM `users` LEFT JOIN `users_profile` ON `users_profile`.`user_id`=`users`.`id` LEFT JOIN `cart_customers` ON `cart_customers`.`user_id`=`users`.`id` WHERE `users`.`user_url`='7439sawyerl' LIMIT 0,1

      QUERY(0.1171ms) - SELECT `img_url`,`thumb_url` FROM `photo` WHERE `photo_id`=99

      QUERY(0.2351ms) - SELECT SQL_CACHE * FROM `userprofiles_cache` WHERE `user_id`=9102 && `updated`>=(NOW() - INTERVAL 60 MINUTE)

      QUERY(0.1202ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='draft'

      QUERY(0.0901ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.2739ms) - SELECT * FROM `users_sizing` WHERE `user_id`=9102 && (`sport_id`=9 || `sport_id`=0) && (`season_id`=254 || `season_id`=0) ORDER BY `season_id` DESC, `sport_id` DESC

      QUERY(0.4089ms) - SELECT SQL_CACHE `sports_positions_link`.`position_id`,`injury`,`name`,`name_url`,`abbr`,`locked` FROM `sports_positions_link` INNER JOIN `sports_positions` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `user_id`=9102 && `sports_positions_link`.`sport_id`=9 && `primary`=1 && (`season_id`=254 || `season_id`=0) ORDER BY `season_id`=254 DESC LIMIT 0,1

      QUERY(0.3459ms) - SELECT SQL_CACHE `sports_positions_link`.`position_id`,`injury`,`name`,`name_url`,`abbr`,`locked` FROM `sports_positions_link` INNER JOIN `sports_positions` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `user_id`=9102 && `sports_positions_link`.`sport_id`=9 && `primary`=2 && (`season_id`=254 || `season_id`=0) ORDER BY `season_id`=254 DESC LIMIT 0,1

      QUERY(0.36ms) - SELECT SQL_CACHE `sports_positions_link`.`position_id`,`injury`,`name`,`name_url`,`abbr`,`locked` FROM `sports_positions_link` INNER JOIN `sports_positions` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `user_id`=9102 && `sports_positions_link`.`sport_id`=9 && `primary`=3 && (`season_id`=254 || `season_id`=0) ORDER BY `season_id`=254 DESC LIMIT 0,1

      QUERY(0.165ms) - SELECT * FROM `photo` WHERE `photo_id`=0

      QUERY(0.2122ms) - SELECT SQL_CACHE `code` FROM `page_footers` WHERE (`domain`=1||domain_global=1) && (`include` LIKE '%:49:%' || (`global`=1 && `exclude` NOT LIKE '%:49:%') ) ORDER BY `id` ASC