WP_Query Object
(
[query] => Array
(
[post_type] => show
[posts_per_page] => -1
[post_status] => publish
[meta_key] => show_start_date
[orderby] => meta_value
[order] => ASC
[meta_query] => Array
(
[0] => Array
(
[key] => show_end_date
[value] => 20250307
[compare] => >=
[type] => NUMERIC
)
)
)
[query_vars] => Array
(
[post_type] => show
[posts_per_page] => -1
[post_status] => publish
[meta_key] => show_start_date
[orderby] => meta_value
[order] => ASC
[meta_query] => Array
(
[0] => Array
(
[key] => show_end_date
[value] => 20250307
[compare] => >=
[type] => NUMERIC
)
)
[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
2025 => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[paged] => 0
[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
(
)
[search_columns] => Array
(
)
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[update_menu_item_cache] =>
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] => 1
[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] => avoldhx_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[key] => show_start_date
)
[1] => Array
(
[0] => Array
(
[key] => show_end_date
[value] => 20250307
[compare] => >=
[type] => NUMERIC
)
[relation] => OR
)
[relation] => AND
)
[relation] => AND
[meta_table] => avoldhx_postmeta
[meta_id_column] => post_id
[primary_table] => avoldhx_posts
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => avoldhx_postmeta
[1] => mt1
)
[clauses:protected] => Array
(
[avoldhx_postmeta] => Array
(
[key] => show_start_date
[compare] => =
[compare_key] => =
[alias] => avoldhx_postmeta
[cast] => CHAR
)
[mt1] => Array
(
[key] => show_end_date
[value] => 20250307
[compare] => >=
[type] => NUMERIC
[compare_key] => =
[alias] => mt1
[cast] => SIGNED
)
)
[has_or_relation:protected] =>
)
[date_query] =>
[request] => SELECT avoldhx_posts.ID
FROM avoldhx_posts INNER JOIN avoldhx_postmeta ON ( avoldhx_posts.ID = avoldhx_postmeta.post_id ) INNER JOIN avoldhx_postmeta AS mt1 ON ( avoldhx_posts.ID = mt1.post_id )
WHERE 1=1 AND (
avoldhx_postmeta.meta_key = 'show_start_date'
AND
(
( mt1.meta_key = 'show_end_date' AND CAST(mt1.meta_value AS SIGNED) >= '20250307' )
)
) AND avoldhx_posts.post_type = 'show' AND ((avoldhx_posts.post_status = 'publish'))
GROUP BY avoldhx_posts.ID
ORDER BY avoldhx_posts.menu_order, avoldhx_postmeta.meta_value ASC
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 6441
[post_author] => 16
[post_date] => 2025-03-06 02:15:32
[post_date_gmt] => 2025-03-06 02:15:32
[post_content] =>
[post_title] => Foam Expo North America
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => foam-expo-north-america
[to_ping] =>
[pinged] =>
[post_modified] => 2025-03-07 08:06:43
[post_modified_gmt] => 2025-03-07 08:06:43
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://tombrowninc.com/?post_type=show&p=6441
[menu_order] => 0
[post_type] => show
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 6442
[post_author] => 16
[post_date] => 2025-03-06 02:16:24
[post_date_gmt] => 2025-03-06 02:16:24
[post_content] =>
[post_title] => Adhesives & Bonding Expo
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => adhesives-bonding-expo
[to_ping] =>
[pinged] =>
[post_modified] => 2025-03-07 08:06:55
[post_modified_gmt] => 2025-03-07 08:06:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://tombrowninc.com/?post_type=show&p=6442
[menu_order] => 0
[post_type] => show
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 6520
[post_author] => 16
[post_date] => 2025-03-06 07:36:51
[post_date_gmt] => 2025-03-06 07:36:51
[post_content] =>
[post_title] => 35th Annual National Trailer Dealers Association Convention
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 35th-annual-national-trailer-dealers-association-convention
[to_ping] =>
[pinged] =>
[post_modified] => 2025-03-06 07:36:51
[post_modified_gmt] => 2025-03-06 07:36:51
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://tombrowninc.com/?post_type=show&p=6520
[menu_order] => 0
[post_type] => show
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 6521
[post_author] => 16
[post_date] => 2025-03-06 07:39:15
[post_date_gmt] => 2025-03-06 07:39:15
[post_content] =>
[post_title] => GlassBuild America
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => glassbuild-america
[to_ping] =>
[pinged] =>
[post_modified] => 2025-03-06 07:39:15
[post_modified_gmt] => 2025-03-06 07:39:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://tombrowninc.com/?post_type=show&p=6521
[menu_order] => 0
[post_type] => show
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 4
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 6441
[post_author] => 16
[post_date] => 2025-03-06 02:15:32
[post_date_gmt] => 2025-03-06 02:15:32
[post_content] =>
[post_title] => Foam Expo North America
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => foam-expo-north-america
[to_ping] =>
[pinged] =>
[post_modified] => 2025-03-07 08:06:43
[post_modified_gmt] => 2025-03-07 08:06:43
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://tombrowninc.com/?post_type=show&p=6441
[menu_order] => 0
[post_type] => show
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 4
[max_num_pages] => 0
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] =>
[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] => 1
[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] =>
[query_vars_hash:WP_Query:private] => 755fd794275cf8eb6b83915b2df5fc01
[query_vars_changed:WP_Query:private] =>
[thumbnails_cached] =>
[allow_query_attachment_by_filename:protected] =>
[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
)
)
1
Jun
24-26
June 24-26, 2025
Foam Expo North America
Suburban Collection Showplace
Novi, MI
+ Add This to Your Calendar
Jun
24-26
June 24-26, 2025
Adhesives & Bonding Expo
Suburban Collection Showplace
Novi, MI
+ Add This to Your Calendar
Oct
7-9
October 7-9, 2025
35th Annual National Trailer Dealers Association Convention
JW Marriott Starr Pass Resort & Spa
Tucson, AZ
+ Add This to Your Calendar
Nov
4-6
November 4-6, 2025
GlassBuild America
Orange County Convention Center
Orlando, FL
+ Add This to Your Calendar
