WP_Query Object
(
[query] => Array
(
[post_type] => wpbdp_listing
[posts_per_page] => 15
[post_status] => publish
[paged] => 4
[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] => 304
)
)
)
)
)
[query_vars] => Array
(
[post_type] => wpbdp_listing
[posts_per_page] => 15
[post_status] => publish
[paged] => 4
[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] => 304
)
)
)
)
[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] => 304
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[0] => Array
(
[taxonomy] => city
[terms] => Array
(
[0] => 304
)
[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] => 304
)
[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 '{8c247a5561be8dd8ca3d107ee021ea8741f611cf12da3df8fbd3383e7dcf41bf}304{8c247a5561be8dd8ca3d107ee021ea8741f611cf12da3df8fbd3383e7dcf41bf}') 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 (304)
)
) 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 45, 15
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 36592
[post_author] => 2646
[post_date] => 2020-09-18 15:24:30
[post_date_gmt] => 2020-09-18 20:24:30
[post_content] => Hexazon believes in supporting our local communities by supporting a business with growth. That means more leads, phone calls, and a higher ranking! It's our pleasure to help you with anything to contribute to the people you love and service!
Our philosophy is to ALWAYS do the right thing, help one another, service is prime, keep our guarantee, overachieve, generate supreme products, and lastly outshine expectations! Hexazon success is based on our clients fulfillment and achievement. Not by quantity. If we focus on volume then our quality will surely fail and so would our clients satisfaction. With that being said we want to be completely honest with you in our evaluation, to make sure we get you to the top. If you can handle our honesty, ideas, and our expressive attitudes then I'm sure we can make you grow! We enjoy long term, joyous, quality, worthwhile, win-win relationships with our clients in order to prosper together. Thank you again for getting to know us a bit more. We will be looking forward to speaking with you!
[post_title] => Hexazon SEO and Design
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => hexazon-seo-design
[to_ping] =>
[pinged] =>
[post_modified] => 2020-09-18 15:24:30
[post_modified_gmt] => 2020-09-18 20:24:30
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=36592
[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] =>
)
[1] => WP_Post Object
(
[ID] => 46789
[post_author] => 6
[post_date] => 2021-01-14 06:39:08
[post_date_gmt] => 2021-01-14 12:39:08
[post_content] => Longtail Marketing provides stellar search engine optimization (SEO) & web design services for local businesses. Get your business on Google's first page!
[post_title] => Longtail Marketing Agency
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => longtail-marketing-agency
[to_ping] =>
[pinged] =>
[post_modified] => 2021-01-14 06:39:08
[post_modified_gmt] => 2021-01-14 12:39:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=46789
[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] =>
)
[2] => WP_Post Object
(
[ID] => 14140
[post_author] => 6
[post_date] => 2019-03-07 08:54:11
[post_date_gmt] => 2019-03-07 14:54:11
[post_content] => Propane is a digital experience and platform agency. We work to augment marketing and digital transformation initiatives. Our services include: brand strategy, content strategy, creative design, digital experience, development, and connecting marketing ecosystems. Founded in 2003, we deliver experiences that inspire action with brands like Kaiser Permanente, Equinix, GE, Intel, CalAmp, Banner Health, Volkswagen, and Clarisonic.
[post_title] => Propane
[post_excerpt] => Propane is a digital experience and platform agency. We work to augment marketing and digital transformation initiatives. Our services include: brand strategy, content strategy, creative design, digital experience, development, and connecting marketing ecosystems. Founded in 2003, we deliver experiences that inspire action with brands like Kaiser Permanente, Equinix, GE, Intel, CalAmp, Banner Health, Volkswagen, and Clarisonic.
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => propane
[to_ping] =>
[pinged] =>
[post_modified] => 2020-05-08 07:28:15
[post_modified_gmt] => 2020-05-08 12:28:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=14140
[menu_order] => 1501
[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] =>
)
[3] => WP_Post Object
(
[ID] => 46360
[post_author] => 6
[post_date] => 2021-01-11 07:04:45
[post_date_gmt] => 2021-01-11 13:04:45
[post_content] => Rankfellas was created to respond to the demands of clients who are looking for SEO marketers who are focused on bottom line and not just traffic. We understand that SEO is multi-layered and extends from traditional SEO tactics to Conversion Rate Optimization to user experience.
[post_title] => RankFellas
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => rankfellas
[to_ping] =>
[pinged] =>
[post_modified] => 2021-01-11 07:04:45
[post_modified_gmt] => 2021-01-11 13:04:45
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=46360
[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] =>
)
[4] => WP_Post Object
(
[ID] => 46334
[post_author] => 6
[post_date] => 2021-01-11 06:18:55
[post_date_gmt] => 2021-01-11 12:18:55
[post_content] => RankScience is an SEO automation platform that works to improve your website's SEO through A/B testing and data science. No matter your goals, our data-driven SEO solutions can help you achieve them.
[post_title] => RankScience
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => rankscience
[to_ping] =>
[pinged] =>
[post_modified] => 2021-01-11 06:18:55
[post_modified_gmt] => 2021-01-11 12:18:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=46334
[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] =>
)
[5] => WP_Post Object
(
[ID] => 47012
[post_author] => 6
[post_date] => 2021-01-18 06:28:36
[post_date_gmt] => 2021-01-18 12:28:36
[post_content] => We provide internet marketing services: Web Design, SEO, Reputation Marketing, Social Media, Facebook Advertising, Mobile and more for local and small business.
[post_title] => Results Marketing
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => results-marketing
[to_ping] =>
[pinged] =>
[post_modified] => 2021-01-18 06:28:36
[post_modified_gmt] => 2021-01-18 12:28:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=47012
[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] =>
)
[6] => WP_Post Object
(
[ID] => 13893
[post_author] => 6
[post_date] => 2019-03-07 14:20:44
[post_date_gmt] => 2019-03-07 20:20:44
[post_content] => We are a business consulting and digital marketing agency that provides innovative solutions and tools to help your business in a multitude of areas. Companies are no longer simply building websites. They are creating business solutions. Our clients understand the importance of the internet for branding, marketing and direct selling of their products and services. They also know they can fulfill many internal corporate business functions with the right online solution. Many firms build websites. Socialfix builds businesses.
[post_title] => Socialfix Media
[post_excerpt] => We are a business consulting and digital marketing agency that provides innovative solutions and tools to help your business in a multitude of areas. Companies are no longer simply building websites. They are creating business solutions. Our clients understand the importance of the internet for branding, marketing and direct selling of their products and services. They also know they can fulfill many internal corporate business functions with the right online solution. Many firms build websites. Socialfix builds businesses.
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => socialfix-media
[to_ping] =>
[pinged] =>
[post_modified] => 2020-05-08 07:28:16
[post_modified_gmt] => 2020-05-08 12:28:16
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=13893
[menu_order] => 1488
[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] =>
)
[7] => WP_Post Object
(
[ID] => 47004
[post_author] => 6
[post_date] => 2021-01-18 06:07:46
[post_date_gmt] => 2021-01-18 12:07:46
[post_content] => Our team brings an extensive set of experiences that speak directly to the needs of emerging businesses, brands, and startups in 2015. Following more of a "bottom-up" and "inclusive" approach (as opposed to traditional forms of business development),
[post_title] => Straub Creative Company
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => straub-creative-company
[to_ping] =>
[pinged] =>
[post_modified] => 2021-01-18 06:07:46
[post_modified_gmt] => 2021-01-18 12:07:46
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=47004
[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] =>
)
[8] => WP_Post Object
(
[ID] => 47286
[post_author] => 6
[post_date] => 2021-01-19 06:38:47
[post_date_gmt] => 2021-01-19 12:38:47
[post_content] => TokyoTechie is a Pune based Company. We provide Blockchain Solutions, ICO Launch, Cryptocurrency Development along with Website & mobile app Development.
[post_title] => TokyoTechie
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => tokyotechie
[to_ping] =>
[pinged] =>
[post_modified] => 2021-01-19 06:38:47
[post_modified_gmt] => 2021-01-19 12:38:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=47286
[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] =>
)
[9] => WP_Post Object
(
[ID] => 47314
[post_author] => 6
[post_date] => 2021-01-19 07:29:53
[post_date_gmt] => 2021-01-19 13:29:53
[post_content] => We are a full-service digital marketing firm helping healthcare businesses improve ROI inside out. We founded Troiqa Media on a shared vision to transform the growing healthcare space in the digital era. We build digital brands and generate real ROI for medical billing companies, healthcare startups, medical practices, and dental clinics.
[post_title] => Troiqa Media
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => troiqa-media
[to_ping] =>
[pinged] =>
[post_modified] => 2021-01-19 07:29:53
[post_modified_gmt] => 2021-01-19 13:29:53
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=47314
[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] => 10
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 36592
[post_author] => 2646
[post_date] => 2020-09-18 15:24:30
[post_date_gmt] => 2020-09-18 20:24:30
[post_content] => Hexazon believes in supporting our local communities by supporting a business with growth. That means more leads, phone calls, and a higher ranking! It's our pleasure to help you with anything to contribute to the people you love and service!
Our philosophy is to ALWAYS do the right thing, help one another, service is prime, keep our guarantee, overachieve, generate supreme products, and lastly outshine expectations! Hexazon success is based on our clients fulfillment and achievement. Not by quantity. If we focus on volume then our quality will surely fail and so would our clients satisfaction. With that being said we want to be completely honest with you in our evaluation, to make sure we get you to the top. If you can handle our honesty, ideas, and our expressive attitudes then I'm sure we can make you grow! We enjoy long term, joyous, quality, worthwhile, win-win relationships with our clients in order to prosper together. Thank you again for getting to know us a bit more. We will be looking forward to speaking with you!
[post_title] => Hexazon SEO and Design
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => hexazon-seo-design
[to_ping] =>
[pinged] =>
[post_modified] => 2020-09-18 15:24:30
[post_modified_gmt] => 2020-09-18 20:24:30
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.seoblog.com/?post_type=wpbdp_listing&p=36592
[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] => 55
[max_num_pages] => 4
[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] => fcacd19ddd016a6423ac31a8cb375aa9
[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
)
SEOblog Score ↓ Sponsorship Level ↓ Business Name ↓
Project Size $0 - $10,000 $10,001 - 30,000 $30,001 - $50,000 $50,001 - $100,000 $100,000+
Employee Size 1-9 10-49 50-99 100-149 150-250 250+
Hourly Rate $1-$49 $50-$99 $100-$149 $150-$199
$10,001 - 30,000
$1-$49
1-9
San Leandro, California
