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

[Carlo Gandolfo]

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,
Carlo