…e = '0:0:0:0:0:0:0:1' LIMIT 1 0.0000ms User::load SELECT ipb_id,ipb_address,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_sitewide,comment_ipb_reason.comment_text AS `…
… Query: SET STATEMENT max_statement_time=30 FOR SELECT * FROM ((SELECT rc_id,rc_timestamp,rc_namespace,rc_title,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc…
… date current_date() current_time current_time() -> time current_time() current_timestamp current_timestamp() -> date current_timestamp() date date(date) -> date date('2000-01-02') datediff datediff(date, date) -> integer datediff(date('2000-01-02'), date('2000-01-01')) datetime …
…gitb #cgitb.enable() import MySQLdb, sys, urllib2 #Aux function for normalizing timestamps def timestamp(ts): if not ts: return "×" else: return "%s/%s/%s %s:%s:%s" % (ts[:4], ts[4:6], ts[6:8], ts[8:10], ts[10:12], ts[12:]) #Needs to send these headers print "Content-Type: text/h…
…each, e.g. to "subscribe" to notices of new posts (something with a new sig and timestamp) to a talk page or even a specific thread at one, on the communication side. Or be notified of any changes at all to the content of a certain non-talk page. And whatever. I'm sure different …
…the data should always be refreshed, the ttl value SHOULD be . The last_updated timestamp represents the publisher's knowledge of the current state of the system at this point in time. The last_reported timestamp represents the last time a station or vehicle reported its status t…
…ce number | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | timestamp | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | synchronization source (SSRC) identifier | +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ | contribut…
…ce number | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | timestamp | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | synchronization source (SSRC) identifier | +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ | contribut…
…'revisionday2' , 'revisionmonth' , 'revisionmonth1' , 'revisionyear' , 'revisiontimestamp' , 'revisionuser' , 'cascadingsources' , 'namespace' , 'namespacee' , 'namespacenumber' , 'talkspace' , 'talkspacee' , 'subjectspace' , 'subjectspacee' , # More parser functions correspondin…
…ce number | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | timestamp | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | synchronization source (SSRC) identifier | +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ | contribut…
…ce number | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | timestamp | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | synchronization source (SSRC) identifier | +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ | contribut…
…g designed primarily for append-only data and ensuring that each document has a timestamp field. A data stream is internally composed of multiple backing indexes. Search requests are routed to all the backing indexes, while indexing requests are routed to the latest write index. …
…duction. Sorting by a single field The following example sorts the index by the timestamp field in descending order: PUT /sample-index { "settings" : { "index" : { "sort.field" : "timestamp" , "sort.order" : "desc" } }, "mappings" : { "properties" : { "timestamp" : { "type" : "da…
…', 'itwiki', 'ruwiki') AND event_isAnon = 1 AND event_popupEnabled = 1 AND LEFT(timestamp, 8) >= '20160925' AND LEFT(timestamp, 8) < '20161030' AND (event_action = 'pageLoaded' OR (event_totalInteractionTime >= event_popupDelay + event_perceivedWait + 1000 )) # card seen for at l…
…ple_data_logs/_search "size" "aggs" "logs_per_month" "date_histogram" "field" "@timestamp" "calendar_interval" "1M" copy Example: Uniform hourly buckets (fixed interval) Retrieve buckets with a fixed interval of exactly 1 hour, regardless of daylight saving time changes: GET my-l…