Медленные страницы поиска

Please login or create account to add a snippet.

Follow @TagMyCode

Language: SQL

Posted by: Dmitriy Lanets

Added: Nov 22, 2019 7:50 AM

Tags: mysql

SELECT COUNT(d) AS c, DATE_FORMAT(s.sse_timestamp,"%Y-%m-%d") AS dat FROM(
SELECT ss.sse_timestamp,TO_DAYS(ss.sse_timestamp) AS d, sse_time FROM search_stat ss WHERE ss.sse_time > 100 AND ss.sse_timestamp >= NOW() - INTERVAL 14 DAY) AS s
GROUP BY d
ORDER BY s.sse_timestamp DESC