email field location in database

hsmeyers
OFFLINE
Posts: 3
Thanks: 0
Karma: 0

11 years 10 months ago #217779 by hsmeyers

email field location in database was created by hsmeyers

Hi everyone,

For my client I'm pulling some data out of the _comprofiler table in my database (all the relevant subscription fields).
Question: I don't see 'email' (primary email adress) between the rows in the _comprofiler table. So does CB pull the email adresses out of the Joomla _users table ?

Anyway, it would be great to include the email data in one single user list (.csv via SQL query) amongst all other relevant fields for my client. Can this be done?

Thanks!
H.

Please Log in or Create an account to join the conversation.

hsmeyers
OFFLINE
Posts: 3
Thanks: 0
Karma: 0

11 years 10 months ago - 11 years 10 months ago #217953 by hsmeyers

Replied by hsmeyers on topic Re: email field location in database

I started reading about SQL and learned how to join certain data from two different tables that share an identical row.
_comprofiler and _users share the id (user) so that makes it possible to link the primary email adress from _users to all the relevant entries in _comprofiler and build a new table.

The query looks like this (short version without a ton of cb_fields):

Code:

SELECT firstname, lastname, cb_mobile, jos_users.email
FROM `jos_comprofiler` JOIN `jos_users`
ON jos_comprofiler.id = jos_users.id

Last edit: 11 years 10 months ago by hsmeyers.

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon