Lines Matching refs:fields
534 $fields = array_diff($terms, $common);
541 $fields[]='COALESCE(r1.'.$c.', r2.'.$c.') AS '.$c;
548 $fields = implode(', ',$fields);
551 'sql'=>'SELECT DISTINCT '.$fields.' FROM ('.$gp1['sql'].') AS r1 '.$join.' ('.$gp2['sql'].') AS r2 ON '.$intersect,
730 $fields = array();
764 // project extra fields that are required for the grouping
769 $fields[] = $name;
784 $fields[] = $name;
795 // add fields suggested for consideration
799 $fields[] = "$name AS $alias";
809 $fields[] = "$term AS $a";
815 $fields = implode(', ',$fields);
825 'sql'=>'SELECT DISTINCT '.$fields.' FROM ('.$gp['sql'].') r'.$ordering,