Lines Matching refs:tables

564         $tables = array();
588                 if(!isset($tables[$key])) {
589                     $tables[$key] = 'T' . (++$cnt);
590 …       $from .= ' LEFT JOIN dataau AS ' . $tables[$key] . ' ON ' . $tables[$key] . '.pid = W1.pid';
591                     $from .= ' AND ' . $tables[$key] . ".key = " . $sqlite->quote_string($key);
601 …                 $select[] = "pages.page || '|' || group_concat(" . $tables[$key] . ".value,'\n')";
605                         $select[] = 'group_concat(" " || ' . $tables[$key] . ".value,'\n')";
625                 if(!$tables[$col]) {
626                     $tables[$col] = 'T' . (++$cnt);
627 …       $from .= ' LEFT JOIN dataau AS ' . $tables[$col] . ' ON ' . $tables[$col] . '.pid = W1.pid';
628                     $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->quote_string($col);
631                 $order = 'ORDER BY ' . $tables[$col] . '.value ' . $dataau['sort'][1];