SELECT
    (SELECT c.title FROM contract c LEFT JOIN user_login_1 ul ON (ul.cid = c.id) WHERE ul.id = lid) AS dogovor,
    DATE_FORMAT(session_start, '%d.%m.%Y %T') AS start,
    DATE_FORMAT(session_stop, '%d.%m.%Y %T') AS stop,
    SEC_TO_TIME(session_time) AS time,
    INET_NTOA(ipaddr) AS ip
FROM
    log_session_<mid>_YYYYMM
WHERE
    session_start LIKE 'ГОД-МЕСЯЦ-ДАТА%'
AND
    ipaddr = INET_ATON('тут.пишем.требуемый.IP');