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

PrimeTime

Visit Team Page

Champion of Keeper Draft - Indy Competitive Summer
08/03/2024

Los Sabrosos

Visit Team Page

Runner Up of Keeper Draft - Indy Competitive Summer
08/03/2024

New Orleans Ultra Draft

King Cake 2025

Softball

Visit League Page

Suncoast Senior Draft

40+ Seniors March 2025

Softball

Visit League Page

Gin & Juice Draft Tourney

Seniors Family Draft - Spring 2025

Softball

Visit League Page

Gin & Juice Draft Tourney

Showcase Draft - Spring 2025

Softball

Visit League Page

Gin & Juice Draft Tourney

Myrtle Beach - Spring 2025

Softball

Visit League Page

Introducing a Brand New Format From League Joe!

We are trial-testing a brand new competitive format for our drafts. 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.

One Day Tournament at Indy Sports Park (turfs)

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 8 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 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"

Contact Organizer

PEAK MEMORY: 9.46 MiB
MEMORY USAGE AFTER: 6.62 MiB

Debug Information

Request Variables

var = tournament

varb = indy-mens-comp

varc = mens-comp-summer

vara =

vard =

vare =

view_var = tournament

view_varb = indy-mens-comp

view_varc = mens-comp-summer

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: f959c9f416e6e4a2d41596349bfa29db

Login Type:

BASE:: tournament

FULL LINK:: tournament/indy-mens-comp/mens-comp-summer

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 = f959c9f416e6e4a2d41596349bfa29db
fullstate =

Cookie Variables

Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /tournament/indy-mens-comp/mens-comp-summer/
QUERY_STRING = var=tournament&varb=indy-mens-comp&varc=mens-comp-summer
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=tournament&varb=indy-mens-comp&varc=mens-comp-summer
REDIRECT_URL = /tournament/indy-mens-comp/mens-comp-summer/
REMOTE_PORT = 64014
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.116.47.194
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/indy-mens-comp/mens-comp-summer
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/indy-mens-comp/mens-comp-summer/
SCRIPT_URL = /tournament/indy-mens-comp/mens-comp-summer/
UNIQUE_ID = Z26OlZNPJJ9hoP1KSOsTFwAAAIw
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/tournament/indy-mens-comp/mens-comp-summer/
REDIRECT_SCRIPT_URL = /tournament/indy-mens-comp/mens-comp-summer/
REDIRECT_UNIQUE_ID = Z26OlZNPJJ9hoP1KSOsTFwAAAIw
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1735298709.8834
REQUEST_TIME = 1735298709

SQL Queries

Total Queries: 79
Total Execution Time: 30.0061ms
Avg Execution Time:0.37982405063291ms

QUERY(3.448ms) - 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-12-27', '11:25:09', 'GET', '/tournament/indy-mens-comp/mens-comp-summer/', '18.116.47.194', 'https://netstuffersdev1.com/tournament/indy-mens-comp/mens-comp-summer' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhelFYTEJNM2tVL0JoQkp3K2NTQWtWSHk2RXh6Y3ZrVGY0VldheDhxa1A3ckw4SkZpVlFLa0FGbGNQb0x1KzZXUkZYRThrNTJYUHE1bVlPcFFlV1JlYUs=','0','','1735298709') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1471ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/tournament/indy-mens-comp/mens-comp-summer/'

QUERY(0.2491ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='tournament/indy-mens-comp/mens-comp-summer' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.129ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.1321ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5209ms) - 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`.`url` = 'indy-mens-comp' LIMIT 0,1

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

QUERY(0.5209ms) - 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` = '140' and `league_seasons`.`url` = 'mens-comp-summer' ORDER BY `league_dates`.`start_date` ASC

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

QUERY(0.1359ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=278

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

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

QUERY(0.175ms) - 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`=140 && `season_id`=278 LIMIT 0,1

QUERY(0.2151ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=140 && `season_id`=278 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

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

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

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

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

QUERY(0.1202ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1321ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='indy-mens-comp'

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

QUERY(0.1109ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.109ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.129ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.2022ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='140' && `season_id`='278' LIMIT 0,1

QUERY(0.1941ms) - SELECT * FROM `league_notices` WHERE `league_id`=140 && `season_id`=278

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

QUERY(0.1111ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.2499ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=140 && `season_id`=278

QUERY(0.1531ms) - SELECT * FROM `league_hotel_settings` WHERE `league_id`=140 && `season_id`=278

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

QUERY(0.1261ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.308ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='140' && `season_id`='278' && `ranking`='1'

QUERY(3.0279ms) - 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`='278' && `finish_rank`=1 ORDER BY `date` DESC

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

QUERY(0.2611ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='140' && `season_id`='278' && `ranking`='2'

QUERY(2.3191ms) - 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`='278' && `finish_rank`=2 ORDER BY `date` DESC

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

QUERY(0.1891ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='140' && `season_id`='278' && `ranking`='3'

QUERY(1.1671ms) - 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`='278' && `finish_rank`=3 ORDER BY `date` DESC

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

QUERY(0.174ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='140' && `season_id`='278' && `ranking`='4'

QUERY(0.8359ms) - 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`='278' && `finish_rank`=4 ORDER BY `date` DESC

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

QUERY(0.1719ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='140' && `season_id`='278' && `ranking`='5'

QUERY(0.6299ms) - 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`='278' && `finish_rank`=5 ORDER BY `date` DESC

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

QUERY(0.3309ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='140' && `season_id`='278' && `ranking`='6'

QUERY(0.5212ms) - 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`='278' && `finish_rank`=6 ORDER BY `date` DESC

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

QUERY(0.8368ms) - 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-12-24 06:25:10' 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.353ms) - 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`.`city` AS `venue_city`,`venues`.`state`,`venues`.`state` AS `venue_state`,`venues`.`fullstate`,`photo`.`img_url`,`photo`.`thumb_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_url`,`season_photo`.`thumb_url` AS `season_thumb_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-12-24 06:25:10' 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.766ms) - 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-12-24 06:25:10' 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.354ms) - 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`.`city` AS `venue_city`,`venues`.`state`,`venues`.`state` AS `venue_state`,`venues`.`fullstate`,`photo`.`img_url`,`photo`.`thumb_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_url`,`season_photo`.`thumb_url` AS `season_thumb_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-12-24 06:25:10' 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.145ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=1

QUERY(0.1318ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=284

QUERY(0.1349ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=328

QUERY(0.1431ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=326

QUERY(0.139ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=325

QUERY(0.144ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=320

QUERY(0.1791ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=140 && `season_id`=278

QUERY(0.2089ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=140 && `season_id`=278

QUERY(0.1659ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=140 && `season_id`=278

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

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

Keeper Draft

Results

PrimeTime

Los Sabrosos

Upcoming Tournaments of Interest

New Orleans Ultra Draft

Suncoast Senior Draft

Gin & Juice Draft Tourney

Gin & Juice Draft Tourney

Gin & Juice Draft Tourney

Description

Introducing a Brand New Format From League Joe!

One Day Tournament at Indy Sports Park (turfs)

How it Works

Event Operator

Debug Information

Request Variables

Debug Messages

Session Variables

Cookie Variables

Server Variables

SQL Queries

Total Queries: 79
Total Execution Time: 30.0061ms
Avg Execution Time:0.37982405063291ms

Keeper Draft

Results

PrimeTime

Los Sabrosos

Upcoming Tournaments of Interest

New Orleans Ultra Draft

Suncoast Senior Draft

Gin & Juice Draft Tourney

Gin & Juice Draft Tourney

Gin & Juice Draft Tourney

Introducing a Brand New Format From League Joe!

One Day Tournament at Indy Sports Park (turfs)

How it Works

Event Operator

Help

How do Draft Leagues Work?

Player Profile

Draft Party

Season Format

Debug Information

Request Variables

Debug Messages

Session Variables

Cookie Variables

Server Variables

SQL Queries

Total Queries: 79Total Execution Time: 30.0061msAvg Execution Time:0.37982405063291ms

Total Queries: 79
Total Execution Time: 30.0061ms
Avg Execution Time:0.37982405063291ms