Filter Users with multiple taxonomies

  • I am trying to filter user listing using multiple taxonomies from the usermeta table. Here is what I have so far:

    //get the authors from the database ordered by user nicename
    $query = "SELECT $wpdb->users.ID, $wpdb->users.user_nicename FROM $wpdb->users INNER JOIN $wpdb->usermeta ON $wpdb->users.ID = $wpdb->usermeta.user_id WHERE $wpdb->usermeta.meta_key = 'css' AND $wpdb->usermeta.meta_key = 'photoshop' ORDER BY $wpdb->users.user_nicename LIMIT $offset, $limit";

    I am receiving no user results when using the above query, however, if I only use one meta_key filter, I see the desired results. How can I query using multiple taxonomies from the usermeta table?

    https://www.ads-software.com/plugins/user-list/

  • The topic ‘Filter Users with multiple taxonomies’ is closed to new replies.