Using SQL Query for Count

I’m trying to use the option SQL Query for Count due to a large query timing out. I added to that input box a simple query like the following, which removed all the related fields I am pulling in my main SQL Query:

SELECT id
FROM wp_posts AS locations
WHERE  %%WHERE%% locations.post_type = 'location'

However, when I run the report, it only shows 25 total results. Should I be querying count(*) or something else in order for it to return a total count to be used? Could you give me an example query to use for SQL Query for Count?

Thanks!
Carl

• This topic was modified 4 years ago by cnasal.