laravel mysql触发器_mysql – Laravel 5中的查询构建器的复杂查询

我已经做了,

$baseQuery = DB::table( 'subscribers_lists')

->leftjoin('subscribers_lists_subscribers', 'subscribers_lists.id', '=', 'subscribers_lists_subscribers.subscribers_list_id')

->leftjoin('subscribers', 'subscribers_lists_subscribers.subscriber_id', '=', 'subscribers.id')

->select(

'subscribers_lists.id',

'subscribers_lists.name',

'subscribers_lists.id as count_openers',

'subscribers_lists.id as count_clickers',

DB::raw('count(case when subscribers.status = "Active" then 1 else null end) as count_active'),

DB::raw('count(case when subscribers.status = "Unsubsribed" then 1 else null end) as count_unsubsribers'),

DB::raw('count(case when subscribers.status = "Bounced" then 1 else null end) as count_bounced'),

DB::raw('count(subscribers_lists_subscribers.subscribers_list_id) as count_total'),

'subscribers_lists.updated_at as last_activity'

)

->where('subscribers_lists.user_id', '=', $user_ID)

->groupBy('subscribers_lists.id');

$totalData = $baseQuery->count();