$ignore_sub = $ignore_cc = 1;



if(!empty($_REQUEST['section']))

 $section = $_REQUEST['section'];

else

 $section = 11;





// ожидается максимум двухуровневая структура

global $nc_core;

$sql = "SELECT Subdivision_ID FROM Subdivision WHERE Parent_Sub_ID = {$section} OR Subdivision_ID = {$section}";

$result = $nc_core->db->get_results($sql, ARRAY_A);

if($result)

{

 $subdivision_ids = array();

 foreach($result as $row)

 {

  $subdivision_ids[] = $row['Subdivision_ID']; 

 }

}

if(!empty($subdivision_ids))

{

 $str = implode(',',$subdivision_ids);

 $query_where .= " a.Subdivision_ID IN ({$str})";

}