Finding posts with exactly set of tags per user
If you are using MySQL 5.6 or later, then the query will be reasonably efficient.  If using an older version, it is "order N*N", which is very slow for large subqueries.