I have the following simple query:
ORDER BY oxadmain.name ASC
Now I would like to add a COUNT(*) function with a WHERE clause to find out how many records of A SPECIFIC KIND are returned. I’ve tried a couple of ways but they all return a syntax error.
What would be the right syntax for this?
Thank you for your attention