[wp-hackers] MySQL View of every posts in a WP network

Carlo Gandolfo carlo at artilibere.com
Wed Nov 23 11:07:29 UTC 2011

Hello everybody,
I got a WP network whose posts tables are named:

> wp_1_posts
> wp_2_posts
> wp_3_posts
> ...
> wp_n_posts

and I wish to build a view in MySql to gather all the contents (with limit
20) in a single block.
That could be very useful to query and filter without having to loop
through php.

Anybody has hints to do that?

Thank a lot,

More information about the wp-hackers mailing list