Mini King Cake Draft
Mini Draft Tournament
Metairie, LA
Registration Info
Rowlett Slowpitch
Spring 2025
Rowlett, TX
Registration Info
Myrtle Beach Slowpitch
 Spring 2025
Myrtle Beach, SC
Registration Info
Euless Draft League
Spring 2025 Session
Euless, TX
Registration Info
Gastonia Slowpitch
Spring Session 2025
Gastonia, NC
Registration Info
Gastonia Slowpitch
Spring Session 2025 - Janes
Gastonia, NC
Registration Info
Gastonia Slowpitch
Spring 2025 Session
Gastonia, NC
Registration Info
Lebanon Slowpitch Draft League
Spring 2025
Lebanon, MO
Registration Info
Bay Minette Draft League
Spring 2025 Session
Bay minette, AL
Registration Info
Pensacola Slowpitch Draft League
Spring 2025
Pensacola, FL
Registration Info
Kenton Lakes - Kentucky/Ohio
Spring Session 2025
Morning View, KY
Registration Info
Cincy Slowpitch (Ohio/Kentucky)
Spring 2025
Cincinnati, OH
Registration Info
St. Louis League Joe
Spring 2025
Bridgeton, MO
Registration Info
Midwest Slowpitch
Spring 2025
Indianapolis, IN
Registration Info
ISP Southside Draft League
Southside Softball Draft League |...
Indianapolis, IN
Registration Info
ISP Southside Draft League
The Janes Spring 25
Indianapolis, IN
Registration Info
Morse Beach Draft League
Spring 2025
Noblesville, IN
Registration Info

Upcoming and Active Leagues

NameDatesLocationGenderCompany

All Leagues

NameDatesLocationGenderCompany

Thursday Slowpitch
Mens Rec A (8 teams)

Softball
Indianapolis, IN Men's

Thursday Slowpitch
Men A Rec (10 teams)

Softball
Indianapolis, IN Coed

Thursday Slowpitch
6/7pm Summer Networking 2024

Softball
Indianapolis, IN Coed

Tuesday Slowpitch
Men rec summer

Softball
Indianapolis, IN Men's

Tuesday Slowpitch
Coed - Summer 24

Softball
Indianapolis, IN Coed

Tuesday Slowpitch
Networking - Summer 24

Softball
Indianapolis, IN Coed

Sunday Slowpitch
Sunday Networking - Spring 24

Softball
Indianapolis, IN Coed

Thursday Slowpitch
Men's Rec A - Spring 2024

Softball
Indianapolis, IN Men's

Thursday Slowpitch
6pm Spring Networking 2024

Softball
Indianapolis, IN Coed

Thursday Slowpitch
Men's Upper - Spring 24

Softball
Indianapolis, IN Coed

Tuesday Slowpitch
Networking - Spring 24

Softball
Indianapolis, IN Coed

Tuesday Slowpitch
Coed - Spring 24

Softball
Indianapolis, IN Coed

Tuesday Slowpitch
Men

Softball
Indianapolis, IN Men's

Monday Networking 6:00 PM
Spring

Softball
Indianapolis, IN Coed

Monday Networking Rotating
Spring 2024

Softball
Indianapolis, IN Coed

Thursday Slowpitch
Men's Rec B - Spring 2024

Softball
Indianapolis, IN Men's

Ft Wayne Adult Soccer Club
Summer 2022

Soccer
Indianapolis, IN Coed

Midwest Sports Complex - Softball -...
Women's Friday Night Comp League

Softball
Indianapolis, IN Women's

Wednesday Basketball League
Season 1

Basketball
Mountain ViewC, CA Coed

Midwest Sports Complex - Volleyball...
Thursdays Coed - Spring 2018

Volleyball
Indianapolis, IN Coed

Midwest Sports Complex - Volleyball...
Wednesdays Coed - Spring 2018

Volleyball
Indianapolis, IN Coed

Midwest Sports Complex - Volleyball...
Tuesdays Coed - Spring 2018

Volleyball
Indianapolis, IN Coed

Midwest Sports Complex - Softball -...
Sunday Softball - Spring 2018

Softball
Indianapolis, IN Coed

Midwest Sports Complex - Softball -...
Thursday Coed Rec - Spring 2018

Softball
Indianapolis, IN Coed

Midwest Sports Complex - Softball -...
Thursday Mens Upper - Spring 2018

Softball
Indianapolis, IN Men's

Midwest Sports Complex - Softball -...
Wednesday Mens Rec - Spring 2018

Softball
Indianapolis, IN Men's

Midwest Sports Complex - Softball -...
Tuesdays Mens - Spring 2018

Softball
Indianapolis, IN Men's

Indy Flag Football League
Fall 2017

Flag Football
Indianapolis, IN Coed

League Joe Flag Football North
Season 1

Flag Football
Carmel, IN Coed

Ladies' Night on the Diamond
Season 1

Softball
Indianapolis, IN Women's

Westside Sunday Coed
Fall 2016

Softball
Clermont, IN Men's

Westside Men's Thursday Softball
Fall 2016

Softball
Clermont, IN Men's

Westside Men's Tuesday Softball
Fall 2016

Softball
Clermont, IN Men's

Westside Men's Softball
Fall 2016

Softball
Clermont, IN Men's

3rd Base Sports Draft League
3rd Base Fall League

Softball
Muncie, IN Coed
PEAK MEMORY: 8.35 MiB
MEMORY USAGE AFTER: 3.8 MiB

Debug Information


Request Variables

var = leagues

vara =

varb =

varc =

vard =

vare =

view_var = leagues

view_varb =

view_varc =

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: League Joe

Template: lj

SECURETOKEN: 06ccca8dd6be4bbcd44db2f40465c317

Login Type:

BASE:: leagues

FULL LINK:: leagues

Page ID: 18

Page ID:: 18

Page Template:: lj

Template Layout:: default

Headers: : Loading page header code

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

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

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

Admin Login Level: :

Admin Login Level: :

Admin Login Level: :

Footer: : Loading page footer code


Session Variables

securetoken = 06ccca8dd6be4bbcd44db2f40465c317
fullstate =


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /leagues/
QUERY_STRING = var=leagues
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=leagues
REDIRECT_URL = /leagues/
REMOTE_PORT = 7491
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.145.167.199
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/leagues
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/leagues/
SCRIPT_URL = /leagues/
UNIQUE_ID = Z7hOT-Qjpmqoq3jK8ZLJ1AAAAJc
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/leagues/
REDIRECT_SCRIPT_URL = /leagues/
REDIRECT_UNIQUE_ID = Z7hOT-Qjpmqoq3jK8ZLJ1AAAAJc
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1740131919.574
REQUEST_TIME = 1740131919


SQL Queries


Total Queries: 34
Total Execution Time: 11.8345ms
Avg Execution Time:0.34807352941176ms

QUERY(0.988ms) - 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-02-21', '09:58:39', 'GET', '/leagues/', '3.145.167.199', 'https://netstuffersdev1.com/leagues' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhelBCRFRSTEZ6ZEFyVWJlT3U1VG9iNkU5aFMyenhQNGJ6a1VsTWFTaUdQWUdlVE8vK01MbFJTdExpNzRNNkx6WFVYaGVZZFhOUVB1WXAyd054YnZQNW0=','0','','1740131919') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1159ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/leagues/'

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

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

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

QUERY(0.1259ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.0849ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='UTC'

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

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

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

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

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

QUERY(0.083ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.674ms) - 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` >= '2025-02-18 09:58:39' and `leagues`.`tournament` = '0' and `league_seasons`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(1.1141ms) - 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` >= '2025-02-18 09:58:39' and `leagues`.`tournament` = '0' and `league_seasons`.`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,32

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

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

QUERY(0.087ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.083ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.077ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.598ms) - 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`.`end_date` >= '2025-02-18 09:58:39' and `leagues`.`tournament` = '0' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(1.018ms) - 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`.`end_date` >= '2025-02-18 09:58:39' and `leagues`.`tournament` = '0' 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,1000

QUERY(1.2219ms) - 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 `leagues`.`tournament` = '0' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(2.923ms) - 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 `leagues`.`tournament` = '0' 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 CASE WHEN `league_dates`.`end_date` < NOW() THEN 1 ELSE 0 END,(CASE WHEN `league_dates`.`end_date` >= NOW() THEN 1 ELSE -1 END) * DATEDIFF(`league_dates`.`end_date`, NOW()) LIMIT 0,1000

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

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

QUERY(0.1919ms) - SELECT * FROM columnmod WHERE `exclude` NOT LIKE '%:18:%' && (`linking`='/leagues/' || (`linking`='/' && `matching`='following') || (`linking`='leagues' && `matching`='following') || `include` LIKE '%:18:%'|| (`global`='1' && `exclude` NOT LIKE '%:18:%') ) && (`domain`=0 || `domain`=1) ORDER BY `order`

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