Rainwave SQL / Users

rw_users.sql

select
    user_id,
    user_type,
    username,
    timestamp with time zone 'epoch' + user_regdate * interval '1 second' as registration_date,
    timestamp with time zone 'epoch' + user_lastvisit * interval '1 second' as last_visit,
    user_posts,
    radio_inactive
from
    phpbb_users
where
    user_type in (0, 3);