-- GET USERNAME, NIM/NIP, AND NAME by USERNAME, NIM/NIP or NAME
SELECT
    USERID,
    u.NAME,
    u2.USERNAME
FROM
    USERS u
JOIN USERLOGINMAPPING u2
        USING(USERID)
WHERE
    NAME LIKE :SEARCH
    OR u.USERNAME LIKE :SEARCH
    OR u2.USERNAME = :SEARCH;

-- GET MODULEFILE by pageId
SELECT
    a2.URL,
    MODULEFILE
FROM
    PAGES p
JOIN PAGESORT p2
        USING(PAGEID)
JOIN MODULES m
        USING(MODULEID)
JOIN APPLICATIONPAGE a
        USING(PAGEID)
JOIN APPLICATIONS a2
        USING(APPLICATIONID)
WHERE
    PAGEID = :PAGEID;