Lines Matching refs:tables
386 $tables = array();
410 if(!$tables[$col]){
411 $tables[$col] = 'T'.(++$cnt);
412 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
413 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
415 $select[] = 'group_concat('.$tables[$col].".value,'\n')";
429 if(!$tables[$col]){
430 $tables[$col] = 'T'.(++$cnt);
431 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
432 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
435 $order = 'ORDER BY '.$tables[$col].'.value '.$data['sort'][1];
454 if(!$tables[$col]){
455 $tables[$col] = 'T'.(++$cnt);
456 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
457 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
460 $where .= ' '.$filter['logic'].' '.$tables[$col].'.value '.$filter['compare'].
471 if(!$tables[$col]){
472 $tables[$col] = 'T'.(++$cnt);
473 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
474 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
477 $where .= ' AND '.$tables[$col].".value = '".sqlite_escape_string($val)."'";
481 if(count($tables)){