select class_key, node_id, site_node.url(node_id) from dotlrn_classes order by class_key