rendered paste body<?php global $wpdb; $link_ids = $wpdb->get_results( "SELECT link_id FROM $wpdb->link2cat WHERE category_i = '1504' ORDER BY link_id" ); foreach ( (array) $link_ids as $link ) { $link_urls = $wpdb->get_results( "SELECT link_url FROM $wpdb->links WHERE link_id = '$link->link_id' ORDER BY link_id" ); foreach ( (array) $link_urls as $link_url ) { $bloggers = $wpdb->get_results( "SELECT ID, user_nicename FROM $wpdb->users WHERE user_url = '$link_url->link_url' ORDER BY display_name" ); foreach ( (array) $bloggers as $blogger ) { $firstname = get_usermeta( $blogger->ID, 'first_name' ); $lastname = get_usermeta( $blogger->ID, 'last_name' ); printf( '<li><a href="%1$s">%2$s</a></li>', get_bloginfo( 'url' ) . '/author/' . $blogger->user_nicename, $firstname . $lastname ); } } } ?>