select id,home from sys_users where home like "%example.com%";
+----+--------------------------------+
| id | home |
+----+--------------------------------+
| 15 | C:\inetpub\vhosts\example.com |
+----+--------------------------------+
select www_root from hosting where sys_user_id=15;
+----------------------------------------+
| www_root |
+----------------------------------------+
| C:\inetpub\vhosts\example.com\httpdocs |
+----------------------------------------+