SELECT sourceip, LOGSOURCENAME(logsourceid) AS log_source, COUNT(*) AS 'Hits', MIN(starttime) AS first_ms, MAX(starttime) AS last_ms FROM events WHERE ((UTF8(payload) ILIKE '%php-fpm%' OR UTF8(payload) ILIKE '%php-cgi%' OR UTF8(payload) ILIKE '%lsphp%') AND (UTF8(payload) ILIKE '%exited on signal 11%' OR UTF8(payload) ILIKE '%exited on signal 7%' OR UTF8(payload) ILIKE '%exited on signal 6%' OR UTF8(payload) ILIKE '%SIGSEGV%' OR UTF8(payload) ILIKE '%SIGBUS%' OR UTF8(payload) ILIKE '% segfault at %')) AND LOGSOURCETYPENAME(devicetype) IN ('Linux OS') GROUP BY sourceip, logsourceid HAVING "Hits" >= 5 ORDER BY "Hits" DESC LAST 7 DAYS