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

RKO

Visit Team Page

Champion of Gin & Juice Draft Tourney - Raleigh - Sept 2023
10/01/2023

Team Unseen

Visit Team Page

Runner Up of Gin & Juice Draft Tourney - Raleigh - Sept 2023
10/01/2023

New Orleans Ultra Draft

King Cake 2025

Softball

Visit League Page

Suncoast Senior Draft

40+ Seniors March 2025

Softball

Visit League Page

Gin & Juice Draft Tourney

Seniors Family Draft - Spring 2025

Softball

Visit League Page

Gin & Juice Draft Tourney

Showcase Draft - Spring 2025

Softball

Visit League Page

Gin & Juice Draft Tourney

Myrtle Beach - Spring 2025

Softball

Visit League Page

She's Gin. He's Juice. And together?
We're ALL Family

Welcome to the Gin & Juice Family Draft where we welcome players of all skills, shapes, and sizes. If you're looking for a FUN-FIRST tournament experience where you can meet new players and make new friends, come join the Gin & Juice Family!

Softball Drafts are no new thing for this duo, this will be their 5th draft style tournament. Daryl (Juice) is a well-respected long time USSSA umpire and tournament director. The Gin & Juice Draft is taking this valuable experience and mixing things up a little! Working together with the League Joe draft system will ensure parity with a LIVE DRAFT and other great changes.

Each team has a hand-picked coach to help make sure everyone has a fun experience. All teams are purposefully balanced. This system will make sure every team has a shot at winning!

Couples CAN stay together (not mandatory, but an option)! Stick with your sweetie or your bestie and you will be drafted together.

Contact Organizer

United States Specialty Sports Association

PEAK MEMORY: 9.46 MiB
MEMORY USAGE AFTER: 6.63 MiB

Debug Information

Request Variables

var = tournament

varb = gin-juice-draft-tourney

varc = raleigh-sept-2023

vara =

vard =

vare =

view_var = tournament

view_varb = gin-juice-draft-tourney

view_varc = raleigh-sept-2023

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: 05c835f080408e5520883d752f85fd18

Login Type:

BASE:: tournament

FULL LINK:: tournament/gin-juice-draft-tourney/raleigh-sept-2023

Page ID: 40

Page ID:: 40

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 = 05c835f080408e5520883d752f85fd18
fullstate =

Cookie Variables

Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /tournament/gin-juice-draft-tourney/raleigh-sept-2023/
QUERY_STRING = var=tournament&varb=gin-juice-draft-tourney&varc=raleigh-sept-2023
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=tournament&varb=gin-juice-draft-tourney&varc=raleigh-sept-2023
REDIRECT_URL = /tournament/gin-juice-draft-tourney/raleigh-sept-2023/
REMOTE_PORT = 57203
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 = 13.58.232.94
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/tournament/gin-juice-draft-tourney/raleigh-sept-2023
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/tournament/gin-juice-draft-tourney/raleigh-sept-2023/
SCRIPT_URL = /tournament/gin-juice-draft-tourney/raleigh-sept-2023/
UNIQUE_ID = Z26JlpNPJJ9hoP1KSOsNXQAAAIY
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/tournament/gin-juice-draft-tourney/raleigh-sept-2023/
REDIRECT_SCRIPT_URL = /tournament/gin-juice-draft-tourney/raleigh-sept-2023/
REDIRECT_UNIQUE_ID = Z26JlpNPJJ9hoP1KSOsNXQAAAIY
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1735297430.3476
REQUEST_TIME = 1735297430

SQL Queries

Total Queries: 101
Total Execution Time: 39.2594ms
Avg Execution Time:0.38870693069307ms

QUERY(1.7381ms) - 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-12-27', '11:03:50', 'GET', '/tournament/gin-juice-draft-tourney/raleigh-sept-2023/', '13.58.232.94', 'https://netstuffersdev1.com/tournament/gin-juice-draft-tourney/raleigh-sept-2023' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhenpTcm5sYkxWb3UyNTEyRG8zNlQydVk5N2EwejhOTXU5M1FKVlpTbWNZOEVZLy9NSWJqZ3dLbE5xTW9IL2NUeHNBUDd1cm1hYkgrcHRGcEhJZ2tPWk8=','0','','1735297430') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1762ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/tournament/gin-juice-draft-tourney/raleigh-sept-2023/'

QUERY(0.2542ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='tournament/gin-juice-draft-tourney/raleigh-sept-2023' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.1531ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.1872ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.6139ms) - SELECT SQL_CACHE `leagues`.*,`sports`.`name` AS `sport_name`,`sports`.`icon` AS `sport_icon`,`sports`.`name_url` AS `sport_url`,`photo`.`img_url`,`photo`.`photo_id` AS `league_logo_id`,`photo`.`thumb_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` = 'gin-juice-draft-tourney' LIMIT 0,1

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

QUERY(0.524ms) - SELECT SQL_CACHE `league_seasons`.*,`league_seasons`.`url` AS season_url,`photo`.`img_url`,`photo`.`thumb_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` = '91' and `league_seasons`.`url` = 'raleigh-sept-2023' ORDER BY `league_dates`.`start_date` ASC

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

QUERY(0.1521ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=142

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

QUERY(0.2449ms) - SELECT `photographers`,`payment_terms`,`payment_type`,`package_pricing`,`min_deposit`,`total_pay_required` FROM `league_custom_content` WHERE `league_id`=91 && `season_id`=142 LIMIT 0,1

QUERY(0.19ms) - 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`=91 && `season_id`=142 LIMIT 0,1

QUERY(0.205ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=91 && `season_id`=142 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

QUERY(0.2389ms) - SELECT SQL_CACHE * FROM `league_schedule_options` WHERE `league_id`='91' && `season_id`='142' LIMIT 0,1

QUERY(0.1888ms) - SELECT SQL_CACHE count(`company_id`) FROM `league_company_links` WHERE `league_id`='91' && (`season_id`='142' || `season_id`=0)

QUERY(0.21ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='91' && (`season_id`='142' || `season_id`=0)

QUERY(0.15ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=91 && `season_id`=0) || `season_id`='142'

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

QUERY(0.4399ms) - SELECT SQL_CACHE count(DISTINCT(`league_players`.`player_id`)) FROM `league_players` INNER JOIN `league_levels` ON `league_players`.`access`=`league_levels`.`level_id` WHERE `league_id`='91' && `season_id`='142' &&`league_players`.`access`=4 && `deleted`=0 && `alternate`=0

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

QUERY(0.221ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons_rules` WHERE `league_id`='91' || `season_id`='142' ORDER BY `season_id` DESC

QUERY(0.2191ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='91' && `season_id`='142'

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

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

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

QUERY(0.139ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=91&&`season_id`=142 LIMIT 0,1

QUERY(0.1738ms) - SELECT `game_id` FROM `games` WHERE `league_id`=91&&`season_id`=142&&`playoff`=1 LIMIT 0,1

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

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

QUERY(0.174ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='91' && `season_id`='142'

QUERY(0.19ms) - 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`='91' && `league_seasons`.`season_id`='142'

QUERY(0.15ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=91 && `season_id`=142 LIMIT 0,1

QUERY(0.109ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=91 && `season_id`=142

QUERY(1.343ms) - 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`,`companies`,`reg_is_open`,`updated`,`show_playoff_menu`) VALUES ('91','142','1',0,0,'124','10','12','7','10',0,0,0,'6',0,'2',0,'102',0,0,0,0,NOW(),0) ON DUPLICATE KEY UPDATE `league_id`='91',`season_id`='142',`articles`='1',`participants`=0,`conferences`=0,`players`='124',`coaches`='10',`subs`='12',`rules`='7',`teams`='10',`games`=0,`groups`=0,`divisions`=0,`seasons`='6',`sponsors`=0,`products`='2',`prizes`=0,`triumphs`='102',`hotels`=0,`is_full`=0,`companies`=0,`reg_is_open`=0,`updated`=NOW(),`show_playoff_menu`=0

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

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

QUERY(0.1421ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='America/Indianapolis'

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

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

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

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

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

QUERY(0.124ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1259ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='gin-juice-draft-tourney'

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

QUERY(0.102ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1149ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.118ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.139ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='91' && `season_id`='142' LIMIT 0,1

QUERY(0.133ms) - SELECT * FROM `league_notices` WHERE `league_id`=91 && `season_id`=142

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

QUERY(0.107ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.241ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=91 && `season_id`=142

QUERY(0.15ms) - SELECT * FROM `league_hotel_settings` WHERE `league_id`=91 && `season_id`=142

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

QUERY(0.114ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.262ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='91' && `season_id`='142' && `ranking`='1'

QUERY(2.938ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='142' && `finish_rank`=1 ORDER BY `date` DESC

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

QUERY(0.2379ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='91' && `season_id`='142' && `ranking`='2'

QUERY(2.3088ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='142' && `finish_rank`=2 ORDER BY `date` DESC

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

QUERY(0.2038ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='91' && `season_id`='142' && `ranking`='3'

QUERY(1.2641ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='142' && `finish_rank`=3 ORDER BY `date` DESC

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

QUERY(0.1929ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='91' && `season_id`='142' && `ranking`='4'

QUERY(0.88ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='142' && `finish_rank`=4 ORDER BY `date` DESC

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

QUERY(0.2141ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='91' && `season_id`='142' && `ranking`='5'

QUERY(0.6571ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='142' && `finish_rank`=5 ORDER BY `date` DESC

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

QUERY(0.1781ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='91' && `season_id`='142' && `ranking`='6'

QUERY(0.571ms) - SELECT `fullname`,`teams`.`url`,`triumphs_awarded`.*,`photo`.`img_url` FROM `triumphs_awarded` LEFT JOIN `photo` ON `picture_id`=`photo_id` INNER JOIN `teams` ON `triumphs_awarded`.`team_id`=`teams`.`team_id` WHERE `triumphs_awarded`.`season_id`='142' && `finish_rank`=6 ORDER BY `date` DESC

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

QUERY(0.8261ms) - SELECT COUNT(*) FROM `leagues` INNER JOIN `league_seasons` ON (`leagues`.`league_id` = `league_seasons`.`league_id`) INNER JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `season_photo` ON (`league_seasons`.`logo_id` = `season_photo`.`photo_id`) INNER JOIN `company` ON (`leagues`.`company_id` = `company`.`company_id`) INNER JOIN `photo` AS `company_photo` ON (`company`.`logo_onwhite` = `company_photo`.`photo_id`) LEFT JOIN `league_cache` ON (`league_seasons`.`season_id` = `league_cache`.`season_id`) INNER JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_dates`.`start_date` >= '2024-12-24 06:03:50' and `leagues`.`tournament` = '0' and `leagues`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(1.214ms) - SELECT SQL_CACHE `leagues`.`tournament`,`leagues`.`ultra`,`leagues`.`featured`,`leagues`.`league_id`,`leagues`.`name`,`leagues`.`name` AS league_name,`leagues`.`url`,`leagues`.`url` AS league_url,`leagues`.`games_per_round`,`leagues`.`approved`,`leagues`.`sport_id`,`leagues`.`gallery_id`,`leagues`.`max_teams`,`leagues`.`min_teams`,`leagues`.`max_players`,`leagues`.`owner_id`,`league_seasons`.`season_id`,`league_seasons`.`season_id` AS `sid`,`league_seasons`.`name` AS `season_name`,`league_seasons`.`url` AS `season_url`,`league_seasons`.`day_of_week`,`league_seasons`.`cancelled`,`league_seasons`.`public`,`league_seasons`.`soldout`,`league_seasons`.`gender`,`league_seasons`.`style`,`league_seasons`.`active`,`venues`.`venue_id`,`venues`.`name` AS `venue`,`venues`.`url` AS `venueurl`,`venues`.`city`,`venues`.`city` AS `venue_city`,`venues`.`state`,`venues`.`state` AS `venue_state`,`venues`.`fullstate`,`photo`.`img_url`,`photo`.`thumb_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_url`,`season_photo`.`thumb_url` AS `season_thumb_url`,`company`.`name` AS `company_name`,`company`.`url` AS `company_url`,`company_photo`.`img_url` AS `company_img_url`,`league_cache`.`reg_is_open`,`league_cache`.`teams`,`league_cache`.`players`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date` FROM `leagues` INNER JOIN `league_seasons` ON (`leagues`.`league_id` = `league_seasons`.`league_id`) INNER JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `season_photo` ON (`league_seasons`.`logo_id` = `season_photo`.`photo_id`) INNER JOIN `company` ON (`leagues`.`company_id` = `company`.`company_id`) INNER JOIN `photo` AS `company_photo` ON (`company`.`logo_onwhite` = `company_photo`.`photo_id`) LEFT JOIN `league_cache` ON (`league_seasons`.`season_id` = `league_cache`.`season_id`) INNER JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_dates`.`start_date` >= '2024-12-24 06:03:50' and `leagues`.`tournament` = '0' and `leagues`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1') GROUP BY `league_seasons`.`season_id` ORDER BY `league_dates`.`start_date` asc LIMIT 0,6

QUERY(0.7131ms) - SELECT COUNT(*) FROM `leagues` INNER JOIN `league_seasons` ON (`leagues`.`league_id` = `league_seasons`.`league_id`) INNER JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `season_photo` ON (`league_seasons`.`logo_id` = `season_photo`.`photo_id`) INNER JOIN `company` ON (`leagues`.`company_id` = `company`.`company_id`) INNER JOIN `photo` AS `company_photo` ON (`company`.`logo_onwhite` = `company_photo`.`photo_id`) LEFT JOIN `league_cache` ON (`league_seasons`.`season_id` = `league_cache`.`season_id`) INNER JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_dates`.`start_date` >= '2024-12-24 06:03:50' and `leagues`.`tournament` = '1' and `leagues`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(1.528ms) - SELECT SQL_CACHE `leagues`.`tournament`,`leagues`.`ultra`,`leagues`.`featured`,`leagues`.`league_id`,`leagues`.`name`,`leagues`.`name` AS league_name,`leagues`.`url`,`leagues`.`url` AS league_url,`leagues`.`games_per_round`,`leagues`.`approved`,`leagues`.`sport_id`,`leagues`.`gallery_id`,`leagues`.`max_teams`,`leagues`.`min_teams`,`leagues`.`max_players`,`leagues`.`owner_id`,`league_seasons`.`season_id`,`league_seasons`.`season_id` AS `sid`,`league_seasons`.`name` AS `season_name`,`league_seasons`.`url` AS `season_url`,`league_seasons`.`day_of_week`,`league_seasons`.`cancelled`,`league_seasons`.`public`,`league_seasons`.`soldout`,`league_seasons`.`gender`,`league_seasons`.`style`,`league_seasons`.`active`,`venues`.`venue_id`,`venues`.`name` AS `venue`,`venues`.`url` AS `venueurl`,`venues`.`city`,`venues`.`city` AS `venue_city`,`venues`.`state`,`venues`.`state` AS `venue_state`,`venues`.`fullstate`,`photo`.`img_url`,`photo`.`thumb_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_url`,`season_photo`.`thumb_url` AS `season_thumb_url`,`company`.`name` AS `company_name`,`company`.`url` AS `company_url`,`company_photo`.`img_url` AS `company_img_url`,`league_cache`.`reg_is_open`,`league_cache`.`teams`,`league_cache`.`players`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date` FROM `leagues` INNER JOIN `league_seasons` ON (`leagues`.`league_id` = `league_seasons`.`league_id`) INNER JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `photo` ON (`leagues`.`logo_id` = `photo`.`photo_id`) INNER JOIN `sports` ON (`leagues`.`sport_id` = `sports`.`sport_id`) LEFT JOIN `photo` AS `season_photo` ON (`league_seasons`.`logo_id` = `season_photo`.`photo_id`) INNER JOIN `company` ON (`leagues`.`company_id` = `company`.`company_id`) INNER JOIN `photo` AS `company_photo` ON (`company`.`logo_onwhite` = `company_photo`.`photo_id`) LEFT JOIN `league_cache` ON (`league_seasons`.`season_id` = `league_cache`.`season_id`) INNER JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_dates`.`start_date` >= '2024-12-24 06:03:50' and `leagues`.`tournament` = '1' and `leagues`.`featured` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1') GROUP BY `league_seasons`.`season_id` ORDER BY `league_dates`.`start_date` asc LIMIT 0,6

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

QUERY(0.1361ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=284

QUERY(0.1462ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=328

QUERY(0.1838ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=326

QUERY(0.1309ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=325

QUERY(0.1352ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=320

QUERY(0.18ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=91 && `season_id`=142

QUERY(0.175ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=91 && `season_id`=142

QUERY(0.1628ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=91 && `season_id`=142

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

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

QUERY(0.2489ms) - SELECT SQL_CACHE `code`,`name` FROM `page_footers` WHERE (`domain`=1||domain_global=1) && (`include` LIKE '%:40:%' || (`global`=1 && `exclude` NOT LIKE '%:40:%') ) ORDER BY `sort` ASC

Gin & Juice Draft Tourney

Results

RKO

Team Unseen

Upcoming Tournaments of Interest

New Orleans Ultra Draft

Suncoast Senior Draft

Gin & Juice Draft Tourney

Gin & Juice Draft Tourney

Gin & Juice Draft Tourney

Description

She's Gin. He's Juice. And together?
We're ALL Family

Event Operator

Ruleset

Debug Information

Request Variables

Debug Messages

Session Variables

Cookie Variables

Server Variables

SQL Queries

Total Queries: 101
Total Execution Time: 39.2594ms
Avg Execution Time:0.38870693069307ms

Gin & Juice Draft Tourney

Results

RKO

Team Unseen

Upcoming Tournaments of Interest

New Orleans Ultra Draft

Suncoast Senior Draft

Gin & Juice Draft Tourney

Gin & Juice Draft Tourney

Gin & Juice Draft Tourney

She's Gin. He's Juice. And together? We're ALL Family

Event Operator

Ruleset

Help

How do Draft Leagues Work?

Player Profile

Draft Party

Season Format

Debug Information

Request Variables

Debug Messages

Session Variables

Cookie Variables

Server Variables

SQL Queries

Total Queries: 101Total Execution Time: 39.2594msAvg Execution Time:0.38870693069307ms

She's Gin. He's Juice. And together?
We're ALL Family

Total Queries: 101
Total Execution Time: 39.2594ms
Avg Execution Time:0.38870693069307ms