WP_Query Object ( [query] => Array ( [post_type] => wpbdp_listing [posts_per_page] => 15 [post_status] => publish [paged] => 34 [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] => 317 ) ) ) ) ) [query_vars] => Array ( [post_type] => wpbdp_listing [posts_per_page] => 15 [post_status] => publish [paged] => 34 [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] => 317 ) ) ) ) [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] => [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] => 317 ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [0] => Array ( [taxonomy] => city [terms] => Array ( [0] => 317 ) [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] => 317 ) [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 '{3cab2d9d2b490be91c191a9955194c28fdd79d7eade3b9bb41a8a32acc9461d4}317{3cab2d9d2b490be91c191a9955194c28fdd79d7eade3b9bb41a8a32acc9461d4}') 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 (317,328,329,330,331,332,353,400,442) ) ) 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 495, 15 [posts] => Array ( [0] => WP_Post Object ( [ID] => 31702 [post_author] => 6 [post_date] => 2020-06-26 10:02:14 [post_date_gmt] => 2020-06-26 15:02:14 [post_content] => Zilker Marketing is a creative, innovative, and cutting edge, inbound marketing firm. Our focus is on using powerful marketing tools to help accelerate your company's growth. We know marketing and are continuously exploring new platforms and strategies to better serve our clients. [post_title] => Zilker Marketing [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => zilker-marketing [to_ping] => [pinged] => [post_modified] => 2020-06-26 10:02:14 [post_modified_gmt] => 2020-06-26 15:02:14 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=31702 [menu_order] => 0 [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] => 31702 [post_author] => 6 [post_date] => 2020-06-26 10:02:14 [post_date_gmt] => 2020-06-26 15:02:14 [post_content] => Zilker Marketing is a creative, innovative, and cutting edge, inbound marketing firm. Our focus is on using powerful marketing tools to help accelerate your company's growth. We know marketing and are continuously exploring new platforms and strategies to better serve our clients. [post_title] => Zilker Marketing [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => zilker-marketing [to_ping] => [pinged] => [post_modified] => 2020-06-26 10:02:14 [post_modified_gmt] => 2020-06-26 15:02:14 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=31702 [menu_order] => 0 [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] => 496 [max_num_pages] => 34 [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] => f6db2c11918911a2a2054f4c55437c98 [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 ) [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] => 34 [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] => 317 ) ) ) ) ) [query_vars] => Array ( [post_type] => wpbdp_listing [posts_per_page] => 15 [post_status] => publish [paged] => 34 [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] => 317 ) ) ) ) [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] => [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] => 317 ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [0] => Array ( [taxonomy] => city [terms] => Array ( [0] => 317 ) [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] => 317 ) [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 '{3cab2d9d2b490be91c191a9955194c28fdd79d7eade3b9bb41a8a32acc9461d4}317{3cab2d9d2b490be91c191a9955194c28fdd79d7eade3b9bb41a8a32acc9461d4}') 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 (317,328,329,330,331,332,353,400,442) ) ) 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 495, 15 [posts] => Array ( [0] => WP_Post Object ( [ID] => 31702 [post_author] => 6 [post_date] => 2020-06-26 10:02:14 [post_date_gmt] => 2020-06-26 15:02:14 [post_content] => Zilker Marketing is a creative, innovative, and cutting edge, inbound marketing firm. Our focus is on using powerful marketing tools to help accelerate your company's growth. We know marketing and are continuously exploring new platforms and strategies to better serve our clients. [post_title] => Zilker Marketing [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => zilker-marketing [to_ping] => [pinged] => [post_modified] => 2020-06-26 10:02:14 [post_modified_gmt] => 2020-06-26 15:02:14 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=31702 [menu_order] => 0 [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] => 31702 [post_author] => 6 [post_date] => 2020-06-26 10:02:14 [post_date_gmt] => 2020-06-26 15:02:14 [post_content] => Zilker Marketing is a creative, innovative, and cutting edge, inbound marketing firm. Our focus is on using powerful marketing tools to help accelerate your company's growth. We know marketing and are continuously exploring new platforms and strategies to better serve our clients. [post_title] => Zilker Marketing [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => zilker-marketing [to_ping] => [pinged] => [post_modified] => 2020-06-26 10:02:14 [post_modified_gmt] => 2020-06-26 15:02:14 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=31702 [menu_order] => 0 [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] => 496 [max_num_pages] => 34 [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] => f6db2c11918911a2a2054f4c55437c98 [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 ) [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]
800 W. 5th, Austin, TX 78703