Ultra Draft

Soccer Ultra Draft Festival

Event: Indy Eleven Spring Event   |   Sport: Soccer

MixedSocialDraft
Event Director
League Joe
Contact / Learn More
Venue
Grand Park Sports Campus
Westfield, IN
Days
Hours
Minutes
Seconds
Join Ultra Draft
Registration Details
DatesCost Guaranteed Min Games
Jun 22, 2024 - Jun 23, 202406/22/24 - 06/23/24Multiple Play Packages Available
Starting at $109.00		3
Helpful Links:

Description

An Awesome 7v7 Adult Soccer Experience that Brings You the FUN without the DRAMA

AGE DIVISIONS: Open (18+) and 30+. Both divisions are mixed gender format

ALL Players are DRAFTED based on experience and skill - no pre-made super teams... every team has a chance to win!
Each team is guaranteed a minimum of 3 games on quality outdoor fields.
Tournament matches officiated by experienced referees.
Total prize pool of cash and prizes upwards to $3,000 total*
Amazing entertainment nearby and between games to make the event a FESTIVAL atmosphere!

indyelevenbanner_recjoe1710966341.jpg

Powered by Indy Eleven

The ultimate soccer experience is brought to you by the ultimate soccer club - Indy Eleven! All player kits will include exclusive swag from Indy Eleven, and all players will enjoy a home game on Saturday night in the biggest soccer party in Indy!

What is this Soccer Ultra Draft?

Adult sports leagues and tournaments are often ruined by extremely strong super teams using the rest of the field as practice, leaving most teams to feel like they are not getting the most fun for their money. In our ULTRA DRAFT format, there are no pre-made teams. Every player signs up as a single or an individual and coaches then draft the teams based on a salary cap formula. For years, this formula has worked for sports like Softball, Volleyball, and Kickball, and now we bring this exciting format to Soccer.

Unrivaled Swag on the Field

Look good, feel good. Feel good, play good. With Ultra Drafts, we make sure each group of random strangers quickly becomes a TEAM by outfitting them in fully dye sublimated jerseys with matching shorts and socks, so players can look great on and off the pitch. Each tournament is a unique experience and a unique opportunity to make friends and memories.

(Click to Enlarge)
jersey-example_recjoe1691035499.png
(Click to Enlarge)
Additional Details
* Minimum of 8 teams required for full tournament prize payouts

Schedule Overview

Part Tourney, All Party

In our Ultra Drafts, we bring you the best of both worlds by creating fun, competitive tournaments while also giving you plenty of opportunities to meet new players and enjoy the sights and scenes of our host cities. While playing in an Ultra Draft, expect plenty of downtime to recover before the final championship!

Tentative Saturday Schedule

  • 8-9am
    Check-in and Warm Up
  • 9am-5pm
    Pool Play / Placement Games / Skills Challenges
  • 9-5pm
    Family Festival / Tailgate Zone
  • 5-7pm
    Time Off for Shower/Changing
  • 7-9pm
    Indy Eleven Home Game with a Soccer Ultra Draft Section
  • 9pm-??
    Official After Party

Tentative Sunday Schedule

  • 8-9am
    Check-in and Warm Up
  • 10am-5pm
    Bracket Play Matches
  • 9-4pm
    Family Festival / Tailgate Zone
  • 4pm
    Championship Game
soccerparty2_recjoe1711402161.png
soccerparty_recjoe1711402173.png
LJ Party

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

Sanctioning Body

Indiana Soccer
Indiana Soccer
Indiana Soccer
Indy Eleven

Debug Information


Request Variables

var = ultra

varb = soccer-ultra-draft-festival

varc = indy-11-soccer-draft-2024

view_var = ultra

view_varb = soccer-ultra-draft-festival

view_varc = indy-11-soccer-draft-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: 847ea8d68adb825a11dbdd79aa9c6022

Login Type:

BASE:: ultra

FULL LINK:: ultra/soccer-ultra-draft-festival/indy-11-soccer-draft-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 = 847ea8d68adb825a11dbdd79aa9c6022


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /ultra/soccer-ultra-draft-festival/indy-11-soccer-draft-2024/
QUERY_STRING = var=ultra&varb=soccer-ultra-draft-festival&varc=indy-11-soccer-draft-2024
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=ultra&varb=soccer-ultra-draft-festival&varc=indy-11-soccer-draft-2024
REDIRECT_URL = /ultra/soccer-ultra-draft-festival/indy-11-soccer-draft-2024/
REMOTE_PORT = 20677
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.218.127.141
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/soccer-ultra-draft-festival/indy-11-soccer-draft-2024/
SCRIPT_URL = /ultra/soccer-ultra-draft-festival/indy-11-soccer-draft-2024/
UNIQUE_ID = Zjilt829GTSt04q7yDWtZQAAAIU
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/ultra/soccer-ultra-draft-festival/indy-11-soccer-draft-2024/
REDIRECT_SCRIPT_URL = /ultra/soccer-ultra-draft-festival/indy-11-soccer-draft-2024/
REDIRECT_UNIQUE_ID = Zjilt829GTSt04q7yDWtZQAAAIU
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1714988471.5511
REQUEST_TIME = 1714988471


SQL Queries


Total Queries: 78
Total Execution Time: 38.933ms
Avg Execution Time:0.49914102564103ms

QUERY(8.373ms) - 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', '09:41:11', 'GET', '/ultra/soccer-ultra-draft-festival/indy-11-soccer-draft-2024/', '18.218.127.141', '' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'OXoxRVZMVjQ4WTB4djhqV3ZoeDVtaWk0bVpKWXNoVFlDeGpkTXRpRUsxWnNPMHBkSG96NzlCYnk2bHhvMkwyMmk1MXhzMEpaMGs0NzNYcUppM1M0MHdVbEVwdFFudkZ0L2pDTmNMVkNQYWt1RGpMNnJDR0c2eEZDOEZ0R2dqemhqdFJnY0hRa2FBWitQSjFSMHVOd2lWZkkwTHdjWVcyMm5TS01WUUltU2hDZ3Q5UkJ4VWdjUWxSbDdmMG95c1M3MWRxMXh6UHR4WjlkSnY2Z0JVd3Zmdz09', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhd0RCRldFTTZvRFhHNXk4enVSK0NvNzMzWUhuUGt0ekJ2SWZuK2daVnRXZmE3eXp0MlJKNnMwWmdZZDVKZnVvcXZrY1J2UlB0ZnBicld3d3htZDBxOW4=','0','','1714988471') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.3819ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/ultra/soccer-ultra-draft-festival/indy-11-soccer-draft-2024/'

QUERY(0.2708ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='ultra/soccer-ultra-draft-festival/indy-11-soccer-draft-2024' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.196ms) - SELECT * FROM userprofiles_config

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

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

QUERY(0.206ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.572ms) - 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` = 'soccer-ultra-draft-festival' LIMIT 0,1

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

QUERY(0.468ms) - 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` = '95' and `league_seasons`.`url` = 'indy-11-soccer-draft-2024' ORDER BY `league_dates`.`start_date` ASC

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

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

QUERY(0.2451ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit` FROM `league_custom_content` WHERE `league_id`=95 && `season_id`=152 LIMIT 0,1

QUERY(0.236ms) - 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`=95 && `season_id`=152 LIMIT 0,1

QUERY(0.2961ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=95 && `season_id`=152 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

QUERY(0.246ms) - 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`='95' && (`season_id`='152' || `season_id`=0)

QUERY(0.2229ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=95 && `season_id`=0) || `season_id`='152'

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

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

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

QUERY(0.2429ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons_rules` WHERE `league_id`='95' || `season_id`='152' ORDER BY `season_id` DESC

QUERY(0.2561ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='95' && `season_id`='152'

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

QUERY(0.272ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons` WHERE `league_id`='95'

QUERY(0.2079ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=95&&`season_id`=152 LIMIT 0,1

QUERY(1.179ms) - SELECT `game_id` FROM `games` WHERE `league_id`=95&&`season_id`=152&&`playoff`=1 LIMIT 0,1

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

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

QUERY(1.1609ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='95' && `season_id`='152'

QUERY(0.206ms) - 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`='95' && `league_seasons`.`season_id`='152'

QUERY(0.205ms) - SELECT `hotelinfo` FROM `league_custom_content` WHERE `league_id`=95 && `season_id`=152 LIMIT 0,1

QUERY(0.195ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=95 && `season_id`=152

QUERY(4.179ms) - 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 ('95','152','0','0','0','34','0','2','1','0','0','0','0','1','2','7','0','0','0','0',NOW(),'0') ON DUPLICATE KEY UPDATE `articles`='0',`participants`='0',`conferences`='0',`players`='34',`coaches`='0',`subs`='2',`rules`='1',`teams`='0',`games`='0',`groups`='0',`divisions`='0',`seasons`='1',`sponsors`='2',`products`='7',`prizes`='0',`hotels`='0',`is_full`='0',`reg_is_open`='0',`updated`=NOW(),`show_playoff_menu`='0'

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

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

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

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

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

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

QUERY(0.1829ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.545ms) - 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` = 'soccer-ultra-draft-festival' LIMIT 0,1

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

QUERY(0.4711ms) - 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` = '95' and `league_seasons`.`url` = 'indy-11-soccer-draft-2024' ORDER BY `league_dates`.`start_date` ASC

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

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

QUERY(0.1931ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit` FROM `league_custom_content` WHERE `league_id`=95 && `season_id`=152 LIMIT 0,1

QUERY(0.2201ms) - 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`=95 && `season_id`=152 LIMIT 0,1

QUERY(0.309ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=95 && `season_id`=152 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

QUERY(0.2868ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='soccer-ultra-draft-festival'

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

QUERY(0.169ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.191ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.1862ms) - SELECT * FROM `league_notices` WHERE `league_id`=95 && `season_id`=152

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

QUERY(0.2711ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=95 && `season_id`=152

QUERY(0.1869ms) - SELECT * FROM `league_hotel_settings` WHERE `league_id`=95 && `season_id`=152

QUERY(0.1819ms) - SELECT `game_term`,`game_terms` FROM `sports` WHERE `sport_id`=9

QUERY(0.1578ms) - SELECT `comeswith` FROM `league_custom_content` WHERE `league_id`=95 && `season_id`=152

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

QUERY(0.4201ms) - 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` = '95' and `league_updates`.`season_id` = '152'

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

QUERY(0.1559ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=95 && `season_id`=152

QUERY(0.2379ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=95 && `season_id`=152

QUERY(0.1788ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=95 && `season_id`=152

QUERY(3.005ms) - 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` = '95' and `league_photographers`.`season_id` = '152'

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

QUERY(0.2451ms) - SELECT s.*,`photo`.`img_url` FROM `sports_governing_bodies` s INNER JOIN `photo` ON `photo`.`photo_id`=s.`logo_id` WHERE `body_id`=7

QUERY(0.385ms) - SELECT SQL_CACHE `name`,`moreinfo`,`img_url` FROM `league_sponsors` INNER JOIN `photo` ON `logo_id`=`photo_id` WHERE `season_id`='152' || `league_id`='95' GROUP BY `league_sponsors`.`name`

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