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

Chase for the Chaos Cup

Event: Pensacola 2024   |   Sport: Softball

MixedSocialDraft
Event Director
League Joe
Contact / Learn More
Venue
Exchange Park Softball Complex
Pensacola, FL
This event has completed. This information has been preserved for archival purposes.
Join as Alternate
Registration Details
DatesCost Guaranteed Min Games
May 03, 2024 - May 05, 202405/03/24 - 05/05/24Multiple Play Packages Available
Starting at $89.00		5
Helpful Links:

Description

Hotel Information

Powered by TeamInn

Schedule Overview

Typical Draft Schedule

All of our 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 a Draft schedule looks like:

Typical Schedule - Subject to Change

  • Meet & Greet Party on Friday Night at the Park!
  • 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 + After Party
  • 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
  • Smitty AvatarSmitty

Pensacola Update - Last Call for Trading Cards

It is almost time to play ball, and one of the unique things we do at League Joe is create collectible networking opportunities with TRADING CARDS! Upload your cards and you can then seek them out... hidden throughout the event and even possibly in your neighbor's player kit. We will place this order on Wednesday morning, so get your pictured uploaded!

To participate, just go and upload your trading card pictures here: Trading Cards Upload

Want to check and see if your cards are uploaded already? Check them out here: Trading Card Status

vaughs_recjoe1713812370.png
mattys_recjoe1713812391.png
julias_recjoe1713812399.png

Continue Reading
  • UPDATE
  • radcliffe42 Avatarradcliffe42

Have a Friend who "forgot to sign up" READ THIS!!!

HEY HEY HEY We have 19 spots open for player only package!!! Please share to your teams!!!! https://leaguejoe.com/ultra/chaos-cup/pensacola-may-2024/packages/

Continue Reading
  • UPDATE
  • Smitty AvatarSmitty

Pensacola Ultra Draft - Make Sure You Get Drafted next Week

Next week, we will officially be drafting our teams for the Pensacola Ultra Draft.  To make sure you are drafted, you must have your payment completed or a payment plan confirmed.  Check your status and make sure you don't miss out on the action!

Registration Status

If you need an extension on your payment or a payment plan, please use the PayPal Pay-in-4 Payment Option or text ‪(317) 210-0038‬.

Hotel Blocks

Looking for accommodations for the weekend? Hotel blocks available for our players.

Hotel Block

Continue Reading

Coaches Wanted

We are looking for coaches for this event! Want to join us?

Apply to Coach

Vouch Codes Active

Create a vouch code and your friends will save money while you reap rewards

Vouch Codes

Trading Cards Active

Create a cool trading card to help spread the word!

Trading Cards

Photographers

View All

Event Operator

League Joe
Contact Organizer

Debug Information


Request Variables

var = ultra

varb = chaos-cup

varc = pensacola-may-2024

view_var = ultra

view_varb = chaos-cup

view_varc = pensacola-may-2024

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: b7e27ecc6315b4d232ccc5d39668009b

Login Type:

BASE:: ultra

FULL LINK:: ultra/chaos-cup/pensacola-may-2024

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 = b7e27ecc6315b4d232ccc5d39668009b


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/chaos-cup/pensacola-may-2024/
QUERY_STRING = var=ultra&varb=chaos-cup&varc=pensacola-may-2024
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=chaos-cup&varc=pensacola-may-2024
REDIRECT_URL = /ultra/chaos-cup/pensacola-may-2024/
REMOTE_PORT = 24017
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.216.205.123
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/chaos-cup/pensacola-may-2024/
SCRIPT_URL = /ultra/chaos-cup/pensacola-may-2024/
UNIQUE_ID = ZjhjWlCcGPNaHSjacrqFGAAAAVg
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/chaos-cup/pensacola-may-2024/
REDIRECT_SCRIPT_URL = /ultra/chaos-cup/pensacola-may-2024/
REDIRECT_UNIQUE_ID = ZjhjWlCcGPNaHSjacrqFGAAAAVg
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1714971482.0945
REQUEST_TIME = 1714971482


SQL Queries


Total Queries: 75
Total Execution Time: 40.3696ms
Avg Execution Time:0.53826133333333ms

QUERY(9.8081ms) - 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', '04:58:02', 'GET', '/ultra/chaos-cup/pensacola-may-2024/', '18.216.205.123', '' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'OXoxRVZMVjQ4WTB4djhqV3ZoeDVtaWk0bVpKWXNoVFlDeGpkTXRpRUsxWnNPMHBkSG96NzlCYnk2bHhvMkwyMjlCWVRSYkhRdGl4M2cyeVBlN3FtamNqeXEvRFFnNmExbVRIZTZaclNFbnBEUlF2SytIVmUzS0xXbFFFcFQ5eHhpUHlRc2FHbGg5QVRQdWJOZkJJTmxYQU1GWFl5MWdCand4eHN5RDR4aE93PQ==', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheGQxVytsSHAreFFjbDJTOGVnZVdnNWJvLzd0bDRMTm8yQnFWamdYL2ljejFrU1ZuMTdyY1R2WVBtRGlHSnRzd0Z0U1BLNTdJbk9NcXl6SU1KeDlSNXE=','0','','1714971482') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.211ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/chaos-cup/pensacola-may-2024/'

QUERY(0.2511ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='ultra/chaos-cup/pensacola-may-2024' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.2279ms) - SELECT * FROM userprofiles_config

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

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

QUERY(0.262ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.7982ms) - 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` = 'chaos-cup' LIMIT 0,1

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

QUERY(0.504ms) - 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` = '107' and `league_seasons`.`url` = 'pensacola-may-2024' ORDER BY `league_dates`.`start_date` ASC

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

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

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

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

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

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

QUERY(0.324ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='107' && (`season_id`='192' || `season_id`=0)

QUERY(0.1991ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=107 && `season_id`=0) || `season_id`='192'

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

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

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

QUERY(0.2761ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons_rules` WHERE `league_id`='107' || `season_id`='192' ORDER BY `season_id` DESC

QUERY(0.2129ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='107' && `season_id`='192'

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

QUERY(0.2899ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons` WHERE `league_id`='107'

QUERY(0.2439ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=107&&`season_id`=192 LIMIT 0,1

QUERY(1.2238ms) - SELECT `game_id` FROM `games` WHERE `league_id`=107&&`season_id`=192&&`playoff`=1 LIMIT 0,1

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

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

QUERY(1.282ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='107' && `season_id`='192'

QUERY(0.3371ms) - 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`='107' && `league_seasons`.`season_id`='192'

QUERY(0.2081ms) - SELECT `hotelinfo` FROM `league_custom_content` WHERE `league_id`=107 && `season_id`=192 LIMIT 0,1

QUERY(0.211ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=107 && `season_id`=192

QUERY(6.8259ms) - 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 ('107','192','4','0','0','182','14','6','1','1','0','0','0','1','0','8','0','1','0','0',NOW(),'0') ON DUPLICATE KEY UPDATE `articles`='4',`participants`='0',`conferences`='0',`players`='182',`coaches`='14',`subs`='6',`rules`='1',`teams`='1',`games`='0',`groups`='0',`divisions`='0',`seasons`='1',`sponsors`='0',`products`='8',`prizes`='0',`hotels`='1',`is_full`='0',`reg_is_open`='0',`updated`=NOW(),`show_playoff_menu`='0'

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

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

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

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

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

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

QUERY(0.1841ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.4799ms) - 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` = 'chaos-cup' 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.4308ms) - 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` = '107' and `league_seasons`.`url` = 'pensacola-may-2024' ORDER BY `league_dates`.`start_date` ASC

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

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

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

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

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

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

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

QUERY(0.1841ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='chaos-cup'

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

QUERY(0.1431ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1738ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.2029ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=107 && `season_id`=192

QUERY(0.212ms) - SELECT * FROM `league_hotel_settings` WHERE `league_id`=107 && `season_id`=192

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

QUERY(0.164ms) - SELECT `comeswith` FROM `league_custom_content` WHERE `league_id`=107 && `season_id`=192

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

QUERY(0.659ms) - 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` = '107' and `league_updates`.`season_id` = '192'

QUERY(1.2829ms) - 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` = '107' and `league_updates`.`season_id` = '192' ORDER BY `article`.`time_stamp` desc LIMIT 0,3

QUERY(0.139ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=107 && `season_id`=192

QUERY(0.1531ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=107 && `season_id`=192

QUERY(0.1841ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=107 && `season_id`=192

QUERY(0.278ms) - 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` = '107' and `league_photographers`.`season_id` = '192'

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

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