This event has completed. This information has been preserved for archival purposes.
League

Flag Football 7v7 Draft League

Season: Spring Saturdays (Other Seasons)   |   Sport: Flag Football

MenCompetitiveDraft
Event Director
League Joe
Contact / Learn More
Venue
Indy Healthplex
Indianapolis, IN
Day of the Week
SAT
This event has completed. This information has been preserved for archival purposes.
Join as Alternate

This Event Has Been Cancelled

The event operator, League Joe, has cancelled this event. Please contact customer support for information on transferring or refunding your event registration.

Registration Details
DatesPlayer CostScheduleTimeslots
May 13, 2024 - Jul 22, 2024$85.00
per player		2 Games p/Day
10 Total Weeks - Play on Saturdays		2pm,5pm
rotating

Description

Welcome to the Flag Football Spring League!


League Info:

We are currently looking for interested players on Saturdays at the Healthplex. Two games per afternoon on a rotating timeslot, so games will be in the afternoon starting no earlier than 2pm.


What is a DRAFT league?

It's a league where all players enter a pool and are selected by coaches before the season begins. All players are ranked based on their experience level, and each team drafts according to a salary cap. This creates even competition, fun head-to-head matchups, and unparalleled social fun as the entire league participates in after-parties as a single entity.


Can I Become a Coach

Absolutely! We will be looking for interested players to serve as coaches for this season, and we'll have an inaugural draft party to draft everyone to their new teams and get the league started ASAP within the next couple of weeks. Contact us with any questions!

Schedule Overview

All games are played on Saturdays between 2 and 5pm at Indy Healthplex.  Official team schedules will be released after preseason week 1.

Updates

  • UPDATE
  • Smitty AvatarSmitty

Saturday Flag Football Important Update

Thank you to everyone who signed up for our inaugural flag football league.  We strongly believe in this draft model and know that it will create fun, fair, and even teams in the long term, but we knew the first season would see it's share of bumps and bruises.

The biggest one is that Saturday afternoons simply does not work as a time slot.  It is impossible to balance teams when entire teams do not show, and it seems as though schedule conflicts are just too rampant to make a Saturday timeslot work.  With that in mind, we will be cancelling the remaining Saturdays for flag football.  Thank you for everyone who showed up and kept your commitment to the league.  It was a blast playing with you even within the chaos, and I hope we can re-invent ourselves and get some fresh blood to bring this back soon.

If you are available to play on Thursdays, there is a healthy league doing well with its four teams and squads could likely use another body or two to help them with a playoff push.  Please let me know if you would like to transfer your registration and we will facilitate.  Otherwise, we will be providing a partial refund to players to cover the missing weeks of play.  If you are interested in other leagues such as Pickleball, Softball, Kickball, or others, we are also happy to transfer your registration to another sport/league of your choice.  

Going forward, we will be meeting with Indy Healthplex to identify another day/time combination to try for Flag Football starting up again in the coming weeks.  For those of you who have been showing up and enjoying the play, I hope you'll join us again.  Speaking of which, we are looking for coaches and others interested in growing this sport with us. 

Every option and opinion is on the table, so if you have ideas please share them direct with Smitty (shawn@leaguejoe.com - 317.372.2623).

Thank you all and sorry this didn't quite meet the mark, but we hope to improve and build upon it shortly.
Smitty

Continue Reading
  • UPDATE
  • Smitty AvatarSmitty

Flag Football Player Schedule Survey - Win a Free League

We have had two great weeks of Thursday football and are officially starting the regular season for Saturdays, so thank you to all players who have come out and played so far.  We have had a number of requests for different nights and start times, so we are doing a survey to find out general player availability.  This information is very important to help us develop the league, so one random player will receive their next league fee completely comped - so please fill it out when you are able!

Player Schedule Survey

Continue Reading
  • UPDATE
  • Smitty AvatarSmitty

Saturday Flag Football Schedule - Games Today at 2 and 3

After a scorcher last week, today's weather looks awesome for some flag football.  Our games are at 2 and 3 and the official schedule can now be found here.

We have a couple of new players - welcome!  If you have not been assigned to a team or heard from your coach yet, please plan on coming out and we'll introduce you to your new teams.  If you have any questions, call or text Smitty at 317.372.2623.

See you soon!

Continue Reading

Event Operator

League Joe
Contact Organizer

Debug Information


Request Variables

var = league

varb = flag-football-7v7

varc = spring-saturdays-23

view_var = league

view_varb = flag-football-7v7

view_varc = spring-saturdays-23

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: ea6001a8232ccc181f9784514b5eace9

Login Type:

BASE:: league

FULL LINK:: league/flag-football-7v7/spring-saturdays-23

Page ID: 27

Page ID:: 27

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


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /league/flag-football-7v7/spring-saturdays-23/
QUERY_STRING = var=league&varb=flag-football-7v7&varc=spring-saturdays-23
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=league&varb=flag-football-7v7&varc=spring-saturdays-23
REDIRECT_URL = /league/flag-football-7v7/spring-saturdays-23/
REMOTE_PORT = 26445
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.129.19.251
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/league/flag-football-7v7/spring-saturdays-23/
SCRIPT_URL = /league/flag-football-7v7/spring-saturdays-23/
UNIQUE_ID = ZjUKV647fdwUUTlc2NZatgAAABQ
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/league/flag-football-7v7/spring-saturdays-23/
REDIRECT_SCRIPT_URL = /league/flag-football-7v7/spring-saturdays-23/
REDIRECT_UNIQUE_ID = ZjUKV647fdwUUTlc2NZatgAAABQ
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1714752087.8401
REQUEST_TIME = 1714752087


SQL Queries


Total Queries: 73
Total Execution Time: 32.9408ms
Avg Execution Time:0.45124383561644ms

QUERY(4.3392ms) - 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-03', '16:01:27', 'GET', '/league/flag-football-7v7/spring-saturdays-23/', '3.129.19.251', '' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'OXoxRVZMVjQ4WTB4djhqV3ZoeDVtaWk0bVpKWXNoVFlDeGpkTXRpRUsxYWhaUWZJa3JqOGw0b0tpaFRYNENENXNMZVpQcWJYU0wvSjVjaHpsYkFFaGlyR3pxdS9WTnExRmFNaWJiUjlOcnErRjY5ZCtaR3FaRUx0SlJuczJvU1Z3L1RqWWljcnpNM1YzSWtrUmNVaHpFcnhpL0lwWWMwajVpSnIxeG1xOVgvOEdZK1NPYk5iS25DQk1nZXJEZ1BH', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheEZQdmxsK2R3TkxnZnZaZFVKNnJwWXY0OGozdnpFOHgxN2w5Z3FqdFBmaytuQ1hJNEtVeTkwbHR3WUViZFZPT0x6TzIwWGVISlAwV1VDOGEzQVhyUlE=','0','','1714752087') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.267ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/league/flag-football-7v7/spring-saturdays-23/'

QUERY(0.2489ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='league/flag-football-7v7/spring-saturdays-23' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.195ms) - SELECT * FROM userprofiles_config

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

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

QUERY(0.2389ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.7429ms) - 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` = 'flag-football-7v7' LIMIT 0,1

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

QUERY(0.5069ms) - 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` = '68' and `league_seasons`.`url` = 'spring-saturdays-23' ORDER BY `league_dates`.`start_date` ASC

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

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

QUERY(0.1979ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit` FROM `league_custom_content` WHERE `league_id`=68 && `season_id`=105 LIMIT 0,1

QUERY(0.3519ms) - 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`=68 && `season_id`=105 LIMIT 0,1

QUERY(0.3181ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=68 && `season_id`=105 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

QUERY(0.396ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='68' && (`season_id`='105' || `season_id`=0)

QUERY(0.33ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=68 && `season_id`=0) || `season_id`='105'

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

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

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

QUERY(0.262ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons_rules` WHERE `league_id`='68' || `season_id`='105' ORDER BY `season_id` DESC

QUERY(0.2408ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='68' && `season_id`='105'

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

QUERY(0.216ms) - SELECT SQL_CACHE count(`league_id`) FROM `league_seasons` WHERE `league_id`='68'

QUERY(0.241ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=68&&`season_id`=105 LIMIT 0,1

QUERY(0.735ms) - SELECT `game_id` FROM `games` WHERE `league_id`=68&&`season_id`=105&&`playoff`=1 LIMIT 0,1

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

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

QUERY(2.1091ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='68' && `season_id`='105'

QUERY(0.2911ms) - 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`='68' && `league_seasons`.`season_id`='105'

QUERY(0.174ms) - SELECT `hotelinfo` FROM `league_custom_content` WHERE `league_id`=68 && `season_id`=105 LIMIT 0,1

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

QUERY(3.9911ms) - 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 ('68','105','10','0','0','19','4','16','1','1','36','0','0','4','0','0','0','0','0','0',NOW(),'1') ON DUPLICATE KEY UPDATE `articles`='10',`participants`='0',`conferences`='0',`players`='19',`coaches`='4',`subs`='16',`rules`='1',`teams`='1',`games`='36',`groups`='0',`divisions`='0',`seasons`='4',`sponsors`='0',`products`='0',`prizes`='0',`hotels`='0',`is_full`='0',`reg_is_open`='0',`updated`=NOW(),`show_playoff_menu`='1'

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

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

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

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

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

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

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

QUERY(0.1779ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5381ms) - 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` = 'flag-football-7v7' LIMIT 0,1

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

QUERY(0.4451ms) - 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` = '68' and `league_seasons`.`url` = 'spring-saturdays-23' ORDER BY `league_dates`.`start_date` ASC

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

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

QUERY(0.1891ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit` FROM `league_custom_content` WHERE `league_id`=68 && `season_id`=105 LIMIT 0,1

QUERY(0.2332ms) - 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`=68 && `season_id`=105 LIMIT 0,1

QUERY(0.241ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=68 && `season_id`=105 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

QUERY(0.268ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='flag-football-7v7'

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

QUERY(0.1631ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1361ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.1781ms) - SELECT * FROM `league_notices` WHERE `league_id`=68 && `season_id`=105

QUERY(0.2229ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=68 && `season_id`=105

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

QUERY(0.1669ms) - SELECT `game_term`,`game_terms` FROM `sports` WHERE `sport_id`=2

QUERY(0.262ms) - SELECT `comeswith` FROM `league_custom_content` WHERE `league_id`=68 && `season_id`=105

QUERY(0.9379ms) - 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` = '68' and `league_updates`.`season_id` = '105'

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

QUERY(0.258ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=68 && `season_id`=105

QUERY(0.1998ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=68 && `season_id`=105

QUERY(0.2599ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=68 && `season_id`=105

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

QUERY(0.2899ms) - SELECT SQL_CACHE `code` FROM `page_footers` WHERE (`domain`=1||domain_global=1) && (`include` LIKE '%:27:%' || (`global`=1 && `exclude` NOT LIKE '%:27:%') ) ORDER BY `id` ASC