kajori

Forum Replies Created

Viewing 1 replies (of 1 total)

  • Hi Sproutchris,

    May be this is goanna help. You have to may have to write different queries to get all the authors for the article.

    For Co-authors

    1. Firstly all the authors are saved in the term_taxonomy table (“term_taxonomy“)
    2. Where they are assigned different term_id. For eg: Term_id is 1 for author A.
    3. In the terms table (“terms), you can see that for term_id 1, author details will be there.
    4. And Finally in the ?term_relationships table, the postID, their co_author and the order in which they are saved are present. PostID is the object ID, co_author is the termID and the last coulumn will contain the order.

    So you have to take the post ID and get the termIds from the term_relationships table. Once you get the termIds, you can get the co-authors ID for the particular post.

Viewing 1 replies (of 1 total)