Lines Matching refs:Expression
34 use Illuminate\Database\Query\Expression; alias
102 return DB::table(new Expression('(' . $subquery1->toSql() . ') AS sub1'))
122 ->having(new Expression('COUNT(s_id)'), '>', '1')
123 ->select([new Expression(DB::groupConcat('s_id') . ' AS xrefs')])
146 ->having(new Expression('COUNT(DISTINCT d_gid)'), '>', '1')
147 ->select([new Expression(DB::groupConcat('d_gid') . ' AS xrefs')])
157 ->groupBy([new Expression('LEAST(f_husb, f_wife)')])
158 ->groupBy([new Expression('GREATEST(f_husb, f_wife)')])
159 ->having(new Expression('COUNT(f_id)'), '>', '1')
160 ->select([new Expression(DB::groupConcat('f_id') . ' AS xrefs')])
170 ->having(new Expression('COUNT(DISTINCT m_id)'), '>', '1')
171 ->select([new Expression(DB::groupConcat('m_id') . ' AS xrefs')])
197 ->select(['i_id AS xref', new Expression("'INDI' AS type")])
200 ->select(['f_id AS xref', new Expression("'FAM' AS type")]))
203 ->select(['s_id AS xref', new Expression("'SOUR' AS type")]))
206 ->select(['m_id AS xref', new Expression("'OBJE' AS type")]))