Wordpress SQL with users and usermeta

wodpress-sql-example-user-usermeta

SELECT wp_users.*, meta_lastname.meta_value as last_name, meta_firstname.meta_value as first_name, meta_workplace.meta_value as workplace, meta_desc.meta_value as description
FROM wp_users
INNER JOIN wp_usermeta AS meta_lastname ON (wp_users.ID = meta_lastname.user_id) AND (meta_lastname.meta_key = 'last_name')
INNER JOIN wp_usermeta AS meta_firstname ON (wp_users.ID = meta_firstname.user_id) AND (meta_firstname.meta_key = 'first_name')
INNER JOIN wp_usermeta AS meta_ulevel ON (wp_users.ID = meta_ulevel.user_id) AND (meta_ulevel.meta_key = 'wp_user_level')
INNER JOIN wp_usermeta AS meta_workplace ON (wp_users.ID = meta_workplace.user_id) AND (meta_workplace.meta_key = 'workplace')
INNER JOIN wp_usermeta AS meta_desc ON (wp_users.ID = meta_desc.user_id) AND (meta_desc.meta_key = 'description')
WHERE
    CAST(meta_ulevel.meta_value AS CHAR) != '0'
    AND CAST(meta_workplace.meta_value AS CHAR) LIKE '%{$workplace}%'
    AND wp_users.ID NOT IN ({$excluded})
ORDER BY last_name ASC, first_name ASC;