SELECT `c`.`slug`, `c`.`file_path`
FROM (`comp_visual_report` b)
RIGHT JOIN `_sys_menu` a ON `b`.`page_id` = `a`.`fldid`
LEFT JOIN `_ref_visual_report` c ON `c`.`id` = `b`.`graph_id`
WHERE `b`.`companyID` =  '1'
AND `a`.`urls` =  'home'
AND `b`.`active` =  1
AND `b`.`is_delete` =  0
ORDER BY `order` ASC