Repetição LEFT JOIN

Galera tenho a seguinte query, estou fazendo o left join de 4 colunas para realizar a busca em todas as tabelas ao mesmo tempo, porém os dados estao vindo duplicados:

SELECT
 sys_companies.id AS cpny_id,
 sys_companies_offers.id AS of_id,
 sys_companies_post.id AS pst_id,
 sys_companies.name AS cpny_name,

 sys_companies.email AS cpny_email,
 sys_companies.type AS cpny_type,
 sys_companies.logoUrl AS cpny_logo,
 sys_companies.description AS cpny_desc,
 sys_companies.website AS cpny_wsite,
 sys_companies.fb AS cpny_fb,
 sys_companies.twt AS cpny_twt,
 sys_companies.inst AS cpny_inst,
 sys_companies.att AS cpny_att,
 sys_companies.link AS cpny_link,

 sys_companies_address.city AS adr_city,
 sys_companies_address.state AS adr_state,
 sys_companies_address.zipcode AS adr_zip,
 sys_companies_address.address AS adr_addr,
 sys_companies_address.neigh AS adr_ngh,
 sys_companies_address.number AS adr_num,
 sys_companies_address.compl AS adr_compl,
 sys_companies_address.lat AS adr_lat,
 sys_companies_address.lon AS adr_lon,
 sys_companies_address.tel1 AS adr_tel1,
 sys_companies_address.tel2 AS adr_tel2,

 sys_companies_category.name AS catName,

 sys_companies_offers.title AS of_title,
 sys_companies_offers.brand AS of_brand,
 sys_companies_offers.description AS of_desc,
 sys_companies_offers.img_url AS of_imgu,
 sys_companies_offers.price AS of_prc,
 sys_companies_offers.link AS of_link,
 sys_companies_offers.createDate AS of_crtd,

 sys_companies_post.description AS pst_desc,
 sys_companies_post.link_video AS pst_link,
 sys_companies_post.createDate AS pst_crtd

 FROM sys_companies
 LEFT JOIN sys_companies_address ON sys_companies_address.id_company = sys_companies.id
 LEFT JOIN sys_companies_category ON sys_companies_category.id = sys_companies.id_category
 LEFT JOIN sys_companies_offers ON sys_companies_offers.id_company = sys_companies.id
 LEFT JOIN sys_companies_post ON sys_companies_post.id_company = sys_companies.id
 WHERE
 sys_companies_address.city = 'rio claro' AND sys_companies_address.state = 'sp'
 AND (MATCH (sys_companies.tag) AGAINST('arquiteto')
 OR MATCH (sys_companies.name) AGAINST('arquiteto')
 OR MATCH (sys_companies_post.description) AGAINST('arquiteto')
 OR MATCH (sys_companies_offers.title) AGAINST('arquiteto'))
 ORDER BY `sys_companies`.`type` DESC limit 0,16

	Retorno:

	imagem erro.png

	 

	retorno desejado:

	imagem desejado.png

	 

	Obrigado!

	 

	 

	Retorno da query:

	![imagem](https://forum.imasters.com.br/monthly_2017_05/erro.png.5605e00fd6e3a8b0c9f4b504d08987ad.png)

	Desejado:

	![imagem](https://forum.imasters.com.br/monthly_2017_05/desejado.png.54081e9789fe74888ee76510753678c6.png)

	 

	Gostaria de trazer as possibilidades de busca para eu gerar diferentes modos de exibições para as diferentes tabelas, para eu determinar um layout para o retorno... baseadas nos campos que estão em branco ou NULL