Custom Taxonomy Listing Help WordPress

Dbranes answers:

Hi, here is one idea to use only a single db query:


$sql=" SELECT
{$wpdb->term_relationships}.object_id as post_id,
{$wpdb->posts}.post_title as beer_name,
{$wpdb->terms}.name as term_name,
{$wpdb->term_taxonomy}.term_id as term_id,
{$wpdb->term_taxonomy}.taxonomy,
{$wpdb->terms}.slug as term_slug
FROM {$wpdb->terms}
LEFT JOIN {$wpdb->term_taxonomy}
ON {$wpdb->term_taxonomy}.term_id = {$wpdb->terms}.term_id
LEFT JOIN {$wpdb->term_relationships}
ON {$wpdb->term_taxonomy}.term_taxonomy_id = {$wpdb->term_relationships}.term_taxonomy_id
LEFT JOIN tfl_posts
ON {$wpdb->term_relationships}.object_id = {$wpdb->posts}.id
WHERE {$wpdb->term_taxonomy}.taxonomy in ( 'country','brewers')
AND {$wpdb->posts}.post_status ='publish'";

$data =$wpdb->get_results($sql,ARRAY_A);

$beers_per_country=array();
$brewers_per_beer=array();
$beers_per_brewer=array();

foreach($data as $d){
if($d['taxonomy']=="country"){
$beers_per_country[$d['term_name']][]=array("post_id"=>$d['post_id'],"country_id"=>$d['term_id'],"country_name"=>$d['term_name']);
}elseif($d['taxonomy']=="brewers"){
$beers_per_brewer[$d['term_name']][]=array("post_id"=>$d['post_id'],"beer_name"=>$d['beer_name']);
$brewers_per_beer[$d['post_id']][]=array("brewer_name"=>$d['term_name'],"brewer_id"=>$d['term_id'],"brewer_slug"=>$d['term_slug']);
}
}

echo "<pre>";

$a=array();
$b=array();
$c=array();

echo "<ul>";

foreach($beers_per_country as $country=>$beers){
echo "<li>".$country."<ul>";
foreach($beers as $beer){
foreach($brewers_per_beer[$beer['post_id']] as $brewer){
$a[]=$brewer['brewer_name'];
foreach($beers_per_brewer[$brewer['brewer_name']] as $item){
$b[$brewer['brewer_name']][]=$item['beer_name'];
}
}
}
$a=array_unique($a);
foreach($a as $brewer_name){
echo "<li>".$brewer_name."<ul>";
$c=array_unique($b[$brewer_name]);
foreach($c as $item){
echo "<li>".$item."</li>";
}
echo "</ul></li>";
}
echo "</ul></li>";
}
echo "</ul>";
echo "</pre>";


---

---