Contact mysql join zu Kunena

<?php
defined('_JEXEC') or die;


use Joomla\Utilities\ArrayHelper;
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$ids = ArrayHelper::getColumn($this->items, 'catid');
ArrayHelper::toInteger($ids);


$query->select('title, id')
->from($db->qn('#__categories'))
->where('id IN('.join(',', $ids).')')
;
$db->setQuery($query);
$Kats = $db->loadObjectList('id');
$sorter = array();
foreach ($this->items as $item)
{
 if (trim($item->sortname1))
 {
  $sorter[$item->catid] = trim($item->sortname1);
 }
}
foreach ($this->items as $item)
{
 @$item->sortname = $sorter[$item->catid];
}
$this->items = ArrayHelper::sortObjects($this->items, array('sortname', 'ordering'));
?>


<?php if (empty($this->items)) : ?>


 <p><?php echo JText::_('COM_CONTACT_NO_CONTACTS'); ?></p>
 
<?php else :
 
 foreach ($this->items as $item)
 {

  if (isset($Kats[$item->catid]))
  {?>
   <h1>Kategorie <?php echo $Kats[$item->catid]->title; ?></h1>;
  <?php
   unset($Kats[$item->catid]);
  }
?>
<h2>Mitarbeiter <a href="<?php echo JRoute::_(ContactHelperRoute::getContactRoute($item->slug, $item->catid)); ?>"><?php echo $item->name; ?></a></h2>


<p><strong>bild:</strong><br /><img src="<?php echo JUri::root().$item->image;?>" /></p>
<p><strong>con_position:</strong> <?php echo $item->con_position; ?></p>
<p><strong>email_to:</strong> <?php echo $item->email_to; ?></p>
<p><strong>telephone:</strong> <?php echo $item->telephone; ?></p>
<p><strong>mobile:</strong> <?php echo $item->mobile; ?></p>
<p><strong>fax:</strong> <?php echo $item->fax; ?></p>
<p><strong>suburb:</strong> <?php echo $item->suburb; ?></p>
<p><strong>state:</strong> <?php echo $item->state; ?></p>
<p><strong>country:</strong> <?php echo $item->country; ?></p>
<p><strong>address:</strong> <?php echo $item->address; ?></p>
<p><strong>postcode:</strong> <?php echo $item->postcode; ?></p>
<div><strong>misc:</strong> <?php echo $item->misc; ?></div>
<?php
 }
?>


<?php endif; ?>