Lines Matching refs:tables
75 $tables = [];
116 if (!$tables[$col]) {
117 $tables[$col] = 'T' . (++$cnt);
118 $from .= ' LEFT JOIN data AS ' . $tables[$col] . ' ON ' . $tables[$col] . '.pid = pages.pid';
119 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->getPdo()->quote($col);
122 $order = ', ' . $tables[$col] . '.value ' . $data['sort'][1];
148 if (!$tables[$col]) {
149 $tables[$col] = 'T' . (++$cnt);
150 $from .= ' LEFT JOIN data AS ' . $tables[$col] . ' ON ' . $tables[$col] . '.pid = pages.pid';
151 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->getPdo()->quote($col);
154 $where .= ' ' . $filter['logic'] . ' ' . $tables[$col] . '.value ' . $filter['compare'] .