The Next Event

Ready for the next event in this series?

2024 Miken/Easton/Worth Series - St. Louis 2024

SOLD OUT

This event has reached capacity.

Ultra Draft

St. Louis Ultra Draft
Powered by Easton/Miken/Worth

Event: Summer 2023
Sport: Softball
Mixed / Senior MixedSocialDraft
Event Director
Sports Drafts LLC
Contact / Learn More
Venue
BMAC (Bridgeton)
Bridgeton, MO
Dates
May 27, 2023 - May 28, 2023

SOLD OUT

This event has reached capacity.


Deprecated: Automatic conversion of false to array is deprecated in /home/leaguejo_dev/public_html/templates/lj/modules/league/schedule.php on line 26

Results

Item

MidWest MisFits

Visit Team Page

Champion of St. Louis Ultra Draft - Summer 2023
05/28/2023

Item

HRH (Home Run Hotties)

Visit Team Page

Runner Up of St. Louis Ultra Draft - Summer 2023
05/28/2023

Item

Code Red

Visit Team Page

Third Place of St. Louis Ultra Draft - Summer 2023
05/28/2023

Item

Plums of Steel

Visit Team Page

Fourth Place of St. Louis Ultra Draft - Summer 2023
05/28/2023

Final Standings - Mixed Division

Tap and drag left and right to view full table
PlaceTeamPoolBracketOverallWin %Pts ForPts AgainstFinal Pts DiffCoach
1
All Holes Matter
2-0 1-23-250500Taylor Allen
2
Miken Diversified Dingers
2-0 1-23-25770--13dlfamily69
3
Easton Gashouse Gang
0-2 2-22-46082--22MattGard95
4
Money $hotz
0-2 0-00-2000fisherfarms2015
5
All mixed Up
0-2 0-40-64892--44Jcgolfs
6
MidWest MisFits
1-1 4-15-27655+21UncleDuck11
7
HRH (Home Run Hotties)
2-0 4-26-29166+25jenelle1281
8
Code Red
1-1 4-35-412184+37Tjgerig
9
Plums of Steel
1-1 3-24-39876+22kimtex1022

Final Standings - Senior Mixed (40+) Division

Tap and drag left and right to view full table
PlaceTeamPoolBracketOverallWin %Pts ForPts AgainstFinal Pts DiffCoach
1
F.I.T.S.
1-2 3-04-28368+15"V" Shaw
2
The Chosen Ones
2-1 2-24-3118111+7Kendo
3
Miken - Scoring Position
1-2 1-22-47288--16KConnor38
4
Worth The Effort
2-1 0-22-37985--6WLambert10

Event Schedule

Friday, May 26
Social Meet & Greet

Local Shenanigans
7:00pm - 10:00pm
Meet & Greet Social Event
RSVP Here
Trainwreck Saloon - Westport

Saturday, May 27
Pool Play / Bracket Play / Side Events

Uniform Pickup
8:00am - 2:00pm
Uniform Pick Up / Check-in
BMAC Fields
Pool Play
9:00am - 1:00pm
Pool Play (2 Games)
BMAC Fields
Tailgate Zone
9:00am - 6:00pm
Tailgate / Party Zone
Hang Out, Win Prizes, Have Fun
Tailgate Zone
Merchandise Zone
9:00am - 6:00pm
Merch / Swag Booth
Merch Tent
Tournament Play
1:00pm - 6:00pm
Tourney Bracket (3-Elim)
All Teams Survive Til Sunday
BMAC Fields
Local Shenanigans
7:00pm - 9:00pm
Cornhole Tournament
Tailgate Zone
Tourney Play
7:00pm - 9:00pm
Home Run Derby
BMAC Fields
Local Shenanigans
7:00pm - 9:00pm
Misc Shenanigans
BMAC Fields

Sunday, May 28
Championship Sunday

Tournament Play
9:00am - 1:00pm
Tourney Bracket
BMAC Fields
Tailgate Zone
9:00am - 4:00pm
Tailgate / Party Zone
Hang Out, Win Prizes, Have Fun
Tailgate Zone
Merchandise Zone
9:00am - 4:00pm
Merch / Swag Booth
Merch Tent
Finals
12:45pm
Finals (Seniors)
BMAC Fields
Finals
3:15pm
Finals (Mixed)
BMAC Fields

Games / Bracket Schedule

Schedule is officially hosted on the USSSA tournament tracker. Please click the link below to access the most up-to-date game schedule information.

Pool play starts Saturday morning and continues through the afternoon Sunday. Our double elimination bracket begins Saturday afternoon, and will finish Sunday afternoon. Every team will make it to Sunday, so please plan on playing Sunday! In case of inclement weather, Monday may be used to finish the event if necessary.

Link to Schedule

All Activities at BMAC Fields

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

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.

Tailgate Zone
Got some down time between your games? Visit the Tailgate Zone to participate in cornhole, pickleball, yard pong, plus several social media contests and ice breaker games.

Play for fun, or win cash and prizes!

73 108
PEAK MEMORY: 12.16 MiB
MEMORY USAGE AFTER: 10.31 MiB

Debug Information


Request Variables

var = ultra

varb = st-louis

varc = summer-2023-1

vard = results

vara =

vare =

view_var = ultra

view_varb = st-louis

view_varc = summer-2023-1

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: de16bf2f0bf2b961434e4a48a6372ef9

Login Type:

BASE:: ultra

FULL LINK:: ultra/st-louis/summer-2023-1/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 = de16bf2f0bf2b961434e4a48a6372ef9
fullstate =


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/st-louis/summer-2023-1/results/
QUERY_STRING = var=ultra&varb=st-louis&varc=summer-2023-1&vard=results
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=st-louis&varc=summer-2023-1&vard=results
REDIRECT_URL = /ultra/st-louis/summer-2023-1/results/
REMOTE_PORT = 40896
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.135.212.183
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/ultra/st-louis/summer-2023-1/results
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/ultra/st-louis/summer-2023-1/results/
SCRIPT_URL = /ultra/st-louis/summer-2023-1/results/
UNIQUE_ID = ZzP66-@0uvM1mJE8m5x-ogAAAQY
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/st-louis/summer-2023-1/results/
REDIRECT_SCRIPT_URL = /ultra/st-louis/summer-2023-1/results/
REDIRECT_UNIQUE_ID = ZzP66-@0uvM1mJE8m5x-ogAAAQY
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1731459819.1285
REQUEST_TIME = 1731459819


SQL Queries


Total Queries: 98
Total Execution Time: 48.9716ms
Avg Execution Time:0.49971020408163ms

QUERY(1.6289ms) - 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-13', '01:03:39', 'GET', '/ultra/st-louis/summer-2023-1/results/', '3.135.212.183', 'https://netstuffersdev1.com/ultra/st-louis/summer-2023-1/results' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhem16dXNwenJ5Sk8zKzJnamYwMU1lQ2kwbDZhLzU5YWJlY3hXQ3RWSEZ6aFR3M3k0UGV2QXlONVBQaDNXbEVlR2R1V3E0L0VUZjZad3drV1JsT2lJUmg=','0','','1731459819') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1459ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/st-louis/summer-2023-1/results/'

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

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

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

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

QUERY(0.1509ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.1478ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.576ms) - 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`,`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` = 'st-louis' LIMIT 0,1

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

QUERY(0.5369ms) - 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`,`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` = '73' and `league_seasons`.`url` = 'summer-2023-1' ORDER BY `league_dates`.`start_date` ASC

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

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

QUERY(0.16ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit`,`total_pay_required` FROM `league_custom_content` WHERE `league_id`=73 && `season_id`=108 LIMIT 0,1

QUERY(0.18ms) - 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`=73 && `season_id`=108 LIMIT 0,1

QUERY(0.2232ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=73 && `season_id`=108 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

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

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

QUERY(0.124ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1359ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='st-louis'

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

QUERY(0.1099ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1061ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1121ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.1471ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='73' && `season_id`='108' LIMIT 0,1

QUERY(0.1309ms) - SELECT `league_id` FROM `league_seasons` WHERE `season_id`=178 LIMIT 0,1

QUERY(0.55ms) - 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`,`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`.`league_id` = '104' LIMIT 0,1

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

QUERY(0.5121ms) - 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`,`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` = '104' and `league_seasons`.`season_id` = '178' 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.113ms) - SELECT SQL_CACHE `zone_name` FROM `zone` WHERE `zone_id`=1026 LIMIT 0,1

QUERY(0.1471ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit`,`total_pay_required` FROM `league_custom_content` WHERE `league_id`=104 && `season_id`=178 LIMIT 0,1

QUERY(0.1659ms) - 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`=104 && `season_id`=178 LIMIT 0,1

QUERY(0.2232ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=104 && `season_id`=178 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

QUERY(0.1221ms) - SELECT * FROM `league_notices` WHERE `league_id`=73 && `season_id`=108

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

QUERY(0.1001ms) - SELECT SQL_CACHE * FROM draft_config

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

QUERY(0.1018ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1121ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.093ms) - SELECT SQL_CACHE * FROM games_config

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

QUERY(0.2291ms) - SELECT `standing_id` FROM `standings_composite` WHERE `season_id`=108

QUERY(0.1471ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='73' && `season_id`='108'

QUERY(9.434ms) - 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`='73' && `league_teams`.`season_id`='108') WHERE `teams`.`approved` = '1' and `teams`.`active` = '1' and `teams`.`personal` = '0' and `standings`.`league_id` = '73' and `standings`.`season_id` = '108' 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.1369ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='73' && `season_id`='108'

QUERY(9.2931ms) - 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`='73' && `league_teams`.`season_id`='108') WHERE `teams`.`approved` = '1' and `teams`.`active` = '1' and `teams`.`personal` = '0' and `standings`.`league_id` = '73' and `standings`.`season_id` = '108' 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.211ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=73 && `season_id`=108

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

QUERY(0.1168ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.2649ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='73' && `season_id`='108' && `ranking`='1'

QUERY(2.97ms) - 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`='108' && `finish_rank`=1 ORDER BY `date` DESC

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

QUERY(0.272ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='73' && `season_id`='108' && `ranking`='2'

QUERY(2.1391ms) - 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`='108' && `finish_rank`=2 ORDER BY `date` DESC

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

QUERY(0.1981ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='73' && `season_id`='108' && `ranking`='3'

QUERY(1.2898ms) - 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`='108' && `finish_rank`=3 ORDER BY `date` DESC

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

QUERY(0.1769ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='73' && `season_id`='108' && `ranking`='4'

QUERY(1.039ms) - 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`='108' && `finish_rank`=4 ORDER BY `date` DESC

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

QUERY(0.1519ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='73' && `season_id`='108' && `ranking`='5'

QUERY(0.632ms) - 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`='108' && `finish_rank`=5 ORDER BY `date` DESC

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

QUERY(0.1819ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='73' && `season_id`='108' && `ranking`='6'

QUERY(0.5219ms) - 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`='108' && `finish_rank`=6 ORDER BY `date` DESC

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

QUERY(0.5679ms) - SELECT * FROM `league_schedule_options` WHERE `season_id`=108

QUERY(0.1929ms) - SELECT `division_id`,`name` FROM `league_divisions` WHERE `season_id`=108

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

QUERY(0.1199ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.118ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.149ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='73' && `season_id`='108'

QUERY(1.8508ms) - 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`.`overall_wins`+`s`.`overall_losses`+`s`.`overall_ties`) as `gamesplayed` FROM `standings_composite` AS `s` WHERE `s`.`team_id`=`standings_composite`.`team_id`) AS `gamesplayed`,`standings_composite`.*,`users`.`user_url`,`users`.`username`,`photo`.`thumb_url`,`league_groups_teams`.`group_id` FROM `teams` INNER JOIN `standings_composite` ON (`teams`.`team_id` = `standings_composite`.`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`='73' && `league_teams`.`season_id`='108') WHERE `standings_composite`.`division_id` = '12' and `teams`.`approved` = '1' and `teams`.`active` = '1' and `teams`.`personal` = '0' and `standings_composite`.`league_id` = '73' and `standings_composite`.`season_id` = '108' ORDER BY `standings_composite`.`finish_rank` asc,`standings_composite`.`overall_win_pct` desc,`standings_composite`.`overall_pts_diff` desc

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

QUERY(0.0942ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.118ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.123ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='73' && `season_id`='108'

QUERY(1.405ms) - 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`.`overall_wins`+`s`.`overall_losses`+`s`.`overall_ties`) as `gamesplayed` FROM `standings_composite` AS `s` WHERE `s`.`team_id`=`standings_composite`.`team_id`) AS `gamesplayed`,`standings_composite`.*,`users`.`user_url`,`users`.`username`,`photo`.`thumb_url`,`league_groups_teams`.`group_id` FROM `teams` INNER JOIN `standings_composite` ON (`teams`.`team_id` = `standings_composite`.`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`='73' && `league_teams`.`season_id`='108') WHERE `standings_composite`.`division_id` = '13' and `teams`.`approved` = '1' and `teams`.`active` = '1' and `teams`.`personal` = '0' and `standings_composite`.`league_id` = '73' and `standings_composite`.`season_id` = '108' ORDER BY `standings_composite`.`finish_rank` asc,`standings_composite`.`overall_win_pct` desc,`standings_composite`.`overall_pts_diff` desc

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