SELECT ne.id, ne.name, stpc.identifier, stpc.id, stpc.identifier, stpc.name, stsc.identifier, stsc.name,
stpc.identifier, stpc.name, stprc.market, stprc.region 
FROM network_element ne
 LEFT JOIN
    snmp_manager.site_tracker_mapping stmc ON stmc.target_id = ne.id AND stmc.target_class = ne.class -- Controller
        LEFT JOIN 
    snmp_manager.site_tracker_project stpc ON stpc.identifier = stmc.project_identifier 
        LEFT JOIN 
    snmp_manager.site_tracker_site stsc ON stsc.id = stpc.site_id 
        LEFT JOIN 
    snmp_manager.site_tracker_program stprc ON stprc.id = stpc.program_id 
WHERE ne.parent_id = 281881 OR ne.id = 281881;