You could simply use the get_blogs_of_user() function:
echo count( get_blogs_of_user( $user_ID ) );
instead of your custom SQL query.
Related Posts:
- get_user_meta() to Return User Meta Only for Current Blog in Multi Site
- Is there a wordpress function to cleanly delete an entry in the signups table?
- Exclude main blog from get_blogs_of_user
- Get users primary blog URL in MultiSite
- How to Move Local Singlesite Database to Remote Multsite Database?
- How to store custom user data on the database?
- Query users by capability – uninstall/deactivate callback
- WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
- How is a user’s primary blog determined?
- Database Tables Lost Indexes? How to Recover?
- List recent 25 blogs across the network
- User Role is Not Specifying in WordPress Multisite?
- Solving a get_user_meta() problem in Multisite
- get_user_meta() in multiste with respect to subdomain
- Delete all user’s meta without knowing all the ‘key’
- WP MultiSite: Can’t select database error after changing to new domain
- Minimize Performance Issues of MultiSite Large Number of Tables Created
- WPMU add custom colum
- Can I replace the “Upgrade Network” with SQL query?
- Get users from all/specific blog by user_role and current_user role
- How does adding custom meta to signup form work?
- How to use 2 different databases but share the same user in wordpress
- How to use WordPress Multisite With Different Domain Names?
- How To Add Custom Form Fields To The User Profile Page?
- Where are available Roles Defined in the wp_ database?
- restore_current_blog() vs switch_to_blog()
- Can i merge 2 new WP_Query($variable) ‘s?
- How to disable a network enabled plugin for just one site?
- How to reliably flush rewrite rules on multisite?
- Site Redirecting to wp-signup.php
- Moving a WP Multisite to a subdirectory
- Cookies in multisite where network sites have their own domain name
- Convert a Multisite WordPress install into a Single site
- WordPress MultiSite Active Directory integration and site privacy
- WordPress Job Interview Preparation
- How to add Custom Blog Options to new blog setup form?
- How can I trust switch_to_blog()?
- Remove the blog slug from WordPress Multisite root node
- Why are my roles not visible in a Multi-site/Network?
- Site admin in a network install can’t edit users?
- How to use same email for multiple users
- How to run an activation function when plugin is network activated on multisite?
- Specific upload folder for PDFs in custom Post type in WP multisite
- What is the correct way to map multiple domains in a WordPress 4.1 multisite install?
- Where can I find documentation on what characters are allowed in user names and why?
- How to migrate subsite from dev multisite to production multisite
- How can I un-reserve a pending username registration?
- How do I remove/delete an old super admin user?
- DB connection error after copying a WordPress Multisite instance to a second location
- Redirect Main Site to Subsite in Multisite WordPress
- Is there a is_user_logged_in() for multisite?
- Switching MultiSite installation from HTTP to HTTPS
- Allow user to select a theme to install when they signup
- Setting up a wordpress network with third level domains
- Get upload URL by blog ID in multisite
- What’s the difference between get_site_option and get_blog_option?
- Need help sorting “My Sites” Alphabetically
- How to delete post revisions?
- Making my plugin multi-site compatible
- Create mobile site with same content just different theme
- Add additional Network constants to wp-config.php dynamically
- Multisite stuck at 1MB for max file size
- How to get blog name, when using WordPress Multisite
- What are options are there to implement a multi language site
- Switching primary site in WordPress Multisite
- Multisite Network Port Num Issues?
- Convert existing site to network
- Where is the robots.txt stored for a WordPress Multisite install?
- Settings API in Multisite – Missing update message
- Add WordPress MU Network Admin via Database
- How to get current site id? (WPMU)
- Multisite on Windows with wildcard subdomains
- Why is WordPress Multisite redirecting to wp-signup.php and how to fix it?
- Which asset URLs are acceptable in a “vanilla” MU install?
- $wpdb->base_prefix not get parent site prefix in multisite
- How to tell which database tables belongs to which multisite site
- what are pmxi tables? [closed]
- Using wp_insert_post() with Networking enabled
- Are nested subdomains possible with a subdomain multisite?
- Sharing Dynamic Sidebars across Multisite Blogs
- I want to develop locally with Multisite, then migrate each site to separate remote WP installs
- Password Reset for Users on a Multisite Subsite
- Anyone figured out how to use WordPress MultiSite with Domain Mapping & SSL?
- Can a multisite’s blogs be accessible from two different sub-domains?
- Querying posts from multiple sites in a network?
- Plugin for editing options on multisite?
- What do I need to do to convert my MultiSite from HTTP to HTTPS?
- is_front_page() malfunction?
- WP Multisite development with Mamp Pro and wildcard subdomains, not really working for me
- How to share WordPress core library
- How do I change the Multisite URL?
- Create site programmatically for WPMU
- Can upload doc and pdf but not ppt – not permitted for security reasons
- How Can I Centralize Content Usage and Approval in a WordPress Multi-Site installation
- WordPress Multisite: Adding actions to only one site
- WordPress Multisite allow site admin to add user without email confirmation
- Domain mapping (without plugin) in 4.5.x multisite?
- wordpress multisite, how to keep user on subdomain throughout registration process?
- How will self-hosted WordPress work with Google Page Speed Service?
- WordPress Multisite, NGINX and WordPress Subdirectory Install