doit-cms
doit-cms copied to clipboard
Оптимизировать внутренние запросы
$clients = d()->Client->where('user_id = ?', $id);
$active = d()->Workstatus->select('DISTINCT client_id')->where('client_id IN (?) AND status_id = 1 AND service_id IN (SELECT service_id FROM services_to_clients WHERE clients.client_id = services_to_clients.client_id)', $clients->all_of('ids'));