API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 19th, 2018
109
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 127.17 KB | None | 0 0
raw download clone embed print report
  1. SELECT COUNT(DISTINCT a.gameid) FROM w3mmdplayers AS a LEFT JOIN gameplayers AS ag ON ag.gameid = a.gameid AND ag.colour = a.pid,
  2. ->
  3. Display all 1894 possibilities? (y or n)
  4. ? PERIOD_DIFF dota2games.sec paypal_transactions.currency
  5. ABS PHASE dota2games.winner paypal_transactions.email
  6. ACOS PI dota2players paypal_transactions.memo
  7. ACTION POINT dota2players.assists paypal_transactions.name
  8. ADD POINTFROMTEXT dota2players.botid paypal_transactions.transaction_id
  9. ADDDATE POINTFROMWKB dota2players.colour performance_schema
  10. ADDTIME POINTN dota2players.courierkills permissions
  11. AES_DECRYPT POLYFROMTEXT dota2players.creepdenies permissions.name
  12. AES_ENCRYPT POLYFROMWKB dota2players.creepkills permissions.user_group
  13. AFTER POLYGON dota2players.deaths permissions.value
  14. AGAINST POLYGONFROMTEXT dota2players.gameid pid
  15. AGGREGATE POLYGONFROMWKB dota2players.gold piwik
  16. ALGORITHM POSITION dota2players.hero player
  17. ALL POW dota2players.id player_id
  18. ALTER POWER dota2players.item1 playingtime
  19. ANALYZE PRECISION dota2players.item2 plugin
  20. AND PREPARE dota2players.item3 plugindb
  21. ANY PREV dota2players.item4 plugindb.id
  22. AREA PRIMARY dota2players.item5 plugindb.k
  23. AS PRIVILEGES dota2players.item6 plugindb.plugin
  24. ASBINARY PROCEDURE dota2players.kills plugindb.val
  25. ASC PROCESS dota2players.neutralkills port
  26. ASCII PROCESSLIST dota2players.newcolour position
  27. ASENSITIVE PURGE dota2players.raxkills practicing
  28. ASIN Player1 dota2players.scorechange price
  29. ASTEXT Player2 dota2players.towerkills print
  30. ASWKB Player3 dota_elo_games_scored processed
  31. ASWKT Player4 dota_elo_games_scored.gameid prompt
  32. ATAN Player5 dota_elo_games_scored.id proxy
  33. ATAN2 Player6 dota_elo_scores queue
  34. AUTO_INCREMENT Poins dota_elo_scores.assists queue.id
  35. AVG QUARTER dota_elo_scores.courierkills queue.message
  36. AVG_ROW_LENGTH QUERY dota_elo_scores.creepdenies quit
  37. Activ QUICK dota_elo_scores.creepkills randname
  38. BACKUP QUOTE dota_elo_scores.deaths rank
  39. BDB RADIANS dota_elo_scores.games rax
  40. BEFORE RAND dota_elo_scores.id raxkills
  41. BEGIN READ dota_elo_scores.kills realm
  42. BENCHMARK READS dota_elo_scores.losses reason
  43. BERKELEYDB REAL dota_elo_scores.modify_date register_end
  44. BETWEEN RECOVER dota_elo_scores.name register_start
  45. BIGINT REDUNDANT dota_elo_scores.neutralkills rehash
  46. BIN REFERENCES dota_elo_scores.rank replays
  47. BINARY REGEXP dota_elo_scores.raxkills replays.filename
  48. BINLOG RELAY_LOG_FILE dota_elo_scores.score replays.gameid
  49. BIT RELAY_LOG_POS dota_elo_scores.server replays.id
  50. BIT_AND RELAY_THREAD dota_elo_scores.towerkills replays.sid
  51. BIT_COUNT RELEASE dota_elo_scores.wins replays.status
  52. BIT_LENGTH RELEASE_LOCK dotagames reserved
  53. BIT_OR RELOAD dotagames.botid round_id
  54. BIT_XOR RENAME dotagames.gameid roundplayer_id
  55. BLOB REPAIR dotagames.id safelist
  56. BOOL REPEAT dotagames.min safelist.id
  57. BOOLEAN REPEATABLE dotagames.sec safelist.name
  58. BOTH REPLACE dotagames.winner safelist.server
  59. BTREE REPLICATION dotaplayers safelist.voucher
  60. BY REQUIRE dotaplayers.assists score
  61. BYTE RESET dotaplayers.botid scorechange
  62. CACHE RESTORE dotaplayers.colour scores
  63. CALL RESTRICT dotaplayers.courierkills scores.category
  64. CASCADE RESUME dotaplayers.creepdenies scores.id
  65. CASCADED RETURN dotaplayers.creepkills scores.name
  66. CASE RETURNS dotaplayers.deaths scores.score
  67. CAST REVERSE dotaplayers.gameid scores.server
  68. CEIL REVOKE dotaplayers.gold sec
  69. CEILING RIGHT dotaplayers.hero seen
  70. CENTROID RLIKE dotaplayers.id server
  71. CHAIN ROLLBACK dotaplayers.item1 sessionkey
  72. CHANGE ROLLUP dotaplayers.item2 set option
  73. CHANGED ROUND dotaplayers.item3 shortname
  74. CHAR ROUTINE dotaplayers.item4 show databases
  75. CHARACTER ROW dotaplayers.item5 show fields from
  76. CHARACTER_LENGTH ROWS dotaplayers.item6 show keys from
  77. CHARSET ROW_COUNT dotaplayers.kills show tables
  78. CHAR_LENGTH ROW_FORMAT dotaplayers.neutralkills sid
  79. CHECK RPAD dotaplayers.newcolour size
  80. CHECKSUM RTREE dotaplayers.raxkills skills
  81. CIPHER RTRIM dotaplayers.scorechange slotstaken
  82. CLIENT SAVEPOINT dotaplayers.towerkills slotstotal
  83. CLOSE SCHEMA doublestats0 source
  84. COALESCE SCHEMAS doublestats1 source_realm
  85. CODE SECOND doublestats2 source_username
  86. COERCIBILITY SECOND_MICROSECOND doublestats3 spoof
  87. COLLATE SECURITY downloads spoof.name
  88. COLLATION SEC_TO_TIME downloads.botid spoof.spoof
  89. COLUMN SELECT downloads.datetime spoofed
  90. COLUMNS SENSITIVE downloads.downloadtime spoofedrealm
  91. COMMENT SEPARATOR downloads.id startalert
  92. COMMIT SERIAL downloads.ip stats
  93. COMMITTED SERIALIZABLE downloads.map stats.assists
  94. COMPACT SESSION downloads.mapsize stats.banned
  95. COMPRESS SESSION_USER downloads.name stats.creeps
  96. COMPRESSED SET downloads.spoofed stats.deaths
  97. CONCAT SHA downloads.spoofedrealm stats.denies
  98. CONCAT_WS SHA1 downloadtime stats.draw
  99. CONCURRENT SHARE draw stats.games
  100. CONDITION SHOW duration stats.id
  101. CONNECTION SHUTDOWN edit stats.ip
  102. CONNECTION_ID SIGN ego stats.kills
  103. CONSISTENT SIGNED elo stats.losses
  104. CONSTRAINT SIMPLE email stats.neutrals
  105. CONTAINS SIN ent_forum stats.player
  106. CONTINUE SLAVE entconnect stats.rax
  107. CONV SLEEP entconnect.amh stats.score
  108. CONVERT SMALLINT entconnect.id stats.towers
  109. CONVERT_TZ SNAPSHOT entconnect.proxy stats.wins
  110. COS SOME entconnect.sessionkey stats_bot_status
  111. COT SONAME entconnect.startalert stats_bot_status.botid
  112. COUNT SOUNDEX entconnect.time stats_bot_status.botname
  113. CRC32 SOUNDS entconnect.username stats_bot_status.gamename
  114. CREATE SPACE entconnect.war3path stats_bot_status.last_update
  115. CROSS SPATIAL entconnect_list stats_bot_status.status
  116. CROSSES SPECIFIC entconnect_list.data stats_bot_status.uptime
  117. CUBE SQL entconnect_list.id stats_transfer_queue
  118. CURDATE SQLEXCEPTION entconnect_list.ipport stats_transfer_queue.admin_name
  119. CURRENT_DATE SQLSTATE entconnect_list.time stats_transfer_queue.category
  120. CURRENT_TIME SQLWARNING entry stats_transfer_queue.id
  121. CURRENT_TIMESTAMP SQL_BIG_RESULT eventtime stats_transfer_queue.source_realm
  122. CURRENT_USER SQL_BUFFER_RESULT exit stats_transfer_queue.source_username
  123. CURSOR SQL_CACHE expiredate stats_transfer_queue.swap
  124. CURTIME SQL_CALC_FOUND_ROWS filename stats_transfer_queue.target_realm
  125. DATA SQL_NO_CACHE flag stats_transfer_queue.target_username
  126. DATABASE SQL_SMALL_RESULT fuser stats_transfer_queue.time
  127. DATABASES SQL_THREAD gameid status
  128. DATE SQL_TSI_DAY gamelist stream_games
  129. DATEDIFF SQL_TSI_HOUR gamelist.age stream_games.botid
  130. DATETIME SQL_TSI_MINUTE gamelist.botid stream_games.gamename
  131. DATE_ADD SQL_TSI_MONTH gamelist.creatorname stream_games.last_update
  132. DATE_FORMAT SQL_TSI_QUARTER gamelist.eventtime stream_games.mapcrc
  133. DATE_SUB SQL_TSI_SECOND gamelist.gamename stream_games.mapflags
  134. DAY SQL_TSI_WEEK gamelist.id stream_games.mappath
  135. DAYNAME SQL_TSI_YEAR gamelist.lobby stream_games.port
  136. DAYOFMONTH SQRT gamelist.map stream_players
  137. DAYOFWEEK SRID gamelist.ownername stream_players.gamename
  138. DAYOFYEAR SSL gamelist.slotstaken stream_players.last_update
  139. DAY_HOUR START gamelist.slotstotal stream_players.name
  140. DAY_MICROSECOND STARTING gamelist.totalplayers summary
  141. DAY_MINUTE STARTPOINT gamelist.usernames swap
  142. DAY_SECOND STATUS gamename system
  143. DEALLOCATE STD gameplayers target_realm
  144. DEC STDDEV gameplayers.botid target_username
  145. DECIMAL STDDEV_POP gameplayers.colour targetbot
  146. DECLARE STDDEV_SAMP gameplayers.gameid tbl_DIHL
  147. DECODE STOP gameplayers.hostname tbl_DIHL.assists
  148. DEFAULT STORAGE gameplayers.id tbl_DIHL.captainlosses
  149. DEFINER STRAIGHT_JOIN gameplayers.ip tbl_DIHL.captainwins
  150. DEGREES STRCMP gameplayers.left tbl_DIHL.cocaptainlosses
  151. DELAYED STRING gameplayers.leftreason tbl_DIHL.cocaptainwins
  152. DELAY_KEY_WRITE STRIPED gameplayers.loadingtime tbl_DIHL.courierkills
  153. DELETE STR_TO_DATE gameplayers.name tbl_DIHL.creepdenies
  154. DESC SUBDATE gameplayers.processed tbl_DIHL.creepkills
  155. DESCRIBE SUBJECT gameplayers.reserved tbl_DIHL.deaths
  156. DES_DECRYPT SUBSTR gameplayers.spoofed tbl_DIHL.elo
  157. DES_ENCRYPT SUBSTRING gameplayers.spoofedrealm tbl_DIHL.games
  158. DES_KEY_FILE SUBSTRING_INDEX gameplayers.team tbl_DIHL.id
  159. DETERMINISTIC SUBTIME gamequeue tbl_DIHL.kills
  160. DIMENSION SUM gamequeue.command tbl_DIHL.losses
  161. DIRECTORY SUPER gamequeue.gamename tbl_DIHL.modify_date
  162. DISABLE SUSPEND gamequeue.id tbl_DIHL.name
  163. DISCARD SYSDATE gamequeue.location tbl_DIHL.neutralkills
  164. DISJOINT SYSTEM_USER gamequeue.mapname tbl_DIHL.rank
  165. DISTINCT TABLE gamequeue.maptype tbl_DIHL.raxkills
  166. DISTINCTROW TABLES gamequeue.obs tbl_DIHL.score
  167. DIV TABLESPACE gamequeue.realm tbl_DIHL.server
  168. DO TAN gamequeue.username tbl_DIHL.towerkills
  169. DOUBLE TEMPORARY gamequeue_status tbl_DIHL.wins
  170. DROP TEMPTABLE gamequeue_status.gamename tbl_LIHL
  171. DUAL TERMINATED gamequeue_status.location tbl_LIHL.category
  172. DUMPFILE TEXT gamequeue_status.position tbl_LIHL.doublestats0
  173. DUPLICATE THEN gamequeue_status.username tbl_LIHL.doublestats1
  174. DYNAMIC TIME games tbl_LIHL.doublestats2
  175. EACH TIMEDIFF games.botid tbl_LIHL.doublestats3
  176. ELSE TIMESTAMP games.creatorname tbl_LIHL.games
  177. ELSEIF TIMESTAMPADD games.creatorserver tbl_LIHL.id
  178. ELT TIMESTAMPDIFF games.datetime tbl_LIHL.intstats0
  179. ENABLE TIME_FORMAT games.duration tbl_LIHL.intstats1
  180. ENCLOSED TIME_TO_SEC games.gamename tbl_LIHL.intstats2
  181. ENCODE TINYBLOB games.gamestate tbl_LIHL.intstats3
  182. ENCRYPT TINYINT games.id tbl_LIHL.intstats4
  183. END TINYTEXT games.map tbl_LIHL.intstats5
  184. ENDPOINT TO games.ownername tbl_LIHL.intstats6
  185. ENGINE TOUCHES games.server tbl_LIHL.intstats7
  186. ENGINES TO_DAYS games.stats tbl_LIHL.losses
  187. ENUM TRAILING games.views tbl_LIHL.modify_date
  188. ENVELOPE TRANSACTION gamestate tbl_LIHL.name
  189. EQUALS TRIGGER gametrack tbl_LIHL.rank
  190. ERRORS TRIGGERS gametrack.bots tbl_LIHL.score
  191. ESCAPE TRIM gametrack.lastgames tbl_LIHL.server
  192. ESCAPED TRUE gametrack.name tbl_LIHL.wins
  193. EVENTS TRUNCATE gametrack.num_autoban team
  194. EXECUTE TYPE gametrack.num_games teamsize
  195. EXISTS TYPES gametrack.num_leftpercent tee
  196. EXIT Team1 gametrack.playingtime text
  197. EXP Team1Loses gametrack.realm tid
  198. EXPANSION Team1Wins gametrack.time_active time
  199. EXPLAIN Team2 gametrack.time_created time_active
  200. EXPORT_SET Team2Loses gametrack.total_leftpercent time_created
  201. EXTENDED Team2Wins generic_forum_preferences title
  202. EXTERIORRING Time generic_forum_preferences.fuser token
  203. EXTRACT UCASE generic_forum_preferences.k total_leftpercent
  204. FALSE UNCOMMITTED generic_forum_preferences.v totalplayers
  205. FAST UNCOMPRESS ghost tournament_id
  206. FETCH UNCOMPRESSED_LENGTH ghost_random towerkills
  207. FIELD UNDEFINED go towers
  208. FIELDS UNDO gold transaction_id
  209. -> gameplayers AS bg ON bg.gameid = b.gameid AND bg.colour = b.pid LEFT JOIN w3mmdplayers AS w ON w.gameid = b.gameid AND w.flag = 'winner' LEFT JOIN gameplayers AS wg ON wg.gameid = w.gameid AND wg.colour = w.pid WHERE ag.name = "diablo_" AND bg.name = "1007" AND wg.team IS NOT NULL AND wg.team = ag.team AND a.gameid = b.gameid AND ag.team = bg.team AND a.category = "lihl" AND b.category = "lihl"
  210. ->
  211. Display all 1894 possibilities? (y or n)
  212. -> ION ALL
  213. ->
  214. Display all 1894 possibilities? (y or n)
  215. ? PERIOD_DIFF dota2games.sec paypal_transactions.currency
  216. ABS PHASE dota2games.winner paypal_transactions.email
  217. ACOS PI dota2players paypal_transactions.memo
  218. ACTION POINT dota2players.assists paypal_transactions.name
  219. ADD POINTFROMTEXT dota2players.botid paypal_transactions.transaction_id
  220. ADDDATE POINTFROMWKB dota2players.colour performance_schema
  221. ADDTIME POINTN dota2players.courierkills permissions
  222. AES_DECRYPT POLYFROMTEXT dota2players.creepdenies permissions.name
  223. AES_ENCRYPT POLYFROMWKB dota2players.creepkills permissions.user_group
  224. AFTER POLYGON dota2players.deaths permissions.value
  225. AGAINST POLYGONFROMTEXT dota2players.gameid pid
  226. AGGREGATE POLYGONFROMWKB dota2players.gold piwik
  227. ALGORITHM POSITION dota2players.hero player
  228. ALL POW dota2players.id player_id
  229. ALTER POWER dota2players.item1 playingtime
  230. ANALYZE PRECISION dota2players.item2 plugin
  231. AND PREPARE dota2players.item3 plugindb
  232. ANY PREV dota2players.item4 plugindb.id
  233. AREA PRIMARY dota2players.item5 plugindb.k
  234. AS PRIVILEGES dota2players.item6 plugindb.plugin
  235. ASBINARY PROCEDURE dota2players.kills plugindb.val
  236. ASC PROCESS dota2players.neutralkills port
  237. ASCII PROCESSLIST dota2players.newcolour position
  238. ASENSITIVE PURGE dota2players.raxkills practicing
  239. ASIN Player1 dota2players.scorechange price
  240. ASTEXT Player2 dota2players.towerkills print
  241. ASWKB Player3 dota_elo_games_scored processed
  242. ASWKT Player4 dota_elo_games_scored.gameid prompt
  243. ATAN Player5 dota_elo_games_scored.id proxy
  244. ATAN2 Player6 dota_elo_scores queue
  245. AUTO_INCREMENT Poins dota_elo_scores.assists queue.id
  246. AVG QUARTER dota_elo_scores.courierkills queue.message
  247. AVG_ROW_LENGTH QUERY dota_elo_scores.creepdenies quit
  248. Activ QUICK dota_elo_scores.creepkills randname
  249. BACKUP QUOTE dota_elo_scores.deaths rank
  250. BDB RADIANS dota_elo_scores.games rax
  251. BEFORE RAND dota_elo_scores.id raxkills
  252. BEGIN READ dota_elo_scores.kills realm
  253. BENCHMARK READS dota_elo_scores.losses reason
  254. BERKELEYDB REAL dota_elo_scores.modify_date register_end
  255. BETWEEN RECOVER dota_elo_scores.name register_start
  256. -> T(DISTINCT a.gameid) FROM w3mmdplayers AS a LEFT JOIN gameplayers AS ag ON ag.gameid = a.gameid AND ag.colour = a.pid,
  257. ->
  258. Display all 1894 possibilities? (y or n)
  259. ? PERIOD_DIFF dota2games.sec paypal_transactions.currency
  260. ABS PHASE dota2games.winner paypal_transactions.email
  261. ACOS PI dota2players paypal_transactions.memo
  262. ACTION POINT dota2players.assists paypal_transactions.name
  263. ADD POINTFROMTEXT dota2players.botid paypal_transactions.transaction_id
  264. ADDDATE POINTFROMWKB dota2players.colour performance_schema
  265. ADDTIME POINTN dota2players.courierkills permissions
  266. AES_DECRYPT POLYFROMTEXT dota2players.creepdenies permissions.name
  267. AES_ENCRYPT POLYFROMWKB dota2players.creepkills permissions.user_group
  268. AFTER POLYGON dota2players.deaths permissions.value
  269. AGAINST POLYGONFROMTEXT dota2players.gameid pid
  270. AGGREGATE POLYGONFROMWKB dota2players.gold piwik
  271. ALGORITHM POSITION dota2players.hero player
  272. ALL POW dota2players.id player_id
  273. ALTER POWER dota2players.item1 playingtime
  274. ANALYZE PRECISION dota2players.item2 plugin
  275. AND PREPARE dota2players.item3 plugindb
  276. ANY PREV dota2players.item4 plugindb.id
  277. AREA PRIMARY dota2players.item5 plugindb.k
  278. AS PRIVILEGES dota2players.item6 plugindb.plugin
  279. ASBINARY PROCEDURE dota2players.kills plugindb.val
  280. ASC PROCESS dota2players.neutralkills port
  281. ASCII PROCESSLIST dota2players.newcolour position
  282. ASENSITIVE PURGE dota2players.raxkills practicing
  283. ASIN Player1 dota2players.scorechange price
  284. ASTEXT Player2 dota2players.towerkills print
  285. ASWKB Player3 dota_elo_games_scored processed
  286. ASWKT Player4 dota_elo_games_scored.gameid prompt
  287. ATAN Player5 dota_elo_games_scored.id proxy
  288. ATAN2 Player6 dota_elo_scores queue
  289. AUTO_INCREMENT Poins dota_elo_scores.assists queue.id
  290. AVG QUARTER dota_elo_scores.courierkills queue.message
  291. AVG_ROW_LENGTH QUERY dota_elo_scores.creepdenies quit
  292. Activ QUICK dota_elo_scores.creepkills randname
  293. BACKUP QUOTE dota_elo_scores.deaths rank
  294. BDB RADIANS dota_elo_scores.games rax
  295. BEFORE RAND dota_elo_scores.id raxkills
  296. BEGIN READ dota_elo_scores.kills realm
  297. BENCHMARK READS dota_elo_scores.losses reason
  298. BERKELEYDB REAL dota_elo_scores.modify_date register_end
  299. BETWEEN RECOVER dota_elo_scores.name register_start
  300. BIGINT REDUNDANT dota_elo_scores.neutralkills rehash
  301. BIN REFERENCES dota_elo_scores.rank replays
  302. BINARY REGEXP dota_elo_scores.raxkills replays.filename
  303. BINLOG RELAY_LOG_FILE dota_elo_scores.score replays.gameid
  304. BIT RELAY_LOG_POS dota_elo_scores.server replays.id
  305. BIT_AND RELAY_THREAD dota_elo_scores.towerkills replays.sid
  306. BIT_COUNT RELEASE dota_elo_scores.wins replays.status
  307. BIT_LENGTH RELEASE_LOCK dotagames reserved
  308. BIT_OR RELOAD dotagames.botid round_id
  309. BIT_XOR RENAME dotagames.gameid roundplayer_id
  310. BLOB REPAIR dotagames.id safelist
  311. BOOL REPEAT dotagames.min safelist.id
  312. BOOLEAN REPEATABLE dotagames.sec safelist.name
  313. BOTH REPLACE dotagames.winner safelist.server
  314. BTREE REPLICATION dotaplayers safelist.voucher
  315. BY REQUIRE dotaplayers.assists score
  316. BYTE RESET dotaplayers.botid scorechange
  317. CACHE RESTORE dotaplayers.colour scores
  318. CALL RESTRICT dotaplayers.courierkills scores.category
  319. CASCADE RESUME dotaplayers.creepdenies scores.id
  320. CASCADED RETURN dotaplayers.creepkills scores.name
  321. CASE RETURNS dotaplayers.deaths scores.score
  322. CAST REVERSE dotaplayers.gameid scores.server
  323. CEIL REVOKE dotaplayers.gold sec
  324. CEILING RIGHT dotaplayers.hero seen
  325. CENTROID RLIKE dotaplayers.id server
  326. CHAIN ROLLBACK dotaplayers.item1 sessionkey
  327. CHANGE ROLLUP dotaplayers.item2 set option
  328. CHANGED ROUND dotaplayers.item3 shortname
  329. CHAR ROUTINE dotaplayers.item4 show databases
  330. CHARACTER ROW dotaplayers.item5 show fields from
  331. CHARACTER_LENGTH ROWS dotaplayers.item6 show keys from
  332. CHARSET ROW_COUNT dotaplayers.kills show tables
  333. CHAR_LENGTH ROW_FORMAT dotaplayers.neutralkills sid
  334. CHECK RPAD dotaplayers.newcolour size
  335. CHECKSUM RTREE dotaplayers.raxkills skills
  336. CIPHER RTRIM dotaplayers.scorechange slotstaken
  337. CLIENT SAVEPOINT dotaplayers.towerkills slotstotal
  338. CLOSE SCHEMA doublestats0 source
  339. COALESCE SCHEMAS doublestats1 source_realm
  340. CODE SECOND doublestats2 source_username
  341. COERCIBILITY SECOND_MICROSECOND doublestats3 spoof
  342. COLLATE SECURITY downloads spoof.name
  343. COLLATION SEC_TO_TIME downloads.botid spoof.spoof
  344. COLUMN SELECT downloads.datetime spoofed
  345. COLUMNS SENSITIVE downloads.downloadtime spoofedrealm
  346. COMMENT SEPARATOR downloads.id startalert
  347. COMMIT SERIAL downloads.ip stats
  348. COMMITTED SERIALIZABLE downloads.map stats.assists
  349. COMPACT SESSION downloads.mapsize stats.banned
  350. COMPRESS SESSION_USER downloads.name stats.creeps
  351. COMPRESSED SET downloads.spoofed stats.deaths
  352. CONCAT SHA downloads.spoofedrealm stats.denies
  353. CONCAT_WS SHA1 downloadtime stats.draw
  354. CONCURRENT SHARE draw stats.games
  355. CONDITION SHOW duration stats.id
  356. CONNECTION SHUTDOWN edit stats.ip
  357. CONNECTION_ID SIGN ego stats.kills
  358. CONSISTENT SIGNED elo stats.losses
  359. CONSTRAINT SIMPLE email stats.neutrals
  360. CONTAINS SIN ent_forum stats.player
  361. CONTINUE SLAVE entconnect stats.rax
  362. CONV SLEEP entconnect.amh stats.score
  363. CONVERT SMALLINT entconnect.id stats.towers
  364. CONVERT_TZ SNAPSHOT entconnect.proxy stats.wins
  365. COS SOME entconnect.sessionkey stats_bot_status
  366. COT SONAME entconnect.startalert stats_bot_status.botid
  367. COUNT SOUNDEX entconnect.time stats_bot_status.botname
  368. CRC32 SOUNDS entconnect.username stats_bot_status.gamename
  369. CREATE SPACE entconnect.war3path stats_bot_status.last_update
  370. CROSS SPATIAL entconnect_list stats_bot_status.status
  371. CROSSES SPECIFIC entconnect_list.data stats_bot_status.uptime
  372. CUBE SQL entconnect_list.id stats_transfer_queue
  373. CURDATE SQLEXCEPTION entconnect_list.ipport stats_transfer_queue.admin_name
  374. CURRENT_DATE SQLSTATE entconnect_list.time stats_transfer_queue.category
  375. CURRENT_TIME SQLWARNING entry stats_transfer_queue.id
  376. CURRENT_TIMESTAMP SQL_BIG_RESULT eventtime stats_transfer_queue.source_realm
  377. CURRENT_USER SQL_BUFFER_RESULT exit stats_transfer_queue.source_username
  378. CURSOR SQL_CACHE expiredate stats_transfer_queue.swap
  379. CURTIME SQL_CALC_FOUND_ROWS filename stats_transfer_queue.target_realm
  380. DATA SQL_NO_CACHE flag stats_transfer_queue.target_username
  381. DATABASE SQL_SMALL_RESULT fuser stats_transfer_queue.time
  382. DATABASES SQL_THREAD gameid status
  383. DATE SQL_TSI_DAY gamelist stream_games
  384. DATEDIFF SQL_TSI_HOUR gamelist.age stream_games.botid
  385. DATETIME SQL_TSI_MINUTE gamelist.botid stream_games.gamename
  386. DATE_ADD SQL_TSI_MONTH gamelist.creatorname stream_games.last_update
  387. DATE_FORMAT SQL_TSI_QUARTER gamelist.eventtime stream_games.mapcrc
  388. DATE_SUB SQL_TSI_SECOND gamelist.gamename stream_games.mapflags
  389. DAY SQL_TSI_WEEK gamelist.id stream_games.mappath
  390. DAYNAME SQL_TSI_YEAR gamelist.lobby stream_games.port
  391. DAYOFMONTH SQRT gamelist.map stream_players
  392. DAYOFWEEK SRID gamelist.ownername stream_players.gamename
  393. DAYOFYEAR SSL gamelist.slotstaken stream_players.last_update
  394. DAY_HOUR START gamelist.slotstotal stream_players.name
  395. DAY_MICROSECOND STARTING gamelist.totalplayers summary
  396. DAY_MINUTE STARTPOINT gamelist.usernames swap
  397. DAY_SECOND STATUS gamename system
  398. DEALLOCATE STD gameplayers target_realm
  399. DEC STDDEV gameplayers.botid target_username
  400. DECIMAL STDDEV_POP gameplayers.colour targetbot
  401. DECLARE STDDEV_SAMP gameplayers.gameid tbl_DIHL
  402. DECODE STOP gameplayers.hostname tbl_DIHL.assists
  403. DEFAULT STORAGE gameplayers.id tbl_DIHL.captainlosses
  404. DEFINER STRAIGHT_JOIN gameplayers.ip tbl_DIHL.captainwins
  405. DEGREES STRCMP gameplayers.left tbl_DIHL.cocaptainlosses
  406. DELAYED STRING gameplayers.leftreason tbl_DIHL.cocaptainwins
  407. DELAY_KEY_WRITE STRIPED gameplayers.loadingtime tbl_DIHL.courierkills
  408. DELETE STR_TO_DATE gameplayers.name tbl_DIHL.creepdenies
  409. DESC SUBDATE gameplayers.processed tbl_DIHL.creepkills
  410. DESCRIBE SUBJECT gameplayers.reserved tbl_DIHL.deaths
  411. DES_DECRYPT SUBSTR gameplayers.spoofed tbl_DIHL.elo
  412. DES_ENCRYPT SUBSTRING gameplayers.spoofedrealm tbl_DIHL.games
  413. DES_KEY_FILE SUBSTRING_INDEX gameplayers.team tbl_DIHL.id
  414. DETERMINISTIC SUBTIME gamequeue tbl_DIHL.kills
  415. DIMENSION SUM gamequeue.command tbl_DIHL.losses
  416. DIRECTORY SUPER gamequeue.gamename tbl_DIHL.modify_date
  417. DISABLE SUSPEND gamequeue.id tbl_DIHL.name
  418. DISCARD SYSDATE gamequeue.location tbl_DIHL.neutralkills
  419. DISJOINT SYSTEM_USER gamequeue.mapname tbl_DIHL.rank
  420. DISTINCT TABLE gamequeue.maptype tbl_DIHL.raxkills
  421. DISTINCTROW TABLES gamequeue.obs tbl_DIHL.score
  422. DIV TABLESPACE gamequeue.realm tbl_DIHL.server
  423. DO TAN gamequeue.username tbl_DIHL.towerkills
  424. DOUBLE TEMPORARY gamequeue_status tbl_DIHL.wins
  425. DROP TEMPTABLE gamequeue_status.gamename tbl_LIHL
  426. DUAL TERMINATED gamequeue_status.location tbl_LIHL.category
  427. DUMPFILE TEXT gamequeue_status.position tbl_LIHL.doublestats0
  428. DUPLICATE THEN gamequeue_status.username tbl_LIHL.doublestats1
  429. DYNAMIC TIME games tbl_LIHL.doublestats2
  430. EACH TIMEDIFF games.botid tbl_LIHL.doublestats3
  431. ELSE TIMESTAMP games.creatorname tbl_LIHL.games
  432. ELSEIF TIMESTAMPADD games.creatorserver tbl_LIHL.id
  433. ELT TIMESTAMPDIFF games.datetime tbl_LIHL.intstats0
  434. ENABLE TIME_FORMAT games.duration tbl_LIHL.intstats1
  435. ENCLOSED TIME_TO_SEC games.gamename tbl_LIHL.intstats2
  436. ENCODE TINYBLOB games.gamestate tbl_LIHL.intstats3
  437. ENCRYPT TINYINT games.id tbl_LIHL.intstats4
  438. END TINYTEXT games.map tbl_LIHL.intstats5
  439. ENDPOINT TO games.ownername tbl_LIHL.intstats6
  440. ENGINE TOUCHES games.server tbl_LIHL.intstats7
  441. ENGINES TO_DAYS games.stats tbl_LIHL.losses
  442. ENUM TRAILING games.views tbl_LIHL.modify_date
  443. ENVELOPE TRANSACTION gamestate tbl_LIHL.name
  444. EQUALS TRIGGER gametrack tbl_LIHL.rank
  445. ERRORS TRIGGERS gametrack.bots tbl_LIHL.score
  446. ESCAPE TRIM gametrack.lastgames tbl_LIHL.server
  447. ESCAPED TRUE gametrack.name tbl_LIHL.wins
  448. EVENTS TRUNCATE gametrack.num_autoban team
  449. EXECUTE TYPE gametrack.num_games teamsize
  450. EXISTS TYPES gametrack.num_leftpercent tee
  451. EXIT Team1 gametrack.playingtime text
  452. EXP Team1Loses gametrack.realm tid
  453. EXPANSION Team1Wins gametrack.time_active time
  454. EXPLAIN Team2 gametrack.time_created time_active
  455. EXPORT_SET Team2Loses gametrack.total_leftpercent time_created
  456. EXTENDED Team2Wins generic_forum_preferences title
  457. EXTERIORRING Time generic_forum_preferences.fuser token
  458. EXTRACT UCASE generic_forum_preferences.k total_leftpercent
  459. FALSE UNCOMMITTED generic_forum_preferences.v totalplayers
  460. FAST UNCOMPRESS ghost tournament_id
  461. FETCH UNCOMPRESSED_LENGTH ghost_random towerkills
  462. FIELD UNDEFINED go towers
  463. FIELDS UNDO gold transaction_id
  464. -> gameplayers AS bg ON bg.gameid = b.gameid AND bg.colour = b.pid LEFT JOIN w3mmdplayers AS w ON w.gameid = b.gameid AND w.flag = 'winner' LEFT JOIN gameplayers AS wg ON wg.gameid = w.gameid AND wg.colour = w.pid WHERE ag.name = "diablo_" AND bg.name = "1007" AND wg.team IS NOT NULL AND wg.team != ag.team AND a.gameid = b.gameid AND ag.team = bg.team AND a.category = "lihl" AND b.category = "lihl"
  465. ->
  466. Display all 1894 possibilities? (y or n)
  467. -> ION ALL
  468. ->
  469. Display all 1894 possibilities? (y or n)
  470. ? PERIOD_DIFF dota2games.sec paypal_transactions.currency
  471. ABS PHASE dota2games.winner paypal_transactions.email
  472. ACOS PI dota2players paypal_transactions.memo
  473. ACTION POINT dota2players.assists paypal_transactions.name
  474. ADD POINTFROMTEXT dota2players.botid paypal_transactions.transaction_id
  475. ADDDATE POINTFROMWKB dota2players.colour performance_schema
  476. ADDTIME POINTN dota2players.courierkills permissions
  477. AES_DECRYPT POLYFROMTEXT dota2players.creepdenies permissions.name
  478. AES_ENCRYPT POLYFROMWKB dota2players.creepkills permissions.user_group
  479. AFTER POLYGON dota2players.deaths permissions.value
  480. AGAINST POLYGONFROMTEXT dota2players.gameid pid
  481. AGGREGATE POLYGONFROMWKB dota2players.gold piwik
  482. ALGORITHM POSITION dota2players.hero player
  483. ALL POW dota2players.id player_id
  484. ALTER POWER dota2players.item1 playingtime
  485. ANALYZE PRECISION dota2players.item2 plugin
  486. AND PREPARE dota2players.item3 plugindb
  487. ANY PREV dota2players.item4 plugindb.id
  488. AREA PRIMARY dota2players.item5 plugindb.k
  489. AS PRIVILEGES dota2players.item6 plugindb.plugin
  490. ASBINARY PROCEDURE dota2players.kills plugindb.val
  491. ASC PROCESS dota2players.neutralkills port
  492. ASCII PROCESSLIST dota2players.newcolour position
  493. ASENSITIVE PURGE dota2players.raxkills practicing
  494. ASIN Player1 dota2players.scorechange price
  495. ASTEXT Player2 dota2players.towerkills print
  496. ASWKB Player3 dota_elo_games_scored processed
  497. ASWKT Player4 dota_elo_games_scored.gameid prompt
  498. ATAN Player5 dota_elo_games_scored.id proxy
  499. ATAN2 Player6 dota_elo_scores queue
  500. AUTO_INCREMENT Poins dota_elo_scores.assists queue.id
  501. AVG QUARTER dota_elo_scores.courierkills queue.message
  502. AVG_ROW_LENGTH QUERY dota_elo_scores.creepdenies quit
  503. Activ QUICK dota_elo_scores.creepkills randname
  504. BACKUP QUOTE dota_elo_scores.deaths rank
  505. BDB RADIANS dota_elo_scores.games rax
  506. BEFORE RAND dota_elo_scores.id raxkills
  507. BEGIN READ dota_elo_scores.kills realm
  508. BENCHMARK READS dota_elo_scores.losses reason
  509. BERKELEYDB REAL dota_elo_scores.modify_date register_end
  510. BETWEEN RECOVER dota_elo_scores.name register_start
  511. -> T(DISTINCT a.gameid) FROM w3mmdplayers AS a LEFT JOIN gameplayers AS ag ON ag.gameid = a.gameid AND ag.colour = a.pid,
  512. ->
  513. Display all 1894 possibilities? (y or n)
  514. ? PERIOD_DIFF dota2games.sec paypal_transactions.currency
  515. ABS PHASE dota2games.winner paypal_transactions.email
  516. ACOS PI dota2players paypal_transactions.memo
  517. ACTION POINT dota2players.assists paypal_transactions.name
  518. ADD POINTFROMTEXT dota2players.botid paypal_transactions.transaction_id
  519. ADDDATE POINTFROMWKB dota2players.colour performance_schema
  520. ADDTIME POINTN dota2players.courierkills permissions
  521. AES_DECRYPT POLYFROMTEXT dota2players.creepdenies permissions.name
  522. AES_ENCRYPT POLYFROMWKB dota2players.creepkills permissions.user_group
  523. AFTER POLYGON dota2players.deaths permissions.value
  524. AGAINST POLYGONFROMTEXT dota2players.gameid pid
  525. AGGREGATE POLYGONFROMWKB dota2players.gold piwik
  526. ALGORITHM POSITION dota2players.hero player
  527. ALL POW dota2players.id player_id
  528. ALTER POWER dota2players.item1 playingtime
  529. ANALYZE PRECISION dota2players.item2 plugin
  530. AND PREPARE dota2players.item3 plugindb
  531. ANY PREV dota2players.item4 plugindb.id
  532. AREA PRIMARY dota2players.item5 plugindb.k
  533. AS PRIVILEGES dota2players.item6 plugindb.plugin
  534. ASBINARY PROCEDURE dota2players.kills plugindb.val
  535. ASC PROCESS dota2players.neutralkills port
  536. ASCII PROCESSLIST dota2players.newcolour position
  537. ASENSITIVE PURGE dota2players.raxkills practicing
  538. ASIN Player1 dota2players.scorechange price
  539. ASTEXT Player2 dota2players.towerkills print
  540. ASWKB Player3 dota_elo_games_scored processed
  541. ASWKT Player4 dota_elo_games_scored.gameid prompt
  542. ATAN Player5 dota_elo_games_scored.id proxy
  543. ATAN2 Player6 dota_elo_scores queue
  544. AUTO_INCREMENT Poins dota_elo_scores.assists queue.id
  545. AVG QUARTER dota_elo_scores.courierkills queue.message
  546. AVG_ROW_LENGTH QUERY dota_elo_scores.creepdenies quit
  547. Activ QUICK dota_elo_scores.creepkills randname
  548. BACKUP QUOTE dota_elo_scores.deaths rank
  549. BDB RADIANS dota_elo_scores.games rax
  550. BEFORE RAND dota_elo_scores.id raxkills
  551. BEGIN READ dota_elo_scores.kills realm
  552. BENCHMARK READS dota_elo_scores.losses reason
  553. BERKELEYDB REAL dota_elo_scores.modify_date register_end
  554. BETWEEN RECOVER dota_elo_scores.name register_start
  555. BIGINT REDUNDANT dota_elo_scores.neutralkills rehash
  556. BIN REFERENCES dota_elo_scores.rank replays
  557. BINARY REGEXP dota_elo_scores.raxkills replays.filename
  558. BINLOG RELAY_LOG_FILE dota_elo_scores.score replays.gameid
  559. BIT RELAY_LOG_POS dota_elo_scores.server replays.id
  560. BIT_AND RELAY_THREAD dota_elo_scores.towerkills replays.sid
  561. BIT_COUNT RELEASE dota_elo_scores.wins replays.status
  562. BIT_LENGTH RELEASE_LOCK dotagames reserved
  563. BIT_OR RELOAD dotagames.botid round_id
  564. BIT_XOR RENAME dotagames.gameid roundplayer_id
  565. BLOB REPAIR dotagames.id safelist
  566. BOOL REPEAT dotagames.min safelist.id
  567. BOOLEAN REPEATABLE dotagames.sec safelist.name
  568. BOTH REPLACE dotagames.winner safelist.server
  569. BTREE REPLICATION dotaplayers safelist.voucher
  570. BY REQUIRE dotaplayers.assists score
  571. BYTE RESET dotaplayers.botid scorechange
  572. CACHE RESTORE dotaplayers.colour scores
  573. CALL RESTRICT dotaplayers.courierkills scores.category
  574. CASCADE RESUME dotaplayers.creepdenies scores.id
  575. CASCADED RETURN dotaplayers.creepkills scores.name
  576. CASE RETURNS dotaplayers.deaths scores.score
  577. CAST REVERSE dotaplayers.gameid scores.server
  578. CEIL REVOKE dotaplayers.gold sec
  579. CEILING RIGHT dotaplayers.hero seen
  580. CENTROID RLIKE dotaplayers.id server
  581. CHAIN ROLLBACK dotaplayers.item1 sessionkey
  582. CHANGE ROLLUP dotaplayers.item2 set option
  583. CHANGED ROUND dotaplayers.item3 shortname
  584. CHAR ROUTINE dotaplayers.item4 show databases
  585. CHARACTER ROW dotaplayers.item5 show fields from
  586. CHARACTER_LENGTH ROWS dotaplayers.item6 show keys from
  587. CHARSET ROW_COUNT dotaplayers.kills show tables
  588. CHAR_LENGTH ROW_FORMAT dotaplayers.neutralkills sid
  589. CHECK RPAD dotaplayers.newcolour size
  590. CHECKSUM RTREE dotaplayers.raxkills skills
  591. CIPHER RTRIM dotaplayers.scorechange slotstaken
  592. CLIENT SAVEPOINT dotaplayers.towerkills slotstotal
  593. CLOSE SCHEMA doublestats0 source
  594. COALESCE SCHEMAS doublestats1 source_realm
  595. CODE SECOND doublestats2 source_username
  596. COERCIBILITY SECOND_MICROSECOND doublestats3 spoof
  597. COLLATE SECURITY downloads spoof.name
  598. COLLATION SEC_TO_TIME downloads.botid spoof.spoof
  599. COLUMN SELECT downloads.datetime spoofed
  600. COLUMNS SENSITIVE downloads.downloadtime spoofedrealm
  601. COMMENT SEPARATOR downloads.id startalert
  602. COMMIT SERIAL downloads.ip stats
  603. COMMITTED SERIALIZABLE downloads.map stats.assists
  604. COMPACT SESSION downloads.mapsize stats.banned
  605. COMPRESS SESSION_USER downloads.name stats.creeps
  606. COMPRESSED SET downloads.spoofed stats.deaths
  607. CONCAT SHA downloads.spoofedrealm stats.denies
  608. CONCAT_WS SHA1 downloadtime stats.draw
  609. CONCURRENT SHARE draw stats.games
  610. CONDITION SHOW duration stats.id
  611. CONNECTION SHUTDOWN edit stats.ip
  612. CONNECTION_ID SIGN ego stats.kills
  613. CONSISTENT SIGNED elo stats.losses
  614. CONSTRAINT SIMPLE email stats.neutrals
  615. CONTAINS SIN ent_forum stats.player
  616. CONTINUE SLAVE entconnect stats.rax
  617. CONV SLEEP entconnect.amh stats.score
  618. CONVERT SMALLINT entconnect.id stats.towers
  619. CONVERT_TZ SNAPSHOT entconnect.proxy stats.wins
  620. COS SOME entconnect.sessionkey stats_bot_status
  621. COT SONAME entconnect.startalert stats_bot_status.botid
  622. COUNT SOUNDEX entconnect.time stats_bot_status.botname
  623. CRC32 SOUNDS entconnect.username stats_bot_status.gamename
  624. CREATE SPACE entconnect.war3path stats_bot_status.last_update
  625. CROSS SPATIAL entconnect_list stats_bot_status.status
  626. CROSSES SPECIFIC entconnect_list.data stats_bot_status.uptime
  627. CUBE SQL entconnect_list.id stats_transfer_queue
  628. CURDATE SQLEXCEPTION entconnect_list.ipport stats_transfer_queue.admin_name
  629. CURRENT_DATE SQLSTATE entconnect_list.time stats_transfer_queue.category
  630. CURRENT_TIME SQLWARNING entry stats_transfer_queue.id
  631. CURRENT_TIMESTAMP SQL_BIG_RESULT eventtime stats_transfer_queue.source_realm
  632. CURRENT_USER SQL_BUFFER_RESULT exit stats_transfer_queue.source_username
  633. CURSOR SQL_CACHE expiredate stats_transfer_queue.swap
  634. CURTIME SQL_CALC_FOUND_ROWS filename stats_transfer_queue.target_realm
  635. DATA SQL_NO_CACHE flag stats_transfer_queue.target_username
  636. DATABASE SQL_SMALL_RESULT fuser stats_transfer_queue.time
  637. DATABASES SQL_THREAD gameid status
  638. DATE SQL_TSI_DAY gamelist stream_games
  639. DATEDIFF SQL_TSI_HOUR gamelist.age stream_games.botid
  640. DATETIME SQL_TSI_MINUTE gamelist.botid stream_games.gamename
  641. DATE_ADD SQL_TSI_MONTH gamelist.creatorname stream_games.last_update
  642. DATE_FORMAT SQL_TSI_QUARTER gamelist.eventtime stream_games.mapcrc
  643. DATE_SUB SQL_TSI_SECOND gamelist.gamename stream_games.mapflags
  644. DAY SQL_TSI_WEEK gamelist.id stream_games.mappath
  645. DAYNAME SQL_TSI_YEAR gamelist.lobby stream_games.port
  646. DAYOFMONTH SQRT gamelist.map stream_players
  647. DAYOFWEEK SRID gamelist.ownername stream_players.gamename
  648. DAYOFYEAR SSL gamelist.slotstaken stream_players.last_update
  649. DAY_HOUR START gamelist.slotstotal stream_players.name
  650. DAY_MICROSECOND STARTING gamelist.totalplayers summary
  651. DAY_MINUTE STARTPOINT gamelist.usernames swap
  652. DAY_SECOND STATUS gamename system
  653. DEALLOCATE STD gameplayers target_realm
  654. DEC STDDEV gameplayers.botid target_username
  655. DECIMAL STDDEV_POP gameplayers.colour targetbot
  656. DECLARE STDDEV_SAMP gameplayers.gameid tbl_DIHL
  657. DECODE STOP gameplayers.hostname tbl_DIHL.assists
  658. DEFAULT STORAGE gameplayers.id tbl_DIHL.captainlosses
  659. DEFINER STRAIGHT_JOIN gameplayers.ip tbl_DIHL.captainwins
  660. DEGREES STRCMP gameplayers.left tbl_DIHL.cocaptainlosses
  661. DELAYED STRING gameplayers.leftreason tbl_DIHL.cocaptainwins
  662. DELAY_KEY_WRITE STRIPED gameplayers.loadingtime tbl_DIHL.courierkills
  663. DELETE STR_TO_DATE gameplayers.name tbl_DIHL.creepdenies
  664. DESC SUBDATE gameplayers.processed tbl_DIHL.creepkills
  665. DESCRIBE SUBJECT gameplayers.reserved tbl_DIHL.deaths
  666. DES_DECRYPT SUBSTR gameplayers.spoofed tbl_DIHL.elo
  667. DES_ENCRYPT SUBSTRING gameplayers.spoofedrealm tbl_DIHL.games
  668. DES_KEY_FILE SUBSTRING_INDEX gameplayers.team tbl_DIHL.id
  669. DETERMINISTIC SUBTIME gamequeue tbl_DIHL.kills
  670. DIMENSION SUM gamequeue.command tbl_DIHL.losses
  671. DIRECTORY SUPER gamequeue.gamename tbl_DIHL.modify_date
  672. DISABLE SUSPEND gamequeue.id tbl_DIHL.name
  673. DISCARD SYSDATE gamequeue.location tbl_DIHL.neutralkills
  674. DISJOINT SYSTEM_USER gamequeue.mapname tbl_DIHL.rank
  675. DISTINCT TABLE gamequeue.maptype tbl_DIHL.raxkills
  676. DISTINCTROW TABLES gamequeue.obs tbl_DIHL.score
  677. DIV TABLESPACE gamequeue.realm tbl_DIHL.server
  678. DO TAN gamequeue.username tbl_DIHL.towerkills
  679. DOUBLE TEMPORARY gamequeue_status tbl_DIHL.wins
  680. DROP TEMPTABLE gamequeue_status.gamename tbl_LIHL
  681. DUAL TERMINATED gamequeue_status.location tbl_LIHL.category
  682. DUMPFILE TEXT gamequeue_status.position tbl_LIHL.doublestats0
  683. DUPLICATE THEN gamequeue_status.username tbl_LIHL.doublestats1
  684. DYNAMIC TIME games tbl_LIHL.doublestats2
  685. EACH TIMEDIFF games.botid tbl_LIHL.doublestats3
  686. ELSE TIMESTAMP games.creatorname tbl_LIHL.games
  687. ELSEIF TIMESTAMPADD games.creatorserver tbl_LIHL.id
  688. ELT TIMESTAMPDIFF games.datetime tbl_LIHL.intstats0
  689. ENABLE TIME_FORMAT games.duration tbl_LIHL.intstats1
  690. ENCLOSED TIME_TO_SEC games.gamename tbl_LIHL.intstats2
  691. ENCODE TINYBLOB games.gamestate tbl_LIHL.intstats3
  692. ENCRYPT TINYINT games.id tbl_LIHL.intstats4
  693. END TINYTEXT games.map tbl_LIHL.intstats5
  694. ENDPOINT TO games.ownername tbl_LIHL.intstats6
  695. ENGINE TOUCHES games.server tbl_LIHL.intstats7
  696. ENGINES TO_DAYS games.stats tbl_LIHL.losses
  697. ENUM TRAILING games.views tbl_LIHL.modify_date
  698. ENVELOPE TRANSACTION gamestate tbl_LIHL.name
  699. EQUALS TRIGGER gametrack tbl_LIHL.rank
  700. ERRORS TRIGGERS gametrack.bots tbl_LIHL.score
  701. ESCAPE TRIM gametrack.lastgames tbl_LIHL.server
  702. ESCAPED TRUE gametrack.name tbl_LIHL.wins
  703. EVENTS TRUNCATE gametrack.num_autoban team
  704. EXECUTE TYPE gametrack.num_games teamsize
  705. EXISTS TYPES gametrack.num_leftpercent tee
  706. EXIT Team1 gametrack.playingtime text
  707. EXP Team1Loses gametrack.realm tid
  708. EXPANSION Team1Wins gametrack.time_active time
  709. EXPLAIN Team2 gametrack.time_created time_active
  710. EXPORT_SET Team2Loses gametrack.total_leftpercent time_created
  711. EXTENDED Team2Wins generic_forum_preferences title
  712. EXTERIORRING Time generic_forum_preferences.fuser token
  713. EXTRACT UCASE generic_forum_preferences.k total_leftpercent
  714. FALSE UNCOMMITTED generic_forum_preferences.v totalplayers
  715. FAST UNCOMPRESS ghost tournament_id
  716. FETCH UNCOMPRESSED_LENGTH ghost_random towerkills
  717. FIELD UNDEFINED go towers
  718. FIELDS UNDO gold transaction_id
  719. -> gameplayers AS bg ON bg.gameid = b.gameid AND bg.colour = b.pid LEFT JOIN w3mmdplayers AS w ON w.gameid = b.gameid AND w.flag = 'winner' LEFT JOIN gameplayers AS wg ON wg.gameid = w.gameid AND wg.colour = w.pid WHERE ag.name = "diablo_" AND bg.name = "1007" AND wg.team IS NOT NULL AND wg.team = ag.team AND a.gameid = b.gameid AND ag.team != bg.team AND a.category = "lihl" AND b.category = "lihl"
  720. ->
  721. Display all 1894 possibilities? (y or n)
  722. -> ION ALL
  723. ->
  724. Display all 1894 possibilities? (y or n)
  725. ? PERIOD_DIFF dota2games.sec paypal_transactions.currency
  726. ABS PHASE dota2games.winner paypal_transactions.email
  727. ACOS PI dota2players paypal_transactions.memo
  728. ACTION POINT dota2players.assists paypal_transactions.name
  729. ADD POINTFROMTEXT dota2players.botid paypal_transactions.transaction_id
  730. ADDDATE POINTFROMWKB dota2players.colour performance_schema
  731. ADDTIME POINTN dota2players.courierkills permissions
  732. AES_DECRYPT POLYFROMTEXT dota2players.creepdenies permissions.name
  733. AES_ENCRYPT POLYFROMWKB dota2players.creepkills permissions.user_group
  734. AFTER POLYGON dota2players.deaths permissions.value
  735. AGAINST POLYGONFROMTEXT dota2players.gameid pid
  736. AGGREGATE POLYGONFROMWKB dota2players.gold piwik
  737. ALGORITHM POSITION dota2players.hero player
  738. ALL POW dota2players.id player_id
  739. ALTER POWER dota2players.item1 playingtime
  740. ANALYZE PRECISION dota2players.item2 plugin
  741. AND PREPARE dota2players.item3 plugindb
  742. ANY PREV dota2players.item4 plugindb.id
  743. AREA PRIMARY dota2players.item5 plugindb.k
  744. AS PRIVILEGES dota2players.item6 plugindb.plugin
  745. ASBINARY PROCEDURE dota2players.kills plugindb.val
  746. ASC PROCESS dota2players.neutralkills port
  747. ASCII PROCESSLIST dota2players.newcolour position
  748. ASENSITIVE PURGE dota2players.raxkills practicing
  749. ASIN Player1 dota2players.scorechange price
  750. ASTEXT Player2 dota2players.towerkills print
  751. ASWKB Player3 dota_elo_games_scored processed
  752. ASWKT Player4 dota_elo_games_scored.gameid prompt
  753. ATAN Player5 dota_elo_games_scored.id proxy
  754. ATAN2 Player6 dota_elo_scores queue
  755. AUTO_INCREMENT Poins dota_elo_scores.assists queue.id
  756. AVG QUARTER dota_elo_scores.courierkills queue.message
  757. AVG_ROW_LENGTH QUERY dota_elo_scores.creepdenies quit
  758. Activ QUICK dota_elo_scores.creepkills randname
  759. BACKUP QUOTE dota_elo_scores.deaths rank
  760. BDB RADIANS dota_elo_scores.games rax
  761. BEFORE RAND dota_elo_scores.id raxkills
  762. BEGIN READ dota_elo_scores.kills realm
  763. BENCHMARK READS dota_elo_scores.losses reason
  764. BERKELEYDB REAL dota_elo_scores.modify_date register_end
  765. BETWEEN RECOVER dota_elo_scores.name register_start
  766. -> T(DISTINCT a.gameid) FROM w3mmdplayers AS a LEFT JOIN gameplayers AS ag ON ag.gameid = a.gameid AND ag.colour = a.pid,
  767. ->
  768. Display all 1894 possibilities? (y or n)
  769. ? PERIOD_DIFF dota2games.sec paypal_transactions.currency
  770. ABS PHASE dota2games.winner paypal_transactions.email
  771. ACOS PI dota2players paypal_transactions.memo
  772. ACTION POINT dota2players.assists paypal_transactions.name
  773. ADD POINTFROMTEXT dota2players.botid paypal_transactions.transaction_id
  774. ADDDATE POINTFROMWKB dota2players.colour performance_schema
  775. ADDTIME POINTN dota2players.courierkills permissions
  776. AES_DECRYPT POLYFROMTEXT dota2players.creepdenies permissions.name
  777. AES_ENCRYPT POLYFROMWKB dota2players.creepkills permissions.user_group
  778. AFTER POLYGON dota2players.deaths permissions.value
  779. AGAINST POLYGONFROMTEXT dota2players.gameid pid
  780. AGGREGATE POLYGONFROMWKB dota2players.gold piwik
  781. ALGORITHM POSITION dota2players.hero player
  782. ALL POW dota2players.id player_id
  783. ALTER POWER dota2players.item1 playingtime
  784. ANALYZE PRECISION dota2players.item2 plugin
  785. AND PREPARE dota2players.item3 plugindb
  786. ANY PREV dota2players.item4 plugindb.id
  787. AREA PRIMARY dota2players.item5 plugindb.k
  788. AS PRIVILEGES dota2players.item6 plugindb.plugin
  789. ASBINARY PROCEDURE dota2players.kills plugindb.val
  790. ASC PROCESS dota2players.neutralkills port
  791. ASCII PROCESSLIST dota2players.newcolour position
  792. ASENSITIVE PURGE dota2players.raxkills practicing
  793. ASIN Player1 dota2players.scorechange price
  794. ASTEXT Player2 dota2players.towerkills print
  795. ASWKB Player3 dota_elo_games_scored processed
  796. ASWKT Player4 dota_elo_games_scored.gameid prompt
  797. ATAN Player5 dota_elo_games_scored.id proxy
  798. ATAN2 Player6 dota_elo_scores queue
  799. AUTO_INCREMENT Poins dota_elo_scores.assists queue.id
  800. AVG QUARTER dota_elo_scores.courierkills queue.message
  801. AVG_ROW_LENGTH QUERY dota_elo_scores.creepdenies quit
  802. Activ QUICK dota_elo_scores.creepkills randname
  803. BACKUP QUOTE dota_elo_scores.deaths rank
  804. BDB RADIANS dota_elo_scores.games rax
  805. BEFORE RAND dota_elo_scores.id raxkills
  806. BEGIN READ dota_elo_scores.kills realm
  807. BENCHMARK READS dota_elo_scores.losses reason
  808. BERKELEYDB REAL dota_elo_scores.modify_date register_end
  809. BETWEEN RECOVER dota_elo_scores.name register_start
  810. BIGINT REDUNDANT dota_elo_scores.neutralkills rehash
  811. BIN REFERENCES dota_elo_scores.rank replays
  812. BINARY REGEXP dota_elo_scores.raxkills replays.filename
  813. BINLOG RELAY_LOG_FILE dota_elo_scores.score replays.gameid
  814. BIT RELAY_LOG_POS dota_elo_scores.server replays.id
  815. BIT_AND RELAY_THREAD dota_elo_scores.towerkills replays.sid
  816. BIT_COUNT RELEASE dota_elo_scores.wins replays.status
  817. BIT_LENGTH RELEASE_LOCK dotagames reserved
  818. BIT_OR RELOAD dotagames.botid round_id
  819. BIT_XOR RENAME dotagames.gameid roundplayer_id
  820. BLOB REPAIR dotagames.id safelist
  821. BOOL REPEAT dotagames.min safelist.id
  822. BOOLEAN REPEATABLE dotagames.sec safelist.name
  823. BOTH REPLACE dotagames.winner safelist.server
  824. BTREE REPLICATION dotaplayers safelist.voucher
  825. BY REQUIRE dotaplayers.assists score
  826. BYTE RESET dotaplayers.botid scorechange
  827. CACHE RESTORE dotaplayers.colour scores
  828. CALL RESTRICT dotaplayers.courierkills scores.category
  829. CASCADE RESUME dotaplayers.creepdenies scores.id
  830. CASCADED RETURN dotaplayers.creepkills scores.name
  831. CASE RETURNS dotaplayers.deaths scores.score
  832. CAST REVERSE dotaplayers.gameid scores.server
  833. CEIL REVOKE dotaplayers.gold sec
  834. CEILING RIGHT dotaplayers.hero seen
  835. CENTROID RLIKE dotaplayers.id server
  836. CHAIN ROLLBACK dotaplayers.item1 sessionkey
  837. CHANGE ROLLUP dotaplayers.item2 set option
  838. CHANGED ROUND dotaplayers.item3 shortname
  839. CHAR ROUTINE dotaplayers.item4 show databases
  840. CHARACTER ROW dotaplayers.item5 show fields from
  841. CHARACTER_LENGTH ROWS dotaplayers.item6 show keys from
  842. CHARSET ROW_COUNT dotaplayers.kills show tables
  843. CHAR_LENGTH ROW_FORMAT dotaplayers.neutralkills sid
  844. CHECK RPAD dotaplayers.newcolour size
  845. CHECKSUM RTREE dotaplayers.raxkills skills
  846. CIPHER RTRIM dotaplayers.scorechange slotstaken
  847. CLIENT SAVEPOINT dotaplayers.towerkills slotstotal
  848. CLOSE SCHEMA doublestats0 source
  849. COALESCE SCHEMAS doublestats1 source_realm
  850. CODE SECOND doublestats2 source_username
  851. COERCIBILITY SECOND_MICROSECOND doublestats3 spoof
  852. COLLATE SECURITY downloads spoof.name
  853. COLLATION SEC_TO_TIME downloads.botid spoof.spoof
  854. COLUMN SELECT downloads.datetime spoofed
  855. COLUMNS SENSITIVE downloads.downloadtime spoofedrealm
  856. COMMENT SEPARATOR downloads.id startalert
  857. COMMIT SERIAL downloads.ip stats
  858. COMMITTED SERIALIZABLE downloads.map stats.assists
  859. COMPACT SESSION downloads.mapsize stats.banned
  860. COMPRESS SESSION_USER downloads.name stats.creeps
  861. COMPRESSED SET downloads.spoofed stats.deaths
  862. CONCAT SHA downloads.spoofedrealm stats.denies
  863. CONCAT_WS SHA1 downloadtime stats.draw
  864. CONCURRENT SHARE draw stats.games
  865. CONDITION SHOW duration stats.id
  866. CONNECTION SHUTDOWN edit stats.ip
  867. CONNECTION_ID SIGN ego stats.kills
  868. CONSISTENT SIGNED elo stats.losses
  869. CONSTRAINT SIMPLE email stats.neutrals
  870. CONTAINS SIN ent_forum stats.player
  871. CONTINUE SLAVE entconnect stats.rax
  872. CONV SLEEP entconnect.amh stats.score
  873. CONVERT SMALLINT entconnect.id stats.towers
  874. CONVERT_TZ SNAPSHOT entconnect.proxy stats.wins
  875. COS SOME entconnect.sessionkey stats_bot_status
  876. COT SONAME entconnect.startalert stats_bot_status.botid
  877. COUNT SOUNDEX entconnect.time stats_bot_status.botname
  878. CRC32 SOUNDS entconnect.username stats_bot_status.gamename
  879. CREATE SPACE entconnect.war3path stats_bot_status.last_update
  880. CROSS SPATIAL entconnect_list stats_bot_status.status
  881. CROSSES SPECIFIC entconnect_list.data stats_bot_status.uptime
  882. CUBE SQL entconnect_list.id stats_transfer_queue
  883. CURDATE SQLEXCEPTION entconnect_list.ipport stats_transfer_queue.admin_name
  884. CURRENT_DATE SQLSTATE entconnect_list.time stats_transfer_queue.category
  885. CURRENT_TIME SQLWARNING entry stats_transfer_queue.id
  886. CURRENT_TIMESTAMP SQL_BIG_RESULT eventtime stats_transfer_queue.source_realm
  887. CURRENT_USER SQL_BUFFER_RESULT exit stats_transfer_queue.source_username
  888. CURSOR SQL_CACHE expiredate stats_transfer_queue.swap
  889. CURTIME SQL_CALC_FOUND_ROWS filename stats_transfer_queue.target_realm
  890. DATA SQL_NO_CACHE flag stats_transfer_queue.target_username
  891. DATABASE SQL_SMALL_RESULT fuser stats_transfer_queue.time
  892. DATABASES SQL_THREAD gameid status
  893. DATE SQL_TSI_DAY gamelist stream_games
  894. DATEDIFF SQL_TSI_HOUR gamelist.age stream_games.botid
  895. DATETIME SQL_TSI_MINUTE gamelist.botid stream_games.gamename
  896. DATE_ADD SQL_TSI_MONTH gamelist.creatorname stream_games.last_update
  897. DATE_FORMAT SQL_TSI_QUARTER gamelist.eventtime stream_games.mapcrc
  898. DATE_SUB SQL_TSI_SECOND gamelist.gamename stream_games.mapflags
  899. DAY SQL_TSI_WEEK gamelist.id stream_games.mappath
  900. DAYNAME SQL_TSI_YEAR gamelist.lobby stream_games.port
  901. DAYOFMONTH SQRT gamelist.map stream_players
  902. DAYOFWEEK SRID gamelist.ownername stream_players.gamename
  903. DAYOFYEAR SSL gamelist.slotstaken stream_players.last_update
  904. DAY_HOUR START gamelist.slotstotal stream_players.name
  905. DAY_MICROSECOND STARTING gamelist.totalplayers summary
  906. DAY_MINUTE STARTPOINT gamelist.usernames swap
  907. DAY_SECOND STATUS gamename system
  908. DEALLOCATE STD gameplayers target_realm
  909. DEC STDDEV gameplayers.botid target_username
  910. DECIMAL STDDEV_POP gameplayers.colour targetbot
  911. DECLARE STDDEV_SAMP gameplayers.gameid tbl_DIHL
  912. DECODE STOP gameplayers.hostname tbl_DIHL.assists
  913. DEFAULT STORAGE gameplayers.id tbl_DIHL.captainlosses
  914. DEFINER STRAIGHT_JOIN gameplayers.ip tbl_DIHL.captainwins
  915. DEGREES STRCMP gameplayers.left tbl_DIHL.cocaptainlosses
  916. DELAYED STRING gameplayers.leftreason tbl_DIHL.cocaptainwins
  917. DELAY_KEY_WRITE STRIPED gameplayers.loadingtime tbl_DIHL.courierkills
  918. DELETE STR_TO_DATE gameplayers.name tbl_DIHL.creepdenies
  919. DESC SUBDATE gameplayers.processed tbl_DIHL.creepkills
  920. DESCRIBE SUBJECT gameplayers.reserved tbl_DIHL.deaths
  921. DES_DECRYPT SUBSTR gameplayers.spoofed tbl_DIHL.elo
  922. DES_ENCRYPT SUBSTRING gameplayers.spoofedrealm tbl_DIHL.games
  923. DES_KEY_FILE SUBSTRING_INDEX gameplayers.team tbl_DIHL.id
  924. DETERMINISTIC SUBTIME gamequeue tbl_DIHL.kills
  925. DIMENSION SUM gamequeue.command tbl_DIHL.losses
  926. DIRECTORY SUPER gamequeue.gamename tbl_DIHL.modify_date
  927. DISABLE SUSPEND gamequeue.id tbl_DIHL.name
  928. DISCARD SYSDATE gamequeue.location tbl_DIHL.neutralkills
  929. DISJOINT SYSTEM_USER gamequeue.mapname tbl_DIHL.rank
  930. DISTINCT TABLE gamequeue.maptype tbl_DIHL.raxkills
  931. DISTINCTROW TABLES gamequeue.obs tbl_DIHL.score
  932. DIV TABLESPACE gamequeue.realm tbl_DIHL.server
  933. DO TAN gamequeue.username tbl_DIHL.towerkills
  934. DOUBLE TEMPORARY gamequeue_status tbl_DIHL.wins
  935. DROP TEMPTABLE gamequeue_status.gamename tbl_LIHL
  936. DUAL TERMINATED gamequeue_status.location tbl_LIHL.category
  937. DUMPFILE TEXT gamequeue_status.position tbl_LIHL.doublestats0
  938. DUPLICATE THEN gamequeue_status.username tbl_LIHL.doublestats1
  939. DYNAMIC TIME games tbl_LIHL.doublestats2
  940. EACH TIMEDIFF games.botid tbl_LIHL.doublestats3
  941. ELSE TIMESTAMP games.creatorname tbl_LIHL.games
  942. ELSEIF TIMESTAMPADD games.creatorserver tbl_LIHL.id
  943. ELT TIMESTAMPDIFF games.datetime tbl_LIHL.intstats0
  944. ENABLE TIME_FORMAT games.duration tbl_LIHL.intstats1
  945. ENCLOSED TIME_TO_SEC games.gamename tbl_LIHL.intstats2
  946. ENCODE TINYBLOB games.gamestate tbl_LIHL.intstats3
  947. ENCRYPT TINYINT games.id tbl_LIHL.intstats4
  948. END TINYTEXT games.map tbl_LIHL.intstats5
  949. ENDPOINT TO games.ownername tbl_LIHL.intstats6
  950. ENGINE TOUCHES games.server tbl_LIHL.intstats7
  951. ENGINES TO_DAYS games.stats tbl_LIHL.losses
  952. ENUM TRAILING games.views tbl_LIHL.modify_date
  953. ENVELOPE TRANSACTION gamestate tbl_LIHL.name
  954. EQUALS TRIGGER gametrack tbl_LIHL.rank
  955. ERRORS TRIGGERS gametrack.bots tbl_LIHL.score
  956. ESCAPE TRIM gametrack.lastgames tbl_LIHL.server
  957. ESCAPED TRUE gametrack.name tbl_LIHL.wins
  958. EVENTS TRUNCATE gametrack.num_autoban team
  959. EXECUTE TYPE gametrack.num_games teamsize
  960. EXISTS TYPES gametrack.num_leftpercent tee
  961. EXIT Team1 gametrack.playingtime text
  962. EXP Team1Loses gametrack.realm tid
  963. EXPANSION Team1Wins gametrack.time_active time
  964. EXPLAIN Team2 gametrack.time_created time_active
  965. EXPORT_SET Team2Loses gametrack.total_leftpercent time_created
  966. EXTENDED Team2Wins generic_forum_preferences title
  967. EXTERIORRING Time generic_forum_preferences.fuser token
  968. EXTRACT UCASE generic_forum_preferences.k total_leftpercent
  969. FALSE UNCOMMITTED generic_forum_preferences.v totalplayers
  970. FAST UNCOMPRESS ghost tournament_id
  971. FETCH UNCOMPRESSED_LENGTH ghost_random towerkills
  972. FIELD UNDEFINED go towers
  973. FIELDS UNDO gold transaction_id
  974. -> gameplayers AS bg ON bg.gameid = b.gameid AND bg.colour = b.pid LEFT JOIN w3mmdplayers AS w ON w.gameid = b.gameid AND w.flag = 'winner' LEFT JOIN gameplayers AS wg ON wg.gameid = w.gameid AND wg.colour = w.pid WHERE ag.name = "diablo_" AND bg.name = "1007" AND wg.team IS NOT NULL AND wg.team = bg.team AND a.gameid = b.gameid AND ag.team != bg.team AND a.category = "lihl" AND b.category = "lihl";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!