Ultra Draft

League Jane Ultra Draft

Event: League Jane Sirens Ultra Draft (Other Events)
Sport: Softball
WomenSocialDraft
Event Director
League Joe
Contact / Learn More
Venue
Exchange Park Softball Complex
Pensacola, FL
Registration Deadline
Sun, Oct 13
Days
Hours
Minutes
Seconds
Join Ultra Draft
Registration Details
DatesCost Guaranteed Min Games
Oct 12, 2024 - Oct 13, 202410/12/24 - 10/13/24Multiple Play Packages Available
Starting at $39.00		5
Helpful Links:

Description

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"
pensacola_recjoe1725641991.png

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

Registration

You may register for this league as an individual or as a couple. You must have a LeagueJoe account to participate in this league.

Join this Ultra Draft

Schedule Overview

Typical Ultra Draft Schedule

All of our Ultra Drafts are scheduled to try to give players a blend of fun activities, down time, and plenty of softball. Schedules are subject to change based on total number of registered players and weather conditions, so check back here closer to the event for an exact schedule.

Planning Your Travel

If you are planning your travel ahead, then the following guidance will help you with those plans. This is most typically what an Ultra Draft schedule looks like:

Typical Schedule - Subject to Change

  • Meet & Greet Party on Friday Night
  • IF THERE ARE GAMES - Games Start after 7pm
  • IF THERE ARE NO GAMES - Home Run Derby sometime after 7pm
  • Saturday - Pool Play + Start of Bracket Play
  • Sunday - As many teams as possible return to conclude the tourney
  • Tourney done by 5pm local timezone on Sunday

We highly recommend getting in-town on Friday and being ready for activities to begin sometime around 7pm Friday evening.

Updates

  • UPDATE
  • hobogabbins Avatarhobogabbins

Important Format Change for the Sirens Draft

Heads up, everyone! The upcoming Sirens Ultra Draft in Pensacola will now be a Keeper Draft format. After trialing this exciting new setup in Indy, we’re bringing it to you!


💥 What’s the Keeper Draft? 💥

Coaches can bring up to 6 players from their existing teams as “Keeper Picks,” then draft additional players to fill out their rosters. This format ensures every team is built for high competition—no salary caps, just pure skill and strategy!


🌊 Already Signed Up as a Free Agent? 🌊

No worries, you're still in! You’ll compete alongside others who are ready to play hard and show off their talents.

🥎New Packages 🥎
With a new format come new packages. We will contact those who have paid early to inquire about refund options. 


📅 Reminder: This is a Two-Day Tournament at Exchange Park!

If this new format affects your plans or availability, please let us know ASAP to confirm your participation or make adjustments.


Reach out if you have any questions.

~Gabs

Continue Reading

Photographers

View All

Event Operator

League Joe
Contact Organizer

Debug Information


Request Variables

var = ultra

varb = womens-draft

varc = pensacola-sirens

vara =

vard =

vare =

view_var = ultra

view_varb = womens-draft

view_varc = pensacola-sirens

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: cfb17e5dce3067e7d0d205ce1871621e

Login Type:

BASE:: ultra

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

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 = cfb17e5dce3067e7d0d205ce1871621e
fullstate =


Cookie Variables

handl_url = https://bocahindonesia.com/wp-json/oembed/1.0/embed?format=xml&url=https%3A%2F%2Fbocahindonesia.com%2Fciri-infeksi-saluran-kemih%2F
handl_ip = 3.147.81.24
HandLtestDomainNameServer = HandLtestDomainValueServer
handl_landing_page = https://bocahindonesia.com/wp-json/oembed/1.0/embed?format=xml&url=https%3A%2F%2Fbocahindonesia.com%2Fciri-infeksi-saluran-kemih%2F
handl_url_base = https://bocahindonesia.com/wp-json/oembed/1.0/embed
user_agent = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/womens-draft/pensacola-sirens/
QUERY_STRING = var=ultra&varb=womens-draft&varc=pensacola-sirens
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=womens-draft&varc=pensacola-sirens
REDIRECT_URL = /ultra/womens-draft/pensacola-sirens/
REMOTE_PORT = 8228
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.147.81.24
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
HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
HTTP_COOKIE = handl_url=https%3A%2F%2Fbocahindonesia.com%2Fwp-json%2Foembed%2F1.0%2Fembed%3Fformat%3Dxml%26url%3Dhttps%253A%252F%252Fbocahindonesia.com%252Fciri-infeksi-saluran-kemih%252F; handl_ip=3.147.81.24; HandLtestDomainNameServer=HandLtestDomainValueServer; handl_landing_page=https%3A%2F%2Fbocahindonesia.com%2Fwp-json%2Foembed%2F1.0%2Fembed%3Fformat%3Dxml%26url%3Dhttps%253A%252F%252Fbocahindonesia.com%252Fciri-infeksi-saluran-kemih%252F; handl_url_base=https%3A%2F%2Fbocahindonesia.com%2Fwp-json%2Foembed%2F1.0%2Fembed; user_agent=Mozilla%2F5.0%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%3B%20compatible%3B%20ClaudeBot%2F1.0%3B%20%2Bclaudebot%40anthropic.com%29
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/
SCRIPT_URL = /ultra/womens-draft/pensacola-sirens/
UNIQUE_ID = Zut2zoYPYX3mW8l5hvpQoQAAAIw
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/womens-draft/pensacola-sirens/
REDIRECT_SCRIPT_URL = /ultra/womens-draft/pensacola-sirens/
REDIRECT_UNIQUE_ID = Zut2zoYPYX3mW8l5hvpQoQAAAIw
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1726707406.5996
REQUEST_TIME = 1726707406


SQL Queries


Total Queries: 77
Total Execution Time: 16.1722ms
Avg Execution Time:0.21002857142857ms

QUERY(0.8402ms) - 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', '00:56:46', 'GET', '/ultra/womens-draft/pensacola-sirens/', '3.147.81.24', 'https://netstuffersdev1.com/ultra/womens-draft/pensacola-sirens' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhd3d5dHRabUpBNnhVb0YxWGNFdjJ1RVBtMVE0ZVVTdWFlOWNtV1JzTi9qb2k3NVV4RmRyV2lCS2lhQ3FqeUZtaE5ZaDBmQ1ZMVklnU1g1OVkwUVlSS2k=','0','','1726707406') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

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

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

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

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

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

QUERY(0.133ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.181ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

QUERY(0.154ms) - 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.1349ms) - 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.1681ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=106 && `season_id`=283 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

QUERY(0.617ms) - 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.3128ms) - 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.4358ms) - 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.118ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons_rules` WHERE `league_id`='106' || `season_id`='283' ORDER BY `season_id` DESC

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

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

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

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

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

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

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

QUERY(0.2189ms) - 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.1271ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='106' && `season_id`='283'

QUERY(0.138ms) - 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.109ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=106 && `season_id`=283 LIMIT 0,1

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

QUERY(0.747ms) - 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.103ms) - SELECT SQL_CACHE `enabled` FROM `league_merch` WHERE `season_id`=283 LIMIT 0,1

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

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

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

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

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

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

QUERY(0.088ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

QUERY(0.0749ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.139ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.119ms) - SELECT SQL_CACHE * FROM teams_config

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

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

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

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

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

QUERY(0.109ms) - SELECT `game_term`,`game_terms` FROM `sports` WHERE `sport_id`=1

QUERY(0.104ms) - SELECT `comeswith` FROM `league_custom_content` WHERE `league_id`=106 && `season_id`=283

QUERY(0.1681ms) - SELECT `package_id` FROM `league_players` WHERE `player_id`=0 && `season_id`=283

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

QUERY(0.0811ms) - SELECT SQL_CACHE * FROM payments_config

QUERY(0.2151ms) - SELECT `fee` FROM `league_seasons` WHERE `season_id`='283'

QUERY(0.572ms) - SELECT `price` FROM `league_reg_packages` WHERE `season_id`=283 && `active`=1 ORDER BY `price` ASC

QUERY(0.2851ms) - SELECT COUNT(*) FROM `article` INNER JOIN `article_text` ON (`article`.`article_id` = `article_text`.`article_id`) INNER JOIN `users` ON (`article`.`user_id` = `users`.`id`) INNER JOIN `league_updates` ON (`article`.`article_id` = `league_updates`.`article_id`) INNER JOIN `photo` ON (`users`.`avatar_id` = `photo`.`photo_id`) WHERE `league_updates`.`league_id` = '106' and `league_updates`.`season_id` = '283'

QUERY(1.0669ms) - SELECT SQL_CACHE `article`.`title`,`article`.`title_url`,`article`.`user_id`,`article`.`article_id`,`article`.`time_stamp`,`article`.`total_comment`,`article_text`.`text`,`users`.`username`,`users`.`user_url`,`league_updates`.`sent`,`photo`.`img_url` FROM `article` INNER JOIN `article_text` ON (`article`.`article_id` = `article_text`.`article_id`) INNER JOIN `users` ON (`article`.`user_id` = `users`.`id`) INNER JOIN `league_updates` ON (`article`.`article_id` = `league_updates`.`article_id`) INNER JOIN `photo` ON (`users`.`avatar_id` = `photo`.`photo_id`) WHERE `league_updates`.`league_id` = '106' and `league_updates`.`season_id` = '283' ORDER BY `article`.`time_stamp` desc LIMIT 0,3

QUERY(0.0949ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=106 && `season_id`=283

QUERY(0.1049ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=106 && `season_id`=283

QUERY(0.1988ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=106 && `season_id`=283

QUERY(0.2229ms) - SELECT SQL_CACHE `league_photographers`.*,`photo`.`img_url` FROM `league_photographers` INNER JOIN `photo` ON (`league_photographers`.`flyer` = `photo`.`photo_id`) WHERE `league_photographers`.`league_id` = '106' and `league_photographers`.`season_id` = '283'

QUERY(0.1431ms) - SELECT `venues`.*,`photo`.`img_url` FROM `venues` LEFT JOIN `photo` ON `venues`.`logo_id`=`photo`.`photo_id` WHERE `venue_id`=39

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