/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT REPLACE(sys_users.home,'/home/httpd/vhosts/','') AS DOMAIN, sys_users.login,accounts.password FROM sys_users LEFT JOIN accounts ON sys_users.account_id=accounts.id ORDER BY sys_users.home ASC;