Reminder cron job API

21:55:45


SELECT p.ID, p.post_title AS text, p.post_author AS user, DATE_SUB(from_unixtime(pm1.meta_value), INTERVAL 1 HOUR) AS 'date', NOW() AS 'now', DATE_SUB(NOW(), INTERVAL 1 MINUTE) AS 'now_1', TIMESTAMPDIFF( MINUTE, DATE_SUB(NOW(), INTERVAL 1 MINUTE), DATE_SUB(from_unixtime(pm1.meta_value), INTERVAL 1 HOUR) ) as minutes FROM wp_posts p LEFT JOIN wp_postmeta pm1 ON p.ID = pm1.post_id AND pm1.meta_key = 'wpcf-data-e-ora' WHERE post_type = 'promemoria' AND post_status = 'publish' AND TIMESTAMPDIFF( MINUTE, DATE_SUB(NOW(), INTERVAL 1 MINUTE), DATE_SUB(from_unixtime(pm1.meta_value), INTERVAL 1 HOUR) ) > -60
Array ( )