File: sql_spooler.txt

package info (click to toggle)

kopanocore 8.7.0-3

links: PTS, VCS
area: main
in suites: buster
size: 15,400 kB
sloc: cpp: 175,422; python: 24,623; perl: 7,319; php: 6,056; sh: 2,172; makefile: 1,294; xml: 45; ansic: 1

file content (6 lines) | stat: -rw-r--r-- 304 bytes

# Show outgoing mail queue and if any mail resting there uses the
# deferred delivery time feature.
#
SELECT q.hierarchy_id, FROM_UNIXTIME(((pt.val_hi<<32)+pt.val_lo-116444736000000000)/10000000) AS tm
FROM outgoingqueue AS q
LEFT JOIN properties AS pt ON q.hierarchy_id=pt.hierarchyid AND pt.tag=16367;