AI
public function phone()
{
return $this->hasOne('App\Phone')->where('blabla_id', $this->relationOne->relationTwo->blabla_id);
}
т.е. где в конструкции where используется цепочка отношений от этой же модели
Size: a a a
AI
DA
AI
DA
AI
pf
u
k
u
pf
А
SELECT DISTINCT users.*,
(SELECT SUM(forecasts.bet * forecasts.coefficient) - SUM(forecasts.bet) FROM forecasts, events where users.id = forecasts.user_id AND events.id = forecasts.event_id AND events.status = 2) / SUM(forecasts.bet) as roi
FROM users, forecasts, events
WHERE users.id = forecasts.user_id
AND events.id = forecasts.event_id
GROUP BY users.id
V
SELECT DISTINCT users.*,
(SELECT SUM(forecasts.bet * forecasts.coefficient) - SUM(forecasts.bet) FROM forecasts, events where users.id = forecasts.user_id AND events.id = forecasts.event_id AND events.status = 2) / SUM(forecasts.bet) as roi
FROM users, forecasts, events
WHERE users.id = forecasts.user_id
AND events.id = forecasts.event_id
GROUP BY users.id
А
V
А
Л@
$users = User::select([
'users.*',
'last_posted_at' => Post::selectRaw('MAX(created_at)')
->whereColumn('user_id', 'users.id')
])->get();
Л@
$users = User::select([
'users.*',
'last_posted_at' => Post::selectRaw('MAX(created_at)')
->whereColumn('user_id', 'users.id')
])->withCasts([
'last_posted_at' => 'date'
])->get();
Л@
V