SELECT GROUP_CONCAT(C.TABLE_ID ORDER BY 1) AS TABLE_ID
FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS C
LEFT JOIN
(
	SELECT DISTINCT TABLE_ID
	FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES
	WHERE TYPE=32
) I ON C.TABLE_ID=I.TABLE_ID
WHERE C.NAME = 'FTS_DOC_ID'
AND I.TABLE_ID IS NULL;

SELECT 
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(SUBSTRING_INDEX(NAME,'/',1),'@0040','@'),'@0025','%'),'@0023','#'),'@0024','$'),'@0021','!'),'@005e','^'),'@002a','*'),'@003f','?'),'@002e','.'),'@003e','>'),'@003c','<'),'@007c','|'),'@002d','-'),'@002b','+'),'@002c',','),'@0020',' ') AS TABLE_SCHEMA
,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(NAME,'/',-1),'#P',1),'@0040','@'),'@0025','%'),'@0023','#'),'@0024','$'),'@0021','!'),'@005e','^'),'@002a','*'),'@003f','?'),'@002e','.'),'@003e','>'),'@003c','<'),'@007c','|'),'@002d','-'),'@002b','+'),'@002c',','),'@0020',' ') AS TABLE_NAME
FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES
WHERE TABLE_ID IN (); /*Substitute value from Previous Query */