Mysql - Help me alter this search query involving multiple joins and conditions to get the desired r
- by sandeepan-nath
About the system -
We are following tags based search.
Tutors create packs - tag relations for tutors stored in tutors_tag_relations and those for packs stored in learning_packs_tag_relations. All tags are stored in tags table.
The system has 6 tables - tutors, Users (linked to tutor_details), learning_packs, learning_packs_tag_relations,…