what is the best query for tags and other related table

Here is my db schema and data

Code:
— Table structure for […]

Original post by Eng_A_Moktar