Sql query that shows all users with meta_key equals to 1

maybe this will help someone?

<?php

 $querystr = "
    SELECT wposts.*
    FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
    WHERE wposts.ID = wpostmeta.post_id
    AND wpostmeta.meta_key = 'tag'
    AND wpostmeta.meta_value = 'email'
    AND wposts.post_status = 'publish'
    AND wposts.post_type = 'post'
    AND wposts.post_date < NOW()
    ORDER BY wposts.post_date DESC
 ";

 $pageposts = $wpdb->get_results($querystr, OBJECT);

?>

or

<?php
//get all users, iterate through users, query for one post for the user, if there is a post then display posts title, author, content info
$blogusers = get_users_of_blog();
if ($blogusers) {
  foreach ($blogusers as $bloguser) {
    $args = array(
    'author' => $bloguser->user_id,
	  'showposts' => 1,
	  'caller_get_posts' => 1
    );
    $my_query = new WP_Query($args);
    if( $my_query->have_posts() ) {
      // $user = get_userdata($bloguser->user_id);
      // echo 'This is one post for author with User ID: ' . $user->ID . ' ' . $user->user_firstname . ' ' . $user->user_lastname;
      while ($my_query->have_posts()) : $my_query->the_post(); ?>
        <p><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></p>
        <small><?php the_time('F jS, Y') ?> by <?php the_author_posts_link() ?> </small><?php
        the_content();
      endwhile;
    }
  }
}
?>

Your first code suggestion is the better of the two imo. Nice one posting back your solution(s).. ??

Hello t31os_

thank you for your reply.

Well this code ( the first one ) searches posts am I right?

I know about the AND, OR stuff, it says to display wposts by it’s day where some tags are available.

But how to turn it and look the authors instead of posts?

.. and after this, it will create a new field that contains all the id’s that meet the requirements