SELECT A.message_inbox_id,A.subject,A.content,
        A.receipient_id, B.fullname AS receipient_name, A.sender_id,
        C.fullname AS sender_name, A.flg_starred, A.flg_read,
        A.flg_delete, A.create_datetime, A.create_user_id, A.update_datetime,
        A.update_user_id, A.version, A.flg_cc,A.original_to, A.original_cc
    FROM m_message_inbox A
    INNER JOIN t_user B ON A.receipient_id = B.user_id
    INNER JOIN t_user C ON A.sender_id = C.user_id
    WHERE true
    AND UPPER(B.fullname) = '%UPPER(keyword)%' OR UPPER(C.fullname) = '%UPPER(keyword)%'
    AND UPPER(A.subject) = '%UPPER(keyword)%'
    AND A.create_datetime BETWEEN 'keyword' AND 'keyword';