WP_Query Object
(
[query] => Array
(
[post_type] => wpbdp_listing
[posts_per_page] => 15
[post_status] => publish
[paged] => 8
[orderby] => title
[order] => ASC
[wpbdp_main_query] => 1
[items_per_page] => 15
[tax_query] => Array
(
[0] => Array
(
[0] => Array
(
[taxonomy] => city
[field] => id
[terms] => Array
(
[0] => 349
)
)
)
)
)
[query_vars] => Array
(
[post_type] => wpbdp_listing
[posts_per_page] => 15
[post_status] => publish
[paged] => 8
[orderby] => title
[order] => ASC
[wpbdp_main_query] => 1
[items_per_page] => 15
[tax_query] => Array
(
[0] => Array
(
[0] => Array
(
[taxonomy] => city
[field] => id
[terms] => Array
(
[0] => 349
)
)
)
)
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] => all
[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] => city
[term_id] => 349
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[0] => Array
(
[taxonomy] => city
[terms] => Array
(
[0] => 349
)
[field] => id
[operator] => IN
[include_children] => 1
)
[relation] => AND
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => wp_term_relationships
)
[queried_terms] => Array
(
[city] => Array
(
[terms] => Array
(
[0] => 349
)
[field] => id
)
)
[primary_table] => wp_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
)
[relation] =>
[meta_table] =>
[meta_id_column] =>
[primary_table] =>
[primary_id_column] =>
[table_aliases:protected] => Array
(
)
[clauses:protected] => Array
(
)
[has_or_relation:protected] =>
)
[date_query] =>
[request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (SELECT is_sticky FROM wp_wpbdp_listings wls WHERE wls.listing_id = wp_posts.ID LIMIT 1) AS wpbdp_is_sticky, (SELECT wp_postmeta.meta_value FROM wp_postmeta WHERE wp_postmeta.post_id = wp_posts.ID AND wp_postmeta.meta_key = '_wpbdp[fields][42]') AS field_42, (SELECT COUNT(wp_postmeta.post_id) FROM wp_postmeta WHERE wp_postmeta.post_id = wp_posts.ID AND wp_posts.post_author <> 6 AND wp_postmeta.meta_key = '_wpbdp[fields][54]' AND wp_postmeta.meta_value LIKE '{dc1f4cfb86b056f59430a5d238d657055dd76541afaf5889cc90d8dad3f340b5}349{dc1f4cfb86b056f59430a5d238d657055dd76541afaf5889cc90d8dad3f340b5}') AS field_54, (SELECT COUNT(DISTINCT url) FROM wp_review_scrapper WHERE listing_id = wp_posts.ID AND source <> 'bbb') AS review_count, (SELECT Count(id) FROM wp_review_scrapper WHERE listing_id = wp_posts.ID AND source = 'bbb') AS bbb_review_count, (SELECT COUNT(wp_postmeta.post_id) FROM wp_postmeta WHERE wp_postmeta.meta_value = wp_posts.ID AND wp_postmeta.meta_key = '_assigned_to') AS local_reviews, (SELECT
wp_postmeta.meta_value FROM wp_postmeta WHERE wp_postmeta.post_id = wp_posts.ID AND wp_postmeta.meta_key = '_glsr_average') AS local_total_rating, (SELECT CAST(AVG(rating_value) AS DECIMAL(10,2)) FROM wp_review_scrapper WHERE listing_id = wp_posts.ID) AS total_rating
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1 AND (
(
wp_term_relationships.term_taxonomy_id IN (349,350,388,394,407)
)
) AND wp_posts.post_type = 'wpbdp_listing' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wpbdp_is_sticky DESC, field_54 DESC, review_count + bbb_review_count + local_reviews DESC, total_rating DESC, wp_posts.post_title ASC
LIMIT 105, 15
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 16621
[post_author] => 6
[post_date] => 2019-06-14 01:40:31
[post_date_gmt] => 2019-06-14 06:40:31
[post_content] =>
thunder::tech is an integrated marketing agency that works across industries throughout the middle-market. Our team members specialize in website development, social media strategy, marketing automation, web optimization, digital advertising, print collateral, logo & identity design, video & animation, and content strategy.
[post_title] => thunder::tech
[post_excerpt] => thunder::tech is an integrated marketing agency that works across industries throughout the middle-market. Our team members specialize in website development, social media strategy, marketing automation, web optimization, digital advertising, print collateral, logo & identity design, video & animation, and content strategy.
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => thundertech
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-16 08:28:58
[post_modified_gmt] => 2020-03-16 13:28:58
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=16621
[menu_order] => 610
[post_type] => wpbdp_listing
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[wpbdp_is_sticky] => 0
[field_42] => 0
[field_54] => 0
[review_count] => 0
[bbb_review_count] => 0
[local_reviews] => 0
[local_total_rating] =>
[total_rating] =>
)
)
[post_count] => 1
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 16621
[post_author] => 6
[post_date] => 2019-06-14 01:40:31
[post_date_gmt] => 2019-06-14 06:40:31
[post_content] =>
thunder::tech is an integrated marketing agency that works across industries throughout the middle-market. Our team members specialize in website development, social media strategy, marketing automation, web optimization, digital advertising, print collateral, logo & identity design, video & animation, and content strategy.
[post_title] => thunder::tech
[post_excerpt] => thunder::tech is an integrated marketing agency that works across industries throughout the middle-market. Our team members specialize in website development, social media strategy, marketing automation, web optimization, digital advertising, print collateral, logo & identity design, video & animation, and content strategy.
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => thundertech
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-16 08:28:58
[post_modified_gmt] => 2020-03-16 13:28:58
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=16621
[menu_order] => 610
[post_type] => wpbdp_listing
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[wpbdp_is_sticky] => 0
[field_42] => 0
[field_54] => 0
[review_count] => 0
[bbb_review_count] => 0
[local_reviews] => 0
[local_total_rating] =>
[total_rating] =>
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 106
[max_num_pages] => 8
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] =>
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] =>
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] => 1
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] => 1
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => a1f2d708f42dc179455a31b360e0d636
[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
)
[query_cache_key:WP_Query:private] =>
[wpbdp_view] =>
[wpbdp_is_main_page] =>
[wpbdp_is_listing] =>
[wpbdp_is_category] =>
[wpbdp_is_tag] =>
[wpbdp_our_query] => 1
)
WP_Query Object
(
[query] => Array
(
[post_type] => wpbdp_listing
[posts_per_page] => 15
[post_status] => publish
[paged] => 8
[orderby] => title
[order] => ASC
[wpbdp_main_query] => 1
[items_per_page] => 15
[tax_query] => Array
(
[0] => Array
(
[0] => Array
(
[taxonomy] => city
[field] => id
[terms] => Array
(
[0] => 349
)
)
)
)
)
[query_vars] => Array
(
[post_type] => wpbdp_listing
[posts_per_page] => 15
[post_status] => publish
[paged] => 8
[orderby] => title
[order] => ASC
[wpbdp_main_query] => 1
[items_per_page] => 15
[tax_query] => Array
(
[0] => Array
(
[0] => Array
(
[taxonomy] => city
[field] => id
[terms] => Array
(
[0] => 349
)
)
)
)
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] => all
[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] => city
[term_id] => 349
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[0] => Array
(
[taxonomy] => city
[terms] => Array
(
[0] => 349
)
[field] => id
[operator] => IN
[include_children] => 1
)
[relation] => AND
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => wp_term_relationships
)
[queried_terms] => Array
(
[city] => Array
(
[terms] => Array
(
[0] => 349
)
[field] => id
)
)
[primary_table] => wp_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
)
[relation] =>
[meta_table] =>
[meta_id_column] =>
[primary_table] =>
[primary_id_column] =>
[table_aliases:protected] => Array
(
)
[clauses:protected] => Array
(
)
[has_or_relation:protected] =>
)
[date_query] =>
[request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (SELECT is_sticky FROM wp_wpbdp_listings wls WHERE wls.listing_id = wp_posts.ID LIMIT 1) AS wpbdp_is_sticky, (SELECT wp_postmeta.meta_value FROM wp_postmeta WHERE wp_postmeta.post_id = wp_posts.ID AND wp_postmeta.meta_key = '_wpbdp[fields][42]') AS field_42, (SELECT COUNT(wp_postmeta.post_id) FROM wp_postmeta WHERE wp_postmeta.post_id = wp_posts.ID AND wp_posts.post_author <> 6 AND wp_postmeta.meta_key = '_wpbdp[fields][54]' AND wp_postmeta.meta_value LIKE '{dc1f4cfb86b056f59430a5d238d657055dd76541afaf5889cc90d8dad3f340b5}349{dc1f4cfb86b056f59430a5d238d657055dd76541afaf5889cc90d8dad3f340b5}') AS field_54, (SELECT COUNT(DISTINCT url) FROM wp_review_scrapper WHERE listing_id = wp_posts.ID AND source <> 'bbb') AS review_count, (SELECT Count(id) FROM wp_review_scrapper WHERE listing_id = wp_posts.ID AND source = 'bbb') AS bbb_review_count, (SELECT COUNT(wp_postmeta.post_id) FROM wp_postmeta WHERE wp_postmeta.meta_value = wp_posts.ID AND wp_postmeta.meta_key = '_assigned_to') AS local_reviews, (SELECT
wp_postmeta.meta_value FROM wp_postmeta WHERE wp_postmeta.post_id = wp_posts.ID AND wp_postmeta.meta_key = '_glsr_average') AS local_total_rating, (SELECT CAST(AVG(rating_value) AS DECIMAL(10,2)) FROM wp_review_scrapper WHERE listing_id = wp_posts.ID) AS total_rating
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1 AND (
(
wp_term_relationships.term_taxonomy_id IN (349,350,388,394,407)
)
) AND wp_posts.post_type = 'wpbdp_listing' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wpbdp_is_sticky DESC, field_54 DESC, review_count + bbb_review_count + local_reviews DESC, total_rating DESC, wp_posts.post_title ASC
LIMIT 105, 15
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 16621
[post_author] => 6
[post_date] => 2019-06-14 01:40:31
[post_date_gmt] => 2019-06-14 06:40:31
[post_content] =>
thunder::tech is an integrated marketing agency that works across industries throughout the middle-market. Our team members specialize in website development, social media strategy, marketing automation, web optimization, digital advertising, print collateral, logo & identity design, video & animation, and content strategy.
[post_title] => thunder::tech
[post_excerpt] => thunder::tech is an integrated marketing agency that works across industries throughout the middle-market. Our team members specialize in website development, social media strategy, marketing automation, web optimization, digital advertising, print collateral, logo & identity design, video & animation, and content strategy.
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => thundertech
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-16 08:28:58
[post_modified_gmt] => 2020-03-16 13:28:58
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=16621
[menu_order] => 610
[post_type] => wpbdp_listing
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[wpbdp_is_sticky] => 0
[field_42] => 0
[field_54] => 0
[review_count] => 0
[bbb_review_count] => 0
[local_reviews] => 0
[local_total_rating] =>
[total_rating] =>
)
)
[post_count] => 1
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 16621
[post_author] => 6
[post_date] => 2019-06-14 01:40:31
[post_date_gmt] => 2019-06-14 06:40:31
[post_content] =>
thunder::tech is an integrated marketing agency that works across industries throughout the middle-market. Our team members specialize in website development, social media strategy, marketing automation, web optimization, digital advertising, print collateral, logo & identity design, video & animation, and content strategy.
[post_title] => thunder::tech
[post_excerpt] => thunder::tech is an integrated marketing agency that works across industries throughout the middle-market. Our team members specialize in website development, social media strategy, marketing automation, web optimization, digital advertising, print collateral, logo & identity design, video & animation, and content strategy.
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => thundertech
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-16 08:28:58
[post_modified_gmt] => 2020-03-16 13:28:58
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=16621
[menu_order] => 610
[post_type] => wpbdp_listing
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[wpbdp_is_sticky] => 0
[field_42] => 0
[field_54] => 0
[review_count] => 0
[bbb_review_count] => 0
[local_reviews] => 0
[local_total_rating] =>
[total_rating] =>
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 106
[max_num_pages] => 8
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] =>
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] =>
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] => 1
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] => 1
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => a1f2d708f42dc179455a31b360e0d636
[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
)
[query_cache_key:WP_Query:private] =>
[wpbdp_view] =>
[wpbdp_is_main_page] =>
[wpbdp_is_listing] =>
[wpbdp_is_category] =>
[wpbdp_is_tag] =>
[wpbdp_our_query] => 1
)
Having trouble logging in? Contact [email protected]
3635 Perkins Ave., Studio 5 SW, Cleveland, OH 44114