Reply To: Mashup query

Home Forums MapPress Support Mashup query Reply To: Mashup query

#12863
amir200770
Participant

Thanks Chris. Yes I would be grateful for an immediate fix.
Please email me at
mail(at)mostofi(dot)com(dot)au

By the way,
$wpq = new WP_Query(‘category_name=lachlan-catchment,rivers-creeks&post_type=events&meta_key=end_date&meta_value=20130618&meta_compare=<‘);
print_r($wpq);

returns only the following

WP_Query Object ( [query_vars] => Array ( [category_name] => lachlan-catchment [post_type] => events [meta_key] => end_date [meta_value] => 20130618 [meta_compare] => < [error] => [m] => 0 [p] => 0 [post_parent] => [subpost] => [subpost_id] => [attachment] => [attachment_id] => 0 [name] => [static] => [pagename] => [page_id] => 0 [second] => [minute] => [hour] => [day] => 0 [monthnum] => 0 [year] => 0 [w] => 0 [tag] => [cat] => 29 [tag_id] => [author_name] => [feed] => [tb] => [paged] => 0 [comments_popup] => [preview] => [s] => [sentence] => [fields] => [menu_order] => [category__in] => Array ( ) [category__not_in] => Array ( ) [category__and] => Array ( ) [post__in] => Array ( ) [post__not_in] => Array ( ) [tag__in] => Array ( ) [tag__not_in] => Array ( ) [tag__and] => Array ( ) [tag_slug__in] => Array ( ) [tag_slug__and] => Array ( ) [ignore_sticky_posts] => [suppress_filters] => [cache_results] => 1 [update_post_term_cache] => 1 [update_post_meta_cache] => 1 [posts_per_page] => 10 [nopaging] => [comments_per_page] => 50 [no_found_rows] => [order] => DESC ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => category [terms] => Array ( [0] => lachlan-catchment [1] => rivers-creeks ) [include_children] => 1 [field] => slug [operator] => IN ) ) [relation] => AND ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [key] => end_date [compare] => < [value] => 20130618 ) ) [relation] => AND ) [post_count] => 0 [current_post] => -1 [in_the_loop] => [comment_count] => 0 [current_comment] => -1 [found_posts] => 0 [max_num_pages] => 0 [max_num_comment_pages] => 0 [is_single] => [is_preview] => [is_page] => [is_archive] => 1 [is_date] => [is_year] => [is_month] => [is_day] => [is_time] => [is_author] => [is_category] => 1 [is_tag] => [is_tax] => [is_search] => [is_feed] => [is_comment_feed] => [is_trackback] => [is_home] => [is_404] => [is_comments_popup] => [is_paged] => [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_posts_page] => [is_post_type_archive] => 1 [query_vars_hash] => 9e115d762c47fb4609a0b0cf54391e51 [query_vars_changed] => [thumbnails_cached] => [query] => Array ( [category_name] => lachlan-catchment,rivers-creeks [post_type] => events [meta_key] => end_date [meta_value] => 20130618 [meta_compare] => < ) [request] => SELECT SQL_CALC_FOUND_ROWS lrwg_posts.ID FROM lrwg_posts INNER JOIN lrwg_term_relationships ON (lrwg_posts.ID = lrwg_term_relationships.object_id) INNER JOIN lrwg_postmeta ON (lrwg_posts.ID = lrwg_postmeta.post_id) WHERE 1=1 AND ( lrwg_term_relationships.term_taxonomy_id IN (30,31) ) AND lrwg_posts.post_type = ‘events’ AND (lrwg_posts.post_status = ‘publish’ OR lrwg_posts.post_status = ‘private’) AND ( (lrwg_postmeta.meta_key = ‘end_date’ AND CAST(lrwg_postmeta.meta_value AS CHAR) < ‘20130618’) ) GROUP BY lrwg_posts.ID ORDER BY lrwg_posts.post_date DESC LIMIT 0, 10 [posts] => Array ( ) )

That is, the query is not actually returning any results.
(Also not that the custom field used now is end_date rather than event_end_date .)

Regards,
Amir