Company Finder

WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => architecture-design ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => architecture-design ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => architecture-design ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => architecture-design ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => architecture-design ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (947) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23693 [post_author] => 1 [post_date] => 2017-09-14 14:04:05 [post_date_gmt] => 2017-09-14 13:04:05 [post_content] => [post_title] => Welsh Oak Frame [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => welsh-oak-frame [to_ping] => [pinged] => [post_modified] => 2023-06-29 09:58:53 [post_modified_gmt] => 2023-06-29 08:58:53 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23693 [menu_order] => 105 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23693 [post_author] => 1 [post_date] => 2017-09-14 14:04:05 [post_date_gmt] => 2017-09-14 13:04:05 [post_content] => [post_title] => Welsh Oak Frame [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => welsh-oak-frame [to_ping] => [pinged] => [post_modified] => 2023-06-29 09:58:53 [post_modified_gmt] => 2023-06-29 08:58:53 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23693 [menu_order] => 105 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 20 [max_num_pages] => 20 [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] => 1 [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] => 6399e063d9b9aad9439412e61694b79a [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => building-materials ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => building-materials ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => building-materials ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => building-materials ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => building-materials ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (948) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23674 [post_author] => 1 [post_date] => 2017-09-14 12:56:28 [post_date_gmt] => 2017-09-14 11:56:28 [post_content] => [post_title] => Tudor Roof Tiles [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => tudor-roof-tiles [to_ping] => [pinged] => [post_modified] => 2023-03-30 11:48:09 [post_modified_gmt] => 2023-03-30 10:48:09 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23674 [menu_order] => 100 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23674 [post_author] => 1 [post_date] => 2017-09-14 12:56:28 [post_date_gmt] => 2017-09-14 11:56:28 [post_content] => [post_title] => Tudor Roof Tiles [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => tudor-roof-tiles [to_ping] => [pinged] => [post_modified] => 2023-03-30 11:48:09 [post_modified_gmt] => 2023-03-30 10:48:09 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23674 [menu_order] => 100 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 24 [max_num_pages] => 24 [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] => 1 [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] => f3376355ea273bed24e5be73793733b3 [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => custom-build ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => custom-build ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => custom-build ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => custom-build ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => custom-build ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (949) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 46185 [post_author] => 1 [post_date] => 2018-07-12 14:00:33 [post_date_gmt] => 2018-07-12 13:00:33 [post_content] => [post_title] => Dan-Wood House [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => dan-wood [to_ping] => [pinged] => [post_modified] => 2023-07-20 11:32:33 [post_modified_gmt] => 2023-07-20 10:32:33 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=46185 [menu_order] => 0 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 46185 [post_author] => 1 [post_date] => 2018-07-12 14:00:33 [post_date_gmt] => 2018-07-12 13:00:33 [post_content] => [post_title] => Dan-Wood House [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => dan-wood [to_ping] => [pinged] => [post_modified] => 2023-07-20 11:32:33 [post_modified_gmt] => 2023-07-20 10:32:33 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=46185 [menu_order] => 0 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 2 [max_num_pages] => 2 [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] => 1 [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] => aefd5dec831938fa436f0d6693b70baf [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => doors ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => doors ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => doors ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => doors ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => doors ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (951) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23704 [post_author] => 1 [post_date] => 2017-09-14 14:13:36 [post_date_gmt] => 2017-09-14 13:13:36 [post_content] => [post_title] => VELFAC [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => velfac [to_ping] => [pinged] => [post_modified] => 2022-12-20 09:13:35 [post_modified_gmt] => 2022-12-20 09:13:35 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23704 [menu_order] => 102 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23704 [post_author] => 1 [post_date] => 2017-09-14 14:13:36 [post_date_gmt] => 2017-09-14 13:13:36 [post_content] => [post_title] => VELFAC [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => velfac [to_ping] => [pinged] => [post_modified] => 2022-12-20 09:13:35 [post_modified_gmt] => 2022-12-20 09:13:35 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23704 [menu_order] => 102 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 18 [max_num_pages] => 18 [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] => 1 [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] => 456246efd0b663a323dfd1caf2e7726c [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => finance-professional-services ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => finance-professional-services ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => finance-professional-services ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => finance-professional-services ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => finance-professional-services ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (953) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 16032 [post_author] => 1 [post_date] => 2017-08-24 10:53:08 [post_date_gmt] => 2017-08-24 09:53:08 [post_content] => [post_title] => Protek [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => protek [to_ping] => [pinged] => [post_modified] => 2023-08-29 09:15:44 [post_modified_gmt] => 2023-08-29 08:15:44 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=16032 [menu_order] => 90 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 16032 [post_author] => 1 [post_date] => 2017-08-24 10:53:08 [post_date_gmt] => 2017-08-24 09:53:08 [post_content] => [post_title] => Protek [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => protek [to_ping] => [pinged] => [post_modified] => 2023-08-29 09:15:44 [post_modified_gmt] => 2023-08-29 08:15:44 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=16032 [menu_order] => 90 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 8 [max_num_pages] => 8 [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] => 1 [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] => aab848b022f28aa1183431de716e309d [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => gardens-outbuildings ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => gardens-outbuildings ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => gardens-outbuildings ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => gardens-outbuildings ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => gardens-outbuildings ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (1559) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 16022 [post_author] => 1 [post_date] => 2017-08-24 10:47:23 [post_date_gmt] => 2017-08-24 09:47:23 [post_content] => [post_title] => Russwood [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => russwood [to_ping] => [pinged] => [post_modified] => 2023-06-22 14:37:53 [post_modified_gmt] => 2023-06-22 13:37:53 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=16022 [menu_order] => 94 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 16022 [post_author] => 1 [post_date] => 2017-08-24 10:47:23 [post_date_gmt] => 2017-08-24 09:47:23 [post_content] => [post_title] => Russwood [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => russwood [to_ping] => [pinged] => [post_modified] => 2023-06-22 14:37:53 [post_modified_gmt] => 2023-06-22 13:37:53 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=16022 [menu_order] => 94 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 5 [max_num_pages] => 5 [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] => 1 [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] => 759c7e080e3885544170d451bcd3319c [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => heating-ventilation ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => heating-ventilation ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => heating-ventilation ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => heating-ventilation ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => heating-ventilation ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (954) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23671 [post_author] => 1 [post_date] => 2017-09-14 12:53:30 [post_date_gmt] => 2017-09-14 11:53:30 [post_content] => [post_title] => NIBE Energy Systems [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => nibe-energy-systems [to_ping] => [pinged] => [post_modified] => 2023-06-29 10:13:25 [post_modified_gmt] => 2023-06-29 09:13:25 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23671 [menu_order] => 83 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23671 [post_author] => 1 [post_date] => 2017-09-14 12:53:30 [post_date_gmt] => 2017-09-14 11:53:30 [post_content] => [post_title] => NIBE Energy Systems [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => nibe-energy-systems [to_ping] => [pinged] => [post_modified] => 2023-06-29 10:13:25 [post_modified_gmt] => 2023-06-29 09:13:25 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23671 [menu_order] => 83 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 21 [max_num_pages] => 21 [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] => 1 [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] => 3c72287e7c0c1b2cefb6df9e527c8552 [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => home-technology ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => home-technology ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => home-technology ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => home-technology ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => home-technology ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (955) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23661 [post_author] => 1 [post_date] => 2017-09-14 12:42:30 [post_date_gmt] => 2017-09-14 11:42:30 [post_content] => [post_title] => Moss Technical [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => moss-technical [to_ping] => [pinged] => [post_modified] => 2022-10-18 15:27:13 [post_modified_gmt] => 2022-10-18 14:27:13 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23661 [menu_order] => 80 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23661 [post_author] => 1 [post_date] => 2017-09-14 12:42:30 [post_date_gmt] => 2017-09-14 11:42:30 [post_content] => [post_title] => Moss Technical [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => moss-technical [to_ping] => [pinged] => [post_modified] => 2022-10-18 15:27:13 [post_modified_gmt] => 2022-10-18 14:27:13 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23661 [menu_order] => 80 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 3 [max_num_pages] => 3 [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] => 1 [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] => 40b0fb655800d1520c8caeaf92f59dc5 [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => interiors-finishes ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => interiors-finishes ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => interiors-finishes ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => interiors-finishes ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => interiors-finishes ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (956) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23668 [post_author] => 1 [post_date] => 2017-09-14 12:50:34 [post_date_gmt] => 2017-09-14 11:50:34 [post_content] => [post_title] => Wetrooms Online [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => wetrooms-online [to_ping] => [pinged] => [post_modified] => 2023-03-16 16:28:09 [post_modified_gmt] => 2023-03-16 16:28:09 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23668 [menu_order] => 106 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23668 [post_author] => 1 [post_date] => 2017-09-14 12:50:34 [post_date_gmt] => 2017-09-14 11:50:34 [post_content] => [post_title] => Wetrooms Online [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => wetrooms-online [to_ping] => [pinged] => [post_modified] => 2023-03-16 16:28:09 [post_modified_gmt] => 2023-03-16 16:28:09 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23668 [menu_order] => 106 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 9 [max_num_pages] => 9 [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] => 1 [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] => 1b732fccafa6c8bf34082cd937f05684 [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => lofts-basements ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => lofts-basements ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => lofts-basements ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => lofts-basements ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => lofts-basements ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (957) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 28061 [post_author] => 2121 [post_date] => 2017-11-06 12:13:14 [post_date_gmt] => 2017-11-06 12:13:14 [post_content] => [post_title] => TeleBeam [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => telebeam [to_ping] => [pinged] => [post_modified] => 2022-10-31 12:24:49 [post_modified_gmt] => 2022-10-31 12:24:49 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=28061 [menu_order] => 35 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 28061 [post_author] => 2121 [post_date] => 2017-11-06 12:13:14 [post_date_gmt] => 2017-11-06 12:13:14 [post_content] => [post_title] => TeleBeam [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => telebeam [to_ping] => [pinged] => [post_modified] => 2022-10-31 12:24:49 [post_modified_gmt] => 2022-10-31 12:24:49 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=28061 [menu_order] => 35 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 8 [max_num_pages] => 8 [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] => 1 [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] => dec7d13e2c0dcb1ee5be7bb96e7892b8 [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => renewable-energy ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => renewable-energy ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => renewable-energy ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => renewable-energy ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => renewable-energy ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (958) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23671 [post_author] => 1 [post_date] => 2017-09-14 12:53:30 [post_date_gmt] => 2017-09-14 11:53:30 [post_content] => [post_title] => NIBE Energy Systems [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => nibe-energy-systems [to_ping] => [pinged] => [post_modified] => 2023-06-29 10:13:25 [post_modified_gmt] => 2023-06-29 09:13:25 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23671 [menu_order] => 83 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23671 [post_author] => 1 [post_date] => 2017-09-14 12:53:30 [post_date_gmt] => 2017-09-14 11:53:30 [post_content] => [post_title] => NIBE Energy Systems [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => nibe-energy-systems [to_ping] => [pinged] => [post_modified] => 2023-06-29 10:13:25 [post_modified_gmt] => 2023-06-29 09:13:25 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23671 [menu_order] => 83 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 7 [max_num_pages] => 7 [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] => 1 [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] => 7d34171ee1d3eee70cd8bc50842f14e6 [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => roofing-rainwater-goods ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => roofing-rainwater-goods ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => roofing-rainwater-goods ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => roofing-rainwater-goods ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => roofing-rainwater-goods ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (960) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23674 [post_author] => 1 [post_date] => 2017-09-14 12:56:28 [post_date_gmt] => 2017-09-14 11:56:28 [post_content] => [post_title] => Tudor Roof Tiles [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => tudor-roof-tiles [to_ping] => [pinged] => [post_modified] => 2023-03-30 11:48:09 [post_modified_gmt] => 2023-03-30 10:48:09 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23674 [menu_order] => 100 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23674 [post_author] => 1 [post_date] => 2017-09-14 12:56:28 [post_date_gmt] => 2017-09-14 11:56:28 [post_content] => [post_title] => Tudor Roof Tiles [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => tudor-roof-tiles [to_ping] => [pinged] => [post_modified] => 2023-03-30 11:48:09 [post_modified_gmt] => 2023-03-30 10:48:09 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23674 [menu_order] => 100 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 13 [max_num_pages] => 13 [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] => 1 [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] => cd94bd34e6a474e8ce6128acd3337393 [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => self-build ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => self-build ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => self-build ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => self-build ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => self-build ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (961) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 28037 [post_author] => 2121 [post_date] => 2017-11-06 11:56:28 [post_date_gmt] => 2017-11-06 11:56:28 [post_content] => [post_title] => Excel Group [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => excel-group [to_ping] => [pinged] => [post_modified] => 2023-07-19 14:15:11 [post_modified_gmt] => 2023-07-19 13:15:11 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=28037 [menu_order] => 29 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 28037 [post_author] => 2121 [post_date] => 2017-11-06 11:56:28 [post_date_gmt] => 2017-11-06 11:56:28 [post_content] => [post_title] => Excel Group [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => excel-group [to_ping] => [pinged] => [post_modified] => 2023-07-19 14:15:11 [post_modified_gmt] => 2023-07-19 13:15:11 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=28037 [menu_order] => 29 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 2 [max_num_pages] => 2 [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] => 1 [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] => 19dc8c60ccc296c3a6d6abd0e5422a12 [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => staircases-joinery ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => staircases-joinery ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => staircases-joinery ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => staircases-joinery ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => staircases-joinery ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (963) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23677 [post_author] => 1 [post_date] => 2017-09-14 12:58:58 [post_date_gmt] => 2017-09-14 11:58:58 [post_content] => [post_title] => Bisca [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bisca [to_ping] => [pinged] => [post_modified] => 2023-06-30 08:50:49 [post_modified_gmt] => 2023-06-30 07:50:49 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23677 [menu_order] => 43 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23677 [post_author] => 1 [post_date] => 2017-09-14 12:58:58 [post_date_gmt] => 2017-09-14 11:58:58 [post_content] => [post_title] => Bisca [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bisca [to_ping] => [pinged] => [post_modified] => 2023-06-30 08:50:49 [post_modified_gmt] => 2023-06-30 07:50:49 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23677 [menu_order] => 43 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 7 [max_num_pages] => 7 [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] => 1 [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] => 58fe6913ab021cc5d081d39f34ff960f [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => structural-systems ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => structural-systems ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => structural-systems ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => structural-systems ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => structural-systems ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (964) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23693 [post_author] => 1 [post_date] => 2017-09-14 14:04:05 [post_date_gmt] => 2017-09-14 13:04:05 [post_content] => [post_title] => Welsh Oak Frame [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => welsh-oak-frame [to_ping] => [pinged] => [post_modified] => 2023-06-29 09:58:53 [post_modified_gmt] => 2023-06-29 08:58:53 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23693 [menu_order] => 105 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23693 [post_author] => 1 [post_date] => 2017-09-14 14:04:05 [post_date_gmt] => 2017-09-14 13:04:05 [post_content] => [post_title] => Welsh Oak Frame [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => welsh-oak-frame [to_ping] => [pinged] => [post_modified] => 2023-06-29 09:58:53 [post_modified_gmt] => 2023-06-29 08:58:53 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23693 [menu_order] => 105 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 38 [max_num_pages] => 38 [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] => 1 [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] => 76272431b2489e21f01ef4403a8d7a8a [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 ) ) WP_Query Object ( [query] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => windows-glazing ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) ) [query_vars] => Array ( [post_type] => company [posts_per_page] => 1 [order] => DESC [orderby] => menu_order [tax_query] => Array ( [0] => Array ( [taxonomy] => directorycategory [field] => slug [terms] => windows-glazing ) ) [meta_query] => Array ( [relation] => AND [0] => Array ( [relation] => OR [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [relation] => OR [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) ) ) [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] => [paged] => 0 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [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] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => directorycategory [term] => windows-glazing ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => directorycategory [terms] => Array ( [0] => windows-glazing ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [directorycategory] => Array ( [terms] => Array ( [0] => windows-glazing ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => ) [relation] => OR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date ) [1] => Array ( [views] => Array ( [key] => views_weekly [compare] => EXISTS ) [0] => Array ( [key] => views_weekly [compare] => NOT EXISTS ) [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 [2] => mt2 [3] => mt3 [4] => mt4 ) [clauses:protected] => Array ( [page_type] => Array ( [key] => page_type [value] => Array ( [0] => product [1] => project ) [compare] => NOT IN [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) [page_type_no] => Array ( [key] => page_type [compare] => NOT EXISTS [value] => [compare_key] => = [alias] => mt1 [cast] => CHAR ) [end_date] => Array ( [key] => end_date [value] => 20230905 [compare] => > [type] => date [compare_key] => = [alias] => mt2 [cast] => DATE ) [views] => Array ( [key] => views_weekly [compare] => EXISTS [compare_key] => = [alias] => mt3 [cast] => CHAR ) [mt4] => Array ( [key] => views_weekly [compare] => NOT EXISTS [compare_key] => = [alias] => mt4 [cast] => CHAR ) ) [has_or_relation:protected] => 1 ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = 'page_type' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) LEFT JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id AND mt4.meta_key = 'views_weekly' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (965) ) AND ( ( ( wp_postmeta.meta_key = 'page_type' AND wp_postmeta.meta_value NOT IN ('product','project') ) OR mt1.post_id IS NULL ) AND ( mt2.meta_key = 'end_date' AND CAST(mt2.meta_value AS DATE) > '20230905' ) AND ( mt3.meta_key = 'views_weekly' OR mt4.post_id IS NULL ) ) AND ((wp_posts.post_type = 'company' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order DESC LIMIT 0, 1 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23704 [post_author] => 1 [post_date] => 2017-09-14 14:13:36 [post_date_gmt] => 2017-09-14 13:13:36 [post_content] => [post_title] => VELFAC [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => velfac [to_ping] => [pinged] => [post_modified] => 2022-12-20 09:13:35 [post_modified_gmt] => 2022-12-20 09:13:35 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23704 [menu_order] => 102 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23704 [post_author] => 1 [post_date] => 2017-09-14 14:13:36 [post_date_gmt] => 2017-09-14 13:13:36 [post_content] => [post_title] => VELFAC [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => velfac [to_ping] => [pinged] => [post_modified] => 2022-12-20 09:13:35 [post_modified_gmt] => 2022-12-20 09:13:35 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.self-build.co.uk/?post_type=company&p=23704 [menu_order] => 102 [post_type] => company [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 22 [max_num_pages] => 22 [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] => 1 [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] => 4caa550e60d5f599f3549a9d8f67ff9d [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 ) )