SELECT wp_users.ID FROM wp_users LEFT JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id WHERE meta_key LIKE 'wp_capabilities' AND meta_value LIKE '%guest%' AND DATEDIFF(CURDATE(), wp_users.user_registered) >= 14
SELECT wp_users.ID FROM wp_users LEFT JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id WHERE meta_key LIKE 'wp_capabilities' AND meta_value LIKE '%agent%' AND DATEDIFF(CURDATE(), wp_users.user_registered) >= 180
Imprint - Davos Square | Accommodation and services at the highest level

Imprint

Horae GmbH
Hechtstrasse 14
9053 Teufen, Switzerland

Tel +4171 333 6161
Fax +4171 333 6262

E-Mail
a.eppenberger@bluewin.ch

UID, VAT
CHE-224.370.919, VAT

CH ID
CH-300-4018836-4

Authorized representative
Dr. Andreas Eppenberger, CEO

Person responsible for the content
Dr. Andreas Eppenberger, CEO

Concept, design and programming

accis Systemhaus Gesellschaft für neue Medien mbH
Web www.accis.de