l.country INNER JOIN {content_type_category_cat} cat ON cat.field_related_page_nid = cou.nid AND cat.nid = cn.cid INNER JOIN {node} n2 ON n2.nid = cou.nid AND n2.vid = cou.vid WHERE field_child_placement_type_value LIKE "%adopt%" GROUP BY cou.nid, n2.nid, n2.title, cou.field_country_code_value ORDER BY COUNT(n.nid) DESC'; $header = array( ); $result1 = db_query($sql1); print '
'; $even = true; while ($row1 = db_fetch_object($result1)) { if($even){ print ''; }else{ print '
'; } print ' ' . $row1->country . '
|
'; if($even){ print ''; $even = false; }else{ print '
'; $even = true; } print '| Case | Receiving country | Date |
'; $sql = 'SELECT n.nid as nid, n.title as title, n2.nid as counid, n2.title as coutitle, ac.field_discovery_date_value as date FROM {node} n INNER JOIN {content_type_case} ac ON ac.nid = n.nid AND ac.vid = n.vid INNER JOIN {category_node} cn ON cn.nid = n.nid AND cn.cid = "' . $row1->counid . '" INNER JOIN {location} l ON n.vid = l.eid INNER JOIN {content_type_country_type} cou ON LOWER(cou.field_country_code_value) = l.country INNER JOIN {node} n2 ON n2.nid = cou.nid AND n2.vid = cou.vid WHERE field_child_placement_type_value LIKE "%adopt%" ORDER BY ac.field_discovery_date_value DESC'; $result = db_query($sql); while ($row = db_fetch_object($result)) { if($even){ print ''; $even = false; }else{ print '
'; $even = true; } print '| ' . $row->title . ' | ' . $row->coutitle . ' | ' . trunc_disc_date($row->date) . ' |
'; } } print '
';?>
Note: The following cases are domestic adoptions in sending countries:
The following cases are international adoptions where the abuse took place while the adoptive parents resided in the sending country: