And you think i know a how load more? lol...
I'm still learning to ya know... ;) I look at examples and go from there.
Maybe an easy approach would be to query the values, then loop over them excluding the unwanted matches, rather then pulling hair over a possibly complex query..
Ok so you select some additional rows that don't match, but it's easier to skip a few items in a loop then to write complex queries wouldn't you agree?
The issue writing the query is that post tags and categories are basically one and the same, except they have a different taxonomy name, but to select based on tag and category requires at a minimum a sub query, which is not always the easiest thing (especially for those of us that are still picking it up, lol).
Of course, (without me testing) it could be as simple as adding ...
AND terms.term_id = X
where X would be a tag ID...
Not sure that would be it though.. have this nagging feeling a sub-query of some kind would be required (i could be over thinking it though).
It may also be of benefit to post this up on the hackers mailing list, if anyone can help with complex queries/questions, it's those guys (they know who they are)... :)
Sorry for the late response, last reply was posted just before going to sleep, hence the delay.. ;)