SELECT
`tiger_site_registry`.`id` as uid,
`tiger_site_registry`.`lft`,
`tiger_site_registry`.`rgt`,
`tiger_site_registry`.`site_id` as site_id,
`tiger_site_registry`.`root_id`,
`dt_sites`.`id`,
`dt_sites`.`url` as url
FROM
`dt_sites`
left Join `tiger_site_registry` ON `tiger_site_registry`.`site_id` = `dt_sites`.`id`
where `tiger_site_registry`.`root_id` = `tiger_site_registry`.`id` and `dt_sites`.`url` like '%singita.siyabona.com'