The Next Event

Ready for the next event in this series?

2024 Miken/Easton/Worth Series - Cincinnati 2024
This event has completed. This information has been preserved for archival purposes.
Ultra Draft

River City Ultra Draft
Powered by Easton/Miken/Worth

Event: June 2023   |   Sport: Softball

MixedSocialDraft
Event Director
Sports Drafts LLC
Contact / Learn More
Venue
River City Sports Complex West
Harrison, OH
This event has completed. This information has been preserved for archival purposes.

Standings

Tap and drag left and right to view full table
PlaceTeamPoolBracketOverallWin %Pts ForPts AgainstFinal Pts DiffCoach
1
Cardiac Cats
8-0 0-08-014664+82Paul coyne
2
Boomstix
6-4 0-06-4148133+15NotMattRyan
3
Pete's Best Bet
5-4 0-05-492122--30Brekblanken
4
Trouble Makers
7-3 0-07-3183144+39selfreliant
5
Let The Stars Rise
6-3 0-06-314595+50WLambert10
6
Mystery Squad
5-2 0-05-210677+29Tjgerig
7
Island of Misfit Toys
3-2 0-03-25744+13kimtex1022
8
The Skyline's The Limit
3-3 0-03-39676+20ahk8907
9
Special Delivery
3-3 0-03-37560+15Boss_Lady
10
Miken Magic
3-3 0-03-310194+7Bearcatfan44
11
Grand Theft Votto
3-3 0-03-38782+5rhossler
12
Who Loves You Baby
4-4 0-04-4135134+1Bigcuz
13
Nitro Inferno
3-3 0-03-37379--6Troy1977
14
Shamrock Sluggers
4-4 0-04-486107--21UncleDuck11
15
Night Fury
2-4 0-02-45691--35afullenkamp7
16
Easton Queen City
1-4 0-01-44370--27MattGard95
17
Star Spangled Bangers
1-4 0-01-45386--33fisherfarms2015
18
Shell Shocked
1-5 0-01-55278--26Flamingo
19
MIKEN- No Walks Allowed (NWA)
0-5 0-00-55491--37EddieIce69
20
The River Hitters
0-5 0-00-543104--61dlfamily69

Event Schedule

Friday, June 23
Social Meet & Greet & Ball Game

Meet & Greet
5:00pm - 7:00pm
Meet Up at The Banks
RSVP and Info!
The Banks
Braves vs Reds
6:40pm - 9:00pm
Braves vs. Reds
Join the Ultra Draft Section!
Great American Ball Park

Saturday, June 24
Pool Play / Bracket Play / Side Events

Uniform Pickup
8:00am - 2:00pm
Uniform Pick Up / Check-in
River City West
Pool Play
9:00am - TBD
Pool Play (2 Games)
River City West
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
Time TBD
Tourney Bracket (2-Elim)
River City West
Tourney Play
Time TBD
Home Run Derby
River City West
Local Shenanigans
Time TBD
Cornhole Tournament
Tailgate Zone
Local Shenanigans
7:30pm - 11:00pm
Meet & Greet Social Event
DJs, Drinks, and Shenanigans
River City West

Sunday, June 25
Championship Sunday

Tournament Play
9:00am - Finish
Tourney Bracket
River City West
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
Time TBD
Finals (Mixed)
River City West

Games / Bracket Schedule

All games will be played to a full 7 innings. In case of inclement weather, games may be shortened and schedule adjusted to accommodate.

Link to Schedule

All Activities at River City West

Daily $5 Gate Fee
Personal Coolers Not Allowed

Uniform / Bat Pickup
Teams will pick up their equipment from the main registration table which will be setup at River City West in Harrison.

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 / Cornhole Tournament
Visit the Tailgate Zone to sign up for Home Run Derby, Cornhole Tourney, or both! Details and rules available on site.

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!

70 106

Debug Information


Request Variables

var = ultra

varb = river-city

varc = june-2023

vard = schedule

view_var = ultra

view_varb = river-city

view_varc = june-2023

view_vard = schedule

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: 467c56472dd04aedf3761345b0c35585

Login Type:

BASE:: ultra

FULL LINK:: ultra/river-city/june-2023/schedule

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 = 467c56472dd04aedf3761345b0c35585


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/river-city/june-2023/schedule/
QUERY_STRING = var=ultra&varb=river-city&varc=june-2023&vard=schedule
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=river-city&varc=june-2023&vard=schedule
REDIRECT_URL = /ultra/river-city/june-2023/schedule/
REMOTE_PORT = 47793
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.223.106.100
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/river-city/june-2023/schedule/
SCRIPT_URL = /ultra/river-city/june-2023/schedule/
UNIQUE_ID = ZjXP5Jdp56LUYOcqucQNLgAAAQc
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/river-city/june-2023/schedule/
REDIRECT_SCRIPT_URL = /ultra/river-city/june-2023/schedule/
REDIRECT_UNIQUE_ID = ZjXP5Jdp56LUYOcqucQNLgAAAQc
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1714802660.9713
REQUEST_TIME = 1714802660


SQL Queries


Total Queries: 112
Total Execution Time: 65.5786ms
Avg Execution Time:0.58552321428571ms

QUERY(6.561ms) - 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-04', '06:04:20', 'GET', '/ultra/river-city/june-2023/schedule/', '18.223.106.100', '' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'OXoxRVZMVjQ4WTB4djhqV3ZoeDVtaWk0bVpKWXNoVFlDeGpkTXRpRUsxWnNPMHBkSG96NzlCYnk2bHhvMkwyMjZHL0lydEkzUEpRa2VZTWpsL1hlOHdwOUNTOUZsZVlzY2VRTDlURzdnZ0Q3SXp4bkVUS0xsMDFPM08xM1FZdjRQWUlFSm1IMTNJall5cEF4VWZqRzBQZHVhemZpaG9SbENMSmpmdlFYUS9XZGNiVkYzWFp1YWNZL1JOTVpjTnQz', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheStMMm93d1BoMUlLeFlWdThQZWR2V0l4SkFzak5Jb2hkQy9hZ0thWUdmV3Q1OGdtMVRiZG9lb2ZqTGpyTFhxdEdaM0p4Nm1nS29yODVBcEJJV0lpNDQ=','0','','1714802660') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.2079ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/river-city/june-2023/schedule/'

QUERY(0.2191ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='ultra/river-city/june-2023/schedule' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.1981ms) - SELECT * FROM userprofiles_config

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

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

QUERY(0.2141ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5929ms) - 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` = 'river-city' LIMIT 0,1

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

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

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

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

QUERY(0.2239ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit` FROM `league_custom_content` WHERE `league_id`=70 && `season_id`=106 LIMIT 0,1

QUERY(0.2251ms) - 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`=70 && `season_id`=106 LIMIT 0,1

QUERY(0.294ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=70 && `season_id`=106 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

QUERY(0.3209ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='70' && (`season_id`='106' || `season_id`=0)

QUERY(0.3471ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=70 && `season_id`=0) || `season_id`='106'

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

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

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

QUERY(0.2511ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons_rules` WHERE `league_id`='70' || `season_id`='106' ORDER BY `season_id` DESC

QUERY(0.2229ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='70' && `season_id`='106'

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

QUERY(0.2501ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons` WHERE `league_id`='70'

QUERY(0.2391ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=70&&`season_id`=106 LIMIT 0,1

QUERY(1.4601ms) - SELECT `game_id` FROM `games` WHERE `league_id`=70&&`season_id`=106&&`playoff`=1 LIMIT 0,1

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

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

QUERY(1.1649ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='70' && `season_id`='106'

QUERY(0.2289ms) - 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`='70' && `league_seasons`.`season_id`='106'

QUERY(0.2899ms) - SELECT `hotelinfo` FROM `league_custom_content` WHERE `league_id`=70 && `season_id`=106 LIMIT 0,1

QUERY(0.1938ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=70 && `season_id`=106

QUERY(4.873ms) - 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 ('70','106','6','0','0','230','20','16','1','1','0','0','0','1','4','1','0','0','0','0',NOW(),'0') ON DUPLICATE KEY UPDATE `articles`='6',`participants`='0',`conferences`='0',`players`='230',`coaches`='20',`subs`='16',`rules`='1',`teams`='1',`games`='0',`groups`='0',`divisions`='0',`seasons`='1',`sponsors`='4',`products`='1',`prizes`='0',`hotels`='0',`is_full`='0',`reg_is_open`='0',`updated`=NOW(),`show_playoff_menu`='0'

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

QUERY(0.2968ms) - 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.2708ms) - SELECT count(`league_id`) FROM `league_players` WHERE `player_id`=''

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

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

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

QUERY(0.16ms) - 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`,`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` = 'river-city' LIMIT 0,1

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

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

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

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

QUERY(0.1669ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit` FROM `league_custom_content` WHERE `league_id`=70 && `season_id`=106 LIMIT 0,1

QUERY(0.2179ms) - 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`=70 && `season_id`=106 LIMIT 0,1

QUERY(0.2739ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=70 && `season_id`=106 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

QUERY(0.2ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='river-city'

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

QUERY(0.1738ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.195ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

QUERY(0.4439ms) - 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` = '104' and `league_seasons`.`season_id` = '182' ORDER BY `league_dates`.`start_date` ASC

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

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

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

QUERY(0.2811ms) - 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`=182 LIMIT 0,1

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

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

QUERY(0.288ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='104' && (`season_id`='182' || `season_id`=0)

QUERY(0.236ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=104 && `season_id`=0) || `season_id`='182'

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

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

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

QUERY(0.2971ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons_rules` WHERE `league_id`='104' || `season_id`='182' ORDER BY `season_id` DESC

QUERY(0.2129ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='104' && `season_id`='182'

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

QUERY(0.2499ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons` WHERE `league_id`='104'

QUERY(0.221ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=104&&`season_id`=182 LIMIT 0,1

QUERY(1.147ms) - SELECT `game_id` FROM `games` WHERE `league_id`=104&&`season_id`=182&&`playoff`=1 LIMIT 0,1

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

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

QUERY(1.092ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='104' && `season_id`='182'

QUERY(0.2298ms) - 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`='104' && `league_seasons`.`season_id`='182'

QUERY(0.19ms) - SELECT `hotelinfo` FROM `league_custom_content` WHERE `league_id`=104 && `season_id`=182 LIMIT 0,1

QUERY(0.176ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=104 && `season_id`=182

QUERY(5.5709ms) - 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 ('104','182','0','0','0','58','0','0','0','0','0','0','0','17','0','0','1','1','0','0',NOW(),'0') ON DUPLICATE KEY UPDATE `articles`='0',`participants`='0',`conferences`='0',`players`='58',`coaches`='0',`subs`='0',`rules`='0',`teams`='0',`games`='0',`groups`='0',`divisions`='0',`seasons`='17',`sponsors`='0',`products`='0',`prizes`='1',`hotels`='1',`is_full`='0',`reg_is_open`='0',`updated`=NOW(),`show_playoff_menu`='0'

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

QUERY(0.2201ms) - SELECT * FROM `league_notices` WHERE `league_id`=70 && `season_id`=106

QUERY(0.226ms) - SELECT SQL_CACHE `img_url`,`name`,`moreinfo` FROM `league_sponsors` LEFT JOIN `photo` ON `photo_id`=`logo_id` WHERE `league_id`=70 && `season_id`=106

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

QUERY(0.1481ms) - SELECT SQL_CACHE * FROM draft_config

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

QUERY(0.145ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1822ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.1981ms) - SELECT `standing_id` FROM `standings_composite` WHERE `season_id`=106

QUERY(0.174ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='70' && `season_id`='106'

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

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

QUERY(0.3719ms) - SELECT * FROM `league_schedule_options` WHERE `season_id`=106

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

QUERY(0.1419ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.154ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.1719ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='70' && `season_id`='106'

QUERY(2.564ms) - 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`='70' && `league_teams`.`season_id`='106') WHERE `teams`.`approved` = '1' and `teams`.`active` = '1' and `teams`.`personal` = '0' and `standings_composite`.`league_id` = '70' and `standings_composite`.`season_id` = '106' ORDER BY `standings_composite`.`finish_rank` asc,`standings_composite`.`overall_win_pct` desc,`standings_composite`.`overall_pts_diff` desc

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