CREATE TABLE tlead
(
    idlead     int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    blive       tinyint         DEFAULT 1  NOT NULL COMMENT 'статус записи',
    strname varchar(250)                   NOT NULL  COMMENT 'название',
);

CREATE TABLE tlead_work
(
    idlead_work int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    tscreate    int(11) UNSIGNED DEFAULT unix_timestamp() NOT NULL COMMENT 'создано',
    blive       tinyint          DEFAULT 1                NOT NULL COMMENT 'статус записи',
    iidlead     int(11) UNSIGNED                          NOT NULL COMMENT 'fk: к лиду',
    strcomment  varchar(255)     DEFAULT ''               NOT NULL COMMENT 'комментарий к назначению',

    CONSTRAINT tleadwork_lead_fk  FOREIGN KEY (iidlead) REFERENCES tlead (idlead)
            ON UPDATE CASCADE ON DELETE CASCADE,
)


SELECT SQL_CALC_FOUND_ROWS l.idlead FROM tlead l
JOIN tlead_work lw ON lw.iidlead = l.idlead AND lw.idlead_work =
    (SELECT MAX(lw1.idlead_work) FROM tlead_work lw1 WHERE lw1.blive=1 AND lw1.iidlead = l.idlead)
WHERE (l.blive=1) AND ((lw.iidmanager IS NULL))
ORDER BY l.idlead
 LIMIT 0,120;

SELECT lw1.*, l1.iidfirm AS forFirm FROM tlead_work lw1
JOIN tlead l1 ON l1.idlead = lw1.iidlead
WHERE l1.idlead IN({$ids})
ORDER BY l1.tscreate DESC, lw1.tscreate DESC

        $assumes = [];
        $stmt = Db::query($sql);
        if( $stmt ){ $assumes = $stmt->fetchAll(PDO::FETCH_ASSOC); }

        return $assumes;