Children sexually exploited by adopters

$sql = "SELECT n.nid FROM {node} n INNER JOIN {content_type_case} ac ON ac.nid = n.nid AND ac.vid = n.vid INNER JOIN {content_field_type_of_abuse} t ON (t.nid = n.nid and t.vid = n.vid) WHERE field_type_of_abuse_value = 'Sexual exploitation' AND field_child_placement_type_value = 'Adoption' ORDER BY n.title ASC";

$result = pager_query(db_rewrite_sql($sql), 200, 0);

while ($data = db_fetch_object($result)) {

$blog_node = node_load($data->nid);

print node_view($blog_node, TRUE);

}

print theme('pager', NULL, 200);

?>

>