Lines Matching refs:gp2
526 function _trans_group($gp1, $gp2, $join) { argument
528 $terms = array_unique(array_merge($gp1['terms'], $gp2['terms']));
531 $common = array_intersect($gp1['terms'], $gp2['terms']);
551 …'sql'=>'SELECT DISTINCT '.$fields.' FROM ('.$gp1['sql'].') AS r1 '.$join.' ('.$gp2['sql'].') AS r2…
561 $gp2 = $this->_dispatch($query['rhs']);
562 return $this->_trans_group($gp1, $gp2, 'LEFT OUTER JOIN');
570 $gp2 = $this->_dispatch($query['rhs']);
571 return $this->_trans_group($gp1, $gp2, 'INNER JOIN');
655 $gp2 = $this->_dispatch($query['rhs']);
658 $common = array_intersect($gp1['terms'], $gp2['terms']);
673 …T DISTINCT * FROM ('.$gp1['sql'].') r1 WHERE NOT EXISTS (SELECT * FROM ('.$gp2['sql'].') r2 WHERE …
684 $gp2 = $this->_dispatch($query['rhs']);
692 $ta = array_diff($gp1['terms'], $gp2['terms']);
693 $tb = array_diff($gp2['terms'], $gp1['terms']);
696 $tc = array_intersect($gp1['terms'], $gp2['terms']);
699 $terms = array_unique(array_merge($gp1['terms'], $gp2['terms']));
715 …'sql'=>'SELECT DISTINCT '.$sa.' FROM ('.$gp1['sql'].') r1 LEFT OUTER JOIN ('.$gp2['sql'].') r2 ON …