SELECT * FROM tenants WHERE tenant_domain = 'reywinindia.reywibooks.com'

SET NAMES utf8

SELECT * FROM `organization` ORDER BY organization_name

SELECT * FROM information_schema.tables WHERE table_schema = 'reywibookscom_reywinindia' AND table_name = 'branch' LIMIT 1

SELECT * FROM `branch` WHERE organization_id IN (1) ORDER BY branch_isdefault DESC, branch_name

SELECT * FROM information_schema.tables WHERE table_schema = 'reywibookscom_reywinindia' AND table_name = 'organizationsettings' LIMIT 1

SELECT setting_key, setting_value, data_type, is_protected FROM organizationsettings WHERE organization_id = 1