I am setting up a search by author section on the blog for my website. I have all the code set up correct, and people are showing up! However, not everyone is showing up. When I run the SQL Query below, I am short a couple of results. When I move a member from Group 6 to Group 1, she shows up.
Am I missing something here?
<h1 style="font-size:24px;font-weight:normal;color:#72736F;border-bottom: 1px dotted #999;">Search by Author</h1>
{exp:query sql="SELECT*
FROM exp_members
WHERE group_id = '1' OR group_id = '6'
AND total_entries != 0
AND in_authorlist = 'y'
"}
<a href="{site_url}wcrealtors_blogs/author/{member_id}" class="blogimg">
<img src="{site_url}/images/avatars/{avatar_filename}" class="imgblogauthorbar"/>
</a>
{/exp:query}
Thank you in advance for your help!