How to get listings created by a specific user using MySQL? Which tables do I use?

[Ant]

I am trying to use MySQL to check whether any listings exist for a particular user, but I am having trouble finding the relevant tables/information. I know that _jreviews_content contains the actual listings with listing ids, but I don’t know how to match this to the user. If someone could help me out here I’d really appreciate it.

 

Miscellaneous info

Theoretically I'm aware that the email info in the table could be used to match the listing to a user, but if the listing is created by the administrator the email information is missing (I've also verified that a users listing can be obtained even though there is no email (via custom where-Listing.created_by XYZ)).

 

[Kristian]

This section is only visible with a valid subscription. If you have a valid subscription, please login.

[Ant]

This section is only visible with a valid subscription. If you have a valid subscription, please login.