Mango Maniacs

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
    KimGleas
    | DEF, DM, W
    Rookie
    C
    B
    N
    Ghartson11
    | CF, S, W
    Rookie
    B
    B
    C
    zogdog602
    | AM, DM
    Rookie
    C
    C
    N
    Mladapo
    | W, S, CF
    Coach
    B
    C
    C
    HamishMunro
    | S, G, CB
    Rookie
    C
    D
    D
    Mario
    | W, AM, DEF
    B
    C
    N
    vernillaice
    | DEF, DM, CB
    Rookie
    N
    N
    N
    Toledo12
    | AM, DM, S
    Rookie Ctoledo13
    B
    B
    B
    Ctoledo13
    | AM, W, S
    Rookie Toledo12
    B
    B
    B
    Urfey
    | DEF, W, AM
    Rookie
    C
    D
    N
      963
      Array
(
    [team_id] => 963
    [sport_id] => 9
    [league_id] => 0
    [division_id] => 
    [wins] => 0
    [losses] => 0
    [wins_all] => 0
    [losses_all] => 0
    [fullname] => Mango Maniacs
    [shortname] => 
    [abbr] => 
    [fullmascot] => 
    [shortmascot] => 
    [url] => team-sope-soccer-1715737589
    [logo_id] => 9978
    [court_id] => 0
    [color_id] => #ffbf34
    [max_roster_size] => 15
    [gallery_id] => 0
    [approved] => 1
    [active] => 1
    [current_roster_size] => 10
    [owner_id] => 9219
    [public] => 1
    [chat_room_id] => 0
    [personal] => 0
    [deleted] => 0
    [invite_code] => 
    [featured_bg] => 6542
    [color_id_2] => #301adb
    [color_id_3] => #000000
    [description] => 
    [shirt_color] => 
    [jersey_img] => 0
    [jersey_img_away] => 0
    [city] => 
    [state] => 
    [created] => 2025-01-02 13:16:54
    [updated] => 0000-00-00 00:00:00
    [leagues] => Speakeasy Soccer - Spring 2024
    [season_id] => 254
    [thumb] => /files/gallery/misc/thumbs/25422a7c73c040c4a2ff8818112521b1_recjoe1716225974.jpeg
    [large] => /files/gallery/misc/25422a7c73c040c4a2ff8818112521b1_recjoe1716225974.jpeg
    [alt] => League
    [name] => Mango Maniacs
    [sport_name] => Soccer
    [sport_icon] => fa-solid fa-futbol
    [sport_url] => soccer
    [gameimage] => 
    [roster] => 1
    [coaches] => 1
    [leaders] => 
    [group_type] => teams
    [link] => /team/team-sope-soccer-1715737589/
    [image] => Array
        (
            [id] => team-sope-soccer-1715737589
            [thumb] => /files/gallery/misc/thumbs/25422a7c73c040c4a2ff8818112521b1_recjoe1716225974.jpeg
            [large] => /files/gallery/misc/25422a7c73c040c4a2ff8818112521b1_recjoe1716225974.jpeg
            [alt] => League
            [link] => /team/team-sope-soccer-1715737589/
        )

    [label] => team
    [tools] => Array
        (
            [score] => 
            [homelink] => /team/team-sope-soccer-1715737589/
            [homelink_type] => teams
        )

    [featured_bg_img] => https://leaguejoe.com/files/gallery/misc/default-green_recjoe1704996203.webp
    [settings] => 
    [merch_settings] => 
    [perm_team_level] => 0
    [perm_team_name] => Guest
    [perm_team_score] => 0
    [score] => 0
    [games] => 9
    [sponsors] => 0
    [reports] => 0
)
      PEAK MEMORY: 7.73 MiB
      MEMORY USAGE AFTER: 4.28 MiB

      Debug Information


      Request Variables

      var = team

      varb = team-sope-soccer-1715737589

      vara =

      varc =

      vard =

      vare =

      Debug Messages

      Site ID: 1

      Sub Domain:

      Domain: netstuffersdev1.com

      Site name: League Joe

      Template: lj

      SECURETOKEN: b8d4963778c86762f55c4a910b98d5b4

      Login Type:

      BASE:: team

      FULL LINK:: team/team-sope-soccer-1715737589

      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 [11] => [12] => [13] => [14] => [15] => )

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

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

      Admin Login Level: :

      Admin Login Level: :

      USER CACHE: User cache reset

      Footer: : Loading page footer code


      Session Variables

      securetoken = b8d4963778c86762f55c4a910b98d5b4
      fullstate =


      Cookie Variables

      laikanxia_cookie_id = 250223050137525
      laikanxia_google_v = 1


      Server Variables

      USER = leaguejo_dev
      HOME = /home/leaguejo_dev
      SCRIPT_NAME = /index.php
      REQUEST_URI = /team/team-sope-soccer-1715737589/
      QUERY_STRING = var=team&varb=team-sope-soccer-1715737589
      REQUEST_METHOD = GET
      SERVER_PROTOCOL = HTTP/1.1
      GATEWAY_INTERFACE = CGI/1.1
      REDIRECT_QUERY_STRING = var=team&varb=team-sope-soccer-1715737589
      REDIRECT_URL = /team/team-sope-soccer-1715737589/
      REMOTE_PORT = 63274
      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.22.77.244
      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-sope-soccer-1715737589
      HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
      HTTP_COOKIE = laikanxia_cookie_id=250223050137525; laikanxia_google_v=1
      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-sope-soccer-1715737589/
      SCRIPT_URL = /team/team-sope-soccer-1715737589/
      UNIQUE_ID = Z7o7NADJprv2ZrkYRdGJRQAAAJM
      REDIRECT_STATUS = 200
      REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
      REDIRECT_HTTPS = on
      REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/team/team-sope-soccer-1715737589/
      REDIRECT_SCRIPT_URL = /team/team-sope-soccer-1715737589/
      REDIRECT_UNIQUE_ID = Z7o7NADJprv2ZrkYRdGJRQAAAJM
      FCGI_ROLE = RESPONDER
      PHP_SELF = /index.php
      REQUEST_TIME_FLOAT = 1740258100.7171
      REQUEST_TIME = 1740258100


      SQL Queries


      Total Queries: 184
      Total Execution Time: 38.6671ms
      Avg Execution Time:0.2101472826087ms

      QUERY(1.0271ms) - INSERT INTO security_log (domain,username, log_date, log_time, method, page, ip, address, browser, getvars, postvars, sessionvars,badlogin,userlogin,timestamp) VALUES ('.netstuffersdev1.com','','2025-02-22', '21:01:40', 'GET', '/team/team-sope-soccer-1715737589/', '3.22.77.244', 'https://netstuffersdev1.com/team/team-sope-soccer-1715737589' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhd2VOeFpCdWZTMVBTL0hYSUlnUGlOUThXTWZWdzRCOVJwTkVaZVlWWjlIaVJnQklMV2dZTGZibDR1SjQwaG1wTW4zUExDMlo2NXVnOXhHU2VTcG9iVmM=','0','','1740258100') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

      QUERY(0.113ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/team/team-sope-soccer-1715737589/'

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

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

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

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

      QUERY(0.0911ms) - SELECT * FROM userprofiles_config

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

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

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

      QUERY(0.066ms) - SELECT SQL_CACHE * FROM teams_config

      QUERY(0.2952ms) - 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-sope-soccer-1715737589'

      QUERY(0.4098ms) - SELECT SQL_CACHE `teams`.*,(SELECT COUNT(`team_id`) FROM `league_teams` WHERE `league_teams`.`team_id`=`teams`.`team_id`) AS `leagues`,(SELECT `season_id` FROM `league_teams` WHERE `league_teams`.`team_id`=`teams`.`team_id` ORDER BY `season_id` DESC LIMIT 0,1) AS `season_id`,`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-sope-soccer-1715737589' GROUP BY `teams`.`team_id`

      QUERY(0.397ms) - SELECT SQL_CACHE tp.access,u.username,u.user_url,tl.name AS level FROM `teams_players` tp INNER JOIN `users` u ON tp.player_id=u.id INNER JOIN `teams_levels` tl ON tp.access=tl.level_id INNER JOIN `teams_levels` ON tp.`access`=`teams_levels`.`level_id` WHERE tp.`team_id`='963' && `teams_levels`.`score`>=40 GROUP BY u.id

      QUERY(0.2389ms) - SELECT SQL_CACHE `leagues`.`tournament`,`leagues`.`name`,`leagues`.`url`,`league_seasons`.`url` AS `season_url`,`league_seasons`.`name` AS `season_name` FROM `league_teams` INNER JOIN `leagues` ON `league_teams`.`league_id`=`leagues`.`league_id` INNER JOIN `league_seasons` ON `league_teams`.`season_id`=`league_seasons`.`season_id` WHERE `team_id`='963' GROUP BY `league_teams`.`team_id` LIMIT 0,3

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

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

      QUERY(0.0908ms) - SELECT * FROM `teams_settings` WHERE `team_id`=963

      QUERY(0.0999ms) - SELECT * FROM `teams_merch_settings` WHERE `team_id`=963

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

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

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

      QUERY(0.17ms) - SELECT COUNT(`sponsor_id`) FROM `teams_sponsors` WHERE `team_id`=963

      QUERY(0.658ms) - SELECT COUNT(`player_id`) FROM `teams_players_scouting_reports` WHERE `team_id`=963

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

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

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

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

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

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

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

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

      QUERY(0.0899ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.066ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.0732ms) - SELECT SQL_CACHE * FROM league_config

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

      QUERY(0.0691ms) - SELECT * FROM userprofiles_config

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

      QUERY(0.1018ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.3021ms) - 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-sope-soccer-1715737589'

      QUERY(0.3591ms) - SELECT SQL_CACHE `teams`.*,(SELECT COUNT(`team_id`) FROM `league_teams` WHERE `league_teams`.`team_id`=`teams`.`team_id`) AS `leagues`,(SELECT `season_id` FROM `league_teams` WHERE `league_teams`.`team_id`=`teams`.`team_id` ORDER BY `season_id` DESC LIMIT 0,1) AS `season_id`,`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-sope-soccer-1715737589' GROUP BY `teams`.`team_id`

      QUERY(0.2899ms) - SELECT SQL_CACHE tp.access,u.username,u.user_url,tl.name AS level FROM `teams_players` tp INNER JOIN `users` u ON tp.player_id=u.id INNER JOIN `teams_levels` tl ON tp.access=tl.level_id INNER JOIN `teams_levels` ON tp.`access`=`teams_levels`.`level_id` WHERE tp.`team_id`='963' && `teams_levels`.`score`>=40 GROUP BY u.id

      QUERY(0.1719ms) - SELECT SQL_CACHE `leagues`.`tournament`,`leagues`.`name`,`leagues`.`url`,`league_seasons`.`url` AS `season_url`,`league_seasons`.`name` AS `season_name` FROM `league_teams` INNER JOIN `leagues` ON `league_teams`.`league_id`=`leagues`.`league_id` INNER JOIN `league_seasons` ON `league_teams`.`season_id`=`league_seasons`.`season_id` WHERE `team_id`='963' GROUP BY `league_teams`.`team_id` LIMIT 0,3

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

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

      QUERY(0.0961ms) - SELECT * FROM `teams_settings` WHERE `team_id`=963

      QUERY(0.114ms) - SELECT * FROM `teams_merch_settings` WHERE `team_id`=963

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

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

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

      QUERY(0.119ms) - SELECT COUNT(`sponsor_id`) FROM `teams_sponsors` WHERE `team_id`=963

      QUERY(0.6602ms) - SELECT COUNT(`player_id`) FROM `teams_players_scouting_reports` WHERE `team_id`=963

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

      QUERY(0.1221ms) - SELECT `season_id` FROM `league_teams` WHERE `team_id`=963

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

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

      QUERY(0.226ms) - SELECT SQL_CACHE `league_seasons`.*,`league_seasons`.`url` AS season_url,`photo`.`img_url`,`photo`.`thumb_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.0958ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=9

      QUERY(0.103ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=254

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

      QUERY(0.1161ms) - 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.1001ms) - SELECT SQL_CACHE `redo_draft`,`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.1111ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=133 && `season_id`=254 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

      QUERY(0.4239ms) - 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.608ms) - 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`.`paid`=1||`league_players`.`moretime`=1) &&`league_levels`.`score`>2 && `deleted`=0 && `alternate`=0

      QUERY(0.3281ms) - 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`.`paid`=0 && `league_players`.`moretime`=1 &&`league_levels`.`score`>2 && `deleted`=0 && `alternate`=0

      QUERY(0.4392ms) - 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`.`paid`=1 && `league_levels`.`score`>2 && `deleted`=0 && `alternate`=0

      QUERY(0.2139ms) - SELECT SQL_CACHE count(DISTINCT(`league_players`.`player_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.3099ms) - 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.109ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons_rules` WHERE `league_id`='133' || `season_id`='254' ORDER BY `season_id` DESC

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

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

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

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

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

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

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

      QUERY(0.1681ms) - 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.144ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='133' && `season_id`='254'

      QUERY(0.1068ms) - 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.0768ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=133 && `season_id`=254 LIMIT 0,1

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

      QUERY(0.916ms) - INSERT INTO `league_cache` (`league_id`,`season_id`,`articles`,`participants`,`conferences`,`registered`,`players`,`moretime`,`paid`,`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','41','4','4','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,`registered`='69',`players`='41',`moretime`='4',`paid`='4',`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.1011ms) - SELECT SQL_CACHE `enabled` FROM `league_merch` WHERE `season_id`=254 LIMIT 0,1

      QUERY(0.0899ms) - SELECT * FROM `teams_privacy` WHERE `team_id`=963

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

      QUERY(0.067ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.102ms) - SELECT `league_id`,`season_id` FROM `league_teams` WHERE `team_id`=963

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

      QUERY(0.236ms) - SELECT SQL_CACHE `league_seasons`.*,`league_seasons`.`url` AS season_url,`photo`.`img_url`,`photo`.`thumb_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.098ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=9

      QUERY(0.1101ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=254

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

      QUERY(0.0958ms) - 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.124ms) - SELECT SQL_CACHE `redo_draft`,`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.104ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=133 && `season_id`=254 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

      QUERY(0.067ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.067ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.0799ms) - SELECT SQL_CACHE * FROM league_config

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

      QUERY(0.1361ms) - SELECT * FROM userprofiles_config

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

      QUERY(0.0951ms) - SELECT SQL_CACHE * FROM draft_config

      QUERY(0.0741ms) - SELECT * FROM `teams_privacy` WHERE `team_id`=963

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

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

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

      QUERY(0.0758ms) - SELECT SQL_CACHE * FROM sports_config

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

      QUERY(0.066ms) - SELECT SQL_CACHE * FROM teams_config

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

      QUERY(0.0942ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

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

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

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

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

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

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

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

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

      QUERY(0.0701ms) - SELECT * FROM userprofiles_config

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

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

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

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

      QUERY(0.1118ms) - SELECT SQL_CACHE * FROM league_config

      QUERY(0.741ms) - UPDATE users SET `lastip`='3.22.77.244' WHERE `id`=9219

      QUERY(0.2649ms) - SELECT COUNT(*) FROM `deadlines` INNER JOIN `users` ON (`deadlines`.`user_id` = `users`.`id`) LEFT JOIN `leagues` ON (`deadlines`.`league_id` = `leagues`.`league_id`) LEFT JOIN `teams` ON (`deadlines`.`team_id` = `teams`.`team_id`) LEFT JOIN `games` ON (`deadlines`.`game_id` = `games`.`game_id`) LEFT JOIN `apparel_orders` ON (`deadlines`.`order_id` = `apparel_orders`.`id`) LEFT JOIN `league_seasons` ON (`deadlines`.`season_id` = `league_seasons`.`season_id`) LEFT JOIN `prospects` ON (`deadlines`.`prospect_id` = `prospects`.`id`) WHERE `deadlines`.`deadline_date` >= DATE_ADD(CURDATE(), INTERVAL -3 DAY) and `deadlines`.`user_id` = '9219' and `deadlines`.`deleted` = '0' and `deadlines`.`deleted` = '0'

      QUERY(0.1278ms) - SELECT SQL_CACHE count(`company_player_id`) FROM `company_players` WHERE `player_id`=9219 && `company_id`>1 && `banned`=0

      QUERY(0.1361ms) - SELECT SQL_CACHE count(`awarded_id`) FROM `triumphs_awarded` WHERE `player_id`='9219' LIMIT 0,1

      QUERY(0.1309ms) - SELECT SQL_CACHE count(`awarded_id`) FROM `triumphs_awarded` WHERE `player_id`='9219' && `finish_rank`=1 LIMIT 0,1

      QUERY(0.1159ms) - SELECT SQL_CACHE count(`awarded_id`) FROM `triumphs_awarded` WHERE `player_id`='9219' && `finish_rank`=2 LIMIT 0,1

      QUERY(0.2949ms) - SELECT SQL_CACHE count(`teams`.`team_id`) FROM `teams` INNER JOIN `teams_players` ON `teams`.`team_id`=`teams_players`.`team_id` WHERE `teams_players`.`player_id`='9219'

      QUERY(0.1709ms) - SELECT COUNT(`coach`) FROM `league_players` WHERE `player_id`=9219 && (`coach`=1||`access`=4) && `deleted`=0 LIMIT 0,1

      QUERY(2.4891ms) - SELECT COUNT(`team_player_id`) FROM `teams_players` INNER JOIN `teams` ON `teams`.`team_id`=`teams_players`.`team_id` INNER JOIN `teams_levels` ON `teams_players`.`access`=`teams_levels`.`level_id` WHERE (`owner_id`=9219 || (`player_id`=9219 && `score`>=70)) && `deleted`=0 LIMIT 0,1

      QUERY(0.092ms) - SELECT `avatar_id` FROM `users` WHERE `id`=9219

      QUERY(0.1171ms) - SELECT COUNT(`report_id`) FROM `teams_players_scouting_reports` WHERE `player_id`=9219 && `public_text`!=''

      QUERY(0.1948ms) - SELECT COUNT(`league_players_id`) FROM `league_players` INNER JOIN `league_seasons` ON `league_seasons`.`season_id`=`league_players`.`season_id` INNER JOIN `leagues` ON `leagues`.`league_id`=`league_seasons`.`league_id` && `leagues`.`tournament`=0 WHERE `player_id`=9219 && `deleted`=0 &&`league_players`.`paid`=1 && `league_players`.`quit`=0

      QUERY(0.1791ms) - SELECT COUNT(`league_players_id`) FROM `league_players` INNER JOIN `league_seasons` ON `league_seasons`.`season_id`=`league_players`.`season_id` INNER JOIN `leagues` ON `leagues`.`league_id`=`league_seasons`.`league_id` && `leagues`.`tournament`=1 WHERE `player_id`=9219 && `deleted`=0 &&`league_players`.`paid`=1 && `league_players`.`quit`=0

      QUERY(0.169ms) - SELECT COUNT(`league_players_id`) FROM `league_players` INNER JOIN `league_seasons` ON `league_seasons`.`season_id`=`league_players`.`season_id` INNER JOIN `leagues` ON `leagues`.`league_id`=`league_seasons`.`league_id` && `leagues`.`ultra`=1 WHERE `player_id`=9219 && `deleted`=0 &&`league_players`.`paid`=1 && `league_players`.`quit`=0

      QUERY(1.436ms) - SELECT AVG(`salary`) FROM `draft_scouting_reports` WHERE `player_id`=9219

      QUERY(0.1779ms) - SELECT SUM(`points`) FROM `users_points` INNER JOIN `users_points_periods` ON `users_points`.`period_id`=`users_points_periods`.`id` WHERE `users_points_periods`.`active`=1 && `user_id`=9219 && `spent`=0

      QUERY(0.113ms) - SELECT SUM(`amount`) FROM `users_balance` WHERE `user_id`=9219 && `spent`=0

      QUERY(0.0911ms) - SELECT SUM(balance) FROM `users_overdue_balances` WHERE `player_id`=9219 && `paid`=0

      QUERY(0.1221ms) - SELECT AVG(`score`) FROM `users_trust` WHERE `user_id`=9219

      QUERY(0.1159ms) - SELECT COUNT(`user_id`) FROM `commish` WHERE `user_id`=9219 && `active`=1

      QUERY(0.0968ms) - SELECT id FROM `apparel_reps` WHERE `user_id`=9219 && `active`=1

      QUERY(0.1478ms) - SELECT COUNT(`id`) FROM `apparel_orders` INNER JOIN `cart_customers` ON `cart_customers`.`customer_id`=`apparel_orders`.`customer_id` WHERE `user_id`=9219 && `apparel_orders`.`active`=1

      QUERY(0.108ms) - SELECT `event` FROM `email_errors` WHERE `receiver_id`=9219 && `resolved`=0

      QUERY(0.0739ms) - SELECT `birthdate` FROM `users` WHERE `id`=9219

      QUERY(0.088ms) - UPDATE `users` SET `age`=33 WHERE `id`=9219

      QUERY(0.1688ms) - SELECT value,text FROM userprofile_fields_initialvalues WHERE field_id = 4

      QUERY(1.6899ms) - SELECT fieldvalue FROM userprofile_profiledata WHERE field_id = '4' && user_id='9219'

      QUERY(0.2341ms) - SELECT `name_url`,`sports`.`name` FROM `sports` INNER JOIN `leagues` ON `sports`.`sport_id`=`leagues`.`sport_id` INNER JOIN `league_players` ON `leagues`.`league_id`=`league_players`.`league_id` && `league_players`.`player_id`=9219 GROUP BY `sports`.`sport_id`

      QUERY(1.1671ms) - INSERT INTO `userprofiles_cache` (`user_id`,`clan_recruiter`,`team_recruiter`,`totalinvites`,`totaloffers`,`age`,`report_id`,`highlights`,`articles`,`venues`,`accomplishments`,`classifieds`,`tracked`,`freeagents`,`groups`,`teams`,`completion`,`unread_offers`,`personal_team`,`reviews`,`coach`,`ships`,`silvers`,`sports`,`active_leagues`,`active_tournaments`,`total_leagues`,`total_tournaments`,`total_ultras`,`avg_salary`,`points_balance`,`cash_balance`,`trust`,`overdue`,`companies`,`flags`,`commish`,`orders`,`service`,`deadlines`,`updated`) VALUES ('9219',0,0,0,0,33,0,0,0,0,'1',0,0,0,0,'2',0,0,0,0,'11','1',0,'Soccer',0,0,'1',0,0,'11.5',0,0,0,0,'0','',0,0,0,0,NOW()) ON DUPLICATE KEY UPDATE `user_id`='9219',`clan_recruiter`=0,`team_recruiter`=0,`totalinvites`=0,`totaloffers`=0,`age`=33,`report_id`=0,`highlights`=0,`articles`=0,`venues`=0,`accomplishments`='1',`classifieds`=0,`tracked`=0,`freeagents`=0,`groups`=0,`teams`='2',`completion`=0,`unread_offers`=0,`personal_team`=0,`reviews`=0,`coach`='11',`ships`='1',`silvers`=0,`sports`='Soccer',`active_leagues`=0,`active_tournaments`=0,`total_leagues`='1',`total_tournaments`=0,`total_ultras`=0,`avg_salary`='11.5',`points_balance`=0,`cash_balance`=0,`trust`=0,`overdue`=0,`companies`='0',`flags`='',`commish`=0,`orders`=0,`service`=0,`deadlines`=0,`updated`=NOW()

      QUERY(0.103ms) - SELECT `season_unfinished` FROM `userprofiles_cache` WHERE `user_id`=9219

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

      QUERY(0.0751ms) - SELECT SQL_CACHE * FROM draft_config

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

      QUERY(0.392ms) - SELECT SQL_CACHE `sports_positions_link`.`position_id`,`injury`,`season_id`,`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`=9219 && `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.2151ms) - SELECT SQL_CACHE `sports_positions_link`.`position_id`,`injury`,`season_id`,`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`=9219 && `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.176ms) - SELECT SQL_CACHE `sports_positions_link`.`position_id`,`injury`,`season_id`,`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`=9219 && `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.082ms) - SELECT * FROM `photo` WHERE `photo_id`=0

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