select cdc_comprofiler.cb_stimme AS Stimme, cdc_comprofiler.firstname AS Vorname, cdc_comprofiler.lastname AS Name, cdc_comprofiler.cb_phone_privat AS TelefonPrivat, cdc_comprofiler.cb_phone_job AS TelefonJob, cdc_comprofiler.cb_strasse AS Strasse, cdc_comprofiler.cb_plz AS PLZ, cdc_comprofiler.cb_ort AS Ort, cdc_comprofiler.cb_mobilephone AS TelefonMobil, cdc_users.email AS EMail, cdc_comprofiler.cb_birthday AS Geburtstag from (cdc_comprofiler join cdc_users) where cdc_comprofiler.id = cdc_users.id and cdc_users.username not like 'adm_%' and cdc_users.username not like 'Test-User%' and cdc_comprofiler.lastname is not null;