SELECT `cd`.*, `c`.`company_name`, `c`.`company_id`, `c`.`gm_approval_status`, `c`.`submit_status`, `c`.`status`
FROM `gm_company_domains` as `cd`
LEFT JOIN `gm_companies` as `c` ON `c`.`company_id` = `cd`.`company_id`
WHERE `cd`.`domain_name` = 'webpulsebharat.com'
AND `cd`.`is_active` = 1
 LIMIT 1test