Very sorry for having troubled all regarding the seemingly stupid rtfm
garnering request for help.
But in my attempt to make the question as simple and succinct as
possible, i forgot to state one EXTREMELY important chunk of information.
I can't use SQLCALCFOUNDROWS because there is a subqry
Then eliminate the subquery and SQL_CALC_FOUND_ROWS will be an option for
you again. If you would like some help refactoring your query, I
volunteer. If I can't help, I know there are several others on the list
just as capable as I (or more so).
Shawn Green
Database Administrator
Unimin