ZendFramework 2 - Construct SQL with subquery
A scenario here:
A Q & A website that allow user to ask question and put several tags to that question.
Now want to get those tags related to a tag with ID 100, the query could be
Now want to construct this query in Zend Frameword 2
In your model table, says ./module/Application/src/Application/Model/TagTable.php
The performance may be sux, in order to solve this, just index