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

Join as Alternate

Registration Details

Dates	Cost	Guaranteed Min Games
Oct 26, 202410/26/24	Multiple Play Packages Available Starting at $35.00	4	View Package Options

Helpful Links:

Full Day of Spooky Good Times

Come out for the ball, stay for the party! The Spooktacular Ultra Draft is a one day tournament where we celebrate the best holiday of the year with costumes, prizes, and a trip to the Pickle to hang out in the evening!

Game Schedule

First game will occur in the mid-morning, giving everyone time to suit up and head to the fields. Before the evening is over, we'll have played a four game guarantee tournament that ends around dinner time. After that, we head out to the local watering hole to celebrate a day of ball.

Preliminary Schedule

Player Draft - 9:00am (at the fields)
First Game - 10:00am
Championship Game - 7-ish
After Party at the Pickle - 9pm+

Official After Party - The Pickle Bar & Bistro

103 N Holland St, Dallas, NC 28034

Keep those costumes on and get ready to party at The Pickle Bar & Bistro. They have their official Halloween Party that same night, including cash prizes for their own costume contest!

Win Bats, Fielding Gloves, and More!

Think up a great costume and show up ready to look good, play good! Prizes for costumes include brand new bats and fielding gloves! Plus, one random player will receive their choice of a bat or fielding glove.

Individual and Team Prize List

UPDATE
Smitty
October 21, 2024

Spooktacular Gastonia Update

The Spooktacular is just a few days away, and we hope everyone is getting their costumes ready. If you're reading this email right now and haven't finished signing up, get in today!

Win Bats, Free Leagues, and More for Best Costumes

We weren't kidding when we said we wanted to see y'all dress up, but we'll show you how serious we are by giving out a FREE BAT to the best costume in the tournament! Additionally, we'll have extra door prizes for snazzy dressers and a FREE LEAGUE to the best costume that is worn through the entire event. You gotta look good on and off the field after all, right?

Weekend Prize List

Get Drafted LIVE On Saturday

We will kick off the event on Saturday morning at 9am at the fields, where we will have our coaches draft the players LIVE! Come hang out, meet the other players, and find out in person where you'll be playing for the day. Play will kick off starting around 10am and the full schedule will be published soon. Player kits and jerseys will also be picked up on Saturday morning before play begins.

After Party at the Pickle

The tournament will end in the evening, but you gotta get maximum mileage out of those costumes, right? So join us at the Pickle Bistro for our official After Party. The Pickle will have their own costume contest as well, with cash prizes and more!

Continue Reading

League Joe

Contact Organizer

PEAK MEMORY: 5.58 MiB
MEMORY USAGE AFTER: 4.61 MiB

Debug Information

Request Variables

var = tournament

varb = gastonia-ultra-draft

varc = spooktacular-ultra-draft

vara =

vard =

vare =

view_var = tournament

view_varb = gastonia-ultra-draft

view_varc = spooktacular-ultra-draft

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: a92e4f6201a43fc98881c178da20f717

Login Type:

BASE:: tournament

FULL LINK:: tournament/gastonia-ultra-draft/spooktacular-ultra-draft

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

Cookie Variables

USER_CITY = sh

Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
QUERY_STRING = var=tournament&varb=gastonia-ultra-draft&varc=spooktacular-ultra-draft
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=tournament&varb=gastonia-ultra-draft&varc=spooktacular-ultra-draft
REDIRECT_URL = /tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
REMOTE_PORT = 41470
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.16.82.182
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/gastonia-ultra-draft/spooktacular-ultra-draft
HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
HTTP_COOKIE = USER_CITY=sh
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/gastonia-ultra-draft/spooktacular-ultra-draft/
SCRIPT_URL = /tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
UNIQUE_ID = Zz90Be9urvFP-X@yUD1YAAAAAIE
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
REDIRECT_SCRIPT_URL = /tournament/gastonia-ultra-draft/spooktacular-ultra-draft/
REDIRECT_UNIQUE_ID = Zz90Be9urvFP-X@yUD1YAAAAAIE
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1732211717.8352
REQUEST_TIME = 1732211717

SQL Queries

Total Queries: 81
Total Execution Time: 26.0681ms
Avg Execution Time:0.32182839506173ms

QUERY(1.451ms) - 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', '17:55:17', 'GET', '/tournament/gastonia-ultra-draft/spooktacular-ultra-draft/', '3.16.82.182', 'https://netstuffersdev1.com/tournament/gastonia-ultra-draft/spooktacular-ultra-draft' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZheG9ORUQwODU1UzNacE9YL1kvL2o1bWVDdC8xUWpsdG9QWHVxOGswQUVndDEyYkV4NHY3UG9vei9oZTlXQUdGSEh5NVhYY1U2T2FoZ2ZCQk1YSUljZFY=','0','','1732211717') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1619ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/tournament/gastonia-ultra-draft/spooktacular-ultra-draft/'

QUERY(0.258ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='tournament/gastonia-ultra-draft/spooktacular-ultra-draft' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.15ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.123ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.5081ms) - 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` = 'gastonia-ultra-draft' LIMIT 0,1

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

QUERY(0.5291ms) - 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` = '137' and `league_seasons`.`url` = 'spooktacular-ultra-draft' ORDER BY `league_dates`.`start_date` ASC

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

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

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

QUERY(0.164ms) - 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`=137 && `season_id`=288 LIMIT 0,1

QUERY(0.212ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=137 && `season_id`=288 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

QUERY(0.216ms) - SELECT SQL_CACHE * FROM `league_schedule_options` WHERE `league_id`='137' && `season_id`='288' LIMIT 0,1

QUERY(0.2439ms) - SELECT SQL_CACHE count(`company_id`) FROM `league_company_links` WHERE `league_id`='137' && (`season_id`='288' || `season_id`=0)

QUERY(0.2451ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='137' && (`season_id`='288' || `season_id`=0)

QUERY(0.1779ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=137 && `season_id`=0) || `season_id`='288'

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

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

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

QUERY(1.106ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons_rules` WHERE `league_id`='137' || `season_id`='288' ORDER BY `season_id` DESC

QUERY(0.17ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='137' && `season_id`='288'

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

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

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

QUERY(0.1681ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=137&&`season_id`=288 LIMIT 0,1

QUERY(0.253ms) - SELECT `game_id` FROM `games` WHERE `league_id`=137&&`season_id`=288&&`playoff`=1 LIMIT 0,1

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

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

QUERY(0.2301ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='137' && `season_id`='288'

QUERY(0.1929ms) - 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`='137' && `league_seasons`.`season_id`='288'

QUERY(0.1249ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=137 && `season_id`=288 LIMIT 0,1

QUERY(0.128ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=137 && `season_id`=288

QUERY(1.194ms) - 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 ('137','288','1',0,0,'70','6','1',0,'5',0,0,0,'3',0,'1','1',0,0,0,0,0,NOW(),0) ON DUPLICATE KEY UPDATE `league_id`='137',`season_id`='288',`articles`='1',`participants`=0,`conferences`=0,`players`='70',`coaches`='6',`subs`='1',`rules`=0,`teams`='5',`games`=0,`groups`=0,`divisions`=0,`seasons`='3',`sponsors`=0,`products`='1',`prizes`='1',`triumphs`=0,`hotels`=0,`is_full`=0,`companies`=0,`reg_is_open`=0,`updated`=NOW(),`show_playoff_menu`=0

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

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

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

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

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

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

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

QUERY(0.1481ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.17ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='gastonia-ultra-draft'

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

QUERY(0.138ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1268ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.181ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.1631ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='137' && `season_id`='288' LIMIT 0,1

QUERY(0.1519ms) - SELECT * FROM `league_notices` WHERE `league_id`=137 && `season_id`=288

QUERY(0.6659ms) - SELECT SQL_CACHE `standings_id` FROM `standings` WHERE `season_id`=288 LIMIT 0,1

QUERY(0.247ms) - SELECT SQL_CACHE `standings_override` FROM `league_schedule_options` WHERE `season_id`=288 LIMIT 0,1

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

QUERY(0.149ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.242ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=137 && `season_id`=288

QUERY(0.1681ms) - SELECT * FROM `league_hotel_settings` WHERE `league_id`=137 && `season_id`=288

QUERY(0.1409ms) - SELECT `game_term`,`game_terms` FROM `sports` WHERE `sport_id`=1

QUERY(0.1569ms) - SELECT `comeswith` FROM `league_custom_content` WHERE `league_id`=137 && `season_id`=288

QUERY(0.2401ms) - SELECT `package_id` FROM `league_players` WHERE `player_id`=0 && `season_id`=288

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

QUERY(0.1268ms) - SELECT SQL_CACHE * FROM payments_config

QUERY(0.181ms) - SELECT `fee` FROM `league_seasons` WHERE `season_id`='288'

QUERY(0.668ms) - SELECT `price` FROM `league_reg_packages` WHERE `season_id`=288 && `active`=1 ORDER BY `price` ASC

QUERY(0.6239ms) - SELECT COUNT(*) FROM `article` INNER JOIN `article_text` ON (`article`.`article_id` = `article_text`.`article_id`) INNER JOIN `users` ON (`article`.`user_id` = `users`.`id`) INNER JOIN `league_updates` ON (`article`.`article_id` = `league_updates`.`article_id`) INNER JOIN `photo` ON (`users`.`avatar_id` = `photo`.`photo_id`) WHERE `league_updates`.`league_id` = '137' and `league_updates`.`season_id` = '288'

QUERY(1.0641ms) - SELECT SQL_CACHE `article`.`title`,`article`.`title_url`,`article`.`user_id`,`article`.`article_id`,`article`.`time_stamp`,`article`.`total_comment`,`article_text`.`text`,`users`.`username`,`users`.`user_url`,`league_updates`.`sent`,`photo`.`img_url` FROM `article` INNER JOIN `article_text` ON (`article`.`article_id` = `article_text`.`article_id`) INNER JOIN `users` ON (`article`.`user_id` = `users`.`id`) INNER JOIN `league_updates` ON (`article`.`article_id` = `league_updates`.`article_id`) INNER JOIN `photo` ON (`users`.`avatar_id` = `photo`.`photo_id`) WHERE `league_updates`.`league_id` = '137' and `league_updates`.`season_id` = '288' ORDER BY `article`.`time_stamp` desc LIMIT 0,3

QUERY(0.1409ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=137 && `season_id`=288

QUERY(0.1609ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=137 && `season_id`=288

QUERY(0.145ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=137 && `season_id`=288

QUERY(0.2351ms) - SELECT COUNT(`photographer_id`) FROM `league_photographers` WHERE `season_id`=288

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

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