SELECT `a`.*, `b`.`file_name`, `b`.`file_location`
FROM `company` `a`
LEFT JOIN `company__logo` `b` ON `b`.`id` = `a`.`main_logo_id`
WHERE `a`.`status` =0
AND `a`.`is_delete` =0
AND `a`.`id` = 1
ORDER BY `a`.`name` ASC