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
ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.child, par.parent ;
FROM
(SELECT com.active, com.committee_id, com.state_id, com.parent_id, com.name child, com.committeetype_id, com.url
LEFT JOIN
FROM committee com ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.name) com
(SELECT com.active, com.committee_id, com.state_id, com.parent_id, com.name parent, com.committeetype_id, com.url
ON (com.parent_id = par.committee_id)
FROM committee com ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.name) par
ORDER BY com.active DESC, com.state_id, com.committeetype_id, com.child, par.parent ;
