SELECT DISTINCT
    (
        SELECT
            s.code
        FROM
            ecc_store s
        WHERE
            s.store_id = v.store_id

    ) AS loja
    , v.usertoken_uuid AS user_token
    , v.url_md5 AS url
    , CONVERT(EXTRACT(YEAR_MONTH FROM v.`timestamp`), CHAR(6)) AS mes
    , LPAD(DAY(`timestamp`), 2, '0') dia
    , ( SELECT
            u.pagetype
        FROM
            ecc_url u
        WHERE
                u.store_id = v.store_id
            AND
                u.url_md5 = v.url_md5) AS categoria

FROM
    ecc_visit_history v

WHERE
    v.`day`
        BETWEEN
            TO_DAYS(DATE(CURDATE()) - INTERVAL DAY(CURDATE()) - 1 DAY - INTERVAL 1 MONTH)
        AND
            TO_DAYS(DATE(CURDATE()) - INTERVAL DAY(CURDATE()) - 1 DAY)
    AND
    v.`timestamp`
        BETWEEN
            DATE(CURDATE()) - INTERVAL DAY(CURDATE()) - 1 DAY - INTERVAL 1 MONTH
        AND
            DATE(CURDATE()) - INTERVAL DAY(CURDATE()) - 1 DAY;