Lines Matching refs:QB

502         $QB = new QueryBuilder();
503         $QB->addTable($stable, 'DATA');
504         $QB->addSelectColumn('DATA', $idColumn, strtoupper($idColumn));
505         $QB->addGroupByStatement("DATA.$idColumn");
514                 $QB->addLeftJoin(
520                 $col->getType()->select($QB, $tn, 'value', $outname);
521                 $sel = $QB->getSelectStatement($outname);
522                 $QB->addSelectStatement("GROUP_CONCAT_DISTINCT($sel, '$sep')", $outname);
524                 $col->getType()->select($QB, 'DATA', $colname, $outname);
525                 $QB->addGroupByStatement($outname);
529         $pl = $QB->addValue($this->{$idColumn});
530         $QB->filters()->whereAnd("DATA.$idColumn = $pl");
531         $pl = $QB->addValue($this->getLastRevisionTimestamp());
532         $QB->filters()->whereAnd("DATA.rev = $pl");
534         return $QB->getSQL();