I am development a module that show a listing of node. Currently, the node of ap specific content type has multiple CCK term references to a specify vocabulary, i.e. v1, v2, v3
I want to list of nodes if they matched a specify term conditions, e.g. v1=tid1 v1=tid1, v2=tid2 v1=tid1, v2=tid2, v3=tid3 v1=tid1, v3=tid3 ... I am using subquery to query the above condition, but I am not sure if any better method to speed up my query? Any suggestion for my usage? Thanks.
