MySQL Select in all blogs of network
Guys, i need to do a select all blogs in the network of may main blog of network, something like this way:
$sql = "SELECT DISTINCT retorno.meta_value FROM ".$wpdb->posts." LEFT JOIN ".$wpdb->postmeta." AS requisicao ON requisicao.post_id = ".$wpdb->posts.".ID LEFT JOIN ".$wpdb->postmeta." AS retorno ON retorno.post_id = requisicao.post_id WHERE....
The question is, how to do it FROM “.$wpdb->posts.” or “.$wpdb->postmeta.” be the wp_postmeta and wp_posts of all blogs on the network?
Do not quite understand, but SELECT something like SELECT DISTINCT FROM wp_2_posts AND wp_3_posts AND wp_4_posts AND … infinitely
Is this possible?
- The topic ‘MySQL Select in all blogs of network’ is closed to new replies.