Now Registering
(See All Leagues) (See All Tournaments)

2024 Miken/Easton/Worth Series
Jacksonville, FL

Director: Sports Drafts LLC

Registration Info
Gastonia Slowpitch
Gastonia, NC

Director: League Joe

Registration Info
Myrtle Beach
Myrtle Beach, SC

Director: League Joe

Registration Info
Gastonia Slowpitch
Gastonia, NC

Director: League Joe

Registration Info
Pensacola Slowpitch Draft League
Pensacola, FL

Director: League Joe

Registration Info
League Jane Ultra Draft
Indianapolis, IN

Director: League Joe

Registration Info
Gin & Juice Draft Tourney
Myrtle Beach, SC

Director: Gin & Juice

Registration Info
Midwest
Indianapolis, IN

Director: League Joe

Registration Info
ISP Southside Draft League
Indianapolis, IN

Director: Indianapolis Sports Park

Registration Info
2024 Miken/Easton/Worth Series
Dalton, GA

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Perris, CA

Director: Sports Drafts LLC

Registration Info
Chase for the Chaos Cup
Pensacola, FL

Director: League Joe

Registration Info
Myrtle Beach USSSA
Myrtle Beach, SC

Director: South Carolina Softball

Registration Info
2024 Miken/Easton/Worth Series
Albuquerque, NM

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Bridgeton, MO

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Anchorage, AK

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Altamonte Springs, FL

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Auburn, AL

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Broken Arrow, OK

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Harrison, OH

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Waipahu, HI

Director: Sports Drafts LLC

Registration Info
Indianapolis Ultra Draft
Indianapolis, IN

Director: League Joe

Registration Info
2024 Miken/Easton/Worth Series
Ocean City, MD

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Millington, TN

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Gilbert, AZ

Director: Sports Drafts LLC

Registration Info
2024 Miken/Easton/Worth Series
Valdosta, GA

Director: Sports Drafts LLC

Registration Info

Upcoming and Active Leagues

NameDatesLocationGenderCompany

Myrtle Beach
Spring 2024

Softball

Myrtle Beach, SC Coed

Midwest
Spring 2024

Softball
Indianapolis, IN Coed

Upcoming and Active Tournaments

NameDatesLocationGenderCompany

Debug Information


Request Variables

view_var =

view_varb =

view_varc =

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: 89cb7acddaf4a600b6f141247765b545

Login Type:

Page ID: 5

Page ID:: 5

Page Template:: lj

Template Layout:: default

Headers: : Loading page header code

Active Blocks: Array ( [0] => [1] => 1 [2] => [3] => 1 [4] => 1 [5] => [6] => [7] => [8] => [9] => [10] => )

Block Types: Array ( [0] => [1] => Array ( [0] => module ) [2] => [3] => Array ( [0] => module [1] => module ) [4] => Array ( [0] => module ) [5] => [6] => [7] => [8] => [9] => [10] => )

Element ID: Array ( [0] => [1] => Array ( [0] => 3 ) [2] => [3] => Array ( [0] => 10 [1] => 21 ) [4] => Array ( [0] => 2 ) [5] => [6] => [7] => [8] => [9] => [10] => )

Admin Login Level: :

Admin Login Level: :

Admin Login Level: :

Admin Login Level: :

Footer: : Loading page footer code


Session Variables

securetoken = 89cb7acddaf4a600b6f141247765b545


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /
QUERY_STRING =
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REMOTE_PORT = 41033
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 = 162.248.190.150
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_BN_CLIENT_PORT = 57100
HTTP_ACCEPT_ENCODING = br,gzip
HTTP_IF_MODIFIED_SINCE = Sun, 03 Dec 2023 13:06:30 GMT
HTTP_ACCEPT_LANGUAGE = en-US,en;q=0.5
HTTP_ACCEPT = text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_USER_AGENT = CCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_X_FORWARDED_PORT = 443
HTTP_X_FORWARDED_SSL = off
HTTP_X_FORWARDED_PROTO = https
HTTP_X_FORWARDED_FOR = 3.237.34.21, 3.237.34.21
HTTP_X_REAL_IP = 3.237.34.21
HTTP_CONNECTION = close
HTTP_HOST = netstuffersdev1.com
proxy-nokeepalive = 1
HTTPS = on
UNIQUE_ID = ZeIA9q3xLVUufT1xdr@EsAAAANM
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1709310198.8414
REQUEST_TIME = 1709310198


SQL Queries


Total Queries: 37
Total Execution Time: 26.4464ms
Avg Execution Time:0.71476756756757ms

QUERY(6.279ms) - 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-03-01', '16:23:18', 'GET', '/', '3.237.34.21, 3.237.34.21', '' ,'CCBot/2.0 (https://commoncrawl.org/faq/)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhempNZEJyR0FoUlBVSTdHclU4OTVmSnkrSGE0WC9hU1Zta3RzN3NqQ2ZiOG5LN0VISVI3VGx1MFpXbjZlSjdvcDJQWStacUM4aWtnVC9GcHRZc1c1d1U=','0','','1709310198') ON DUPLICATE KEY UPDATE `ip`=`ip`

QUERY(0.721ms) - SELECT SQL_CACHE `end_timestamp` FROM `security_locks` WHERE ((`who`='3.237.34.21, 3.237.34.21' && `which`='IP'))

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

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

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

QUERY(0.19ms) - SELECT * FROM userprofiles_config

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

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

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

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

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

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

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

QUERY(0.2301ms) - SELECT * FROM tickers_config

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

QUERY(0.2019ms) - SELECT SQL_CACHE * FROM league_config

QUERY(1.951ms) - 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-02-27 16:23:18' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(4.8249ms) - SELECT SQL_CACHE `leagues`.`tournament`,`leagues`.`ultra`,`leagues`.`featured`,`leagues`.`league_id`,`leagues`.`name`,`leagues`.`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`.`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`,`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`,(SELECT COUNT(*) FROM `league_teams` WHERE `league_id`=`leagues`.`league_id`) AS `teams`,(SELECT COUNT(*) FROM `league_players` WHERE `league_id`=`leagues`.`league_id`) AS `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-02-27 16:23:18' 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,32

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

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

QUERY(0.165ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1512ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1571ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.977ms) - 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`.`end_date` >= '2024-02-27 16:23:18' and `leagues`.`tournament` = '0' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(2.2829ms) - SELECT SQL_CACHE `leagues`.`tournament`,`leagues`.`ultra`,`leagues`.`featured`,`leagues`.`league_id`,`leagues`.`name`,`leagues`.`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`.`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`,`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`,(SELECT COUNT(*) FROM `league_teams` WHERE `league_id`=`leagues`.`league_id`) AS `teams`,(SELECT COUNT(*) FROM `league_players` WHERE `league_id`=`leagues`.`league_id`) AS `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`.`end_date` >= '2024-02-27 16:23:18' and `leagues`.`tournament` = '0' 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,1000

QUERY(0.8218ms) - 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`.`end_date` >= '2024-02-27 16:23:18' and `leagues`.`tournament` = '1' and ( `league_seasons`.`public` = '1' and `league_seasons`.`cancelled` = '0' and `league_seasons`.`active` = '1' and `league_seasons`.`listed` = '1')

QUERY(2.331ms) - SELECT SQL_CACHE `leagues`.`tournament`,`leagues`.`ultra`,`leagues`.`featured`,`leagues`.`league_id`,`leagues`.`name`,`leagues`.`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`.`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`,`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`,(SELECT COUNT(*) FROM `league_teams` WHERE `league_id`=`leagues`.`league_id`) AS `teams`,(SELECT COUNT(*) FROM `league_players` WHERE `league_id`=`leagues`.`league_id`) AS `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`.`end_date` >= '2024-02-27 16:23:18' and `leagues`.`tournament` = '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,1000

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

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

QUERY(0.232ms) - SELECT SQL_CACHE * FROM company_config

QUERY(0.257ms) - SELECT SQL_CACHE `company`.*,`ponwhite`.`img_url` AS `logo_onwhite`,`photo`.`img_url` AS `logo` FROM `company` LEFT JOIN `photo` AS `ponwhite` ON (`company`.`logo_id` = `ponwhite`.`photo_id`) LEFT JOIN `photo` ON (`company`.`logo_id` = `photo`.`photo_id`) WHERE `company`.`company_id` = '1'

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

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

QUERY(0.3362ms) - SELECT * FROM columnmod WHERE `exclude` NOT LIKE '%:5:%' && (`linking`='/' || `include` LIKE '%:5:%'|| (`global`='1' && `exclude` NOT LIKE '%:5:%') ) ORDER BY `order`

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