$sql = "SELECT `ID` FROM $wpdb->posts WHERE `post_date`<'".date('Y-m-d h:i:s', strtotime("-$prun_period days"))."' AND `post_status`='publish' AND `post_type`='post' LIMIT 10";
$prun_exp_time = date('Y-m-d', time());
$sql = "SELECT * FROM $wpdb->posts
LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
WHERE `meta_key`='e_date'
AND `meta_value` != ''
AND '$prun_exp_time' > `meta_value` AND `post_status`='publish' AND `post_type`='post' LIMIT 10";
There are currently 1 users browsing this thread. (0 members and 1 guests)
