Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagephp
$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']]);