SELECT me.net_id, me.node_id, me.node_name, me.node_type_id, sdh_mux_settings.no
de_id, sdh_mux_settings.mux_type_id, sdh_mux_settings.ip_address, sdh_mux_settin
gs.nsap, mux_types.mux_type_id, mux_types.mux_type, mux_types.description FROM n
odes me LEFT JOIN sdh_mux_settings sdh_mux_settings ON ( sdh_mux_settings.node_i
d = me.node_id ) LEFT JOIN mux_types mux_types ON ( mux_types.mux_type_id = sdh_
mux_settings.mux_type_id ) ORDER BY sdh_mux_settings.node_id:
SELECT me.node_id, me.mux_type_id, me.ip_address, me.nsap FROM sdh_mux_settings
me WHERE ( me.node_id = ? ): '2'
SELECT me.node_id, me.mux_type_id, me.ip_address, me.nsap FROM sdh_mux_settings
me WHERE ( me.node_id = ? ): '3'
SELECT me.node_id, me.mux_type_id, me.ip_address, me.nsap FROM sdh_mux_settings
me WHERE ( me.node_id = ? ): '4'
SELECT me.node_id, me.mux_type_id, me.ip_address, me.nsap FROM sdh_mux_settings
me WHERE ( me.node_id = ? ): '5'
SELECT me.node_id, me.mux_type_id, me.ip_address, me.nsap FROM sdh_mux_settings
me WHERE ( me.node_id = ? ): '6'
SELECT me.node_id, me.mux_type_id, me.ip_address, me.nsap FROM sdh_mux_settings
me WHERE ( me.node_id = ? ): '7'
SELECT me.node_id, me.mux_type_id, me.ip_address, me.nsap FROM sdh_mux_settings
me WHERE ( me.node_id = ? ): '8'