Children killed within their adoptive family

$sql = "SELECT n.nid FROM {node} n

INNER JOIN {content_type_case} c ON (c.nid = n.nid AND c.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 REGEXP '^Lethal'

AND (field_child_placement_type_value = 'Adoption' OR field_child_placement_type_value = 'To be adopted')

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);

?>

>