select * from core_config_data where path like '%base_url%'; +-----------+----------+----------+--------------------------------------+-----------------------------+ | config_id | scope | scope_id | path | value | +-----------+----------+----------+--------------------------------------+-----------------------------+ | 1 | default | 0 | web/unsecure/base_url | https://example.com/ | | 2 | default | 0 | web/secure/base_url | https://example.com/ | | 5118 | websites | 6 | web/unsecure/base_url | http://example.com/nz/ | | 5130 | websites | 6 | web/secure/base_url | https://example.com/nz/ | | 5571 | default | 0 | seositemap/frontend/sitemap_base_url | /media/ | +-----------+----------+----------+--------------------------------------+-----------------------------+