Lines Matching refs:tables
270 $tables = array();
294 if(!$tables[$col]){
295 $tables[$col] = 'T'.(++$cnt);
296 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
297 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
299 $select[] = 'group_concat('.$tables[$col].".value,'\n')";
313 if(!$tables[$col]){
314 $tables[$col] = 'T'.(++$cnt);
315 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
316 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
319 $order = 'ORDER BY '.$tables[$col].'.value '.$data['sort'][1];
338 if(!$tables[$col]){
339 $tables[$col] = 'T'.(++$cnt);
340 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
341 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
344 $where .= ' '.$filter['logic'].' '.$tables[$col].'.value '.$filter['compare'].
355 if(!$tables[$col]){
356 $tables[$col] = 'T'.(++$cnt);
357 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
358 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
361 $where .= ' AND '.$tables[$col].".value = '".sqlite_escape_string($val)."'";
365 if(count($tables)){