Отображать в админке в заказах город заказчика

<th class="hikashop_order_modified_title title">
                <?php echo JHTML::_('grid.sort',   "Город", 'b.order_shipping_address_id', $this->pageInfo->filter->order->dir, $this->pageInfo->filter->order->value ); ?>
        </th>

<td class="hikashop_order_address_value">
                    <?php  $db = JFactory::getDBO();
               $my_query = "SELECT * \n"
    . "FROM `#__hikashop_address` \n"
    . "WHERE `address_id` \n"
    . "IN (".$row->order_shipping_address_id. ")\n";
      $db->setQuery($my_query);
      $myq = $db->loadObjectList();   
      echo $myq[0]->address_city;
     ?>
      </td>

SQL=SELECT a.*,b.*,c.* FROM bmbi3_hikashop_order AS b LEFT JOIN bmbi3_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN bmbi3_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale')