contact_id | contact_name | contact_email
---------- | ------------ | ------------------
1          | Deepak       | deepak@yopmail.com
---------- | ------------ | ------------------
2          | Shivam       | shivam@yopmail.com

id | contact_id | contact_phone
---| ---------- | ------------
1  | 1          | 123456789
---| ---------- | ------------
2  | 1          | 789456123
---| ---------- | ------------
3  | 2          | 456123654
---| ---------- | ------------
4  | 2          | 698521473

id | contact_id | user_id
---| ---------- | --------
1  | 1          | 22201
---| ---------- | --------
2  | 1          | 22202
---| ---------- | --------
3  | 2          | 22201

contact_id | contact_name | contact_email      | contact_phone | deleted
---------- | ------------ | ------------------ | ------------- | -------
1          | Deepak       | deepak@yopmail.com | 123456789     | 1
---------- | ------------ | ------------------ | ------------- | -------
1          | Deepak       | deepak@yopmail.com | 789456123     | 1
---------- | ------------ | ------------------ | ------------- | -------
2          | Shivam       | shivam@yopmail.com | 456123654     | 1
---------- | ------------ | ------------------ | ------------- | -------
2          | Shivam       | shivam@yopmail.com | 698521473     | 1

contact_id | contact_name | contact_email      | contact_phone | deleted
---------- | ------------ | ------------------ | ------------- | -------
1          | Deepak       | deepak@yopmail.com | 123456789     | 1
---------- | ------------ | ------------------ | ------------- | -------
1          | Deepak       | deepak@yopmail.com | 789456123     | 1
---------- | ------------ | ------------------ | ------------- | -------
2          | Shivam       | shivam@yopmail.com | 456123654     | 0
---------- | ------------ | ------------------ | ------------- | -------
2          | Shivam       | shivam@yopmail.com | 698521473     | 0

SELECT tb_contacts.contact_id, tb_contacts.contact_name, tb_contacts.contact_email, tb_numbers.contact_phone from tb_contacts join tb_numbers on tb_contacts.contact_id = tb_numbers.contact_id left join tb_deleted on tb_contacts.contact_id = tb_deleted.contact_id;