Pressbooks\Catalog::getByTagId PHP Метод

getByTagId() публичный Метод

Get catalog by tag id
public getByTagId ( integer $tag_group, integer $tag_id ) : array
$tag_group integer
$tag_id integer
Результат array
    function getByTagId($tag_group, $tag_id)
    {
        /** @var $wpdb \wpdb */
        global $wpdb;
        $sql = "SELECT DISTINCT {$this->dbTable}.* FROM {$this->dbTable}\n\t\t\t\tINNER JOIN {$this->dbLinkTable} ON {$this->dbLinkTable}.blogs_id = {$this->dbTable}.blogs_id\n \t\t\t\tINNER JOIN {$this->dbTagsTable} ON {$this->dbTagsTable}.id = {$this->dbLinkTable}.tags_id\n \t\t\t\tWHERE {$this->dbLinkTable}.users_id = %d AND {$this->dbLinkTable}.tags_group = %d AND {$this->dbLinkTable}.tags_id = %d AND {$this->dbTable}.deleted = 0 ";
        $sql = $wpdb->prepare($sql, $this->userId, $tag_group, $tag_id);
        return $wpdb->get_results($sql, ARRAY_A);
    }