select jobs_companies.title as company_title, `location`, `jobs_companies`.`id` as `company_id`, `jobs_companies`.`slug` as `company_slug`, `logo`, `about`, `jobs`.*from `jobs` leftjoin `jobs_companies` on `jobs_companies`.`id` = `jobs`.`company_id` where `jobs_companies`.`id` =1101