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

Outdoor Pickleball League

Season: Spring Thurs & Sat (Other Seasons)
Sport: Pickleball
CoedSocialDraft
Event Director
Venue
Indy Healthplex
Indianapolis, IN
Day of the Week
THU,
This event has completed. This information has been preserved for archival purposes.
Join as Alternate
Registration Details
DatesPlay PackagesScheduleTimeslots
May 18 - Jul 15, 2024Multiple Play Packages
Starting at $10.00
3 Matches p/Day
8 Total Weeks - Play on
7-9 Thu, 2-5 Sat
Set Times Weekly

Description

Welcome to the Pickleball Spring League!

It's time to bring the LeagueJoe formula to the fastest growing sport in America - Pickleball!  As we look to offer this incredible sport to players all around Indy, we also want to introduce it to new players as well so we have two formats - Open Play and League Play.


Open Play - Beginner Training

For players who want to experience and learn Pickleball before committing to a league, we've got your back! Our OPEN PLAY format allows anyone to come play pickleball with our players for just $10 per week. And if you're a brand new player, your fee covers basic lessons for pickleball to teach you the basics! To get started, sign up and complete your player profile and select the Open Play format during checkout to purchase your first week of play.


League Play

If you're ready to dial up the intensity, our League Play will pit singles and couples against one another in head-to-head ladder play with a minimum of 3 games per night. For this league, we will institute Ladder Based Scoring with each player establishing a league rank. As you play, you will move up and down the ladder and your performance matters! If you're a weak player against a strong player, you can still earn points even if you lose by giving the other player a run for their money.

Doubles Format
Play will start with doubles format with two matches focused on pre-selected couples and the third match being random player assignments to the courts. Enjoy a mix of social play to get to know your fellow league mates!

Schedule Overview

Matches will be determined each session based on the number of participants attending in that given session.  Players are able to play Thursdays (7-9) and/or Saturdays (2-5) as they wish.  A minimum of three games will qualify towards league play in each given week.

Matches will be balanced based on the players involved, with placements typically matching strong players with novice players.  Singles competitions will be made available in the season as all players become more comfortable.

First time / Training Session players are welcome at anytime!  Please visit with the session commissioner to get started with your training matches.

Updates

PIckleball Cancelled Saturday 7/8

Greetings!  With inclement weather on the rain after an already rainy morning, we will cancel pickleball this afternoon.  Early next week, we will be announcing the start of our next Pickleball season so stay tuned!

On Thursday, July 13 we will have our final pickleball session of this season and will introduce a tournament to determine a season 1 champion.  We will also have a professional photographer on-hand to take some photos of everyone.  Please wear your pickleball shirts if you have them (or at least bring them for a couple photos :) ) 

Thanks for a fun season and can't wait to continue to grow the program!


Saturday Pickleball Rained Out

No pickleball today :)

Enjoy your holiday weekend everyone!


Tonight's Game Cancelled

Good morning everyone,

We have been monitoring the Air Quality Index and have decided to cancel tonight's game. Due to the cancellation, we are bumping the end date by a week to ensure everyone has a chance to play in the eight-week season, whether you are in the league or open play. 

Stay safe, and see everyone next Thursday!

Cheers, 

Gaby 


Event Operator

PEAK MEMORY: 5.57 MiB
MEMORY USAGE AFTER: 4.59 MiB

Debug Information


Request Variables

var = league

varb = outdoor-pickleball

varc = spring-pb

vara =

vard =

vare =

view_var = league

view_varb = outdoor-pickleball

view_varc = spring-pb

view_vard =

view_vare =

view_varf =

view_varg =

Debug Messages

Site ID: 1

Sub Domain:

Domain: netstuffersdev1.com

Site name: LeagueJoe

Template: lj

SECURETOKEN: 555c46e3957922ccda9c3b0f6185ae57

Login Type:

BASE:: league

FULL LINK:: league/outdoor-pickleball/spring-pb

Page ID: 27

Page ID:: 27

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 = 555c46e3957922ccda9c3b0f6185ae57
fullstate =


Cookie Variables


Server Variables

USER = leaguejo_dev
HOME = /home/leaguejo_dev
SCRIPT_NAME = /index.php
REQUEST_URI = /league/outdoor-pickleball/spring-pb/
QUERY_STRING = var=league&varb=outdoor-pickleball&varc=spring-pb
REQUEST_METHOD = GET
SERVER_PROTOCOL = HTTP/1.1
GATEWAY_INTERFACE = CGI/1.1
REDIRECT_QUERY_STRING = var=league&varb=outdoor-pickleball&varc=spring-pb
REDIRECT_URL = /league/outdoor-pickleball/spring-pb/
REMOTE_PORT = 10032
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.135.220.219
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/league/outdoor-pickleball/spring-pb
HTTP_ACCEPT_ENCODING = gzip, br, zstd, deflate
HTTP_USER_AGENT = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_ACCEPT = */*
proxy-nokeepalive = 1
SSL_TLS_SNI = netstuffersdev1.com
HTTPS = on
SCRIPT_URI = https://netstuffersdev1.com/league/outdoor-pickleball/spring-pb/
SCRIPT_URL = /league/outdoor-pickleball/spring-pb/
UNIQUE_ID = Zz79iQfhIcys8cPa6k@0VwAAABg
REDIRECT_STATUS = 200
REDIRECT_SSL_TLS_SNI = netstuffersdev1.com
REDIRECT_HTTPS = on
REDIRECT_SCRIPT_URI = https://netstuffersdev1.com/league/outdoor-pickleball/spring-pb/
REDIRECT_SCRIPT_URL = /league/outdoor-pickleball/spring-pb/
REDIRECT_UNIQUE_ID = Zz79iQfhIcys8cPa6k@0VwAAABg
FCGI_ROLE = RESPONDER
PHP_SELF = /index.php
REQUEST_TIME_FLOAT = 1732181385.4968
REQUEST_TIME = 1732181385


SQL Queries


Total Queries: 80
Total Execution Time: 27.4529ms
Avg Execution Time:0.34316125ms

QUERY(1.6811ms) - 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', '09:29:45', 'GET', '/league/outdoor-pickleball/spring-pb/', '3.135.220.219', 'https://netstuffersdev1.com/league/outdoor-pickleball/spring-pb' ,'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '','OXoxRVZMVjQ4WTB4djhqV3ZoeDVtblpoN1hrL0hkTEp1M0toVlNEamZhenNodU5rLzRkWXh2dzR4NHZ0alk3ekppWFBoTk9oTDBoK2l3Q1pwTXlrWFFNUk9ZcnlqNUNBS0xzUEdYVm9EVmNEZEJNNnBZK0s3Ui9ZY1BsQkVqT28=','0','','1732181385') ON DUPLICATE KEY UPDATE `ip`=`ip`

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

QUERY(0.1881ms) - SELECT SQL_CACHE dest FROM redirects WHERE source = '/league/outdoor-pickleball/spring-pb/'

QUERY(0.2689ms) - SELECT SQL_CACHE `id`,`layout`,`name`,`pagedisplay` FROM pages WHERE `pagedisplay`='league/outdoor-pickleball/spring-pb' ORDER BY `domain`='1' DESC,`domain` ASC

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

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

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

QUERY(0.1669ms) - SELECT * FROM userprofiles_config

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

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

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

QUERY(0.1781ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.6289ms) - 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` = 'outdoor-pickleball' LIMIT 0,1

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

QUERY(0.576ms) - 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` = '85' and `league_seasons`.`url` = 'spring-pb' ORDER BY `league_dates`.`start_date` ASC

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

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

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

QUERY(0.221ms) - 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`=85 && `season_id`=126 LIMIT 0,1

QUERY(0.299ms) - SELECT SQL_CACHE * FROM `league_cache` WHERE `league_id`=85 && `season_id`=126 && `updated`>=(NOW() - INTERVAL 30 MINUTE)

QUERY(0.282ms) - SELECT SQL_CACHE * FROM `league_schedule_options` WHERE `league_id`='85' && `season_id`='126' LIMIT 0,1

QUERY(0.2148ms) - SELECT SQL_CACHE count(`company_id`) FROM `league_company_links` WHERE `league_id`='85' && (`season_id`='126' || `season_id`=0)

QUERY(0.3219ms) - SELECT SQL_CACHE count(`update_id`) FROM `league_updates` WHERE `league_id`='85' && (`season_id`='126' || `season_id`=0)

QUERY(0.181ms) - SELECT SQL_CACHE count(`conference_id`) FROM `league_conferences` WHERE (`league_id`=85 && `season_id`=0) || `season_id`='126'

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

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

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

QUERY(0.2611ms) - SELECT SQL_CACHE count(`season_id`) FROM `league_seasons_rules` WHERE `league_id`='85' || `season_id`='126' ORDER BY `season_id` DESC

QUERY(0.2081ms) - SELECT SQL_CACHE count(`sponsor_id`) FROM `league_sponsors` WHERE `league_id`='85' && `season_id`='126'

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

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

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

QUERY(0.2091ms) - SELECT SQL_CACHE `group_id` FROM `league_groups` WHERE `league_id`=85&&`season_id`=126 LIMIT 0,1

QUERY(0.3998ms) - SELECT `game_id` FROM `games` WHERE `league_id`=85&&`season_id`=126&&`playoff`=1 LIMIT 0,1

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

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

QUERY(0.3209ms) - SELECT SQL_CACHE count(`game_id`) FROM `games` WHERE `league_id`='85' && `season_id`='126'

QUERY(0.217ms) - 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`='85' && `league_seasons`.`season_id`='126'

QUERY(0.1462ms) - SELECT `allow_hotelpage` FROM `league_hotel_settings` WHERE `league_id`=85 && `season_id`=126 LIMIT 0,1

QUERY(0.1409ms) - SELECT allow_hotelpage FROM `league_hotel_settings` WHERE `league_id`=85 && `season_id`=126

QUERY(1.2431ms) - 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 ('85','126','7',0,0,'28','14','1',0,'55','33',0,0,'4',0,0,0,0,0,0,0,0,NOW(),0) ON DUPLICATE KEY UPDATE `league_id`='85',`season_id`='126',`articles`='7',`participants`=0,`conferences`=0,`players`='28',`coaches`='14',`subs`='1',`rules`=0,`teams`='55',`games`='33',`groups`=0,`divisions`=0,`seasons`='4',`sponsors`=0,`products`=0,`prizes`=0,`triumphs`=0,`hotels`=0,`is_full`=0,`companies`=0,`reg_is_open`=0,`updated`=NOW(),`show_playoff_menu`=0

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

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

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

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

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

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

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

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

QUERY(0.1829ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1781ms) - SELECT `sport_id` FROM `sports` WHERE `name_url`='outdoor-pickleball'

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

QUERY(0.129ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.212ms) - SELECT SQL_CACHE * FROM league_config

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

QUERY(0.1299ms) - SELECT SQL_CACHE * FROM teams_config

QUERY(0.1709ms) - SELECT `hall_of_fame` FROM `league_schedule_options` WHERE `league_id`='85' && `season_id`='126' LIMIT 0,1

QUERY(0.1678ms) - SELECT * FROM `league_notices` WHERE `league_id`=85 && `season_id`=126

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

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

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

QUERY(0.176ms) - SELECT SQL_CACHE * FROM league_config

QUERY(0.2611ms) - SELECT * FROM `league_schedule_options` WHERE `league_id`=85 && `season_id`=126

QUERY(0.191ms) - SELECT * FROM `league_hotel_settings` WHERE `league_id`=85 && `season_id`=126

QUERY(0.1309ms) - SELECT `game_term`,`game_terms` FROM `sports` WHERE `sport_id`=12

QUERY(0.1419ms) - SELECT `comeswith` FROM `league_custom_content` WHERE `league_id`=85 && `season_id`=126

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

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

QUERY(0.138ms) - SELECT SQL_CACHE * FROM payments_config

QUERY(0.2871ms) - SELECT `fee` FROM `league_seasons` WHERE `season_id`='126'

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

QUERY(0.6969ms) - 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` = '85' and `league_updates`.`season_id` = '126'

QUERY(1.775ms) - 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` = '85' and `league_updates`.`season_id` = '126' ORDER BY `article`.`time_stamp` desc LIMIT 0,3

QUERY(0.186ms) - SELECT `open_call` FROM `league_coach_settings` WHERE `league_id`=85 && `season_id`=126

QUERY(0.145ms) - SELECT `allow_vouch` FROM `league_vouch_settings` WHERE `league_id`=85 && `season_id`=126

QUERY(0.1681ms) - SELECT `allow_cards` FROM `league_tradingcard_settings` WHERE `league_id`=85 && `season_id`=126

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

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