Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Query Help

November 10, 2008 9:45am

Subscribe [1]

#1 / Nov 10, 2008 9:45am
simplyee
104 posts
Hi all. I have this query to display entries from authors in the search results, and it works, but I would like to limit to a certain weblog id and just can’t seem to get it right.
```
{exp:query sql="SELECT member_id, total_entries FROM exp_members WHERE group_id='1' ORDER BY total_entries DESC LIMIT 12"}
<a href="http://www.mysite.com/?ACT=19&result_path=search/results&mbr={member_id}">_Find more posts by this author_</a>
{/exp:query}
```
How to limit it to just showing the entries from one weblog?