Lines Matching refs:datatable

62             $datatable = 'data_' . $schema->getTable();
65 …       $QB->addLeftJoin($first_table, $datatable, $datatable, "$first_table.pid = $datatable.pid");
68                 $QB->addTable($datatable);
72                 $subAnd->whereAnd("$datatable.pid = ''");
74                 $subOr->whereAnd("GETACCESSLEVEL($datatable.pid) > 0");
75                 $subOr->whereAnd("PAGEEXISTS($datatable.pid) = 1");
80                     $datatable,
83                     "$datatable.pid != ''
84                     AND $datatable.pid = schema_assignments.pid
88                 $QB->addSelectColumn($datatable, 'rid');
89                 $QB->addSelectColumn($datatable, 'pid', 'PID');
90                 $QB->addSelectColumn($datatable, 'rev');
92                 $QB->addGroupByColumn($datatable, 'pid');
93                 $QB->addGroupByColumn($datatable, 'rid');
95                 $first_table = $datatable;
98                 $QB->filters()->whereAnd("$datatable.rev =
99                 (SELECT MAX(SUB.rev) FROM $datatable SUB
100                     WHERE SUB.pid=$datatable.pid AND SUB.rev <= '$this->at')");
102                 $QB->filters()->whereAnd("$datatable.latest = 1");
113                 $datatable  = "data_{$col->getTable()}";
118                     $datatable,
121                     "$datatable.pid = $MN.pid AND $datatable.rid = $MN.rid AND
122                      $datatable.rev = $MN.rev AND
143             $datatable  = "data_{$col->getTable()}";
151                     $datatable,
154                     "$datatable.pid = $MN.pid AND $datatable.rid = $MN.rid AND
155                      $datatable.rev = $MN.rev AND
161                 $coltbl = $datatable;