SELECT pl.ID AS ID, trx.trx_id AS TRX_ID, pl.STATE AS STATE, trx.trx_state AS TRX_STATE, waits.blocking_trx_id AS BLOCKING_TRX_ID, trx.trx_weight AS RECORDS, trx.trx_query AS QUERY FROM information_schema.INNODB_TRX AS trx LEFT JOIN information_schema.PROCESSLIST AS pl ON trx.trx_mysql_thread_id = pl.ID LEFT JOIN information_schema.INNODB_LOCK_WAITS AS waits ON trx.trx_id = waits.requesting_trx_id