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

2024 Miken/Easton/Worth Series

Valdosta 2024

Softball

Visit League Page

Myrtle Beach USSSA

Island of Misfit Toys Draft 2024

Softball

Visit League Page

New Orleans Ultra Draft

King Cake 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: 3.09 MiB
MEMORY USAGE AFTER: 1.29 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: 7263e2ec234c17531a3e59ed930b835f

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 = 7263e2ec234c17531a3e59ed930b835f
fullstate =
refer_params = https://netstuffersdev1.com/profile/kalani540/skills/

Cookie Variables

care_did = 4aa82947-1679-4046-bfbc-da2f159cf3b3
PHPSESSID = 76rvvmb1bti2cudto8vmv3g5og

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 = 19292
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.116.86.160
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_COOKIE = care_did=4aa82947-1679-4046-bfbc-da2f159cf3b3; PHPSESSID=76rvvmb1bti2cudto8vmv3g5og
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 = Zz@z0R6VT6CzUk2o3Z1KigAAANQ
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 = Zz@z0R6VT6CzUk2o3Z1KigAAANQ
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1732228049.3061
REQUEST_TIME = 1732228049

SQL Queries

Total Queries: 95
Total Execution Time: 37.7753ms
Avg Execution Time:0.39763473684211ms

QUERY(1.636ms) - 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-11-21', '22:27:29', 'GET', '/tournament/gin-juice-draft-tourney/raleigh-sept-2023/', '18.116.86.160', '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)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheGN5S3pyQ1ZpVjZqb2JObEQ2UUN3L2QxQVdnVXRSWjQway8zdlFUTjc2SEE1RER4blQzRjZZRktPSmdOL0l6NG1zdGZpekFCUXNXRGVSclREMS9qWmIrNlhpUFQyWjF4TEh6SnVGcy9QMjJYMThoUGpFNXJ1aXdJUUNyY2VFS0ROREU2bHpLdytHQ0l1TDFRQ0xXd1pLcmU2cXhkeE1CYUJnYnc1bDBBdjZ2QWRtbERIcGs5RDkzZzd3eUJZU0UzNGhZY3dmaWhHQUZkK0NiOVBGZHVqMXp6Q014SkZxSUg4am50MTRreGs1bVE9PQ==','0','','1732228049') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

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

QUERY(0.2718ms) - 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.2601ms) - SELECT SQL_CACHE `id`,`layout`,`light`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='tournament' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

QUERY(0.1512ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.1411ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.5209ms) - SELECT SQL_CACHE `league_seasons`.*,`league_seasons`.`url` AS season_url,`photo`.`img_url`,`venues`.`name` AS `venue`,`venues`.`city`,`venues`.`state`,`league_dates`.`reg_date`,`league_dates`.`reg_end_date`,`league_dates`.`start_date`,`league_dates`.`end_date`,`league_dates`.`draft_date`,`league_dates`.`manual_date_display` FROM `league_seasons` LEFT JOIN `photo` ON (`league_seasons`.`logo_id` = `photo`.`photo_id`) LEFT JOIN `venues` ON (`league_seasons`.`venue_id` = `venues`.`venue_id`) LEFT JOIN `league_dates` ON (`league_seasons`.`season_id` = `league_dates`.`season_id`) WHERE `league_seasons`.`league_id` = '91' and `league_seasons`.`url` = 'raleigh-sept-2023' ORDER BY `league_dates`.`start_date` ASC

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

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

QUERY(0.159ms) - 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.2191ms) - 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.2301ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=91 && `season_id`=142 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

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

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

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

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

QUERY(2.1942ms) - 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.4139ms) - 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_players`.`access`=4 && `deleted`=0 && `alternate`=0

QUERY(1.6401ms) - 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.2179ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons_rules` WHERE `league_id`='91' || `season_id`='142' ORDER BY `season_id` DESC

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

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

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

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

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

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

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

QUERY(0.366ms) - 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.1991ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='91' && `season_id`='142'

QUERY(0.2232ms) - 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.1349ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=91 && `season_id`=142 LIMIT 0,1

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

QUERY(1.0691ms) - 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','3','10',0,0,0,'3',0,'2',0,'65',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`='3',`teams`='10',`games`=0,`groups`=0,`divisions`=0,`seasons`='3',`sponsors`=0,`products`='2',`prizes`=0,`triumphs`='65',`hotels`=0,`is_full`=0,`companies`=0,`reg_is_open`=0,`updated`=NOW(),`show_playoff_menu`=0

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

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

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

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

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

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

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

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

QUERY(0.1359ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

QUERY(0.1218ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1171ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.114ms) - SELECT SQL_CACHE * FROM teams_config

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

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

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

QUERY(0.1049ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

QUERY(0.14ms) - SELECT SQL_CACHE * FROM teams_config

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

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

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

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

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

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

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

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

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

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

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

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

QUERY(0.849ms) - 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-11-18 17:27:29' 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.1842ms) - 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`.`state`,`venues`.`fullstate`,`photo`.`img_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_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-11-18 17:27:29' 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.711ms) - 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-11-18 17:27:29' 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.276ms) - 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`.`state`,`venues`.`fullstate`,`photo`.`img_url`,`sports`.`name` AS `sport`,`sports`.`icon`,`sports`.`name_url` AS `sport_url`,`season_photo`.`img_url` AS `season_img_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-11-18 17:27:29' 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.175ms) - SELECT SQL_CACHE `name`,`img_url` FROM `sports` INNER JOIN `photo` ON `sports`.`logo_id`=`photo`.`photo_id` WHERE `sport_id`=1

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

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

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

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

QUERY(0.19ms) - 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.2611ms) - SELECT SQL_CACHE `code` FROM `page_footers` WHERE (`domain`=1||domain_global=1) && (`include` LIKE '%:40:%' || (`global`=1 && `exclude` NOT LIKE '%:40:%') ) ORDER BY `id` ASC

Gin & Juice Draft Tourney

Results

RKO

Team Unseen

Upcoming Tournaments of Interest

2024 Miken/Easton/Worth Series

Myrtle Beach USSSA

New Orleans Ultra Draft

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: 95
Total Execution Time: 37.7753ms
Avg Execution Time:0.39763473684211ms

Gin & Juice Draft Tourney

Results

RKO

Team Unseen

Upcoming Tournaments of Interest

2024 Miken/Easton/Worth Series

Myrtle Beach USSSA

New Orleans Ultra Draft

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: 95Total Execution Time: 37.7753msAvg Execution Time:0.39763473684211ms

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

Total Queries: 95
Total Execution Time: 37.7753ms
Avg Execution Time:0.39763473684211ms