Page MenuHomePhabricator
Paste P163

Wrong query, but will be useful as a reference later when we have the Date header information
ActivePublic

Authored by Gilles on Dec 17 2014, 10:15 AM.
SELECT event_total, timestamp, event_age, DATE_FORMAT(FROM_UNIXTIME(event_timestamp), '%Y%m%d%H%i%s') AS last_modified, event_uploadTimestamp FROM MultimediaViewerNetworkPerformance_10596581 WHERE event_type = 'image' AND event_varnish1hits = 0 AND event_varnish2hits = 0 AND event_varnish3hits = 0 AND event_uploadTimestamp IS NOT NULL HAVING timestamp - last_modified > event_age + 2

Event Timeline

Gilles edited the content of this paste. (Show Details)Dec 17 2014, 10:15 AM
Gilles changed the title of this paste from untitled to Wrong query, but will be useful as a reference later when we have the Date header information.
Gilles updated the paste's language from autodetect to autodetect.

DATE_FORMAT(FROM_UNIXTIME(event_timestamp), '%Y%m%d%H%i%s') is actually "Date" and not Last-Modified