3 tables multiple joins?

[JJ Pagac]

so I am creating a custom checkin/poetry website on top of wordpress.

I need to list all the poetry from users that check in for the night.

I have a table called 'checkin' with a field called ID which is the wordpress users id. I also have a filed called date, which is a timestamp.

The poems get stored in the 'wp0k_posts' table, The user again is stored as ID. I need to grab of course the 'post_content' and 'post_title' where the 'post_type' is equal to 'um_story'.

The real difficult part is that wordpress stores the users first name and last name in a separate table called 'wp0k_usermeta'. user_id is equal to wp0k_users.ID. the store the values like so filed "first_name" = "Jim", "last_name" = "Harris"