13     protected $qb;  variable in dokuwiki\\plugin\\struct\\meta\\SearchSQLBuilder
23         $this->qb = new QueryBuilder();
40 … $this->qb->addLeftJoin($first_table, $datatable, $datatable, "$first_table.pid = $datatable.pid");
43                 $this->qb->addTable($datatable);
46                 $subAnd = $this->qb->filters()->whereSubAnd();
55                 $this->qb->addLeftJoin(
65                     $this->qb->addSelectColumn($datatable, 'rid');
66                     $this->qb->addSelectColumn($datatable, 'pid', 'PID');
67                     $this->qb->addSelectColumn($datatable, 'rev');
68                     $this->qb->addSelectColumn('schema_assignments', 'assigned', 'ASSIGNED');
69                     $this->qb->addGroupByColumn($datatable, 'pid');
70                     $this->qb->addGroupByColumn($datatable, 'rid');
75             $this->qb->filters()->whereAnd($this->addPublishClauses($datatable));
94                 $MN = $this->qb->generateTableAlias('M');
96                 $this->qb->addLeftJoin(
105                 $col->getType()->select($this->qb, $MN, 'value', $CN);
106                 $sel = $this->qb->getSelectStatement($CN);
107                 $this->qb->addSelectStatement("GROUP_CONCAT_DISTINCT($sel, '$sep')", $CN);
109 …           $col->getType()->select($this->qb, 'data_' . $col->getTable(), $col->getColName(), $CN);
110                 $this->qb->addGroupByStatement($CN);
126         $subClause = $this->qb->filters()->where('AND');
137                 $MN = $this->qb->generateTableAlias('MN');
139                 $this->qb->addLeftJoin(
172 …     $col->getType()->sort($this->qb, 'data_' . $col->getTable(), $colname, $asc ? 'ASC' : 'DESC');
198         return $this->qb;
210         return $this->qb->getSQL();