SOLD OUT

This event has reached capacity.

Tournament

Turf Wars

Division: Battle for Indy 2024
Sport: Softball
CoedSocialDraft
Event Director
League Joe
Contact / Learn More
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

  • UPDATE
  • Smitty AvatarSmitty

Turf Wars Indy - Event Recap and Survey

Thank you to everyone who attended last week's Turf Wars.  This was a new concept for play and from what we've seen, it was highly successful.  We loved seeing so many faces of people who haven't played in a long time, mixed with people we see every week, and the condensed format was hectic but fun.  If you didn't stay until the end, the results are below.  But first - please help us by completing this quick survey about the format.  This will help us learn what you liked, what you didn't, and enable us to do similar, fun pop up events more often in the future.

Turf Wars Player Survey

And the winner is....

The scoring system for Turf Wars was simple - we are looking for which park had the best overall represented Run Differential based on their matchups for the evening. Our most competitive matchups were more valuable, however, and counted as double on the standings.

Midwest Dominated Early
The players from Midwest came out to play and won the first three overall timeslots 5 games to 4, with a substantial run differential lead built in their victories.

Early Score
134-109 - Midwest Advantage


ISP Competitive Might Shows Up Late
But those competitive games between our Men's and Women's Squads and the former championship teams mattered quite a bit. While the parks split the gender matchups with Midwest taking Men's and ISP taking Women's, it was ultimately the ISP Run-it-Back Championship squads that completed the comeback for Indy Sports Park.

Final Score
198-197 - ISP Wins

When we make our events, we want to make sure everyone has fun, and everyone has a chance to win. To have 14 total games end up with a run differential of 1 freakin' run is phenomenal, and players from both teams should be proud. Although at the end of the day, there can be only one pie.... and.... well.... Smitty wears it well, at least.

See the Full Results465401955101004117860698602388453765160924908_recjoe1730919039.jpg

Thank you for Playing, and Embracing the Spirit of Fun

We know things were a little chaotic, but overall we saw nothing but smiles, and laughter, and reunions, and a healthy dose of appropriately friendly smack talk. This is just the first Turf Wars and we will definitely be back - bigger and better next year!

Turf Wars Player Survey
Continue Reading
  • UPDATE
  • Smitty AvatarSmitty

Turf Wars - Scheduled Games

View Your Timeslots on the Site

teampicture_recjoe1730323539.png

Please login to your League Joe account and visit the Turf Wars page. If you are logged in, you will see your player info at the top of the site, with your teams and the times listed.

Turf Wars Page

Schedule / Field Assignments

Visit the schedule page to find out where you team is playing!

Schedule

Having Trouble Finding Your Games

Come visit the League Joe tent over by Field 3. We'll get you straight!

Continue Reading
  • UPDATE
  • Smitty AvatarSmitty

Turf Wars - Schedule Update for Tonight

We are still working on finalizing team rosters due to some technical issues that unfortunately slowed us down. We do expect them to be done within the next hour or two. In the meantime, we have posted 6:30 team rosters so players know to get there early if they need to. You can click on the rosters below to see if you play at 6:30.

If you do not see your name in those rosters, assume your first game will be at 7:30 or 8:30 tonight and the final rosters will be finished as soon as possible.

Where Do I Find My Teams?

teampicture_recjoe1730311351.png

Go to the website and login, and visit the Turf Wars page. Your teams will be listed at the top next to your player information.

Turf Wars Page

Check Again at 5pm

As mentioned above, we are making final roster placements and adding additional timeslots so everyone can get more games in. The 6:30 games are locked, but you may find yourself on a new team or two before this process completes. So please check again before you come to the park to see your final teams list.

Thank you everyone - see you soon!

Continue Reading

Event Operator

League Joe
Contact Organizer
PEAK MEMORY: 12.35 MiB
MEMORY USAGE AFTER: 11.37 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: 15c9a580d4739dc0b20c16debee3c469

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

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

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

Admin Login Level: :

Footer: : Loading page footer code


Session Variables

securetoken = 15c9a580d4739dc0b20c16debee3c469
fullstate =


Cookie Variables

cartid = f93f6b866220250121024432.a55547
PHPSESSID = 71loehm4kcf0q24chipjmiabt1


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 = 7766
SCRIPT_FILENAME = /home/leaguejo_dev/public_html/index.php
SERVER_ADMIN = support@aod.net
CONTEXT_DOCUMENT_ROOT = /home/leaguejo_dev/public_html
CONTEXT_PREFIX =
REQUEST_SCHEME = https
DOCUMENT_ROOT = /home/leaguejo_dev/public_html
REMOTE_ADDR = 3.149.234.78
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 = cartid=f93f6b866220250121024432.a55547; PHPSESSID=71loehm4kcf0q24chipjmiabt1
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 = Z496k6@bS1wMo2@i4RKE1wAAABU
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 = Z496k6@bS1wMo2@i4RKE1wAAABU
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1737456275.0356
REQUEST_TIME = 1737456275


SQL Queries


Total Queries: 81
Total Execution Time: 30.4724ms
Avg Execution Time:0.3762024691358ms

QUERY(1.3371ms) - INSERT INTO security_log (domain,username, log_date, log_time, method, page, ip, address, browser, getvars, postvars, sessionvars,badlogin,userlogin,timestamp) VALUES ('.netstuffersdev1.com','','2025-01-21', '10:44:35', 'GET', '/tournament/turf-wars/battle-for-indy/', '3.149.234.78', '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)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheHc5aVVKNnpxOVl0anlTcDc5Z0hyNFpDcjdtWFNmMi9yZWFqSWFEUzRNR2NROWtsZXpCVmVCczFPa3hZTjVXRFloQmI5NXZsUHNjOXVXNjVXU043L1k=','0','','1737456275') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

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

QUERY(0.2692ms) - 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.1791ms) - SELECT SQL_CACHE `id`,`layout`,`light`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='tournament' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

QUERY(0.1421ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.149ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

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

QUERY(0.2029ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=318

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

QUERY(0.1349ms) - 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.1199ms) - 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.1431ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=151 && `season_id`=318 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

QUERY(0.783ms) - 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.325ms) - SELECT SQL_CACHE count(DISTINCT(`league_players`.`player_id`)) FROM `league_players` INNER JOIN `league_levels` ON `league_players`.`access`=`league_levels`.`level_id` WHERE `league_id`='151' && `season_id`='318' &&`league_players`.`access`=4 && `deleted`=0 && `alternate`=0

QUERY(1.2159ms) - 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.1531ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons_rules` WHERE `league_id`='151' || `season_id`='318' ORDER BY `season_id` DESC

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

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

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

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

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

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

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

QUERY(0.2849ms) - 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.2038ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='151' && `season_id`='318'

QUERY(0.14ms) - 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.102ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=151 && `season_id`=318 LIMIT 0,1

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

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

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

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

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

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

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

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

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

QUERY(0.092ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

QUERY(0.1328ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1001ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1361ms) - SELECT SQL_CACHE * FROM teams_config

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

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

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

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

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

QUERY(0.119ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

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

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

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

QUERY(0.262ms) - SELECT SQL_CACHE * FROM payments_config

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

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

QUERY(0.643ms) - 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(7.0188ms) - 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(1.3251ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=151 && `season_id`=318

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

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

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

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