The Next Event

Ready for the next event in this series?

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

Valdosta Ultra Draft
Powered by Easton/Miken/Worth

Event: Christmas Bash
Sport: Softball
CoedSocialDraft
Event Director
Sports Drafts LLC
Contact / Learn More
Venue
Freedom Park
Valdosta, GA
Dates
Dec 16, 2023 - Dec 17, 2023
This event has completed. This information has been preserved for archival purposes.

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

Event Schedule

Location

Location: Freedom Park – 3795 Guest Rd, Valdosta, GA 31605
(Location for all activities)

Friday, December 15

BATTING PRACTICE: Fields available all day long on Friday for bp so come on down!

HITTING CLINIC AND SKILLS CHALLENGE: 3pm on Friday with Miken/Worth/Easton Pros Bob O’Brien, Veronica Shaw and others. Hitting for average vs power. Pre-at bat routine. Utilize the batter’s box to your advantage. Bat control tips and techniques to get that big base hit when you need to. Also learn how to add a little extra distance to your swing when they are playing you too short, or when you are trying to hit a home run.

MEET N' GREET: 🤝 This will be held from 4pm-6pm. Meet some new people, pick up your player packages and enjoy free pizza and drinks!

HR DERBY: 🚀 This will be held at 5pm. $20 Entry Fee, and everyone gets a pair of sunglasses and an extra Rawlings beanie with paid entry. *Must be an Ultra Draft participant to take part in the Ultra Draft HR Derby. Mixed men’s and women’s, and senior men’s and women’s. Winners in all four divisions will get a new bat! Men’s and Women’s Mixed can use 220’s or 240’s that pass compression. Senior Mixed can use 220’s, 240’s or senior bats.

💰You can pay that day via cash, Zelle, Paypal, Venmo or CashApp with Jason Kendrick.

Derby Rules

  • *Men hit from the plate and ladies hit from 2nd base
  • 1st Round - 8 pitches and 5 swings (Top 4 advance)
  • 2nd Round - 12 pitches and 8 swings (Top 2 advance)
  • Final Round - 15 pitches and 10 swings

*Hit me to register or with questions on FB Messenger or text @602.391.7918 👉🏼 Thank you.
-Mickey Zarr

Saturday / Sunday

Player Packages Available at Freedom Park starting at 8:30am

Games will start Saturday morning at 10am

In case of weather on the weekend (mostly looks like highest chance of rain on late Saturday night after games would be over and early Sunday morning from midnight till 8am)... we may play another game in both brackets to get to only one winner going into Sunday.

  • All teams in the senior division are scheduled to play 4 games minimum on Saturday…3 pool play games and 1 bracket game.
  • All teams in the younger divisions are scheduled to play 5 games minimum on Saturday…4 pool play games and 1 bracket game.

All teams in both divisions are scheduled to play on Sunday morning. So plan to get your money’s worth. No team is out of the tournament on Saturday night.

Full Schedule On Tourney Machine

Tourney Machine

Click for Game Schedule

86 133
PEAK MEMORY: 12.17 MiB
MEMORY USAGE AFTER: 10.28 MiB

Debug Information


Request Variables

var = ultra

varb = valdosta

varc = christmas

vard = results

vara =

vare =

view_var = ultra

view_varb = valdosta

view_varc = christmas

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

Login Type:

BASE:: ultra

FULL LINK:: ultra/valdosta/christmas/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 = bf33fee05f713676f4c19af272780b01
fullstate =


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/valdosta/christmas/results/
QUERY_STRING = var=ultra&varb=valdosta&varc=christmas&vard=results
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=valdosta&varc=christmas&vard=results
REDIRECT_URL = /ultra/valdosta/christmas/results/
REMOTE_PORT = 33246
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.139.104.16
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/valdosta/christmas/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/valdosta/christmas/results/
SCRIPT_URL = /ultra/valdosta/christmas/results/
UNIQUE_ID = ZzQEbZaSGK0lUDVWk9AbVwAAAMI
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/valdosta/christmas/results/
REDIRECT_SCRIPT_URL = /ultra/valdosta/christmas/results/
REDIRECT_UNIQUE_ID = ZzQEbZaSGK0lUDVWk9AbVwAAAMI
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1731462253.7947
REQUEST_TIME = 1731462253


SQL Queries


Total Queries: 107
Total Execution Time: 52.8376ms
Avg Execution Time:0.49380934579439ms

QUERY(1.6589ms) - 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:44:13', 'GET', '/ultra/valdosta/christmas/results/', '3.139.104.16', 'https://netstuffersdev1.com/ultra/valdosta/christmas/results' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhei8wYktUWTV0dERhSlFOUlkxcERHU2k2djBOaHhjYkhDRW1EMFYwbGJQUGlabUhic243VkxWdjZwRTZqOVJPMCtZTVlxdVBSak9JOS9QdEdKbmRzTVI=','0','','1731462253') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1781ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/valdosta/christmas/results/'

QUERY(0.2689ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='ultra/valdosta/christmas/results' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.2289ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.144ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5939ms) - 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` = 'valdosta' LIMIT 0,1

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.5059ms) - 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` = '86' and `league_seasons`.`url` = 'christmas' ORDER BY `league_dates`.`start_date` ASC

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

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

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

QUERY(0.1969ms) - 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`=86 && `season_id`=133 LIMIT 0,1

QUERY(0.252ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=86 && `season_id`=133 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

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

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

QUERY(0.2072ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.181ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='valdosta'

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

QUERY(0.145ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.15ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1671ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.2019ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='86' && `season_id`='133' LIMIT 0,1

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

QUERY(0.6571ms) - 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.2189ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=1

QUERY(0.55ms) - 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` = '187' ORDER BY `league_dates`.`start_date` ASC

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

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

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

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

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

QUERY(0.221ms) - SELECT SQL_CACHE * FROM `league_schedule_options` WHERE `league_id`='104' && `season_id`='187' LIMIT 0,1

QUERY(0.2019ms) - SELECT SQL_CACHE count(`company_id`) FROM `league_company_links` WHERE `league_id`='104' && (`season_id`='187' || `season_id`=0)

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

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

QUERY(0.7989ms) - 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`='187' &&`league_levels`.`score`>2 && `deleted`=0 && `alternate`=0

QUERY(0.4849ms) - 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`='187' &&`league_players`.`access`=4 && `deleted`=0 && `alternate`=0

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

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

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

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

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

QUERY(1.322ms) - SELECT SQL_CACHE count(`season_id`) FROM `triumphs_awarded` WHERE `league_id`='104'

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

QUERY(0.231ms) - SELECT SQL_CACHE `division_id` FROM `league_divisions` WHERE `league_id`=104&&`season_id`=187 LIMIT 0,1

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

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

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

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

QUERY(0.2439ms) - 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`='187'

QUERY(0.1509ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=104 && `season_id`=187 LIMIT 0,1

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

QUERY(1.5259ms) - INSERT INTO `league_cache` (`league_id`,`season_id`,`articles`,`participants`,`conferences`,`players`,`coaches`,`subs`,`rules`,`teams`,`games`,`groups`,`divisions`,`seasons`,`sponsors`,`products`,`prizes`,`triumphs`,`hotels`,`is_full`,`companies`,`reg_is_open`,`updated`,`show_playoff_menu`) VALUES ('104','187',0,0,0,'97',0,'4','6',0,0,0,'1','17',0,0,'1','274','1',0,0,0,NOW(),0) ON DUPLICATE KEY UPDATE `league_id`='104',`season_id`='187',`articles`=0,`participants`=0,`conferences`=0,`players`='97',`coaches`=0,`subs`='4',`rules`='6',`teams`=0,`games`=0,`groups`=0,`divisions`='1',`seasons`='17',`sponsors`=0,`products`=0,`prizes`='1',`triumphs`='274',`hotels`='1',`is_full`=0,`companies`=0,`reg_is_open`=0,`updated`=NOW(),`show_playoff_menu`=0

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

QUERY(0.1631ms) - SELECT * FROM `league_notices` WHERE `league_id`=86 && `season_id`=133

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

QUERY(0.134ms) - SELECT SQL_CACHE * FROM draft_config

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

QUERY(0.123ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1509ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.1359ms) - SELECT SQL_CACHE * FROM games_config

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

QUERY(0.2859ms) - SELECT `standing_id` FROM `standings_composite` WHERE `season_id`=133

QUERY(0.1872ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='86' && `season_id`='133'

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

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

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

QUERY(0.1681ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.3779ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='86' && `season_id`='133' && `ranking`='1'

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

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

QUERY(0.3331ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='86' && `season_id`='133' && `ranking`='2'

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

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

QUERY(0.2341ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='86' && `season_id`='133' && `ranking`='3'

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

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

QUERY(0.2279ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='86' && `season_id`='133' && `ranking`='4'

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

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

QUERY(0.196ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='86' && `season_id`='133' && `ranking`='5'

QUERY(0.7601ms) - 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`='133' && `finish_rank`=5 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.181ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='86' && `season_id`='133' && `ranking`='6'

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

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

QUERY(0.623ms) - SELECT * FROM `league_schedule_options` WHERE `season_id`=133

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