This event has completed. This information has been preserved for archival purposes.
Ultra Draft

Myrtle Beach Ultra Draft
Powered by Easton/Miken/Worth

Event: Summer 2023   |   Sport: Softball

MixedSocialDraft
Event Director
Sports Drafts LLC
Contact / Learn More
Venue
Grand Park Market Common
Myrtle Beach, SC
This event has completed. This information has been preserved for archival purposes.
Join as Alternate

Results

Event Schedule

Friday, Oct 6
Social Meet & Greet

Meet & Greet
7:00pm - 11:00pm
Meet Up at Park
Riptydz Oceanfront Grill
Meet & Greet
7:30pm - 8:00pm
Coaches Meeting
Riptydz Oceanfront Grill

Saturday, Sept 30
Pool Play / Bracket Play / Side Events

Uniform Pickup
9:00am - 2:00pm
Uniform Pick Up / Check-in
Grand Park
Pool Play
10:00am - 12:30pm
Pool Play (1 Game)
Grand Park
Pool Play
12:30pm - 1:40pm
Showcase Game
The Bearden Bowl
Grand Park
Tournament Play
2:00pm - 9:00pm
Tourney Bracket
Grand Park
Tourney Play
Time TBD
Home Run Derby
Field TBD

Sunday, Oct 1
Championship Sunday

Tournament Play
8:00am - 4:00pm
Tourney Bracket
Grand Park

Competition Format

1 Pool play seeding game followed by 3-game guarantee bracket.

All Activities at Grand Park

$6 Daily Gate Fee / $14 Weekend Pass

Free Batting Cages. No Coolers.

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 on Friday night! Details and rules available on site.

Games Schedule

Full Live Schedule Found on One Nation Website

One Nation Schedule

Schedule

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



Bracket Play Starts Around 2:30pm Saturday. All Teams Survive to Sunday!

One Nation 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 !!!

74 109

Debug Information


Request Variables

var = ultra

varb = myrtle-beach

varc = summer-2023-2

vard = results

view_var = ultra

view_varb = myrtle-beach

view_varc = summer-2023-2

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: 4cd11ac283d3c96e38c17ed1129d8d80

Login Type:

BASE:: ultra

FULL LINK:: ultra/myrtle-beach/summer-2023-2/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 = 4cd11ac283d3c96e38c17ed1129d8d80


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/myrtle-beach/summer-2023-2/results/
QUERY_STRING = var=ultra&varb=myrtle-beach&varc=summer-2023-2&vard=results
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=myrtle-beach&varc=summer-2023-2&vard=results
REDIRECT_URL = /ultra/myrtle-beach/summer-2023-2/results/
REMOTE_PORT = 27806
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.138.114.38
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/myrtle-beach/summer-2023-2/results/
SCRIPT_URL = /ultra/myrtle-beach/summer-2023-2/results/
UNIQUE_ID = Zji4XmoPt1-TD0kRaLvAVAAAAA4
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/myrtle-beach/summer-2023-2/results/
REDIRECT_SCRIPT_URL = /ultra/myrtle-beach/summer-2023-2/results/
REDIRECT_UNIQUE_ID = Zji4XmoPt1-TD0kRaLvAVAAAAA4
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1714993246.1168
REQUEST_TIME = 1714993246


SQL Queries


Total Queries: 97
Total Execution Time: 94.4738ms
Avg Execution Time:0.97395670103093ms

QUERY(26.017ms) - 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-06', '11:00:46', 'GET', '/ultra/myrtle-beach/summer-2023-2/results/', '3.138.114.38', '' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'OXoxRVZMVjQ4WTB4djhqV3ZoeDVtaWk0bVpKWXNoVFlDeGpkTXRpRUsxWnNPMHBkSG96NzlCYnk2bHhvMkwyMkVQRWJXRUdnYVVweU9XaGQ2R3lmYU44bzJ2NmI0WEVXSC9GNnJ0NzBxUWRWMDdXRVRaWi9NZjdvUm9YOEVCOGZlblVFQkdVenhjRlZsN3E3Nkl5eW5uSkYxRkNFVVJLeVRuSHh2RmFGa3Z0MVBDcFRsSURzbzZpY1FyUDJmdDN3ZDhhaWVIY3ZIUUFGVWsxaUo4RjFjZz09', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhd3N2MEpJVVJEakxldDlaZ25KWGljOE9ZNWlML0xkdGFZelB6cmVpS3BZeGV4ZU1obWFHcjFXMkQ0NGQrcFZjUy9SSTJkb1BiYU9WOXBuN1FBem43UDc=','0','','1714993246') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.2398ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/myrtle-beach/summer-2023-2/results/'

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

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

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

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

QUERY(0.1981ms) - SELECT * FROM userprofiles_config

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

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

QUERY(0.1991ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.531ms) - 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` = 'myrtle-beach' LIMIT 0,1

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

QUERY(0.5021ms) - 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` = '74' and `league_seasons`.`url` = 'summer-2023-2' ORDER BY `league_dates`.`start_date` ASC

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

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

QUERY(0.2661ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit` FROM `league_custom_content` WHERE `league_id`=74 && `season_id`=109 LIMIT 0,1

QUERY(0.3099ms) - 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`=74 && `season_id`=109 LIMIT 0,1

QUERY(0.3691ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=74 && `season_id`=109 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

QUERY(0.344ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='74' && (`season_id`='109' || `season_id`=0)

QUERY(0.304ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=74 && `season_id`=0) || `season_id`='109'

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

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

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

QUERY(0.2811ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons_rules` WHERE `league_id`='74' || `season_id`='109' ORDER BY `season_id` DESC

QUERY(0.3278ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='74' && `season_id`='109'

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

QUERY(0.567ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons` WHERE `league_id`='74'

QUERY(0.205ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=74&&`season_id`=109 LIMIT 0,1

QUERY(1.1899ms) - SELECT `game_id` FROM `games` WHERE `league_id`=74&&`season_id`=109&&`playoff`=1 LIMIT 0,1

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

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

QUERY(2.255ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='74' && `season_id`='109'

QUERY(0.246ms) - 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`='74' && `league_seasons`.`season_id`='109'

QUERY(0.1729ms) - SELECT `hotelinfo` FROM `league_custom_content` WHERE `league_id`=74 && `season_id`=109 LIMIT 0,1

QUERY(0.1612ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=74 && `season_id`=109

QUERY(26.685ms) - 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 ('74','109','5','0','0','171','14','5','1','1','7','1','0','1','4','3','0','0','0','0',NOW(),'0') ON DUPLICATE KEY UPDATE `articles`='5',`participants`='0',`conferences`='0',`players`='171',`coaches`='14',`subs`='5',`rules`='1',`teams`='1',`games`='7',`groups`='1',`divisions`='0',`seasons`='1',`sponsors`='4',`products`='3',`prizes`='0',`hotels`='0',`is_full`='0',`reg_is_open`='0',`updated`=NOW(),`show_playoff_menu`='0'

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

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

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

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

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

QUERY(0.176ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5429ms) - 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` = 'myrtle-beach' LIMIT 0,1

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

QUERY(0.396ms) - 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` = '74' and `league_seasons`.`url` = 'summer-2023-2' ORDER BY `league_dates`.`start_date` ASC

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

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

QUERY(0.2711ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit` FROM `league_custom_content` WHERE `league_id`=74 && `season_id`=109 LIMIT 0,1

QUERY(0.2961ms) - 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`=74 && `season_id`=109 LIMIT 0,1

QUERY(0.2139ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=74 && `season_id`=109 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

QUERY(0.1838ms) - SELECT SQL_CACHE `enabled` FROM `league_merch` WHERE `season_id`=109 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.2201ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='myrtle-beach'

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

QUERY(0.1581ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.159ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.21ms) - SELECT * FROM `league_notices` WHERE `league_id`=74 && `season_id`=109

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

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

QUERY(0.139ms) - SELECT SQL_CACHE * FROM draft_config

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

QUERY(0.14ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.144ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.2079ms) - SELECT `standing_id` FROM `standings_composite` WHERE `season_id`=109

QUERY(0.1731ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='74' && `season_id`='109'

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

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

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

QUERY(0.1709ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.2458ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='74' && `season_id`='109' && `ranking`='1'

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

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

QUERY(0.2151ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='74' && `season_id`='109' && `ranking`='2'

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

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

QUERY(0.1919ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='74' && `season_id`='109' && `ranking`='3'

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

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

QUERY(0.2632ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='74' && `season_id`='109' && `ranking`='4'

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

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

QUERY(0.2401ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='74' && `season_id`='109' && `ranking`='5'

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

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

QUERY(0.2542ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='74' && `season_id`='109' && `ranking`='6'

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

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

QUERY(0.3278ms) - SELECT * FROM `league_schedule_options` WHERE `season_id`=109

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