/*execute before the rpt*/
SET GLOBAL general_log='ON';
SET GLOBAL log_output='TABLE';

TRUNCATE TABLE mysql.general_log;
/*run disaster.sql*/

/* execute all this for the rpt*/
SET GLOBAL general_log='OFF';

CREATE TABLE LOGGING(
name         VARCHAR(20)      ,
times          DECIMAL(6));

INSERT INTO LOGGING
(SELECT 'APPLICANT' , COUNT(*) TIMES
FROM mysql.general_log
WHERE  argument LIKE '%APPLICANT%'
GROUP BY 'APPLICANT'
ORDER BY TIMES ASC);

INSERT INTO LOGGING
(SELECT 'APPLIES' , COUNT(*) TIMES
FROM mysql.general_log
WHERE  argument LIKE '%APPLIES%'
GROUP BY 'APPLIES'
ORDER BY TIMES ASC);

INSERT INTO LOGGING
(SELECT 'EMPLOYER' , COUNT(*) TIMES
FROM mysql.general_log
WHERE  argument LIKE '%EMPLOYER%'
GROUP BY 'EMPLOYER'
ORDER BY TIMES ASC);

INSERT INTO LOGGING
(SELECT 'EMPLBY' , COUNT(*) TIMES
FROM mysql.general_log
WHERE  argument LIKE '%EMPLBY%'
GROUP BY 'EMPLBY'
ORDER BY TIMES ASC);

INSERT INTO LOGGING
(SELECT 'SNEEDED' , COUNT(*) TIMES
FROM mysql.general_log
WHERE  argument LIKE '%SNEEDED%'
GROUP BY 'SNEEDED'
ORDER BY TIMES ASC);

INSERT INTO LOGGING
(SELECT 'SPOSSESSED' , COUNT(*) TIMES
FROM mysql.general_log
WHERE  argument LIKE '%SPOSSESSED%'
GROUP BY 'SPOSSESSED'
ORDER BY TIMES ASC);

INSERT INTO LOGGING
(SELECT 'POSITIONS' , COUNT(*) TIMES
FROM mysql.general_log
WHERE  argument LIKE '%POSITIONS%'
GROUP BY 'POSITIONS'
ORDER BY TIMES ASC);

INSERT INTO LOGGING
(SELECT 'SREQUIRED' , COUNT(*) TIMES
FROM mysql.general_log
WHERE  argument LIKE '%SREQUIRED%'
GROUP BY 'SREQUIRED'
ORDER BY TIMES ASC);

INSERT INTO LOGGING
(SELECT 'SKILL' , COUNT(*) TIMES
FROM mysql.general_log
WHERE  argument LIKE '%SKILL%'
GROUP BY 'SKILL'
ORDER BY TIMES ASC);

SELECT * FROM LOGGING;