SOLD OUT

This event has reached capacity.

Tournament

Turf Wars

Division: Battle for Indy 2024
Sport: Softball
CoedSocialDraft
Event Director
Venue
Indy Sports Park
Indianapolis, IN
Dates
Oct 30, 2024

SOLD OUT

This event has reached capacity.

Join as Alternate
Registration Details
DatesCost Guaranteed Min GamesCost Includes
Oct 30, 202410/30/24Multiple Play Packages Available
Starting at $20.00
4

2-3+ Game Guarantee*
Friendships You Make Along the Way
* Total gg depends on registration

Description

End the Season with a Bang

For years, League Joe has seen champions forged at both Indy Sports Park and Midwest Sports Complex, but we've always wondered.... who would win in a battle between the two?

Let's Find Out!


Alliances Will Be Formed, Allegiances Will Be Tested, Beer Will Be Drank!

In the first official League Joe Turf Wars, players will join and participate in an evening of softball where the main goal is for the teams to rack up the best run differential in their games. At the end of the night, the best run differential from all of the combined games will determine the overall park winner!

Two Formats of Play

When you sign up to play, you will be able to participate in one of two ways...

Run it Back

Re-united with at least 9 other players from a former Championship Squad in 2023 or 2024 and you will face off against a championship squad from the other park

Park Draft

Enter yourself in the draft and declare your allegiance, or enter the player pool if you play both parks. Play with new teams each game and try to rack up points!


The Stakes Are High...

Public Humiliation

The reputations of the Commissioners of League Joe are on the line, so battle for them because if you don't, the loser will receive the very public humiliation of a pie to the face, thrown by the MVP of the tournament!

midwestvsindy-pie_recjoe1729694346.png

Hang the Banner

The winning park will receive the first ever Turf Wars Championship Banner to be displayed at the home park. The names of each and every participant in the event will be forever immortalized on the banner as celebrated defenders of the park!

shipbanner_recjoe1729694436.png

Door Prizes / Individual Recognition

Several door prizes will be given out, including free league registrations in 2025! Plus, the league jerseys for the 2025 seasons at the winning park will carry an exclusive Championship badge on their sleeves!

Costume Contest

Prizes for best costumes! Break in that Halloween costume early!

Schedule Overview

Schedule Format

All games will be played at 6:30/7:30/8:30/9:30 timeslots. Total number of games to be determined by total player registration numbers - as long as people are at the park wanting to play, we'll play!

Flexible Timeslots

To help players with work obligations during the week, we have new registration options available for this event. During registration, select "Early Registration" and your games are guaranteed before the 9:30 timeslot. Select "Late Registration" and your games are guaranteed to start at 7:30+.

Draft Round Robin

Rosters will be formed based on a draft process and you will be assigned your initial starting field. After each game, some players will stay on the field and others will move to other fields or be on an assigned break. All players guaranteed a minimum of 2, but likely 3 or more games depending on total registrations.

Run It Back Games

Championship teams that are running it back will play their games during the 8:30/9:30 timeslots to finish out the event. Draft Pool games will continue to be played during this time. Participating in a Run It Back game does count towards your evening's minimum GG threshold.

Updates

Turf Wars Update

Gotta love some unscheduled Spring weather, eh?  Tomorrow looks awesome for a fun end to the season and we look forward to seeing everyone.  This is an unusual format, so we're going to give you the basics of what to expect as we do our draft tonight.


Coaches Are Drafting Tonight

All coaches will be drafting the initial teams tonight, selecting 9 players for the various squads that will play. If you are 100% in, please complete your registration payment this evening to guarantee maximum team placements.


You Will Be Drafted to Multiple Teams

This is not a tournament format where you are placed on a team and play with that squad all night. Instead, you're going to be playing with new faces each game of the evening. Your team assignment will show multiple squads and the timeslots you're assigned.


Specialty Games

We will have our special Run it Back rosters which will feature the original players from those teams, with a couple of subs as needed. We also are going to have a Women's Matchup at 7:30pm and a Men's Matchup at 7:30pm. Both will be balanced as per our standards, but we expect the intensity level of those will be a little more amped so we are seeking volunteers who want to play that style. If you prefer a more casual style, the other 7:30 game will feature players on the more beer-heavy side of the scale! If you wish to throw your hat in the ring for these games, please fill out this super quick form*:

7:30 Game Preference

* Not everyone will play at 7:30 so if you don't mind any way, you can skip the form


Only Want One or Two Games? Let Us Know

A couple of players have expressed they really only want to play one or two games, and that's totally ok with us! Plenty of players will want as many games as they can squeeze in, so if you want to opt for *less* games, use the same form.

Schedule Preferences

Door Prizes - Keep Your Ticket

We will have a number of door prizes including hats, swag, and more. Keep your Gate Fee ticket, as prizes will be drawn at the end of the evening.


Thank you to everyone for enthusiastically giving this a shot. We're trying some new things so we hope this is a fun format that everyone likes that we can do more often!


Event Operator

PEAK MEMORY: 5.58 MiB
MEMORY USAGE AFTER: 4.62 MiB

Debug Information


Request Variables

var = tournament

varb = turf-wars

varc = battle-for-indy

vara =

vard =

vare =

view_var = tournament

view_varb = turf-wars

view_varc = battle-for-indy

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: 2c079f39b62a3cff3ee35ff567d89064

Login Type:

BASE:: tournament

FULL LINK:: tournament/turf-wars/battle-for-indy

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 = 2c079f39b62a3cff3ee35ff567d89064
fullstate =


Cookie Variables

handl_landing_page = https://sprutcam.com/hu/sprut-id-sign-in
handl_original_ref = https://sprutcam.com/hu/sprut-id-sign-in
HandLtestDomainNameServer = HandLtestDomainValueServer
care_did = 506c3412-d7a4-44b2-9951-a0f8ee678b76
handl_url = https://sprutcam.com/hu/sprut-id-sign-in/?redirect_to=https%3A%2F%2Fsprutcam.com%2Fhu%2Fsprut-id-sign-in
PHPSESSID = cbecd02f65d4b1e008f4ebf5af12b865
user_agent = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
organic_source = https://sprutcam.com/hu/sprut-id-sign-in
handl_url_base = https://sprutcam.com/hu/sprut-id-sign-in/
handl_ref = https://sprutcam.com/hu/sprut-id-sign-in/
organic_source_str = Internal
handl_ip = 18.220.242.160
mcontent = 3


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /tournament/turf-wars/battle-for-indy/
QUERY_STRING = var=tournament&varb=turf-wars&varc=battle-for-indy
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=tournament&varb=turf-wars&varc=battle-for-indy
REDIRECT_URL = /tournament/turf-wars/battle-for-indy/
REMOTE_PORT = 28508
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.220.242.160
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/turf-wars/battle-for-indy
HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
HTTP_COOKIE = handl_landing_page=https%3A%2F%2Fsprutcam.com%2Fhu%2Fsprut-id-sign-in; handl_original_ref=https%3A%2F%2Fsprutcam.com%2Fhu%2Fsprut-id-sign-in; HandLtestDomainNameServer=HandLtestDomainValueServer; care_did=506c3412-d7a4-44b2-9951-a0f8ee678b76; handl_url=https%3A%2F%2Fsprutcam.com%2Fhu%2Fsprut-id-sign-in%2F%3Fredirect_to%3Dhttps%253A%252F%252Fsprutcam.com%252Fhu%252Fsprut-id-sign-in; PHPSESSID=cbecd02f65d4b1e008f4ebf5af12b865; user_agent=Mozilla%2F5.0%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%3B%20compatible%3B%20ClaudeBot%2F1.0%3B%20%2Bclaudebot%40anthropic.com%29; organic_source=https%3A%2F%2Fsprutcam.com%2Fhu%2Fsprut-id-sign-in; handl_url_base=https%3A%2F%2Fsprutcam.com%2Fhu%2Fsprut-id-sign-in%2F; handl_ref=https%3A%2F%2Fsprutcam.com%2Fhu%2Fsprut-id-sign-in%2F; organic_source_str=Internal; handl_ip=18.220.242.160; mcontent=3
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/turf-wars/battle-for-indy/
SCRIPT_URL = /tournament/turf-wars/battle-for-indy/
UNIQUE_ID = Zz8EdSvSRWk5hKvDdtP8KAAAAFE
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/tournament/turf-wars/battle-for-indy/
REDIRECT_SCRIPT_URL = /tournament/turf-wars/battle-for-indy/
REDIRECT_UNIQUE_ID = Zz8EdSvSRWk5hKvDdtP8KAAAAFE
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1732183157.5036
REQUEST_TIME = 1732183157


SQL Queries


Total Queries: 80
Total Execution Time: 27.418ms
Avg Execution Time:0.342725ms

QUERY(1.415ms) - 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', '09:59:17', 'GET', '/tournament/turf-wars/battle-for-indy/', '18.220.242.160', 'https://netstuffersdev1.com/tournament/turf-wars/battle-for-indy' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhelFvTDVtejRLQ2lrcXVKNGs4OUY4eExHaVFVeitIVVVvSmRyaFR0bW1wSmt5ZFgxTGtyR3Myb1Z5WHg2UDVYMDBJZGhPdmsvSURPalpSNlRFVGlWWFk=','0','','1732183157') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1972ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/tournament/turf-wars/battle-for-indy/'

QUERY(0.273ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='tournament/turf-wars/battle-for-indy' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.1559ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.145ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5331ms) - 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` = 'turf-wars' LIMIT 0,1

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

QUERY(0.566ms) - 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` = '151' and `league_seasons`.`url` = 'battle-for-indy' ORDER BY `league_dates`.`start_date` ASC

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

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

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

QUERY(0.2289ms) - 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`=151 && `season_id`=318 LIMIT 0,1

QUERY(0.2408ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=151 && `season_id`=318 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

QUERY(0.252ms) - SELECT SQL_CACHE * FROM `league_schedule_options` WHERE `league_id`='151' && `season_id`='318' LIMIT 0,1

QUERY(0.1991ms) - SELECT SQL_CACHE count(`company_id`) FROM `league_company_links` WHERE `league_id`='151' && (`season_id`='318' || `season_id`=0)

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

QUERY(0.1791ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=151 && `season_id`=0) || `season_id`='318'

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

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

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

QUERY(0.2501ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons_rules` WHERE `league_id`='151' || `season_id`='318' ORDER BY `season_id` DESC

QUERY(0.19ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='151' && `season_id`='318'

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

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

QUERY(0.221ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=151&&`season_id`=318 LIMIT 0,1

QUERY(0.185ms) - SELECT SQL_CACHE `division_id` FROM `league_divisions` WHERE `league_id`=151&&`season_id`=318 LIMIT 0,1

QUERY(0.3991ms) - SELECT `game_id` FROM `games` WHERE `league_id`=151&&`season_id`=318&&`playoff`=1 LIMIT 0,1

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

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

QUERY(0.3111ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='151' && `season_id`='318'

QUERY(0.2611ms) - 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`='151' && `league_seasons`.`season_id`='318'

QUERY(0.1612ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=151 && `season_id`=318 LIMIT 0,1

QUERY(0.134ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=151 && `season_id`=318

QUERY(1.236ms) - 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 ('151','318','1',0,0,'131','14','1','1','23','10',0,'1','1',0,'14',0,0,0,0,0,0,NOW(),0) ON DUPLICATE KEY UPDATE `league_id`='151',`season_id`='318',`articles`='1',`participants`=0,`conferences`=0,`players`='131',`coaches`='14',`subs`='1',`rules`='1',`teams`='23',`games`='10',`groups`=0,`divisions`='1',`seasons`='1',`sponsors`=0,`products`='14',`prizes`=0,`triumphs`=0,`hotels`=0,`is_full`=0,`companies`=0,`reg_is_open`=0,`updated`=NOW(),`show_playoff_menu`=0

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

QUERY(0.263ms) - 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.1411ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='America/New_York'

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

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

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

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

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

QUERY(0.1559ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.16ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='turf-wars'

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

QUERY(0.1321ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.108ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1569ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.1862ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='151' && `season_id`='318' LIMIT 0,1

QUERY(0.144ms) - SELECT * FROM `league_notices` WHERE `league_id`=151 && `season_id`=318

QUERY(0.694ms) - SELECT SQL_CACHE `standings_id` FROM `standings` WHERE `season_id`=318 LIMIT 0,1

QUERY(0.242ms) - SELECT SQL_CACHE `standings_override` FROM `league_schedule_options` WHERE `season_id`=318 LIMIT 0,1

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

QUERY(0.128ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.2451ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=151 && `season_id`=318

QUERY(0.1721ms) - SELECT * FROM `league_hotel_settings` WHERE `league_id`=151 && `season_id`=318

QUERY(0.1459ms) - SELECT `game_term`,`game_terms` FROM `sports` WHERE `sport_id`=1

QUERY(0.1421ms) - SELECT `comeswith` FROM `league_custom_content` WHERE `league_id`=151 && `season_id`=318

QUERY(0.277ms) - SELECT `package_id` FROM `league_players` WHERE `player_id`=0 && `season_id`=318

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

QUERY(0.134ms) - SELECT SQL_CACHE * FROM payments_config

QUERY(0.2291ms) - SELECT `fee` FROM `league_seasons` WHERE `season_id`='318'

QUERY(0.3009ms) - SELECT `price` FROM `league_reg_packages` WHERE `season_id`=318 && `active`=1 ORDER BY `price` ASC

QUERY(0.499ms) - SELECT COUNT(*) FROM `article` INNER JOIN `article_text` ON (`article`.`article_id` = `article_text`.`article_id`) INNER JOIN `users` ON (`article`.`user_id` = `users`.`id`) INNER JOIN `league_updates` ON (`article`.`article_id` = `league_updates`.`article_id`) INNER JOIN `photo` ON (`users`.`avatar_id` = `photo`.`photo_id`) WHERE `league_updates`.`league_id` = '151' and `league_updates`.`season_id` = '318'

QUERY(1.0641ms) - SELECT SQL_CACHE `article`.`title`,`article`.`title_url`,`article`.`user_id`,`article`.`article_id`,`article`.`time_stamp`,`article`.`total_comment`,`article_text`.`text`,`users`.`username`,`users`.`user_url`,`league_updates`.`sent`,`photo`.`img_url` FROM `article` INNER JOIN `article_text` ON (`article`.`article_id` = `article_text`.`article_id`) INNER JOIN `users` ON (`article`.`user_id` = `users`.`id`) INNER JOIN `league_updates` ON (`article`.`article_id` = `league_updates`.`article_id`) INNER JOIN `photo` ON (`users`.`avatar_id` = `photo`.`photo_id`) WHERE `league_updates`.`league_id` = '151' and `league_updates`.`season_id` = '318' ORDER BY `article`.`time_stamp` desc LIMIT 0,3

QUERY(0.195ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=151 && `season_id`=318

QUERY(0.1402ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=151 && `season_id`=318

QUERY(0.17ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=151 && `season_id`=318

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

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