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

SoCal Ultra Draft
Powered by Easton/Miken/Worth

Event: April 2023
Sport: Softball
CoedSocialDraft
Event Director
Sports Drafts LLC
Contact / Learn More
Venue
Big League Dreams Perris
Perris, CA
Dates
Apr 28, 2023 - Apr 30, 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

Item

Jock Straps & G-Strings

Visit Team Page

Champion of SoCal Ultra Draft - April 2023
04/30/2023

Item

Blowing Middle

Visit Team Page

Runner Up of SoCal Ultra Draft - April 2023
04/30/2023

Item

Above 500

Visit Team Page

Third Place of SoCal Ultra Draft - April 2023
04/30/2023

Item

Quit Your Pitchin

Visit Team Page

Fourth Place of SoCal Ultra Draft - April 2023
04/30/2023

Item

Sandbaggers

Visit Team Page

Doghouse Champion of SoCal Ultra Draft - April 2023
04/30/2023

Item

Nulli Secundus

Visit Team Page

Doghouse Runner Up of SoCal Ultra Draft - April 2023
04/30/2023

Standings

Tap and drag left and right to view full table
PlaceTeamPoolBracketOverallWin %Pts ForPts AgainstFinal Pts DiffCoach
1
Jock Straps & G-Strings
2-0 9-111-1172109+63abrown145
2
Blowing Middle
2-0 4-26-212986+43conradsnell
3
Above 500
1-1 3-24-38692--6Boltfan79
4
Quit Your Pitchin
2-0 3-25-29259+33Beltran5
5
Sandbaggers
1-1 4-35-4112104+8Sergio160919
6
Nulli Secundus
2-0 2-24-29285+7dgaitan36
7
BOHICA
2-0 1-23-27158+13Ha-y-n
8
Dirty Dozen
2-0 1-23-26257+5lizbaldwin86
9
Undrafted Free Agents
1-1 3-24-39481+13LOS
10
Easton California Breeze
1-1 3-24-37669+7MattGard95
11
Ballpark Bullies
0-2 4-24-410182+19izafelix
12
Base Invaders
2-0 0-22-24846+2Miesha17
13
Upper Deckies
1-1 1-22-35860--2staythecourse15
14
Off The Handle
1-1 1-22-34753--6Glendon Yoder
15
Masterbatterz
1-1 1-22-36672--6Damion
16
Stay Golden
0-2 2-22-479790fisherfarms2015
17
That One Team
0-2 2-22-47578--3Venom123
18
Bet on Black
1-1 0-21-34058--18Biggs
19
Stay Classy
1-1 0-21-32771--44navyjaker732
20
Mystery Machine
0-2 1-21-44268--26amarchand1297
21
Worth- Ump Yours
0-2 1-21-43676--40EddieIce69
22
Lets Taco Bout It
0-2 0-20-43762--25rmhobson
23
Pitches Brew
0-2 0-20-42663--37Mike Vegas

Event Schedule

All times shown are pacific standard time

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. Most teams will make it to Sunday, so please plan on playing Sunday!

Link to Schedule

All Activities at Perris Big League Dreams

Uniform / Bat Pickup

Teams will pick up their equipment from the main registration table which will be setup at Big League Dreams in Perris.

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 8pm Friday. They are eligible for Registration and pickup between 7-8pm Friday. Team B does not play until 9, so they do their uniform check-in from 8-9pm.

71 107
PEAK MEMORY: 9.49 MiB
MEMORY USAGE AFTER: 7.62 MiB

Debug Information


Request Variables

var = ultra

varb = socal

varc = april-2023

vard = results

vara =

vare =

view_var = ultra

view_varb = socal

view_varc = april-2023

view_vard = results

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: a70a519ed058ae13ad6facfdc2600176

Login Type:

BASE:: ultra

FULL LINK:: ultra/socal/april-2023/results

Page ID: 57

Page ID:: 57

Page Template:: lj

Template Layout:: default

Headers: : Loading page header code

Active Blocks: Array ( [0] => [1] => [2] => 1 [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => )

Block Types: Array ( [0] => [1] => [2] => Array ( [0] => module ) [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => )

Element ID: Array ( [0] => [1] => [2] => Array ( [0] => 10 ) [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => )

Admin Login Level: :

Footer: : Loading page footer code


Session Variables

securetoken = a70a519ed058ae13ad6facfdc2600176
fullstate =


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/socal/april-2023/results/
QUERY_STRING = var=ultra&varb=socal&varc=april-2023&vard=results
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=socal&varc=april-2023&vard=results
REDIRECT_URL = /ultra/socal/april-2023/results/
REMOTE_PORT = 9449
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.134.163
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/socal/april-2023/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/socal/april-2023/results/
SCRIPT_URL = /ultra/socal/april-2023/results/
UNIQUE_ID = Z2997JNPJJ9hoP1KSOt-sQAAAIY
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/socal/april-2023/results/
REDIRECT_SCRIPT_URL = /ultra/socal/april-2023/results/
REDIRECT_UNIQUE_ID = Z2997JNPJJ9hoP1KSOt-sQAAAIY
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1735359980.7203
REQUEST_TIME = 1735359980


SQL Queries


Total Queries: 83
Total Execution Time: 61.9958ms
Avg Execution Time:0.74693734939759ms

QUERY(1.581ms) - 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-12-28', '04:26:20', 'GET', '/ultra/socal/april-2023/results/', '3.138.134.163', 'https://netstuffersdev1.com/ultra/socal/april-2023/results' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheEVQUVhkRmNEZGdYVk9XVURoU1E3cjB0Q3VoTUgzYzllWERzZlBYS1J6eFZMdVoya054YXdwQnp5TkRKYmdhQ05jK0JlcE9QNXFIbXFWZDFja1FNc28=','0','','1735359980') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.155ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/socal/april-2023/results/'

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

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

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

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

QUERY(0.149ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.1261ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.525ms) - 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`,`photo`.`thumb_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` = 'socal' LIMIT 0,1

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

QUERY(0.5341ms) - SELECT SQL_CACHE `league_seasons`.*,`league_seasons`.`url` AS season_url,`photo`.`img_url`,`photo`.`thumb_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` = '71' and `league_seasons`.`url` = 'april-2023' ORDER BY `league_dates`.`start_date` ASC

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

QUERY(0.1609ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=107

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

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

QUERY(0.1609ms) - 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`=71 && `season_id`=107 LIMIT 0,1

QUERY(0.2191ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=71 && `season_id`=107 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

QUERY(0.1249ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='America/Indianapolis'

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

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

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

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

QUERY(0.1111ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.145ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='socal'

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

QUERY(0.1049ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1061ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.114ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.145ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='71' && `season_id`='107' LIMIT 0,1

QUERY(0.1349ms) - SELECT * FROM `league_notices` WHERE `league_id`=71 && `season_id`=107

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

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

QUERY(0.098ms) - SELECT SQL_CACHE * FROM draft_config

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

QUERY(0.103ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1221ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.0899ms) - SELECT SQL_CACHE * FROM games_config

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

QUERY(0.21ms) - SELECT `standing_id` FROM `standings_composite` WHERE `season_id`=107

QUERY(0.1309ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='71' && `season_id`='107'

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

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

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

QUERY(0.113ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.2842ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='71' && `season_id`='107' && `ranking`='1'

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

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

QUERY(0.2539ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='71' && `season_id`='107' && `ranking`='2'

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

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

QUERY(0.1879ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='71' && `season_id`='107' && `ranking`='3'

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

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

QUERY(0.1919ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='71' && `season_id`='107' && `ranking`='4'

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

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

QUERY(0.1891ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='71' && `season_id`='107' && `ranking`='5'

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

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

QUERY(0.191ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='71' && `season_id`='107' && `ranking`='6'

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

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

QUERY(0.618ms) - SELECT * FROM `league_schedule_options` WHERE `season_id`=107

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

QUERY(0.1101ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.118ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.1259ms) - SELECT SQL_CACHE `competition_type` FROM `league_seasons` WHERE `league_id`='71' && `season_id`='107'

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

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