This event has completed. This information has been preserved for archival purposes.

Item

YNS

Visit Team Page

Champion of Sailors Draft - Men
10/13/2024

Item

WTP

Visit Team Page

Runner Up of Sailors Draft - Men
10/13/2024

Beer, Besties, & Bowling

Beer, Besties, & Bowling

Bowling

Visit League Page

2024 Miken/Easton/Worth Series

Phoenix 2024

Softball

Visit League Page

2024 Miken/Easton/Worth Series

Valdosta 2024

Softball

Visit League Page

Myrtle Beach USSSA

Island of Misfit Toys Draft 2024

Softball

Visit League Page

New Orleans Ultra Draft

King Cake 2025

Softball

Visit League Page

Introducing a Brand New Format From League Joe!

We trial-tested a brand new competitive format, Keeper Draft, for our drafts in Indy, so now we are bringing this to Pensacola. Unlike our other drafts, players must meet minimum skill and competitive standards to participate. No soft, warm and fuzzy feelings here - you're coming to play, and you're here to win.The ladies are playing in the Siren's Ultra Draft, so might as well theme this Sailors!

Two-Day Tournament at Exchange Park

How it Works

For Coaches of Existing Teams
Missing a bunch of your guys this weekend? You can still get valuable swings by bringing up to 6 players to the draft. These are your "Keeper Picks" and will be slotted into the draft, and then you will draft up to 10, 11 or 12 players (your choice).

Safety rails are removed - there's no salary cap
Every player in the draft will be a competitive player ready to give it their all
Scout potential future recruits
Coaches help vote on and determine rules for the event

For Free Agents
New to the area? Your team disbanded? Been looking for a new competitive team? Join us a Free Agent and you will put your talents on display for teams around the region.

Receive a non custom "Free Agent" jersey that matches your team, but also makes it clear that you're up for grabs
Have a team already, and just want extra swings? Come get em
Test your mettle against strong competition without risking a "ratings bump"

Sirens Ultra Draft

Got a female significant other, friend, or travel buddy? They can play now, too! Sign them up for the SirensUltra Draft Women's Tourney!

Sirens Ultra Draft

League Joe

Contact Organizer

PEAK MEMORY: 11.58 MiB
MEMORY USAGE AFTER: 9.28 MiB

Debug Information

Request Variables

var = tournament

varb = keeper-draft

varc = pensacola-mens-pirates

vara =

vard =

vare =

view_var = tournament

view_varb = keeper-draft

view_varc = pensacola-mens-pirates

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: 0adaf381fa8c9888b24ef071c574034b

Login Type:

BASE:: tournament

FULL LINK:: tournament/keeper-draft/pensacola-mens-pirates

Page ID: 40

Page ID:: 40

Page Template:: lj

Template Layout:: default

Headers: : Loading page header code

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

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

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

Admin Login Level: :

Footer: : Loading page footer code

Session Variables

securetoken = 0adaf381fa8c9888b24ef071c574034b
fullstate =

Cookie Variables

Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /tournament/keeper-draft/pensacola-mens-pirates/
QUERY_STRING = var=tournament&varb=keeper-draft&varc=pensacola-mens-pirates
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=tournament&varb=keeper-draft&varc=pensacola-mens-pirates
REDIRECT_URL = /tournament/keeper-draft/pensacola-mens-pirates/
REMOTE_PORT = 27357
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 = 18.223.108.59
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/tournament/keeper-draft/pensacola-mens-pirates
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/tournament/keeper-draft/pensacola-mens-pirates/
SCRIPT_URL = /tournament/keeper-draft/pensacola-mens-pirates/
UNIQUE_ID = ZzPY-LQmzHZSLPSeLupfrQAAAJQ
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/tournament/keeper-draft/pensacola-mens-pirates/
REDIRECT_SCRIPT_URL = /tournament/keeper-draft/pensacola-mens-pirates/
REDIRECT_UNIQUE_ID = ZzPY-LQmzHZSLPSeLupfrQAAAJQ
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1731451132.1682
REQUEST_TIME = 1731451132

SQL Queries

Total Queries: 74
Total Execution Time: 27.6651ms
Avg Execution Time:0.3738527027027ms

QUERY(1.334ms) - 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-12', '22:38:52', 'GET', '/tournament/keeper-draft/pensacola-mens-pirates/', '18.223.108.59', 'https://netstuffersdev1.com/tournament/keeper-draft/pensacola-mens-pirates' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhd2F2T0szZ0g4WFluNlF4SVBndjVhL1poMGJ5bG5HZTZocWU2dWlBWU55TnpDY3VVdEIxWjhkUnRsWjl0MlNSVHY3Zm1KOW1ySTF6UW1MY1NJaGZialY=','0','','1731451132') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1669ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/tournament/keeper-draft/pensacola-mens-pirates/'

QUERY(0.263ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='tournament/keeper-draft/pensacola-mens-pirates' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.14ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.1562ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5529ms) - 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`.`url` = 'keeper-draft' LIMIT 0,1

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

QUERY(0.5982ms) - 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` = '148' and `league_seasons`.`url` = 'pensacola-mens-pirates' ORDER BY `league_dates`.`start_date` ASC

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

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

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

QUERY(0.1831ms) - 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`=148 && `season_id`=310 LIMIT 0,1

QUERY(0.2689ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=148 && `season_id`=310 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

QUERY(0.1469ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='America/Chicago'

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

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

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

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

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

QUERY(0.138ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.2549ms) - SELECT `company`.*,`img_url` FROM `company` INNER JOIN `photo` ON `photo`.`photo_id`=`company`.`logo_onwhite` WHERE `company_id`=1

QUERY(0.1569ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='keeper-draft'

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

QUERY(0.124ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1462ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1221ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.1452ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='148' && `season_id`='310' LIMIT 0,1

QUERY(0.1571ms) - SELECT * FROM `league_notices` WHERE `league_id`=148 && `season_id`=310

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

QUERY(0.107ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.2441ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=148 && `season_id`=310

QUERY(0.1512ms) - SELECT * FROM `league_hotel_settings` WHERE `league_id`=148 && `season_id`=310

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

QUERY(0.1209ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.2809ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='148' && `season_id`='310' && `ranking`='1'

QUERY(2.9619ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='310' && `finish_rank`=1 ORDER BY `date` DESC

QUERY(0.1509ms) - SELECT `img_url`,`name` FROM `sports` INNER JOIN `photo` ON `photo`.`photo_id`=`logo_id` WHERE `sports`.`sport_id`='1'

QUERY(0.2341ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='148' && `season_id`='310' && `ranking`='2'

QUERY(2.2521ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='310' && `finish_rank`=2 ORDER BY `date` DESC

QUERY(0.169ms) - SELECT `img_url`,`name` FROM `sports` INNER JOIN `photo` ON `photo`.`photo_id`=`logo_id` WHERE `sports`.`sport_id`='1'

QUERY(0.2382ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='148' && `season_id`='310' && `ranking`='3'

QUERY(1.1351ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='310' && `finish_rank`=3 ORDER BY `date` DESC

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

QUERY(0.1979ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='148' && `season_id`='310' && `ranking`='4'

QUERY(0.8762ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='310' && `finish_rank`=4 ORDER BY `date` DESC

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

QUERY(0.1709ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='148' && `season_id`='310' && `ranking`='5'

QUERY(0.6669ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='310' && `finish_rank`=5 ORDER BY `date` DESC

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

QUERY(0.1509ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='148' && `season_id`='310' && `ranking`='6'

QUERY(0.4721ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='310' && `finish_rank`=6 ORDER BY `date` DESC

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

QUERY(0.823ms) - SELECT COUNT(*) FROM `leagues` INNER JOIN `league_seasons` ON (`leagues`.`league_id` = `league_seasons`.`league_id`) INNER JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `season_photo` ON (`league_seasons`.`logo_id` = `season_photo`.`photo_id`) INNER JOIN `company` ON (`leagues`.`company_id` = `company`.`company_id`) INNER JOIN `photo` AS `company_photo` ON (`company`.`logo_onwhite` = `company_photo`.`photo_id`) LEFT JOIN `league_cache` ON (`league_seasons`.`season_id` = `league_cache`.`season_id`) INNER JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_dates`.`start_date` >= '2024-11-09 16:38:52' and `leagues`.`tournament` = '0' and `leagues`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(1.3189ms) - SELECT SQL_CACHE `leagues`.`tournament`,`leagues`.`ultra`,`leagues`.`featured`,`leagues`.`league_id`,`leagues`.`name`,`leagues`.`name` AS league_name,`leagues`.`url`,`leagues`.`url` AS league_url,`leagues`.`games_per_round`,`leagues`.`approved`,`leagues`.`sport_id`,`leagues`.`gallery_id`,`leagues`.`max_teams`,`leagues`.`min_teams`,`leagues`.`max_players`,`leagues`.`owner_id`,`league_seasons`.`season_id`,`league_seasons`.`season_id` AS `sid`,`league_seasons`.`name` AS `season_name`,`league_seasons`.`url` AS `season_url`,`league_seasons`.`day_of_week`,`league_seasons`.`cancelled`,`league_seasons`.`public`,`league_seasons`.`soldout`,`league_seasons`.`gender`,`league_seasons`.`style`,`league_seasons`.`active`,`venues`.`venue_id`,`venues`.`name` AS `venue`,`venues`.`url` AS `venueurl`,`venues`.`city`,`venues`.`state`,`venues`.`fullstate`,`photo`.`img_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_url`,`company`.`name` AS `company_name`,`company`.`url` AS `company_url`,`company_photo`.`img_url` AS `company_img_url`,`league_cache`.`reg_is_open`,`league_cache`.`teams`,`league_cache`.`players`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date` FROM `leagues` INNER JOIN `league_seasons` ON (`leagues`.`league_id` = `league_seasons`.`league_id`) INNER JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `season_photo` ON (`league_seasons`.`logo_id` = `season_photo`.`photo_id`) INNER JOIN `company` ON (`leagues`.`company_id` = `company`.`company_id`) INNER JOIN `photo` AS `company_photo` ON (`company`.`logo_onwhite` = `company_photo`.`photo_id`) LEFT JOIN `league_cache` ON (`league_seasons`.`season_id` = `league_cache`.`season_id`) INNER JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_dates`.`start_date` >= '2024-11-09 16:38:52' and `leagues`.`tournament` = '0' and `leagues`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1') GROUP BY `league_seasons`.`season_id` ORDER BY `league_dates`.`start_date` asc LIMIT 0,6

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

QUERY(1.086ms) - SELECT COUNT(*) FROM `leagues` INNER JOIN `league_seasons` ON (`leagues`.`league_id` = `league_seasons`.`league_id`) INNER JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `season_photo` ON (`league_seasons`.`logo_id` = `season_photo`.`photo_id`) INNER JOIN `company` ON (`leagues`.`company_id` = `company`.`company_id`) INNER JOIN `photo` AS `company_photo` ON (`company`.`logo_onwhite` = `company_photo`.`photo_id`) LEFT JOIN `league_cache` ON (`league_seasons`.`season_id` = `league_cache`.`season_id`) INNER JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_dates`.`start_date` >= '2024-11-09 16:38:52' and `leagues`.`tournament` = '1' and `leagues`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(1.3959ms) - SELECT SQL_CACHE `leagues`.`tournament`,`leagues`.`ultra`,`leagues`.`featured`,`leagues`.`league_id`,`leagues`.`name`,`leagues`.`name` AS league_name,`leagues`.`url`,`leagues`.`url` AS league_url,`leagues`.`games_per_round`,`leagues`.`approved`,`leagues`.`sport_id`,`leagues`.`gallery_id`,`leagues`.`max_teams`,`leagues`.`min_teams`,`leagues`.`max_players`,`leagues`.`owner_id`,`league_seasons`.`season_id`,`league_seasons`.`season_id` AS `sid`,`league_seasons`.`name` AS `season_name`,`league_seasons`.`url` AS `season_url`,`league_seasons`.`day_of_week`,`league_seasons`.`cancelled`,`league_seasons`.`public`,`league_seasons`.`soldout`,`league_seasons`.`gender`,`league_seasons`.`style`,`league_seasons`.`active`,`venues`.`venue_id`,`venues`.`name` AS `venue`,`venues`.`url` AS `venueurl`,`venues`.`city`,`venues`.`state`,`venues`.`fullstate`,`photo`.`img_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_url`,`company`.`name` AS `company_name`,`company`.`url` AS `company_url`,`company_photo`.`img_url` AS `company_img_url`,`league_cache`.`reg_is_open`,`league_cache`.`teams`,`league_cache`.`players`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date` FROM `leagues` INNER JOIN `league_seasons` ON (`leagues`.`league_id` = `league_seasons`.`league_id`) INNER JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `season_photo` ON (`league_seasons`.`logo_id` = `season_photo`.`photo_id`) INNER JOIN `company` ON (`leagues`.`company_id` = `company`.`company_id`) INNER JOIN `photo` AS `company_photo` ON (`company`.`logo_onwhite` = `company_photo`.`photo_id`) LEFT JOIN `league_cache` ON (`league_seasons`.`season_id` = `league_cache`.`season_id`) INNER JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_dates`.`start_date` >= '2024-11-09 16:38:52' and `leagues`.`tournament` = '1' and `leagues`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1') GROUP BY `league_seasons`.`season_id` ORDER BY `league_dates`.`start_date` asc LIMIT 0,6

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

QUERY(0.129ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=148 && `season_id`=310

QUERY(0.1249ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=148 && `season_id`=310

QUERY(0.1409ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=148 && `season_id`=310

QUERY(0.1929ms) - SELECT `venues`.*,`photo`.`img_url` FROM `venues` LEFT JOIN `photo` ON `venues`.`logo_id`=`photo`.`photo_id` WHERE `venue_id`=39

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