WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Don't Understand Relationship Between posts & term_relationships Tables (2 posts)

  1. travelvice
    Member
    Posted 3 years ago #

    I'm working on a custom SQL query, and I honestly don't understand how the posts table and the term_relationships table form the relationship illustrated on the ERD.

    Most every piece of custom SQL I've seen uses a LEFT JOIN between posts.ID and term_relationships.object_id -- but these fields have nothing to do with each other.

    Guess I'm just at a loss about why I'm structuring my SQL queries like this.

  2. travelvice
    Member
    Posted 3 years ago #

    Ugh - nevermind. I was misreading the numbers stored in the object_id field. I see they pair up.

    FYI:
    http://www.dagondesign.com/files/wp-2.3-db-structure-categories.png

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags