Hi there,

You can refer them here '#__social_fields_data' on 'address' datakey. You will need to check if there are data inside 'data' columns as well.

Please give it a try and see how it goes.

Yeah, I was there already, but the data are all but uniform...
I see usernames, countries, cities, empty cells, first names, last names...
And I don't see the Address data key... Is there an SQL code I can run to show in how many countries our users are?

Right now I can only count those who geolocate themselves... not those who chose their country manually.

Hi there,

You should be able to see them as you can see here https://take.ms/hirh0. Can you provide with your Database access so that we can take look on those data?

Found it. Thanks!

Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding.