The Next Event

Ready for the next event in this series?

Indianapolis Ultra Draft - Greatest Hits 2024
This event has completed. This information has been preserved for archival purposes.
Ultra Draft

Indianapolis Ultra Draft

Event: National Championship - Sept (Other Events)
Sport: Softball
CoedSocialDraft
Event Director
Venue
Indy Sports Park
Indianapolis, IN
Dates
Sep 30, 2023 - Oct 01, 2023
This event has completed. This information has been preserved for archival purposes.

Your Player Kit Package

Select your player kit during the checkout process while registering for the event.

View Available Packages

Your Bat Settings Package

Some player kits include bats. Click here to manage your bat preferences for this event.

View Available Bats

Extra Merchandise Information

Need some gear for your experience? Don't worry, we got you!

Browse and Purchase Extra Merch

Easton - Roller Bag

This deluxe slowpitch wheeled bag is the ultimate bag for traveling with all your gear. It features a large main compartment to keep all your gear protected. It also has a center padded compartment large enough for 6 bats, making it perfect for players who carry multiple bats to every game! In addition, it's equipped with a top vented compartment ideal for a helmet, ball glove or cleats.

$189.00

$300.00
Miken - Roller Bag

This deluxe slowpitch wheeled bag is the ultimate bag for traveling with all your gear. It features a large main compartment to keep all your gear protected. It also has a center padded compartment large enough for 6 bats, making it perfect for players who carry multiple bats to every game! In addition, it's equipped with a top vented compartment ideal for a helmet, ball glove or cleats.

$189.00

$300.00
Worth - Roller Bag

This deluxe slowpitch wheeled bag is the ultimate bag for traveling with all your gear. It features a large main compartment to keep all your gear protected. It also has a center padded compartment large enough for 6 bats, making it perfect for players who carry multiple bats to every game! In addition, it's equipped with a top vented compartment ideal for a helmet, ball glove or cleats.

$189.00

$300.00
Easton - Stars & Stripes Backpack

Engineered specifically for slowpitch players who need a quality bag for their gear. First off, it has 4 individual bat sleeves on the sides so you can easily carry all you bats to the field. It's also equipped with a large main compartment for helmets and other gear, and also features a top glove compartment to keep your glove safe and in game form. It has large, durable zippers too.

$69.00

$109.00
Miken - Stars & Stripes Backpack

Engineered specifically for slowpitch players who need a quality bag for their gear. First off, it has 4 individual bat sleeves on the sides so you can easily carry all you bats to the field. It's also equipped with a large main compartment for helmets and other gear, and also features a top glove compartment to keep your glove safe and in game form. It has large, durable zippers too.

$69.00

$109.00
Worth - Stars & Stripes Backpack

Engineered specifically for slowpitch players who need a quality bag for their gear. First off, it has 4 individual bat sleeves on the sides so you can easily carry all you bats to the field. It's also equipped with a large main compartment for helmets and other gear, and also features a top glove compartment to keep your glove safe and in game form. It has large, durable zippers too.

$69.00

$109.00
Easton - Black Backpack

Engineered specifically for slowpitch players who need a quality bag for their gear. First off, it has 4 individual bat sleeves on the sides so you can easily carry all you bats to the field. It's also equipped with a large main compartment for helmets and other gear, and also features a top glove compartment to keep your glove safe and in game form. It has large, durable zippers too.

$69.00

$109.00
Miken - Black Backpack

Engineered specifically for slowpitch players who need a quality bag for their gear. First off, it has 4 individual bat sleeves on the sides so you can easily carry all you bats to the field. It's also equipped with a large main compartment for helmets and other gear, and also features a top glove compartment to keep your glove safe and in game form. It has large, durable zippers too.

$69.00

$109.00
Worth - Black Backpack

Engineered specifically for slowpitch players who need a quality bag for their gear. First off, it has 4 individual bat sleeves on the sides so you can easily carry all you bats to the field. It's also equipped with a large main compartment for helmets and other gear, and also features a top glove compartment to keep your glove safe and in game form. It has large, durable zippers too.

$69.00

$109.00
Chillpak Cooler

Keep up to 30 cans cold while flexible walls allow it to fit in most spaces - including bat bags!

$45.00

$50.00
Stoolpak - Chair, Cooler + Backpack

It's a stool! It's a cooler! It's a backpack! It's all of the above! Perfect for your beach exploration plans.

$30.00

$35.00
Home Run Derby

Prizes TBA based on total participation

$20.00

$0.00
Cornhole Tournament (Single)

Prizes TBA based on total participation

$15.00

$0.00
Cornhole Tournament (Team)

Prizes TBA based on total participation

$30.00

$0.00
Skills Challenge

Top golf for softball! Score points based on ball placement. Prizes TBA based on total participation

$20.00

$0.00
Snapback Hat

Add a snapback hat. Select from available color options at merchandise table.

$30.00

$35.00
Fitted Hat

Add a S/M or L/XL fitted hat. Select from available color options at merchandise table.

$30.00

$35.00
Extra Jersey

Add an extra jersey to your kit. You may purchase for yourself, or for a companion.

Jersey Styles

Sold out!


Browse and Purchase Extra Merch

Jersey Gallery - Away Variants

'Ship Happens Jersey
'Ship Happens - Away Variant

Batting Brigade Jersey
Batting Brigade - Away Variant

Brickyard Bombers Jersey
Brickyard Bombers - Away Variant

Circle City Sluggers Jersey
Circle City Sluggers - Away Variant

Flag 'Ship Ballers Jersey
Flag 'Ship Ballers - Away Variant

GY6 Freaks Jersey
GY6 Freaks - Away Variant

Indy 300 Jersey
Indy 300 - Away Variant

Inglorious Batters Jersey
Inglorious Batters - Away Variant

JSE Jersey
JSE - Away Variant

Let’s Get Corny Jersey
Let’s Get Corny - Away Variant

Mound Pounders Jersey
Mound Pounders - Away Variant

Not Fast Just Furious Jersey
Not Fast Just Furious - Away Variant

Star Spangled Slammers Jersey
Star Spangled Slammers - Away Variant

The Golden Bombers Jersey
The Golden Bombers - Away Variant

The Mothership Jersey
The Mothership - Away Variant

Torches and Titties Jersey
Torches and Titties - Away Variant

Unicorn Warriors Jersey
Unicorn Warriors - Away Variant

Vicious and Delicious Jersey
Vicious and Delicious - Away Variant

Walk Dirty To Me Jersey
Walk Dirty To Me - Away Variant

75 112
PEAK MEMORY: 7.36 MiB
MEMORY USAGE AFTER: 5.61 MiB

Debug Information


Request Variables

var = ultra

varb = indy

varc = the-ship

vard = merch

vara =

vare =

view_var = ultra

view_varb = indy

view_varc = the-ship

view_vard = merch

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: c7e110824b1367848b29ddb34c8031f3

Login Type:

BASE:: ultra

FULL LINK:: ultra/indy/the-ship/merch

Page ID: 57

Page ID:: 57

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


Cookie Variables

care_did = 1666fafd-8ff2-4090-a5c2-4c0e4c9849ec


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/indy/the-ship/merch/
QUERY_STRING = var=ultra&varb=indy&varc=the-ship&vard=merch
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=indy&varc=the-ship&vard=merch
REDIRECT_URL = /ultra/indy/the-ship/merch/
REMOTE_PORT = 4413
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 = 13.58.61.197
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/ultra/indy/the-ship/merch
HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
HTTP_COOKIE = care_did=1666fafd-8ff2-4090-a5c2-4c0e4c9849ec
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/ultra/indy/the-ship/merch/
SCRIPT_URL = /ultra/indy/the-ship/merch/
UNIQUE_ID = Zz@@uu9urvFP-X@yUD2H9QAAAJQ
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/indy/the-ship/merch/
REDIRECT_SCRIPT_URL = /ultra/indy/the-ship/merch/
REDIRECT_UNIQUE_ID = Zz@@uu9urvFP-X@yUD2H9QAAAJQ
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1732230842.5916
REQUEST_TIME = 1732230842


SQL Queries


Total Queries: 81
Total Execution Time: 33.4112ms
Avg Execution Time:0.41248395061728ms

QUERY(1.406ms) - 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-21', '23:14:02', 'GET', '/ultra/indy/the-ship/merch/', '13.58.61.197', 'https://netstuffersdev1.com/ultra/indy/the-ship/merch' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheWdoQzU1RkxvOGl4R2FBVk1TdHJNT2xXbmlDaWFwWDNYOVcvRGVXN0lxd1Y2Rmx1TElRa2tRVmJPVFJvUm11Zk8zNUtSTFRud0FkVm1YbXdhWkd5bW0=','0','','1732230842') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.221ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/indy/the-ship/merch/'

QUERY(0.2949ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='ultra/indy/the-ship/merch' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.149ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.124ms) - SELECT SQL_CACHE * FROM league_config

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

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

QUERY(0.6731ms) - 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` = '75' and `league_seasons`.`url` = 'the-ship' ORDER BY `league_dates`.`start_date` ASC

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

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

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

QUERY(0.1781ms) - 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`=75 && `season_id`=112 LIMIT 0,1

QUERY(0.2489ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=75 && `season_id`=112 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

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

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

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

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

QUERY(0.1612ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.175ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='indy'

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

QUERY(0.149ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.128ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.124ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.1841ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='75' && `season_id`='112' LIMIT 0,1

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

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

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

QUERY(0.5448ms) - 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` = '75' and `league_seasons`.`season_id` = '188' ORDER BY `league_dates`.`start_date` ASC

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

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

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

QUERY(0.2329ms) - 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`=75 && `season_id`=188 LIMIT 0,1

QUERY(0.217ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=75 && `season_id`=188 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

QUERY(0.2611ms) - SELECT SQL_CACHE * FROM `league_schedule_options` WHERE `league_id`='75' && `season_id`='188' LIMIT 0,1

QUERY(0.205ms) - SELECT SQL_CACHE count(`company_id`) FROM `league_company_links` WHERE `league_id`='75' && (`season_id`='188' || `season_id`=0)

QUERY(0.2201ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='75' && (`season_id`='188' || `season_id`=0)

QUERY(0.191ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=75 && `season_id`=0) || `season_id`='188'

QUERY(3.561ms) - 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`='75' && `season_id`='188' &&`league_levels`.`score`>2 && `deleted`=0 && `alternate`=0

QUERY(0.53ms) - 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`='75' && `season_id`='188' &&`league_players`.`access`=4 && `deleted`=0 && `alternate`=0

QUERY(2.696ms) - 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`='75' && `season_id`='188' &&`league_levels`.`score`>2 && `quit`=0 && `alternate`=1

QUERY(0.2582ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons_rules` WHERE `league_id`='75' || `season_id`='188' ORDER BY `season_id` DESC

QUERY(0.1838ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='75' && `season_id`='188'

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

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

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

QUERY(0.196ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=75&&`season_id`=188 LIMIT 0,1

QUERY(0.3829ms) - SELECT `game_id` FROM `games` WHERE `league_id`=75&&`season_id`=188&&`playoff`=1 LIMIT 0,1

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

QUERY(0.489ms) - 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`='75' && `league_teams`.`season_id`='188' && `teams`.`personal`=0 && `teams`.`deleted`=0 GROUP BY `league_teams`.`team_id`

QUERY(0.35ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='75' && `season_id`='188'

QUERY(0.2451ms) - 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`='75' && `league_seasons`.`season_id`='188'

QUERY(0.1609ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=75 && `season_id`=188 LIMIT 0,1

QUERY(0.15ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=75 && `season_id`=188

QUERY(1.4911ms) - INSERT INTO `league_cache` (`league_id`,`season_id`,`articles`,`participants`,`conferences`,`players`,`coaches`,`subs`,`rules`,`teams`,`games`,`groups`,`divisions`,`seasons`,`sponsors`,`products`,`prizes`,`triumphs`,`hotels`,`is_full`,`companies`,`reg_is_open`,`updated`,`show_playoff_menu`) VALUES ('75','188','6',0,0,'233','16','9','2','16','26',0,0,'2',0,'18','1','119','1',0,0,0,NOW(),0) ON DUPLICATE KEY UPDATE `league_id`='75',`season_id`='188',`articles`='6',`participants`=0,`conferences`=0,`players`='233',`coaches`='16',`subs`='9',`rules`='2',`teams`='16',`games`='26',`groups`=0,`divisions`=0,`seasons`='2',`sponsors`=0,`products`='18',`prizes`='1',`triumphs`='119',`hotels`='1',`is_full`=0,`companies`=0,`reg_is_open`=0,`updated`=NOW(),`show_playoff_menu`=0

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

QUERY(0.2019ms) - SELECT * FROM `league_notices` WHERE `league_id`=75 && `season_id`=112

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

QUERY(0.134ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.1199ms) - SELECT SQL_CACHE * FROM draft_config

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

QUERY(0.1922ms) - SELECT SQL_CACHE * FROM payments_config

QUERY(0.4361ms) - SELECT * FROM league_merch WHERE season_id=112

QUERY(1.044ms) - SELECT * FROM `products` LEFT JOIN `photo` ON `photo`.`photo_id`=`products`.`photo_id` WHERE `products`.`deleted`=0 && `products`.`season_id`=112 ORDER BY `soldout` ASC,`products`.`sort` ASC

QUERY(2.527ms) - SELECT `img_url`,`fullname` FROM `teams` INNER JOIN `league_teams` ON `teams`.`team_id`=`league_teams`.`team_id` INNER JOIN `league_seasons` ON `league_teams`.`season_id`=`league_seasons`.`season_id` && `league_seasons`.`url`='the-ship' INNER JOIN `photo` ON `teams`.`jersey_img`=`photo`.`photo_id` WHERE `jersey_img` > 0 ORDER BY `fullname` ASC

QUERY(0.9301ms) - SELECT `img_url`,`fullname` FROM `teams` INNER JOIN `league_teams` ON `teams`.`team_id`=`league_teams`.`team_id` INNER JOIN `league_seasons` ON `league_teams`.`season_id`=`league_seasons`.`season_id` && `league_seasons`.`url`='the-ship' INNER JOIN `photo` ON `teams`.`jersey_img_away`=`photo`.`photo_id` WHERE `jersey_img_away` > 0 ORDER BY `fullname` ASC

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