For restricting the categories, maybe the plugin Restrict Categories can help. But it doesn’t have Multisite capabilities.
Take a look at the filter list_terms_exclusions that it uses in the cat_filter function.
But Role Scoper states that it has “Extensive WP-mu support”. May be worth a try.
For the query part, take a look at this Q&A, find a random blogid across my multisite network that has at least one post published.
Basically, you need the functions switch_to_blog and restore_current_blog.
Related Posts:
- Prevent duplicate pages from being added
- Very complex post query
- Delete post revisions only for a single post
- How to give classname to post if post has no content?
- Display post by click on the link
- Queries take 120+ seconds on my large WordPress site
- Exclude some posts from displaying in wp_query based on some condition
- Related Posts function not working
- How to retrieve certain number of images from a wordpress post?
- How to convert query sql to shortcode in wordpress?
- WordPress loop not working on static front page
- Change Author Name to Sitename on Frontend
- Some doubts about how the loop work (trying debugging it)
- Cannot select certain authors for posts after import
- How to display only one category in a custom post type?
- why the posts queried from sql is more than those showed on the page?
- Adjust the order for returned posts
- Export all posts to import as product items
- get last post’s link with SQL query
- Trim posts from WP-Query?
- Custom Select Query – Selecting the Year?
- Anyone know a php snippet for showing the first 200 characters of the most recent post?
- Get current taxonomy and display query accordingly
- Show 10 latest posts only from users with contributors role
- Trying to exclude custom posts based on date, while sorting by custom field
- WordPress, custom post type and posts query help!
- How Can I Always Display A Particular Post First Using WP_Query?
- Return records between two meta datetimes saved as strings
- WordPress Query – Display 5 posts (same post type), each from a given tag
- how to add tags to post in the Loop?
- Merge get_comments & get_posts into a single query
- How to optimize posts query in wordpress
- unable to write to the database while uploading images
- Check if almost 10 year old – working code is up to date
- Query to fetch custom taxonomy along with post title
- Displaying all posts from other sites on the network on one site
- How to fetch courses in all languages in WordPress?
- Query custom post type custom meta key
- Multisite how to display merged posts from two sites and sort by latest date?
- Ignore posts content in the posts queries for internal linking
- How to search through “post title” and “tags” using WP_Query?
- Need to display a Jan 1st post as the site’s front page on Jan 1st, and Jan 2nd post as front page on Jan 2nd etc
- Multisite Issue on Subdomain’s article pages
- I have two post types in the same query, how can I use CSS to select only one post type?
- filter posts based on menu_order
- Bulk Post update_post_meta
- Count posts for pagination
- Populate a drop down list with post titles across a multisite network
- Show 5 posts and than 3 posts offset with pagination
- AJAX load more posts not using correct category and repeating the same few posts
- I need some explanation on global $post [duplicate]
- How to delete all posts with dead image urls?
- Numbering author posts in posts query
- How to run select query of post with category and tags?
- Querying posts from current category, using a variable as array argument
- Query posts from newest category
- Sort Events by Venue Title – Sort Post set by related post ids
- wp query custom orderby not custom field
- Query post for today, if no post get the previous one
- Custom Select Query pagination not working properly
- Query post by meta key of another table
- Sort / Filter Queries
- Query post category & remove any post id
- Display the latest post from some selected authors
- How can I have the posts from one word press blog show on the presentation page of another word press site
- Advanced Post Display/Pagination/Ordering
- Ordering posts alphabetically by meta keys and title
- Why I obtain this WP_Query strange behavior trying to select posts having a specific tag?
- Why I have this strange behavior when I try to exlude the featured post from posts visualization?
- Grab next post title in archive page
- Removing a post from the results of a WP Query
- How to get posts from network blog
- Sorting Posts by Date – get_blogs_of_user_id()
- Query posts from a specific category and selected tag
- Continuous listing from a custom field
- Displaying Results From Custom Taxonomy Query
- Sort post by category using HTML Select tag
- How to store post rating system data post independent?
- Users cannot post when editor or admin on more than 1 site on multisite
- How to link two news page multilingual press
- Get first comment link on the post itself
- WP_Query retrieve custom posts but not the post showing
- Special Query: Title, Terms, Content – %LIKE%
- Creating pages and getting their values from the database table
- Make division in post_query?
- How to limit post query to only return a total count of items with certain post statuses?
- Get image paths from RSS feeds
- making a few sites in wordpress
- Display one post randomly from category on home page
- How to set value in Query Loop?
- Wp_query WooCommerce products
- The page that displays Posts on homepage
- query_post or single-[cpt].php?
- Do I need to create a multisite for querying posts from multiple WordPress sites?
- Need to show birthday of custom post type(Famous people in this case) in elementor. Date of birth set in custom fields
- Display posts with id equal to relationship value
- Site ‘Categories’: save an admin global setting with post metadata [closed]
- Sort Posts Alphabetically Based on Specific Category (Divi)
- users followin the blog post author
- Change permalinks in posts via SQL