Upcoming and Active Leagues

NameDatesLocationGenderCompany

All Leagues

NameDatesLocationGenderCompany

ISP Southside Draft League
The Janes Fall 24

Softball
Indianapolis, IN Women's

ISP Southside Draft League
Southside Softball Draft League |...

Softball

Indianapolis, IN Coed

Thursday Slowpitch
6/7pm Summer Networking 2024

Softball
Indianapolis, IN Coed

Thursday Slowpitch
Men A Rec (10 teams)

Softball
Indianapolis, IN Coed

Thursday Slowpitch
Mens Rec A (8 teams)

Softball
Indianapolis, IN Men's

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

ISP Southside Draft League
The Janes Summer 24

Softball
Indianapolis, IN Women's

ISP Southside Draft League
Southside Softball Draft League |...

Softball
Indianapolis, IN Coed

Sunday Slowpitch
Sunday Networking - Spring 24

Softball
Indianapolis, IN Coed

Thursday Slowpitch
Men's Upper - 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

Tuesday Slowpitch
Coed - Spring 24

Softball
Indianapolis, IN Coed

Tuesday Slowpitch
Men

Softball
Indianapolis, IN Men's

Tuesday Slowpitch
Networking - Spring 24

Softball
Indianapolis, IN Coed

Monday Networking Rotating
Spring 2024

Softball
Indianapolis, IN Coed

Monday Networking 6:00 PM
Spring

Softball
Indianapolis, IN Coed

Thursday Slowpitch
Men's Rec B - Spring 2024

Softball
Indianapolis, IN Men's

ISP Southside Draft League
Southside Softball Draft League |...

Softball

Indianapolis, IN Coed

ISP Southside Draft League
Southside Softball Draft League |...

Softball
Indianapolis, IN Coed

ISP Southside Draft League
Southside Softball Draft League |...

Softball
Indianapolis, IN Coed

ISP Southside Draft League
Summer 2023

Softball
Indianapolis, IN Coed

ISP Southside Draft League
Spring 2023

Softball
Indianapolis, IN Coed

ISP Southside Draft League
Summer 2 Draft 2022

Softball
Indianapolis, IN Coed

Ft Wayne Adult Soccer Club
Summer 2022

Soccer
Indianapolis, IN Coed

ISP Southside Draft League
Summer 2022

Softball
Indianapolis, IN Coed

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

Softball
Indianapolis, IN Women's

ISP Southside Draft League
Spring 2019

Softball
Indianapolis, IN Coed

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 Tuesday Softball
Fall 2016

Softball
Clermont, IN Men's

Westside Men's Thursday 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: 3.08 MiB
MEMORY USAGE AFTER: 1.49 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: LeagueJoe

Template: lj

SECURETOKEN: fc473513d3e8afc45bb739cfc268335a

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] => )

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

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

Admin Login Level: :

Admin Login Level: :

Admin Login Level: :

Footer: : Loading page footer code


Session Variables

securetoken = fc473513d3e8afc45bb739cfc268335a
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 = 28103
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.218.76.193
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 = Zz7jc3MIYG2Ja7kUoJGqsAAAAMk
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 = Zz7jc3MIYG2Ja7kUoJGqsAAAAMk
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1732174707.1839
REQUEST_TIME = 1732174707


SQL Queries


Total Queries: 34
Total Execution Time: 22.5655ms
Avg Execution Time:0.66369117647059ms

QUERY(1.2219ms) - 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', '07:38:27', 'GET', '/leagues/', '18.218.76.193', 'https://netstuffersdev1.com/leagues' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheFBpT2JNT2s0S0pIZkw5YW9iS25jdU10WWl6OGFjNnBFbitMaGp6NUJYN3JDZnR6cFZZTGsyUWpVSGRtalBOcnZDUURIZGNXZWpYdHJSM2tZM3B0eGE=','0','','1732174707') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

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

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

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

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

QUERY(0.1569ms) - SELECT * FROM userprofiles_config

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

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

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

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

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

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

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

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

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

QUERY(0.1111ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.9532ms) - SELECT COUNT(*) FROM `leagues` INNER JOIN `league_seasons` ON (`leagues`.`league_id` = `league_seasons`.`league_id`) INNER JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `season_photo` ON (`league_seasons`.`logo_id` = `season_photo`.`photo_id`) INNER JOIN `company` ON (`leagues`.`company_id` = `company`.`company_id`) INNER JOIN `photo` AS `company_photo` ON (`company`.`logo_onwhite` = `company_photo`.`photo_id`) LEFT JOIN `league_cache` ON (`league_seasons`.`season_id` = `league_cache`.`season_id`) INNER JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_dates`.`start_date` >= '2024-11-18 07:38:27' and `leagues`.`tournament` = '0' and `leagues`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(1.261ms) - 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`.`state`,`venues`.`fullstate`,`photo`.`img_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_url`,`company`.`name` AS `company_name`,`company`.`url` AS `company_url`,`company_photo`.`img_url` AS `company_img_url`,`league_cache`.`reg_is_open`,`league_cache`.`teams`,`league_cache`.`players`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date` FROM `leagues` INNER JOIN `league_seasons` ON (`leagues`.`league_id` = `league_seasons`.`league_id`) INNER JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `season_photo` ON (`league_seasons`.`logo_id` = `season_photo`.`photo_id`) INNER JOIN `company` ON (`leagues`.`company_id` = `company`.`company_id`) INNER JOIN `photo` AS `company_photo` ON (`company`.`logo_onwhite` = `company_photo`.`photo_id`) LEFT JOIN `league_cache` ON (`league_seasons`.`season_id` = `league_cache`.`season_id`) INNER JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_dates`.`start_date` >= '2024-11-18 07:38:27' and `leagues`.`tournament` = '0' and `leagues`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1') GROUP BY `league_seasons`.`season_id` ORDER BY `league_dates`.`start_date` asc LIMIT 0,32

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

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

QUERY(0.1171ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.118ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.097ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.788ms) - 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` >= '2024-11-18 07:38:27' 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.5459ms) - 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`.`state`,`venues`.`fullstate`,`photo`.`img_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_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` >= '2024-11-18 07:38:27' 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(2.7959ms) - 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(7.7ms) - 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`.`state`,`venues`.`fullstate`,`photo`.`img_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_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.123ms) - select SQL_CACHE codename,classname,scriptname from modules WHERE `id`='2'

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

QUERY(0.417ms) - 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.2179ms) - SELECT SQL_CACHE `code` FROM `page_footers` WHERE (`domain`=1||domain_global=1) && (`include` LIKE '%:18:%' || (`global`=1 && `exclude` NOT LIKE '%:18:%') ) ORDER BY `id` ASC