Display the children of the current page

The following snippet will give you all children of the current page and will include the title and thumbnail.

get_results("SELECT *    FROM $wpdb->posts WHERE post_parent = ".$post->ID."    AND post_type = 'page' ORDER BY menu_order", 'OBJECT');    ?>


  ID, 'thumbnail'); ?>
 post_title; ?>