...
Code Block | ||
---|---|---|
| ||
$services = $this->query(<<<SQL SELECT S.RECID, S.SERVICE_ID FROM SERVICES S LEFT JOIN LISTS ON S.SERVICE_STATUS_LISTS_RECID = LISTS.RECID WHERE LISTS.CODE IN (:statusCodesactive, :available) SQL, [':statusCodesactive' => ['ACTIVE', ':available' => 'AVAILABLE']]); |