select a.id,a.catid,a.title,a.url,c.name as floor_name,d.name as lcspfl_name
from `dr_1_news` a
left join `dr_1_news_category_data` b
on a.catid = b.catid
left join `dr_linkage_data_3` c
on b.floor = c.id
left join `dr_linkage_data_4` d
on b.lcspfl = d.id
where c.id = 10;