Lines Matching refs:tables
310 $tables = array();
334 if(!$tables[$col]){
335 $tables[$col] = 'T'.(++$cnt);
336 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
337 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
339 $select[] = 'group_concat('.$tables[$col].".value,'\n')";
353 if(!$tables[$col]){
354 $tables[$col] = 'T'.(++$cnt);
355 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
356 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
359 $order = 'ORDER BY '.$tables[$col].'.value '.$data['sort'][1];
378 if(!$tables[$col]){
379 $tables[$col] = 'T'.(++$cnt);
380 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
381 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
384 $where .= ' '.$filter['logic'].' '.$tables[$col].'.value '.$filter['compare'].
395 if(!$tables[$col]){
396 $tables[$col] = 'T'.(++$cnt);
397 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
398 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
401 $where .= ' AND '.$tables[$col].".value = '".sqlite_escape_string($val)."'";
405 if(count($tables)){