1.1 KiB
1.1 KiB
LEFT JOIN %s pm1 ON p.ID = pm1.post_id AND pm1.meta_key = 'hotornot_vote_user_id' LEFT JOIN %s pm2 ON p.ID = pm2.post_id AND pm2.meta_key = 'thesgem_start_date' LEFT JOIN %s pm3 ON p.ID = pm3.post_id AND pm3.meta_key = 'thesgem_end_date' WHERE p.post_type = 'hotornot' AND p.post_status = 'publish' AND pm1.meta_value <> %d AND (CURDATE() BETWEEN STR_TO_DATE(pm2.meta_value, '%%Y-%%m-%%d') AND STR_TO_DATE(pm3.meta_value, '%%Y-%%m-%%d') ) GROUP BY p.ID ORDER BY RAND() LIMIT 1", $wpdb->posts, $wpdb->postmeta, $wpdb->postmeta, $wpdb->postmeta, get_current_user_id()