Reminder cron job API


<h1>Reminder cron job API</h1>
<p>03:08:18</p>

</br>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</br>Array
(
)