time to thrive

WP_Query Object
(
    [query] => Array
        (
            [post_type] => um_events
            [post_status] => publish
            [order] => ASC
            [orderby] => _um_event_date_start
            [meta_key] => _um_event_date_start
            [paged] => 1
            [meta_query] => Array
                (
                    [0] => Array
                        (
                            [key] => _um_event_date_start
                            [compare] => >=
                            [value] => 2021-07-27
                        )

                )

            [posts_per_page] => 10
        )

    [query_vars] => Array
        (
            [post_type] => um_events
            [post_status] => publish
            [order] => ASC
            [orderby] => _um_event_date_start
            [meta_key] => _um_event_date_start
            [paged] => 1
            [meta_query] => Array
                (
                    [0] => Array
                        (
                            [key] => _um_event_date_start
                            [compare] => >=
                            [value] => 2021-07-27
                        )

                )

            [posts_per_page] => 10
            [error] => 
            [m] => 
            [p] => 0
            [post_parent] => 
            [subpost] => 
            [subpost_id] => 
            [attachment] => 
            [attachment_id] => 0
            [name] => 
            [pagename] => 
            [page_id] => 0
            [second] => 
            [minute] => 
            [hour] => 
            [day] => 0
            [monthnum] => 0
            [year] => 0
            [w] => 0
            [category_name] => 
            [tag] => 
            [cat] => 
            [tag_id] => 
            [author] => 
            [author_name] => 
            [feed] => 
            [tb] => 
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => 
            [menu_order] => 
             => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => Array
                (
                )

            [post__not_in] => Array
                (
                )

            [post_name__in] => Array
                (
                )

            [tag__in] => Array
                (
                )

            [tag__not_in] => Array
                (
                )

            [tag__and] => Array
                (
                )

            [tag_slug__in] => Array
                (
                )

            [tag_slug__and] => Array
                (
                )

            [post_parent__in] => Array
                (
                )

            [post_parent__not_in] => Array
                (
                )

            [author__in] => Array
                (
                )

            [author__not_in] => Array
                (
                )

            [ignore_sticky_posts] => 
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                )

            [queried_terms] => Array
                (
                )

            [primary_table] => wp_posts
            [primary_id_column] => ID
        )

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [key] => _um_event_date_start
                        )

                    [1] => Array
                        (
                            [0] => Array
                                (
                                    [key] => _um_event_date_start
                                    [compare] => >=
                                    [value] => 2021-07-27
                                )

                            [relation] => OR
                        )

                    [relation] => AND
                )

            [relation] => AND
            [meta_table] => wp_postmeta
            [meta_id_column] => post_id
            [primary_table] => wp_posts
            [primary_id_column] => ID
            [table_aliases:protected] => Array
                (
                    [0] => wp_postmeta
                    [1] => mt1
                )

            [clauses:protected] => Array
                (
                    [wp_postmeta] => Array
                        (
                            [key] => _um_event_date_start
                            [compare] => =
                            [compare_key] => =
                            [alias] => wp_postmeta
                            [cast] => CHAR
                        )

                    [mt1] => Array
                        (
                            [key] => _um_event_date_start
                            [compare] => >=
                            [value] => 2021-07-27
                            [compare_key] => =
                            [alias] => mt1
                            [cast] => CHAR
                        )

                )

            [has_or_relation:protected] => 
        )

    [date_query] => 
    [request] => SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, CASE WHEN pm1_time.meta_value IS NULL OR pm1_time.meta_value = '' THEN CONCAT( pm1.meta_value, ' ', '00:00:00') ELSE CONCAT( pm1.meta_value, ' ', pm1_time.meta_value )  END AS start_time,
	CASE WHEN pm2_time.meta_value IS NULL OR pm2_time.meta_value = '' THEN CONCAT( pm2.meta_value, ' ', '23:59:59') ELSE CONCAT( pm2.meta_value, ' ', pm2_time.meta_value )  END AS end_time
	 FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS pm1 ON ( wp_posts.ID = pm1.post_id ) AND pm1.meta_key='_um_event_date_start'   INNER JOIN wp_postmeta AS pm1_time ON ( wp_posts.ID = pm1_time.post_id ) AND pm1_time.meta_key='_um_event_time_start'  LEFT JOIN wp_postmeta AS pm2 ON ( wp_posts.ID = pm2.post_id ) AND pm2.meta_key='_um_event_date_end'   LEFT JOIN wp_postmeta AS pm2_time ON ( wp_posts.ID = pm2_time.post_id ) AND pm2_time.meta_key='_um_event_time_end'  WHERE 1=1  AND ( 
  wp_postmeta.meta_key = '_um_event_date_start' 
  AND 
  ( 
    ( mt1.meta_key = '_um_event_date_start' AND mt1.meta_value >= '2021-07-27' )
  )
) AND wp_posts.post_type = 'um_events' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value ASC LIMIT 0, 10
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 5795
                    [post_author] => 2
                    [post_date] => 2020-01-27 20:54:15
                    [post_date_gmt] => 2020-01-27 20:54:15
                    [post_content] => 
                    [post_title] => Building Your Business
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => building-your-business
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2020-01-27 20:54:15
                    [post_modified_gmt] => 2020-01-27 20:54:15
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://mdrnhouse.com/um_events/building-your-business/
                    [menu_order] => 0
                    [post_type] => um_events
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [start_time] => 2021-10-02 6:00:00 PM
                    [end_time] => 2021-10-02 8:00:00 PM
                )

            [1] => WP_Post Object
                (
                    [ID] => 5793
                    [post_author] => 2
                    [post_date] => 2020-01-27 20:51:57
                    [post_date_gmt] => 2020-01-27 20:51:57
                    [post_content] => 
                    [post_title] => Get Started with Oils
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => get-started-with-oils
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2020-01-27 20:51:57
                    [post_modified_gmt] => 2020-01-27 20:51:57
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => https://mdrnhouse.com/um_events/get-started-with-oils/
                    [menu_order] => 0
                    [post_type] => um_events
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                    [start_time] => 2022-04-01 5:00:00 PM
                    [end_time] => 2022-04-01 6:00:00 PM
                )

        )

    [post_count] => 2
    [current_post] => -1
    [in_the_loop] => 
    [post] => WP_Post Object
        (
            [ID] => 5795
            [post_author] => 2
            [post_date] => 2020-01-27 20:54:15
            [post_date_gmt] => 2020-01-27 20:54:15
            [post_content] => 
            [post_title] => Building Your Business
            [post_excerpt] => 
            [post_status] => publish
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => building-your-business
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2020-01-27 20:54:15
            [post_modified_gmt] => 2020-01-27 20:54:15
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => https://mdrnhouse.com/um_events/building-your-business/
            [menu_order] => 0
            [post_type] => um_events
            [post_mime_type] => 
            [comment_count] => 0
            [filter] => raw
            [start_time] => 2021-10-02 6:00:00 PM
            [end_time] => 2021-10-02 8:00:00 PM
        )

    [comment_count] => 0
    [current_comment] => -1
    [found_posts] => 2
    [max_num_pages] => 1
    [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] => 
    [is_tag] => 
    [is_tax] => 
    [is_search] => 
    [is_feed] => 
    [is_comment_feed] => 
    [is_trackback] => 
    [is_home] => 
    [is_privacy_policy] => 
    [is_404] => 
    [is_embed] => 
    [is_paged] => 
    [is_admin] => 
    [is_attachment] => 
    [is_singular] => 
    [is_robots] => 
    [is_favicon] => 
    [is_posts_page] => 
    [is_post_type_archive] => 1
    [query_vars_hash:WP_Query:private] => 8fe6e87e72fdda78b046bd51159c0fc6
    [query_vars_changed:WP_Query:private] => 
    [thumbnails_cached] => 
    [stopwords:WP_Query:private] => 
    [compat_fields:WP_Query:private] => Array
        (
            [0] => query_vars_hash
            [1] => query_vars_changed
        )

    [compat_methods:WP_Query:private] => Array
        (
            [0] => init_query_flags
            [1] => parse_tax_query
        )

)