AuRORA Borealis SC

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
    Georon
    | W, DEF, DM
    Rookie
    C
    C
    N
    Aelsar
    | S, W, CF
    Coach
    B
    C
    N
    Damas jean
    | AM, S, DM
    Rookie
    A
    A
    N
    Jair3k
    | W, DM, DEF
    Rookie
    C
    C
    C
    Efrain
    | DM, S, AM
    C
    B
    C
    Cromerov10
    | S, AM, G
    Rookie
    B
    C
    B
    Tsamba
    | S, AM, CF
    Rookie
    A
    A
    N
    BRArchaeologist
    | CB, DM, DEF
    Rookie
    D
    D
    N
    SpeakeasySoccerNoah
    | CB, DEF, AM
    Admin
    C
    D
    N
    JordanTaylor
    | DM, AM, S
    Rookie
    C
    D
    D
      966
      Array
(
    [team_id] => 966
    [sport_id] => 9
    [league_id] => 0
    [division_id] => 
    [wins] => 0
    [losses] => 0
    [wins_all] => 0
    [losses_all] => 0
    [fullname] => AuRORA Borealis SC
    [shortname] => 
    [abbr] => 
    [fullmascot] => 
    [shortmascot] => 
    [url] => team-austin-soccer-1715737630
    [logo_id] => 9999
    [court_id] => 0
    [color_id] => #18f2e3
    [max_roster_size] => 15
    [gallery_id] => 0
    [approved] => 1
    [active] => 1
    [current_roster_size] => 10
    [owner_id] => 9342
    [public] => 1
    [chat_room_id] => 0
    [personal] => 0
    [deleted] => 0
    [invite_code] => 
    [featured_bg] => 6542
    [color_id_2] => #9313fb
    [color_id_3] => #000000
    [description] => 
    [shirt_color] => 
    [jersey_img] => 0
    [jersey_img_away] => 0
    [leagues] => 1
    [thumb] => /files/gallery/misc/thumbs/ce924d24816e45fc89a061e50b59e62e_recjoe1716245721.png
    [large] => /files/gallery/misc/ce924d24816e45fc89a061e50b59e62e_recjoe1716245721.png
    [alt] => League
    [name] => AuRORA Borealis SC
    [sport_name] => Soccer
    [sport_icon] => fa-solid fa-futbol
    [sport_url] => soccer
    [gameimage] => 
    [roster] => 1
    [earnings] => -
    [group_type] => teams
    [teamorg] => 
    [link] => /team/team-austin-soccer-1715737630/
    [image] => Array
        (
            [id] => team-austin-soccer-1715737630
            [thumb] => /files/gallery/misc/thumbs/ce924d24816e45fc89a061e50b59e62e_recjoe1716245721.png
            [large] => /files/gallery/misc/ce924d24816e45fc89a061e50b59e62e_recjoe1716245721.png
            [alt] => League
            [link] => /team/team-austin-soccer-1715737630/
        )

    [label] => team
    [game] => All Games
    [tools] => Array
        (
            [score] => 
            [homelink] => /team/team-austin-soccer-1715737630/
            [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] => 9
    [sponsors] => 0
    [reports] => 0
)
      PEAK MEMORY: 13.09 MiB
      MEMORY USAGE AFTER: 10.22 MiB

      Debug Information


      Request Variables

      var = team

      varb = team-austin-soccer-1715737630

      vara =

      varc =

      vard =

      vare =

      Debug Messages

      Site ID: 1

      Sub Domain:

      Domain: netstuffersdev1.com

      Site name: LeagueJoe

      Template: lj

      SECURETOKEN: 08933f3ff80786e63634d46dc1c3ff2e

      Login Type:

      BASE:: team

      FULL LINK:: team/team-austin-soccer-1715737630

      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 = 08933f3ff80786e63634d46dc1c3ff2e
      fullstate =


      Cookie Variables


      Server Variables

      USER = leaguejo_dev
      HOME = /home/leaguejo_dev
      SCRIPT_NAME = /index.php
      REQUEST_URI = /team/team-austin-soccer-1715737630/
      QUERY_STRING = var=team&varb=team-austin-soccer-1715737630
      REQUEST_METHOD = GET
      SERVER_PROTOCOL = HTTP/1.1
      GATEWAY_INTERFACE = CGI/1.1
      REDIRECT_QUERY_STRING = var=team&varb=team-austin-soccer-1715737630
      REDIRECT_URL = /team/team-austin-soccer-1715737630/
      REMOTE_PORT = 33390
      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 = 3.145.12.195
      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-austin-soccer-1715737630
      HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
      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-austin-soccer-1715737630/
      SCRIPT_URL = /team/team-austin-soccer-1715737630/
      UNIQUE_ID = ZzQCLpaSGK0lUDVWk9AYkQAAAMw
      REDIRECT_STATUS = 200
      REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
      REDIRECT_HTTPS = on
      REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/team/team-austin-soccer-1715737630/
      REDIRECT_SCRIPT_URL = /team/team-austin-soccer-1715737630/
      REDIRECT_UNIQUE_ID = ZzQCLpaSGK0lUDVWk9AYkQAAAMw
      FCGI_ROLE = RESPONDER
      PHP_SELF = /index.php
      REQUEST_TIME_FLOAT = 1731461678.8076
      REQUEST_TIME = 1731461678


      SQL Queries


      Total Queries: 143
      Total Execution Time: 45.0066ms
      Avg Execution Time:0.31473146853147ms

      QUERY(1.925ms) - 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-13', '01:34:38', 'GET', '/team/team-austin-soccer-1715737630/', '3.145.12.195', 'https://netstuffersdev1.com/team/team-austin-soccer-1715737630' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheXRLOUFyTElVYXR5T0R3YW1QNm5aZXRLaC8xR04yVzlFN0ttbGFBbVFnWXNyOG53bFdPbjRLY2NaV2JjUEhRcTl1UGJrVG9mMFdUaUNFSm0rZ0wzWEg=','0','','1731461678') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

      QUERY(0.1519ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/team/team-austin-soccer-1715737630/'

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

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

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

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

      QUERY(0.1411ms) - SELECT * FROM userprofiles_config

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

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

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

      QUERY(0.1318ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.5159ms) - 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-austin-soccer-1715737630'

      QUERY(0.752ms) - 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-austin-soccer-1715737630' GROUP BY `teams`.`team_id`

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

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

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

      QUERY(0.114ms) - SELECT * FROM `teams_settings` WHERE `team_id`=966

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

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

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

      QUERY(0.1431ms) - SELECT COUNT(`sponsor_id`) FROM `teams_sponsors` WHERE `team_id`=966

      QUERY(2.1482ms) - SELECT COUNT(`player_id`) FROM `teams_players_scouting_reports` WHERE `team_id`=966

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

      QUERY(0.2639ms) - 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.1349ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='UTC'

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

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

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

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

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

      QUERY(0.1631ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.124ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.1481ms) - SELECT SQL_CACHE * FROM league_config

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

      QUERY(0.1602ms) - SELECT * FROM userprofiles_config

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

      QUERY(0.1221ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.4611ms) - 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-austin-soccer-1715737630'

      QUERY(0.685ms) - 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-austin-soccer-1715737630' GROUP BY `teams`.`team_id`

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

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

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

      QUERY(0.169ms) - SELECT * FROM `teams_settings` WHERE `team_id`=966

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

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

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

      QUERY(0.1619ms) - SELECT COUNT(`sponsor_id`) FROM `teams_sponsors` WHERE `team_id`=966

      QUERY(2.1892ms) - SELECT COUNT(`player_id`) FROM `teams_players_scouting_reports` WHERE `team_id`=966

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

      QUERY(0.1559ms) - SELECT `season_id` FROM `league_teams` WHERE `team_id`=966

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

      QUERY(0.483ms) - 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.1531ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=9

      QUERY(0.546ms) - 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.144ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=9

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

      QUERY(0.1521ms) - 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.1881ms) - 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.211ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=133 && `season_id`=254 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

      QUERY(0.21ms) - SELECT SQL_CACHE * FROM `league_schedule_options` WHERE `league_id`='133' && `season_id`='254' LIMIT 0,1

      QUERY(0.1819ms) - SELECT SQL_CACHE count(`company_id`) FROM `league_company_links` WHERE `league_id`='133' && (`season_id`='254' || `season_id`=0)

      QUERY(0.2301ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='133' && (`season_id`='254' || `season_id`=0)

      QUERY(0.1559ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=133 && `season_id`=0) || `season_id`='254'

      QUERY(1.1919ms) - SELECT SQL_CACHE count(`league_players_id`) FROM `league_players` INNER JOIN `league_levels` ON `league_players`.`access`=`league_levels`.`level_id` WHERE `league_id`='133' && `season_id`='254' &&`league_levels`.`score`>2 && `deleted`=0 && `alternate`=0

      QUERY(0.3979ms) - SELECT SQL_CACHE count(`league_players_id`) FROM `league_players` INNER JOIN `league_levels` ON `league_players`.`access`=`league_levels`.`level_id` WHERE `league_id`='133' && `season_id`='254' &&`league_players`.`access`=4 && `deleted`=0 && `alternate`=0

      QUERY(0.8578ms) - SELECT SQL_CACHE count(`league_players_id`) FROM `league_players` INNER JOIN `league_levels` ON `league_players`.`access`=`league_levels`.`level_id` WHERE `league_id`='133' && `season_id`='254' &&`league_levels`.`score`>2 && `quit`=0 && `alternate`=1

      QUERY(0.2198ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons_rules` WHERE `league_id`='133' || `season_id`='254' ORDER BY `season_id` DESC

      QUERY(0.1528ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='133' && `season_id`='254'

      QUERY(0.19ms) - SELECT SQL_CACHE count(`product_id`) FROM `products` WHERE `season_id`='254'

      QUERY(0.232ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons` WHERE `league_id`='133'

      QUERY(1.5361ms) - SELECT SQL_CACHE count(`season_id`) FROM `triumphs_awarded` WHERE `league_id`='133'

      QUERY(0.1578ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=133&&`season_id`=254 LIMIT 0,1

      QUERY(0.3202ms) - SELECT `game_id` FROM `games` WHERE `league_id`=133&&`season_id`=254&&`playoff`=1 LIMIT 0,1

      QUERY(0.1221ms) - SELECT `season_id` FROM `league_custom_content` WHERE `prizes` IS NOT NULL&&`season_id`=254 LIMIT 0,1

      QUERY(0.299ms) - SELECT SQL_CACHE `league_teams`.`team_id` FROM `league_teams` INNER JOIN `teams` ON `league_teams`.`team_id`=`teams`.`team_id` WHERE `league_teams`.`league_id`='133' && `league_teams`.`season_id`='254' && `teams`.`personal`=0 && `teams`.`deleted`=0 GROUP BY `league_teams`.`team_id`

      QUERY(0.2449ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='133' && `season_id`='254'

      QUERY(0.1922ms) - SELECT SQL_CACHE `leagues`.`max_players` AS `league_max`, `league_seasons`.`max_players` AS `season_max` FROM `leagues` INNER JOIN `league_seasons` ON `leagues`.`league_id`=`league_seasons`.`league_id` WHERE `leagues`.`league_id`='133' && `league_seasons`.`season_id`='254'

      QUERY(0.1431ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=133 && `season_id`=254 LIMIT 0,1

      QUERY(0.1149ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=133 && `season_id`=254

      QUERY(1.174ms) - INSERT INTO `league_cache` (`league_id`,`season_id`,`articles`,`participants`,`conferences`,`players`,`coaches`,`subs`,`rules`,`teams`,`games`,`groups`,`divisions`,`seasons`,`sponsors`,`products`,`prizes`,`triumphs`,`hotels`,`is_full`,`companies`,`reg_is_open`,`updated`,`show_playoff_menu`) VALUES ('133','254','10',0,0,'69','4','9',0,'4','19',0,0,'2',0,0,0,0,0,0,0,0,NOW(),0) ON DUPLICATE KEY UPDATE `league_id`='133',`season_id`='254',`articles`='10',`participants`=0,`conferences`=0,`players`='69',`coaches`='4',`subs`='9',`rules`=0,`teams`='4',`games`='19',`groups`=0,`divisions`=0,`seasons`='2',`sponsors`=0,`products`=0,`prizes`=0,`triumphs`=0,`hotels`=0,`is_full`=0,`companies`=0,`reg_is_open`=0,`updated`=NOW(),`show_playoff_menu`=0

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

      QUERY(0.1268ms) - SELECT * FROM `teams_privacy` WHERE `team_id`=966

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

      QUERY(0.1409ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.1609ms) - SELECT `league_id`,`season_id` FROM `league_teams` WHERE `team_id`=966

      QUERY(0.4799ms) - 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.1831ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=9

      QUERY(0.5071ms) - 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.145ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=9

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

      QUERY(0.1688ms) - 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.1559ms) - 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.226ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=133 && `season_id`=254 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

      QUERY(0.1302ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.128ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.1221ms) - SELECT SQL_CACHE * FROM league_config

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

      QUERY(0.1411ms) - SELECT * FROM userprofiles_config

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

      QUERY(0.109ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.123ms) - SELECT * FROM `teams_privacy` WHERE `team_id`=966

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

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

      QUERY(0.2921ms) - 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.1209ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='sports'

      QUERY(0.108ms) - SELECT SQL_CACHE * FROM sports_config

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

      QUERY(0.1199ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.1249ms) - SELECT SQL_CACHE * FROM league_config

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

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

      QUERY(0.7179ms) - 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.1531ms) - SELECT SQL_CACHE `wins`,`losses`,`ties` FROM `standings` WHERE `team_id`=965 && `league_id`='133' && `season_id`='254'

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

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

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

      QUERY(4.0081ms) - 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` = '966' and `teams_players`.`quit` = '0' ORDER BY `users`.`last_name` ASC LIMIT 0,500

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

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

      QUERY(0.452ms) - 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`=966 && (`coach`=1 || `access`=4 || `access`=5 || `access`=6) ORDER BY `access` DESC

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

      QUERY(0.139ms) - SELECT * FROM userprofiles_config

      QUERY(0.427ms) - 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`='aelsar' LIMIT 0,1

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

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

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

      QUERY(0.1252ms) - SELECT SQL_CACHE * FROM draft_config

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

      QUERY(0.468ms) - 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`=9342 && `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.3738ms) - 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`=9342 && `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.3369ms) - 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`=9342 && `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.145ms) - SELECT * FROM `photo` WHERE `photo_id`=0

      QUERY(0.2069ms) - 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