SELECT MAX ( `p` . `post_modified_gmt` ) AS `last_modified` , MIN ( `p` . `post_date_gmt` ) AS `published_at` FROM `wp_posts` AS `p` INNER JOIN `wp_term_relationships` AS `term_rel` ON `term_rel` . `object_id` = `p` . `ID` INNER JOIN `wp_term_taxonomy` AS `term_tax` ON `term_tax` . `term_taxonomy_id` = `term_rel` . `term_taxonomy_id` AND `term_tax` . `taxonomy` = ? AND `term_tax` . `term_id` = ? WHERE `p` . `post_status` IN (?) AND `p` . `post_password` = ? 