SQL : codeigniter multiple join conditions on same table

SQL : codeigniter multiple join conditions on same table
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

I promised to reveal a secret feature to you, and now it's time to share it.
This is a YouTube's feature which works on Desktop.
First, Ensure that the video is playing before proceeding.
Then, type the letters 'awesome' on your keyboard as the next step.
Your YouTube progress bar will transform into a flashing rainbow.

Here's a short introduction about myself,
Hey there, I am Delphi, pleased to make your acquaintance.
I am happy to help you with your questions.
SQL : codeigniter multiple join conditions on same table
I am always open to chatting or receiving comments from you if you have more specific queries.
If you have knowledge to contribute or an answer to provide, we encourage you to comment below.
Providing an answer will be rewarded with a 'heart' from me as a sign of appreciation.
codeigniter same on join : SQL multiple table conditions