I have a custom post type of 'events' which has a meta key 'event_date'
Im using the following to retrieve those posts and arrange them by 'event_date'
global $wpdb;
$today = date('Y/m/d', strtotime("now"));
$events = $wpdb->get_results("SELECT
posts.id, posts.post_title, meta.meta_value
FROM
{$wpdb->prefix}postmeta as meta
LEFT JOIN
{$wpdb->prefix}posts as posts
ON
(meta.post_id = posts.id)
WHERE
(meta.meta_key = 'event_date'
AND
meta.meta_value >= '{$today}'
AND
posts.post_status='publish' and posts.post_date < NOW())
ORDER BY
meta.meta_value
");
The above works fine however i would like to show 'events' from only certain categories (say category id '5'). How can i modify the query to achive this?
Any help would be appreciated :)
wp query
it have the paramaters your asking for.