**Query for full listing of all parent and child committees**

	SELECT com.state_id, par.active par_active, par.parent, com.committeetype_id, com.active com_active, com.committee_id, com.child committee, com.url
	FROM
		(SELECT com.active, com.committee_id, com.state_id, com.parent_id, com.name child, com.committeetype_id, com.url
			 FROM committee com ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.name) com
	LEFT JOIN
		(SELECT com.active, com.committee_id, com.state_id, com.parent_id, com.name parent, com.committeetype_id, com.url
			 FROM committee com ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.name) par
	ON (com.parent_id = par.committee_id)
	ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.child, par.parent ;