SELECT usr_id, first_name.usd_value as first_name, last_name.usd_value as last_name,, referer:
https://seite.de/adm_program/modules/me ... ssages.php
rol_mail_this_role, rol_id, mem_begin, mem_end, referer:
https://seite.de/adm_program/modules/me ... ssages.php
FROM adm_members, referer:
https://seite.de/adm_program/modules/me ... ssages.php
INNER JOIN adm_roles, referer:
https://seite.de/adm_program/modules/me ... ssages.php
ON rol_id = mem_rol_id, referer:
https://seite.de/adm_program/modules/me ... ssages.php
INNER JOIN adm_users, referer:
https://seite.de/adm_program/modules/me ... ssages.php
ON usr_id = mem_usr_id, referer:
https://seite.de/adm_program/modules/me ... ssages.php
INNER JOIN adm_user_data as email, referer:
https://seite.de/adm_program/modules/me ... ssages.php
ON email.usd_usr_id = usr_id, referer:
https://seite.de/adm_program/modules/me ... ssages.php
AND LENGTH(email.usd_value) > 0, referer:
https://seite.de/adm_program/modules/me ... ssages.php
INNER JOIN adm_user_fields as field, referer:
https://seite.de/adm_program/modules/me ... ssages.php
ON field.usf_id = email.usd_usf_id, referer:
https://seite.de/adm_program/modules/me ... ssages.php
AND field.usf_type = 'EMAIL', referer:
https://seite.de/adm_program/modules/me ... ssages.php
LEFT JOIN adm_user_data as last_name, referer:
https://seite.de/adm_program/modules/me ... ssages.php
ON last_name.usd_usr_id = usr_id, referer:
https://seite.de/adm_program/modules/me ... ssages.php
AND last_name.usd_usf_id = 7, referer:
https://seite.de/adm_program/modules/me ... ssages.php
LEFT JOIN adm_user_data as first_name, referer:
https://seite.de/adm_program/modules/me ... ssages.php
ON first_name.usd_usr_id = usr_id, referer:
https://seite.de/adm_program/modules/me ... ssages.php
AND first_name.usd_usf_id = 8, referer:
https://seite.de/adm_program/modules/me ... ssages.php
WHERE rol_id in (), referer:
https://seite.de/adm_program/modules/me ... ssages.php
AND usr_id <> 63, referer:
https://seite.de/adm_program/modules/me ... ssages.php
AND usr_valid = 1, referer:
https://seite.de/adm_program/modules/me ... ssages.php
GROUP BY usr_id, first_name.usd_value, last_name.usd_value, email.usd_value, rol_mail_this_role, rol_id, referer:
https://seite.de/adm_program/modules/me ... ssages.php
ORDER BY last_name, first_name, rol_mail_this_role DESC, referer:
https://seite.de/adm_program/modules/me ... ssages.php
42000: 1064, referer:
https://seite.de/adm_program/modules/me ... ssages.php
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), referer:
https://seite.de/adm_program/modules/me ... ssages.php
AND usr_id <> 63, referer:
https://seite.de/adm_program/modules/me ... ssages.php
AND usr_valid =' at line 7, referer:
https://seite.de/adm_program/modules/me ... ssages.php