Skip to content

Instantly share code, notes, and snippets.

@fedir

fedir/getPowermailSentMails.sql

Last active December 17, 2015 16:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fedir/5637338 to your computer and use it in GitHub Desktop.
Save fedir/5637338 to your computer and use it in GitHub Desktop.
Download ZIP
Get powermail sent mails since some time #typo3 #powermail
Raw
getPowermailSentMails.sql
# Count first
SELECT count(1) FROM tx_powermail_mails WHERE (tstamp > unix_timestamp(STR_TO_DATE('01:00:00','%d/%m/%Y %H:%i:%s'))) AND (tstamp < unix_timestamp(STR_TO_DATE('01:01:00','%d/%m/%Y %H:%i:%s'))) ORDER BY FROM_UNIXTIME(tstamp) ASC;
# Get dates
SELECT FROM_UNIXTIME(tstamp) FROM tx_powermail_mails WHERE (tstamp > unix_timestamp(STR_TO_DATE('01:00:00','%d/%m/%Y %H:%i:%s'))) AND (tstamp < unix_timestamp(STR_TO_DATE('01:01:00','%d/%m/%Y %H:%i:%s'))) ORDER BY time_send ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment