/usr/sbin/mysqld, Version: 10.2.17-MariaDB-log (MariaDB Server). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
180818 12:16:45	    9 Connect	ipswichdba@192.168.163.128 as anonymous on 
		    9 Query	SELECT CONNECTION_ID()
		    9 Query	SET NAMES utf8mb4
		    9 Query	SHOW STATUS
		    9 Query	SHOW VARIABLES
		    9 Query	SHOW DATABASES
		    9 Query	SHOW OPEN TABLES FROM ipswichdb WHERE `in_use`!=0
		    9 Query	SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='ipswichdb'
		    9 Query	SHOW TABLE STATUS FROM `ipswichdb`
		    9 Query	SHOW FUNCTION STATUS WHERE `Db`='ipswichdb'
		    9 Query	SHOW PROCEDURE STATUS WHERE `Db`='ipswichdb'
		    9 Query	SHOW TRIGGERS FROM `ipswichdb`
		    9 Query	SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='information_schema'
		    9 Query	SHOW TABLE STATUS FROM `information_schema`
		    9 Query	SHOW FUNCTION STATUS WHERE `Db`='information_schema'
		    9 Query	SHOW PROCEDURE STATUS WHERE `Db`='information_schema'
		    9 Query	SHOW TRIGGERS FROM `information_schema`
		    9 Query	SHOW EVENTS FROM `information_schema`
		    9 Query	SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='ipswichdb'
		    9 Query	USE `ipswichdb`
180818 12:16:54	    9 Query	DROP TABLE IF EXISTS TEST_TABLE_1
		    9 Query	CREATE TABLE TEST_TABLE_1 (
UID BIGINT
)
		    9 Query	DROP TABLE IF EXISTS TEST_TABLE_2
		    9 Query	CREATE TABLE TEST_TABLE_2 (
UID BIGINT
)
		    9 Query	DROP TABLE IF EXISTS TEST_TABLE_3
		    9 Query	CREATE TABLE TEST_TABLE_3 (
UID BIGINT
)
		    9 Query	SELECT
ROW_NUMBER() OVER (PARTITION BY GROUP_CONCAT(TT1.UID))

FROM TEST_TABLE_1 TT1
WHERE EXISTS (
SELECT *
FROM TEST_TABLE_2 TT2
JOIN TEST_TABLE_3 TT3 ON TT2.UID = TT3.UID
WHERE TT3.UID = TT1.UID
)
GROUP BY TT1.UID
/usr/sbin/mysqld, Version: 10.2.17-MariaDB-log (MariaDB Server). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument