Get list of user with them email

[pippuccio76]

Hi how can i extract all user with them email ? Ishould do a query with a join of auth_identities and where auth_identities='email_password' ?

[pippuccio76]

I foud that iif i join with another table :

      $data['lista']= $users_model->select('
                                                users.*,
                                                auth_groups_users.group,
                                                clienti.*

                                             ')
                                    ->join('auth_groups_users','auth_groups_users.user_id=users.id')
                                    ->join('clienti','clienti.id_users=users.id','eft')
                                    ->where('auth_groups_users.group','cliente')
                                    ->findAll();

i lost email , why ?

[neznaika0]

'eft'?

[pippuccio76]

sorry but with left is the same

if i remove clienti.* from select and join magically email appears

if i dd($users_model->getLastQuery()) i don't see email in mysql result ...

[neznaika0]

I looked at the models here and I don't see the email field. Maybe it doesn't exist by default?

[pippuccio76]

i try to do this :

      $data['lista']= $users_model->select('
                                                users.*,
                                                auth_groups_users.group,
                                                clienti.* ,
                                                auth_identities.secret as email
                                             ')
                                    ->join('auth_groups_users','auth_groups_users.user_id=users.id')
                                    ->join('clienti','clienti.id_users=users.id')
                                    ->join('auth_identities','auth_identities.user_id=users.id')
                                    ->where('auth_groups_users.group','cliente')
                                    ->where('auth_identities.type','email_password')
                                    ->findAll();

but i dont see email , if i dd the query and past on my db it show email i don't understand....