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

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!

Daryl (Juice) is a well-respected long time USSSA umpire and director. Ginger (Gin) is known for being EXTRA and brings it all together. Softball Drafts are no new thing for this duo, this will be their 7th draft style tournament. This will be the 3rd time working with the League Joe draft system and a lot was learned from the first one! The system will ensure parity and includes a LIVE DRAFT for the coaches.

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.49 MiB
MEMORY USAGE AFTER: 6.68 MiB

Debug Information

Request Variables

var = tournament

varb = gin-juice-draft-tourney

varc = raleigh-fall-24

vara =

vard =

vare =

view_var = tournament

view_varb = gin-juice-draft-tourney

view_varc = raleigh-fall-24

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: d641468bf865616364688efbc4d8183b

Login Type:

BASE:: tournament

FULL LINK:: tournament/gin-juice-draft-tourney/raleigh-fall-24

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 = d641468bf865616364688efbc4d8183b
fullstate =

Cookie Variables

fikker-InIR-Qh5V = mbyZOTi0cx3R3LgZidkBShUMQdqPNMmO

Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /tournament/gin-juice-draft-tourney/raleigh-fall-24/
QUERY_STRING = var=tournament&varb=gin-juice-draft-tourney&varc=raleigh-fall-24
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-fall-24
REDIRECT_URL = /tournament/gin-juice-draft-tourney/raleigh-fall-24/
REMOTE_PORT = 9048
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.141.19.115
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-fall-24
HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
HTTP_COOKIE = fikker-InIR-Qh5V=mbyZOTi0cx3R3LgZidkBShUMQdqPNMmO
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-fall-24/
SCRIPT_URL = /tournament/gin-juice-draft-tourney/raleigh-fall-24/
UNIQUE_ID = Z298ayahBlEYsO0wJl@MigAAANU
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/tournament/gin-juice-draft-tourney/raleigh-fall-24/
REDIRECT_SCRIPT_URL = /tournament/gin-juice-draft-tourney/raleigh-fall-24/
REDIRECT_UNIQUE_ID = Z298ayahBlEYsO0wJl@MigAAANU
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1735359595.2189
REQUEST_TIME = 1735359595

SQL Queries

Total Queries: 82
Total Execution Time: 27.2386ms
Avg Execution Time:0.33217804878049ms

QUERY(1.5099ms) - 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-28', '04:19:55', 'GET', '/tournament/gin-juice-draft-tourney/raleigh-fall-24/', '3.141.19.115', 'https://netstuffersdev1.com/tournament/gin-juice-draft-tourney/raleigh-fall-24' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhd3pmNWx3YVViRXlvRkVLa1k5RS9zWVpvcFNvTDFoN3ZCbzRBWXpiODkzRmkyWit6S095TEJoRndaUzY4eHNjTjFaaUNVOFpOWmtZT2xSUHpCNnBlaVU=','0','','1735359595') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1478ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/tournament/gin-juice-draft-tourney/raleigh-fall-24/'

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

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

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

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

QUERY(0.133ms) - SELECT * FROM userprofiles_config

QUERY(0.1829ms) - 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.1991ms) - SELECT COUNT(*),version FROM modules WHERE `codename`='league'

QUERY(0.1318ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.5109ms) - 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-fall-24' ORDER BY `league_dates`.`start_date` ASC

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

QUERY(0.16ms) - SELECT COUNT(order_id) FROM products_purchased WHERE season_id=255

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

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

QUERY(0.174ms) - 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`=255 LIMIT 0,1

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

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

QUERY(0.252ms) - 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.119ms) - SELECT `offset` FROM `zone` WHERE `zone_name`='America/Indianapolis'

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

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

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

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

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

QUERY(0.1099ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

QUERY(0.103ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.0951ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.108ms) - SELECT SQL_CACHE * FROM teams_config

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

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

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

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

QUERY(0.0999ms) - SELECT SQL_CACHE * FROM league_config

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

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

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

QUERY(0.1121ms) - SELECT SQL_CACHE * FROM teams_config

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

QUERY(2.986ms) - 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`='255' && `finish_rank`=1 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`='1'

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

QUERY(2.3179ms) - 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`='255' && `finish_rank`=2 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.1891ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='91' && `season_id`='255' && `ranking`='3'

QUERY(1.2238ms) - 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`='255' && `finish_rank`=3 ORDER BY `date` DESC

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

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

QUERY(0.8631ms) - 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`='255' && `finish_rank`=4 ORDER BY `date` DESC

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

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

QUERY(0.6559ms) - 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`='255' && `finish_rank`=5 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.1841ms) - SELECT `accomplishment_id` FROM `league_results` WHERE `league_id`='91' && `season_id`='255' && `ranking`='6'

QUERY(0.5319ms) - 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`='255' && `finish_rank`=6 ORDER BY `date` DESC

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

QUERY(0.741ms) - 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 23:19:55' 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.1771ms) - 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 23:19:55' 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.7122ms) - 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 23:19:55' 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.3249ms) - 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 23:19:55' 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.1318ms) - 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 COUNT(order_id) FROM products_purchased WHERE season_id=284

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

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

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

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

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

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

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

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

QUERY(0.154ms) - 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.248ms) - SELECT SQL_CACHE `name`,`moreinfo`,`img_url` FROM `league_sponsors` INNER JOIN `photo` ON `logo_id`=`photo_id` WHERE `season_id`='255' || `league_id`='91' GROUP BY `league_sponsors`.`name`

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

YEET

The Other Side

Out of Control!

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: 82
Total Execution Time: 27.2386ms
Avg Execution Time:0.33217804878049ms

Gin & Juice Draft Tourney

Results

YEET

The Other Side

Out of Control!

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: 82Total Execution Time: 27.2386msAvg Execution Time:0.33217804878049ms

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

Total Queries: 82
Total Execution Time: 27.2386ms
Avg Execution Time:0.33217804878049ms