New Orleans Ultra Draft
King Cake 2025
Metairie, LA
Registration Info
Suncoast Senior Draft
40+ Seniors March 2025
Sebring, FL
Registration Info
Gin & Juice Draft Tourney
Seniors Family Draft - Spring 2025
Myrtle Beach, SC
Registration Info
Gin & Juice Draft Tourney
Showcase Draft - Spring 2025
Myrtle Beach, SC
Registration Info
2024 Miken/Easton/Worth Series
Dalton SuperDrafts 2025
Dalton, GA
Registration Info
Gin & Juice Draft Tourney
Myrtle Beach - Spring 2025
Myrtle Beach, SC
Registration Info
Chase for the Chaos Cup
Pensacola 2025
Pensacola, FL
Registration Info

Upcoming and Active Tournaments

NameDatesLocationGenderCompany

2024 Miken/Easton/Worth Series
Dalton SuperDrafts 2025

Softball
Dalton, GA Coed

All Tournaments

NameDatesLocationGenderCompany

2024 Miken/Easton/Worth Series
Dalton SuperDrafts 2025

Softball
Dalton, GA Coed

2024 Miken/Easton/Worth Series
Valdosta 2024

Softball

Valdosta, GA Coed

2024 Miken/Easton/Worth Series
Phoenix 2024

Softball
Glendale, AZ Coed

2024 Miken/Easton/Worth Series
Johnson City, TN 2024

Softball

Johnson City, TN Coed

Indianapolis Ultra Draft
Greatest Hits 2024

Softball
Indianapolis, IN Coed

2024 Miken/Easton/Worth Series
Waipahu 2024

Softball

Waipahu, HI Coed

2024 Miken/Easton/Worth Series
Cincinnati 2024

Softball
Cincinnati, OH Coed

2024 Miken/Easton/Worth Series
Altamonte 2024

Softball
Altamonte Springs, FL Coed

2024 Miken/Easton/Worth Series
Anchorage 2024

Softball

Anchorage, AK Coed

2024 Miken/Easton/Worth Series
St. Louis 2024

Softball

Bridgeton, MO Coed

2024 Miken/Easton/Worth Series
Perris, CA 2024

Softball
Perris, CA Coed

2024 Miken/Easton/Worth Series
Dalton 2024

Softball

Dalton, GA Coed

2024 Miken/Easton/Worth Series
Jacksonville 2024

Softball

Jacksonville, FL Coed

Indianapolis Ultra Draft
National Championship - Sept

Softball
Indianapolis, IN Coed

Last Bash Tournament & Halloween...
Fall 2017

Softball
Indianapolis, IN Coed

Fall Festival Cornhole Tournament
Fall Festival 2017

Cornhole
Carmel, IN Coed

Lindsey Wilkins Benefit Softball...
September 23

Softball
Indianapolis, IN Coed

St. Practice Day Cornhole...
Fall 2017

Cornhole
Carmel, IN

Last Bash Tournament & Halloween...
Fall Tournament

Softball
Indianapolis, IN Coed
PEAK MEMORY: 11.82 MiB
MEMORY USAGE AFTER: 7.31 MiB

Debug Information


Request Variables

var = tournaments

vara =

varb =

varc =

vard =

vare =

view_var = tournaments

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: 138f58fe212eb3828c64ebff45f516b1

Login Type:

BASE:: tournaments

FULL LINK:: tournaments

Page ID: 26

Page ID:: 26

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 = 138f58fe212eb3828c64ebff45f516b1
fullstate =
refer_params = https://netstuffersdev1.com/robots.txt/


Cookie Variables

PHPSESSID = l2gc10tqku7gu15ave2cmd11cq


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /tournaments/
QUERY_STRING = var=tournaments
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=tournaments
REDIRECT_URL = /tournaments/
REMOTE_PORT = 37461
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.226.187.60
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/tournaments
HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
HTTP_COOKIE = PHPSESSID=l2gc10tqku7gu15ave2cmd11cq
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/tournaments/
SCRIPT_URL = /tournaments/
UNIQUE_ID = Z46MxnfnqU53XkLCR4RP3gAAAFM
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/tournaments/
REDIRECT_SCRIPT_URL = /tournaments/
REDIRECT_UNIQUE_ID = Z46MxnfnqU53XkLCR4RP3gAAAFM
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1737395398.9918
REQUEST_TIME = 1737395398


SQL Queries


Total Queries: 34
Total Execution Time: 11.9964ms
Avg Execution Time:0.35283529411765ms

QUERY(1.266ms) - 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-20', '17:49:59', 'GET', '/tournaments/', '18.226.187.60', 'https://netstuffersdev1.com/tournaments' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheEVZbmF4ZDBUUndhaEQ5ZUxRVU5IMC8vd01Rc0tmRFJoSG5Ic29RUVhGOWs1VWRwK0xrYW50d2NiTW51NTFOMlhvbmhVQUpNVk80SnJ1WWRtOFFpZG1rbDFlU3pISjg4TWtpVE56UHFOUFdNdE1SR3JUR1NWSTczdmNPSURFT2ZvbGZ0M0JhTkJkQlZCdUJlSW9xVTR1KzY5S0d1enJDbFo0cVlqYVZGRGEvVEsxY0FtSVE3Q2tDSFI2cjZBeFJMQ2ZTazNUditUNGZob0tXTW10enVKZw==','0','','1737395399') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1049ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/tournaments/'

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

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

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

QUERY(0.2029ms) - SELECT * FROM userprofiles_config

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

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

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

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

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

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

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

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

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

QUERY(0.1099ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.6628ms) - 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-01-17 17:49:59' and `leagues`.`tournament` = '1' 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.1201ms) - 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-01-17 17:49:59' and `leagues`.`tournament` = '1' 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.1261ms) - select SQL_CACHE codename,classname,scriptname from modules WHERE `id`='10'

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

QUERY(0.0849ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.078ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.071ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5281ms) - 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-01-17 17:49:59' and `leagues`.`tournament` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(1.0538ms) - 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-01-17 17:49:59' and `leagues`.`tournament` = '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,1000

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

QUERY(2.1501ms) - 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` = '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 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.1011ms) - select SQL_CACHE codename,classname,scriptname from modules WHERE `id`='2'

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

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

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