ExteNet Site Tracker

SELECT 
    ne.id,
    ne.name,
    ne.jde_contract_id as 'Site Tracker Revenue Product Id',
    ne.circuit_id,
    stpc.identifier as 'Site Tracker Project Identifier',
    stpc.id as 'Site Tracker Project Id',
    stpc.name as 'Site Tracker Project Name',
    stsc.identifier as 'Site Tracker Site Identifier',
    stsc.name as 'Site Tracker Site Name',
    stpc.identifier as 'Site Tracker Program Name',
    stpc.name as 'Site Tracker Program Name',
    stprc.market as 'Site Tracker Market',
    stprc.region as 'Site Tracker 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
        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;