This can be a good starting point, I take from examples from this forum and added something on my own ...
SELECT `cli`.`account_id`, `cli`.`parent_id`, `cli`.`cname`, `cli`.`pname`, `dom`.`name`, `dom`.`status`, `sub`.`locked`, `sub`.`synchronized`, `tpl`.`name`
FROM `clients` `cli`
INNER JOIN...