SOLD OUT

This event has reached capacity.

Ultra Draft

Arizona Ultra Draft
Powered by Easton/Miken/Worth

Event: November 2023   |   Sport: Softball

MixedSocialDraft
Event Director
Sports Drafts LLC
Contact / Learn More
Venue
Victory Lane
Glendale, AZ

SOLD OUT

This event has reached capacity.

Join as Alternate

Results

Event Schedule

Friday, Nov 17
Meet & Greet

Meet & Greet
5:00pm - 7:00pm
Meet & Greet Social
Appetizers provided!
Jersey's On Deck Sports Grill - Victory Field
Tourney Play
7:00pm
Home Run Derby
Victory Field - Field TBD

Saturday, Nov 18
Pool Play / Bracket Play

Uniform Pickup
8:30am - 12:00pm
Player Kit Pick Up / Check-in
Victory Field
Pool Play
9:15am - 11:45pm
Pool Play
Victory Field
Tournament Play
12:00pm - 8:30pm
Tourney Bracket
Victory Field

Sunday, Nov 19
Championship Sunday

Tournament Play
8:00am - 2:00pm
Tourney Bracket
Victory Field
Tournament Play
10:30am - 11:45am
Super Secret Special Single Elim
Victory Field
Tournament Play
2:00pm - 4:30pm
The Championship
Victory Field - Field TBD

Competition Format

1 Pool Play Seeding Game followed by 3gg bracket. Super Secret Consolation bracket on Sunday. 5gg Overall.

All Activities at Victory Field

Daily Gate Fee

Uniform / Bat Pickup
Teams will pick up their equipment from the main registration table which will be setup at the park.

Your team is eligible for check-in and equipment pickup one hour prior to your first game. Please only check-in during your allotted timeslot and do not go to check-in early. Players may arrive at the park and hang out ahead of their scheduled check-in time, and then head over during their time block.

E.g. Team A's first game is at 11am Saturday. They are eligible for Registration and pickup between 10-11am Saturday. Team B does not play until 12, so they do their uniform check-in from 11a-12pm.

Home Run Derby
Visit the Registration Table to sign up for Home Run Derby! Details and rules available on site.

Games Schedule

Full Live Schedule Found on Tourney Machine Website

Tourney Machine Schedule

Schedule

For convenience, here is the initial pool schedule. Please visit the website above for live updates and scores!



Tourney Machine Schedule

3 Game Guarantee Bracket. Will be posted here ASAP

!!! There is an AM/PM bug in the bracket software. Doghouse Bracket starts Sunday morning and Championship for Doghouse will be 2:50pm !!!

76 113

Debug Information


Request Variables

var = ultra

varb = arizona

varc = nov-2023

vard = results

view_var = ultra

view_varb = arizona

view_varc = nov-2023

view_vard = results

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: 95f75f91768da0054872d9d3466256b8

Login Type:

BASE:: ultra

FULL LINK:: ultra/arizona/nov-2023/results

Page ID: 57

Page ID:: 57

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 = 95f75f91768da0054872d9d3466256b8


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/arizona/nov-2023/results/
QUERY_STRING = var=ultra&varb=arizona&varc=nov-2023&vard=results
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=arizona&varc=nov-2023&vard=results
REDIRECT_URL = /ultra/arizona/nov-2023/results/
REMOTE_PORT = 48885
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.116.239.195
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_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/ultra/arizona/nov-2023/results/
SCRIPT_URL = /ultra/arizona/nov-2023/results/
UNIQUE_ID = ZjLrKq47fdwUUTlc2Na4ogAAAAs
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/arizona/nov-2023/results/
REDIRECT_SCRIPT_URL = /ultra/arizona/nov-2023/results/
REDIRECT_UNIQUE_ID = ZjLrKq47fdwUUTlc2Na4ogAAAAs
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1714613034.4852
REQUEST_TIME = 1714613034


SQL Queries


Total Queries: 96
Total Execution Time: 58.4383ms
Avg Execution Time:0.60873229166667ms

QUERY(10.932ms) - 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-05-02', '01:23:54', 'GET', '/ultra/arizona/nov-2023/results/', '18.116.239.195', '' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'OXoxRVZMVjQ4WTB4djhqV3ZoeDVtaWk0bVpKWXNoVFlDeGpkTXRpRUsxWnNPMHBkSG96NzlCYnk2bHhvMkwyMk5Eb2QwcmE2R2ZQWVV4NnRXSk91MHlZVytVYkI1ZS9UUWFSbGJCVnpnZkN3NkFVZ0U0eDQydTZzdTRlOG9NSUdaQkZBL3JhYXJUTmpaSlY1WlNtZWFpbGZWYlFsc0ZsdWVPdVUvSGtPUWR4TFNmRTJPSG9xVGJrSXFzNjJFcGhD', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheFFtQStSRHBseU13NjRZZnB2NDYxMVB1ckdFZFNDSUNlTytFWUxRbUJWSkhqb3pwbmlzU2o2N2Rtejd6MWxHekM5STNucXZBd1lKejBhVzREMFhadDM=','0','','1714613034') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1831ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/arizona/nov-2023/results/'

QUERY(0.222ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='ultra/arizona/nov-2023/results' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.1709ms) - SELECT * FROM userprofiles_config

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

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

QUERY(0.1628ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.6518ms) - SELECT SQL_CACHE `leagues`.*,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`photo`.`img_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` = 'arizona' LIMIT 0,1

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

QUERY(0.556ms) - 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` 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` = '76' and `league_seasons`.`url` = 'nov-2023' ORDER BY `league_dates`.`start_date` ASC

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

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

QUERY(0.2351ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit` FROM `league_custom_content` WHERE `league_id`=76 && `season_id`=113 LIMIT 0,1

QUERY(0.3331ms) - 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`=76 && `season_id`=113 LIMIT 0,1

QUERY(0.2649ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=76 && `season_id`=113 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

QUERY(0.2179ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`='' && `season_id`=''

QUERY(0.2851ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='76' && (`season_id`='113' || `season_id`=0)

QUERY(0.2379ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=76 && `season_id`=0) || `season_id`='113'

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

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

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

QUERY(0.217ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons_rules` WHERE `league_id`='76' || `season_id`='113' ORDER BY `season_id` DESC

QUERY(0.1869ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='76' && `season_id`='113'

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

QUERY(0.339ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons` WHERE `league_id`='76'

QUERY(0.2279ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=76&&`season_id`=113 LIMIT 0,1

QUERY(1.1661ms) - SELECT `game_id` FROM `games` WHERE `league_id`=76&&`season_id`=113&&`playoff`=1 LIMIT 0,1

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

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

QUERY(1.2739ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='76' && `season_id`='113'

QUERY(0.2999ms) - 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`='76' && `league_seasons`.`season_id`='113'

QUERY(0.2251ms) - SELECT `hotelinfo` FROM `league_custom_content` WHERE `league_id`=76 && `season_id`=113 LIMIT 0,1

QUERY(0.2561ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=76 && `season_id`=113

QUERY(5.2061ms) - INSERT INTO `league_cache` (`league_id`,`season_id`,`articles`,`participants`,`conferences`,`players`,`coaches`,`subs`,`rules`,`teams`,`games`,`groups`,`divisions`,`seasons`,`sponsors`,`products`,`prizes`,`hotels`,`is_full`,`reg_is_open`,`updated`,`show_playoff_menu`) VALUES ('76','113','4','0','0','150','12','6','1','1','0','0','0','1','0','11','0','0','0','0',NOW(),'0') ON DUPLICATE KEY UPDATE `articles`='4',`participants`='0',`conferences`='0',`players`='150',`coaches`='12',`subs`='6',`rules`='1',`teams`='1',`games`='0',`groups`='0',`divisions`='0',`seasons`='1',`sponsors`='0',`products`='11',`prizes`='0',`hotels`='0',`is_full`='0',`reg_is_open`='0',`updated`=NOW(),`show_playoff_menu`='0'

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

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

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

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

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

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

QUERY(0.2079ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5341ms) - SELECT SQL_CACHE `leagues`.*,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`photo`.`img_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` = 'arizona' LIMIT 0,1

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

QUERY(0.495ms) - 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` 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` = '76' and `league_seasons`.`url` = 'nov-2023' ORDER BY `league_dates`.`start_date` ASC

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

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

QUERY(0.195ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit` FROM `league_custom_content` WHERE `league_id`=76 && `season_id`=113 LIMIT 0,1

QUERY(0.2151ms) - 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`=76 && `season_id`=113 LIMIT 0,1

QUERY(0.2229ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=76 && `season_id`=113 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

QUERY(0.411ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='arizona'

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

QUERY(0.164ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.2191ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.227ms) - SELECT * FROM `league_notices` WHERE `league_id`=76 && `season_id`=113

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

QUERY(0.2179ms) - SELECT SQL_CACHE * FROM draft_config

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

QUERY(0.247ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.2069ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.293ms) - SELECT `standing_id` FROM `standings_composite` WHERE `season_id`=113

QUERY(0.2282ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='76' && `season_id`='113'

QUERY(4.9779ms) - SELECT SQL_CACHE `teams`.`url`,`teams`.`team_id`,`teams`.`fullname`,`teams`.`personal`,(SELECT `player_id` FROM `teams_players` WHERE `team_id`=`teams`.`team_id` && `access`=4 LIMIT 0,1) AS `coach_id`,(SELECT SUM(`s`.`wins`+`s`.`losses`+`s`.`ties`) as `gamesplayed` FROM `standings` AS `s` WHERE `s`.`team_id`=`standings`.`team_id`) AS `gamesplayed`,`standings`.`wins`,`standings`.`losses`,`standings`.`ties`,`standings`.`games_back`,`standings`.`points_for`,`standings`.`points_against`,`standings`.`streak`,`standings`.`forfeits`,`standings`.`forfeit_wins`,`users`.`user_url`,`users`.`username`,`photo`.`thumb_url`,`league_groups_teams`.`group_id` FROM `teams` LEFT JOIN `standings` ON (`teams`.`team_id` = `standings`.`team_id`) LEFT JOIN `users` ON (`teams`.`owner_id` = `users`.`id`) LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `league_groups_teams` ON (`teams`.`team_id` = `league_groups_teams`.`team_id`) INNER JOIN league_teams ON (`league_teams`.`team_id`=`teams`.`team_id` && `league_teams`.`league_id`='76' && `league_teams`.`season_id`='113') WHERE `teams`.`approved` = '1' and `teams`.`active` = '1' and `teams`.`personal` = '0' and `standings`.`league_id` = '76' and `standings`.`season_id` = '113' ORDER BY `standings`.`wins` desc,`standings`.`ties` desc,`standings`.`pts_diff` desc,`standings`.`points_for` desc,`standings`.`points_against` asc,`standings`.`forfeits` asc

QUERY(0.1841ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='76' && `season_id`='113'

QUERY(3.9971ms) - SELECT SQL_CACHE `teams`.`url`,`teams`.`team_id`,`teams`.`fullname`,`teams`.`personal`,(SELECT `player_id` FROM `teams_players` WHERE `team_id`=`teams`.`team_id` && `access`=4 LIMIT 0,1) AS `coach_id`,(SELECT SUM(`s`.`wins`+`s`.`losses`+`s`.`ties`) as `gamesplayed` FROM `standings` AS `s` WHERE `s`.`team_id`=`standings`.`team_id`) AS `gamesplayed`,`standings`.`wins`,`standings`.`losses`,`standings`.`ties`,`standings`.`games_back`,`standings`.`points_for`,`standings`.`points_against`,`standings`.`streak`,`standings`.`forfeits`,`standings`.`forfeit_wins`,`users`.`user_url`,`users`.`username`,`photo`.`thumb_url`,`league_groups_teams`.`group_id` FROM `teams` LEFT JOIN `standings` ON (`teams`.`team_id` = `standings`.`team_id`) LEFT JOIN `users` ON (`teams`.`owner_id` = `users`.`id`) LEFT JOIN `photo` ON (`teams`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `league_groups_teams` ON (`teams`.`team_id` = `league_groups_teams`.`team_id`) INNER JOIN league_teams ON (`league_teams`.`team_id`=`teams`.`team_id` && `league_teams`.`league_id`='76' && `league_teams`.`season_id`='113') WHERE `teams`.`approved` = '1' and `teams`.`active` = '1' and `teams`.`personal` = '0' and `standings`.`league_id` = '76' and `standings`.`season_id` = '113' ORDER BY `standings`.`wins` desc,`standings`.`ties` desc,`standings`.`pts_diff` desc,`standings`.`points_for` desc,`standings`.`points_against` asc,`standings`.`forfeits` asc

QUERY(0.397ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=76 && `season_id`=113

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

QUERY(0.165ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.428ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='76' && `season_id`='113' && `ranking`='1'

QUERY(1.6911ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='113' && `finish_rank`=1 ORDER BY `date` DESC

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

QUERY(0.2358ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='76' && `season_id`='113' && `ranking`='2'

QUERY(1.334ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='113' && `finish_rank`=2 ORDER BY `date` DESC

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

QUERY(0.32ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='76' && `season_id`='113' && `ranking`='3'

QUERY(0.5682ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='113' && `finish_rank`=3 ORDER BY `date` DESC

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

QUERY(0.227ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='76' && `season_id`='113' && `ranking`='4'

QUERY(0.4828ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='113' && `finish_rank`=4 ORDER BY `date` DESC

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

QUERY(0.2499ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='76' && `season_id`='113' && `ranking`='5'

QUERY(0.623ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='113' && `finish_rank`=5 ORDER BY `date` DESC

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

QUERY(0.283ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='76' && `season_id`='113' && `ranking`='6'

QUERY(0.608ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='113' && `finish_rank`=6 ORDER BY `date` DESC

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

QUERY(0.8321ms) - SELECT * FROM `league_schedule_options` WHERE `season_id`=113

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