Join Ultra Draft

Already have an account? Login here.

Already have an account? Login here.

You will receive a confirmation email in your inbox
with a link to activate your account!

Event Director

League Joe
Contact / Learn More

Venue

Exchange Park Softball Complex
Pensacola, FL

Registration Deadline

Sun, Oct 13

Introducing a Brand New Format From League Jane!

We trial-tested a brand new competitive format for men, Keeper Draft, for our drafts in Indy, so now we are bringing this to Pensacola for the Sirens Keeper Draft (Women's) AND Sailors Keeper Draft (Men's). Unlike our other drafts, players must meet minimum skill and competitive standards to participate. No soft, warm and fuzzy feelings here - you're coming to play, and you're here to win.The ladies are playing in the Siren's Ultra Draft, so might as well theme this Sailors!

Two-Day Tournament at Exchange Park

How it Works

For Coaches of Existing Teams
Missing a bunch of your guys this weekend? You can still get valuable swings by bringing up to 6 players to the draft. These are your "Keeper Picks" and will be slotted into the draft, and then you will draft up to 10, 11 or 12 players (your choice).

Safety rails are removed - there's no salary cap
Every player in the draft will be a competitive player ready to give it their all
Scout potential future recruits
Coaches help vote on and determine rules for the event

For Free Agents
New to the area? Your team disbanded? Been looking for a new competitive team? Join us a Free Agent and you will put your talents on display for teams around the region.

Receive a non custom "Free Agent" jersey that matches your team, but also makes it clear that you're up for grabs
Have a team already, and just want extra swings? Come get em
Test your mettle against strong competition without risking a "ratings bump"

Sailors Ultra Draft

Got a male significant other, friend, or travel buddy? They can play now, too! Sign them up for the Sailors Ultra Draft competitive Men's Tourney.

Sailors Ultra Draft

You will be drafted to play on a team and will receive a non-custom "Free Agent" jersey.

$59.00

Package Disclaimer: Packages with customized elements must have minimum payment received no later than 21 days before the event. If payment is delayed, items may be ordered late but could be missing some customized data such as names and/or numbers.

Select if you have been picked up by a coach to play in this event and are paying your fee. No jersey is included at this cost.

$39.00

Package Disclaimer: Packages with customized elements must have minimum payment received no later than 21 days before the event. If payment is delayed, items may be ordered late but could be missing some customized data such as names and/or numbers.

You will Coach a team and select up to 5 other players (6 if you do not play) to participate on your team, and draft the other players during the player draft. No jerseys or gear are included.

$39.00

Package Disclaimer: Packages with customized elements must have minimum payment received no later than 21 days before the event. If payment is delayed, items may be ordered late but could be missing some customized data such as names and/or numbers.

Package Disclaimer: Packages with customized elements must have minimum payment received no later than 21 days before the event. If payment is delayed, items may be ordered late but could be missing some customized data such as names and/or numbers.

106 283

Debug Information

Request Variables

var = ultra

varb = womens-draft

varc = pensacola-sirens

vard = join

vara =

vare =

view_var = ultra

view_varb = womens-draft

view_varc = pensacola-sirens

view_vard = join

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: 0c73c18a5cfa35f38fcabbf4223fbe9d

Login Type:

BASE:: ultra

FULL LINK:: ultra/womens-draft/pensacola-sirens/join

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 = 0c73c18a5cfa35f38fcabbf4223fbe9d
fullstate =

Cookie Variables

Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/womens-draft/pensacola-sirens/join/
QUERY_STRING = var=ultra&varb=womens-draft&varc=pensacola-sirens&vard=join
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=womens-draft&varc=pensacola-sirens&vard=join
REDIRECT_URL = /ultra/womens-draft/pensacola-sirens/join/
REMOTE_PORT = 21340
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.221.181.79
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/womens-draft/pensacola-sirens/join
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/womens-draft/pensacola-sirens/join/
SCRIPT_URL = /ultra/womens-draft/pensacola-sirens/join/
UNIQUE_ID = ZuxMfLn0-A1tcH14s4hDkQAAAEw
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/womens-draft/pensacola-sirens/join/
REDIRECT_SCRIPT_URL = /ultra/womens-draft/pensacola-sirens/join/
REDIRECT_UNIQUE_ID = ZuxMfLn0-A1tcH14s4hDkQAAAEw
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1726762108.9907
REQUEST_TIME = 1726762108

SQL Queries

Total Queries: 78
Total Execution Time: 17.603ms
Avg Execution Time:0.22567948717949ms

QUERY(1.2031ms) - 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-09-19', '16:08:29', 'GET', '/ultra/womens-draft/pensacola-sirens/join/', '18.221.181.79', 'https://netstuffersdev1.com/ultra/womens-draft/pensacola-sirens/join' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheFdiUFBoREdZNXpkUHI1OElERm9mMlJaYnBrVTNpUkg4ZEtPeXNscndNRFpBVlA0Z1hhUDd1MXVNY09RWjdBMTNFVTRwOG5ubXZXNHpqMkpCU0t1M0M=','0','','1726762109') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1178ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/womens-draft/pensacola-sirens/join/'

QUERY(0.221ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='ultra/womens-draft/pensacola-sirens/join' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.0889ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.092ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.3569ms) - 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` = 'womens-draft' LIMIT 0,1

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

QUERY(0.3042ms) - 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` = '106' and `league_seasons`.`url` = 'pensacola-sirens' ORDER BY `league_dates`.`start_date` ASC

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

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

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

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

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

QUERY(0.1328ms) - SELECT SQL_CACHE * FROM `league_schedule_options` WHERE `league_id`='106' && `season_id`='283' LIMIT 0,1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

QUERY(0.108ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=106 && `season_id`=283 LIMIT 0,1

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

QUERY(0.8869ms) - 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`,`reg_is_open`,`updated`,`show_playoff_menu`) VALUES ('106','283','1',0,0,'45',0,'2','2',0,0,0,0,'3',0,'11','1','106',0,0,0,NOW(),0) ON DUPLICATE KEY UPDATE `league_id`='106',`season_id`='283',`articles`='1',`participants`=0,`conferences`=0,`players`='45',`coaches`=0,`subs`='2',`rules`='2',`teams`=0,`games`=0,`groups`=0,`divisions`=0,`seasons`='3',`sponsors`=0,`products`='11',`prizes`='1',`triumphs`='106',`hotels`=0,`is_full`=0,`reg_is_open`=0,`updated`=NOW(),`show_playoff_menu`=0

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

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

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

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

QUERY(0.134ms) - SELECT `abbr`,`name` FROM `states` WHERE `active`=1 ORDER BY `name` ASC

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

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

QUERY(0.093ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.124ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='womens-draft'

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

QUERY(0.104ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.0811ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.0958ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.262ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='106' && `season_id`='283' LIMIT 0,1

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

QUERY(0.2561ms) - SELECT SQL_CACHE `standings_id` FROM `standings` WHERE `season_id`=283 LIMIT 0,1

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

QUERY(0.102ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.082ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(0.1011ms) - SELECT SQL_CACHE * FROM payments_config

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

QUERY(0.097ms) - SELECT * FROM userprofiles_config

QUERY(2.897ms) - SELECT SQL_CACHE `users`.`rookie`,`users`.`id`,`users`.`username`,`users`.`city_address`,`users`.`state_address`,`users`.`first_name`,`users`.`last_name`,`users`.`avatar_id`,`users`.`gender`,`users`.`user_url`,`users`.`level`,`users`.`confirmed`,`users`.`phone_number`,`users`.`email`,`users`.`approved`,`users`.`noemail`,`users`.`problem_list`,`users`.`creation`,`users`.`skill_flag`,`userprofiles_cache`.`trust`,`userprofiles_cache`.`ships`,`userprofiles_cache`.`avg_salary`,`userprofiles_cache`.`silvers`,`userprofiles_cache`.`age`,`league_players`.`league_players_id`,`league_players`.`ready`,`league_players`.`season_id`,`league_players`.`created`,`league_players`.`package_id`,`league_players`.`closed`,`league_players`.`moretime`,`league_players`.`player_id`,`league_players`.`league_id`,`league_players`.`alternate`,`league_players`.`coach`,`league_players`.`paid`,`league_players`.`couple`,`league_players`.`couple_uname`,`league_players`.`access`,`league_players`.`nosalary`,`users_socialmedia`.`facebook`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=1 LIMIT 0,1) AS `outfield`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=2 LIMIT 0,1) AS `infield`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=3 LIMIT 0,1) AS `speed`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=4 LIMIT 0,1) AS `hitting`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=5 LIMIT 0,1) AS `slugging`,(SELECT `value` FROM `user_attributes` WHERE `user_attributes`.`user_id`=`users`.`id` && `user_attributes`.`attribute_id`=7 LIMIT 0,1) AS `arm`,(SELECT `salary` FROM `draft_scouting_reports` WHERE `draft_scouting_reports`.`player_id`=`league_players`.`player_id` && `draft_scouting_reports`.`season_id`=`league_players`.`season_id` ORDER BY `lock` DESC LIMIT 0,1) AS `salary`,(SELECT `abbr` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=1 && `sports_positions`.`sport_id`=1 ORDER BY `season_id`=283 DESC LIMIT 0,1) AS `primary`,(SELECT `abbr` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=2 && `sports_positions`.`sport_id`=1 ORDER BY `season_id`=283 DESC LIMIT 0,1) AS `secondary`,(SELECT `abbr` FROM `sports_positions` INNER JOIN `sports_positions_link` ON `sports_positions`.`position_id`=`sports_positions_link`.`position_id` WHERE `sports_positions_link`.`user_id`=`users`.`id` && `sports_positions_link`.`primary`=3 && `sports_positions`.`sport_id`=1 ORDER BY `season_id`=283 DESC LIMIT 0,1) AS `tertiary`,(SELECT `thumb_url` FROM `photo` WHERE `photo_id`=`users`.`avatar_id` LIMIT 0,1) AS `avatar`,(SELECT `payment_id` FROM `payments` WHERE `league_players`.`player_id`=`payments`.`player_id` && `payments`.`season_id`=`league_players`.`season_id` LIMIT 0,1) AS `payment_id`,(SELECT `teams`.`team_id` FROM `teams` INNER JOIN `teams_players` ON `teams`.`team_id`=`teams_players`.`team_id` INNER JOIN `league_teams` ON `teams`.`team_id`=`league_teams`.`team_id` WHERE `league_teams`.`league_id`=106 && `league_teams`.`season_id`=283 && `teams_players`.`league_id`=106 && `teams_players`.`season_id`=283 &&`teams_players`.`player_id`=`users`.`id` && `teams_players`.`quit`=0 LIMIT 0,1) AS `team_id` FROM `users` INNER JOIN `userprofiles_cache` ON (`users`.`id` = `userprofiles_cache`.`user_id`) INNER JOIN `league_players` ON (`users`.`id` = `league_players`.`player_id`) LEFT JOIN `users_socialmedia` ON (`users`.`id` = `users_socialmedia`.`user_id`) WHERE `league_players`.`league_id` = '106' and `league_players`.`season_id` = '283' and ( `league_players`.`alternate` = '1' or `users`.`problem_list` = '1' or `league_players`.`nosalary` = '1') and `league_players`.`deleted` = '0' GROUP BY `league_players`.`player_id` ORDER BY `users`.`last_name` ASC LIMIT 0,200

QUERY(0.1211ms) - SELECT COUNT(*) FROM `league_teams` WHERE `league_id`=106

QUERY(0.164ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=106 || (`league_id`=106 && `season_id`=283) ORDER BY `season_id` DESC LIMIT 0,1

QUERY(0.1531ms) - SELECT `allow_vouch`,`allow_promo` FROM `league_vouch_settings` WHERE `season_id`=283

QUERY(0.1419ms) - SELECT `text` FROM `company_policies` WHERE (`company_id`=1 || `company_id`=1) && `policy_type`='waiver' ORDER BY `company_id`=1 DESC LIMIT 0,1

QUERY(0.1581ms) - SELECT COUNT(`package_id`) FROM `league_reg_packages` WHERE `season_id`=283 && `active`=1

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

QUERY(0.0792ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.3839ms) - SELECT * FROM `league_reg_packages` WHERE `season_id`=283 && `visible`=1 ORDER BY `active` DESC,`sort` ASC,`price` DESC

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