Inner-join for 3 tables

let’s assume we have three table which can be used for simple website with Tags.

• Fist table is for Posts.
• Second for Tags
• Third for Tags & Post relation

fist table “videogame”

id | title | reg_date | Content | —— | —— | —— | —–– | 1 | BioShock Infinite | 2016-08-08 | ….

“tags” table

id | name | — | ——— | 1 | yennefer | 2 | elizabeth |

“tags_meta” table

post_id | tag_id | —– | —– | 1 | 2 |

SELECT videogame.id,
    videogame.title,
    videogame.reg_date,
    tags.name,
    tags_meta.post_id
FROM tags_meta
INNER JOIN videogame ON videogame.id = tags_meta.post_id
INNER JOIN tags ON tags.id = tags_meta.tag_id
WHERE tags.name = "elizabeth"
ORDER BY videogame.reg_date

this code can return all posts which related to that tag “#elizabeth”