I am currently moving a website from Drupal. The information I need to transfer is divided to many DB tables and connected through entity_id (That is my understanding, I have no experience in Drupal).
E.g. I have 2 MySQL tables:
users — contains
uids, passwords and emails
field_revision_field_user_profile_phone — contains phone numbers and
I believe there should be a table that matches
entity_ids, that will let me build a MySQL query to join them, but I can't find it.
How do I join those tables?