$sql="
select *
from
(
  select orig.lac as lac, orig.cellid as cellid, dest.lac as targetlac, dest.cellid as targetcellid
  from
  (
    select d_dir.cellref, d_dir.targetcellref, d_dir.omc as omc
    from
    (select * from cells_adj where date_='$date' and omc=$omc) as d_dir
    left outer join
    (select * from cells_adj where date_='$date' and omc=$omc) as b_dir
    on d_dir.cellref=b_dir.targetcellref and d_dir.targetcellref=b_dir.cellref
    where b_dir.cellref is null
  ) as one_way, 
  (select * from cells where date_='$date' and omc=$omc) as orig, 
  (select * from cells where date_='$date' and omc=$omc) as dest
  where one_way.cellref=orig.cellref and one_way.omc=orig.omc and 
  one_way.targetcellref=dest.cellref and orig.omc=dest.omc and
  orig.lac>=$lac_begin and orig.lac<=$lac_end
) as one_ways
group by lac, cellid, targetlac, targetcellid
order by targetlac, targetcellid, lac, cellid
";

/*Поиск направлений (linkset), где идет стабильное превышение нагрузки над порогом в 250 мЭрл */
$sql_get_ss7= 
"select sel.*, f.f_count
from
( 
  select ne, lsname, avg( bh_ls_avg) as bh_ls_avg, max( bh_ls_max) as bh_ls_max, count(report_day) as err_count
  from
  (
    select ne, lsname, avg(bh_max) as bh_ls_avg, max( bh_max) as bh_ls_max, report_day
    from msc_ss7 
    where bh_max > 0 and $where_day
    group by ne, lsname, report_day
    having avg(bh_max) > 250 and avg(bh_max)<1000
  ) sel

  group by ne, lsname
) sel

right join

(
  select ne, lsname,  count(report_day) as f_count
  from
  (
    select ne, lsname, report_day
    from msc_ss7
    where bh_max > 0 and $where_day
    group by ne, lsname, report_day
  ) sel

group by ne, lsname
) f

using( ne, lsname)
where err_count*1.0/f_count >= .5
order by ne, lsname";

$sql="select date_, lac, cellid, trx_number,
tpr_timing_advance_1*100/sum_all as perc_1, tpr_timing_advance_2*100/sum_all  as perc_2, 
tpr_timing_advance_3*100/sum_all as perc_3, tpr_timing_advance_4*100/sum_all as perc_4, 
tpr_timing_advance_5*100/sum_all as perc_5, tpr_timing_advance_6*100/sum_all as perc_6, 
tpr_timing_advance_7*100/sum_all as perc_7, tpr_timing_advance_8*100/sum_all as perc_8, 
tpr_timing_advance_9*100/sum_all as perc_9, tpr_timing_advance_10*100/sum_all as perc_10, 
par_meas_stat_ta_0, par_meas_stat_ta_1, par_meas_stat_ta_2, par_meas_stat_ta_3, 
par_meas_stat_ta_4, par_meas_stat_ta_5, par_meas_stat_ta_6, par_meas_stat_ta_7, 
par_meas_stat_ta_8, par_meas_stat_ta_9, par_meas_stat_ta_10,

(tpr_timing_advance_1*(par_meas_stat_ta_1+par_meas_stat_ta_0)/2 + 
tpr_timing_advance_2*(par_meas_stat_ta_2+par_meas_stat_ta_1)/2 + 
tpr_timing_advance_3*(par_meas_stat_ta_3+par_meas_stat_ta_2)/2 + 
tpr_timing_advance_4*(par_meas_stat_ta_4+par_meas_stat_ta_3)/2 + 
tpr_timing_advance_5*(par_meas_stat_ta_5+par_meas_stat_ta_4)/2 + 
tpr_timing_advance_6*(par_meas_stat_ta_6+par_meas_stat_ta_5)/2 + 
tpr_timing_advance_7*(par_meas_stat_ta_7+par_meas_stat_ta_6)/2 + 
tpr_timing_advance_8*(par_meas_stat_ta_8+par_meas_stat_ta_7)/2 + 
tpr_timing_advance_9*(par_meas_stat_ta_9+par_meas_stat_ta_8)/2 + 
tpr_timing_advance_10*(par_meas_stat_ta_10+par_meas_stat_ta_9)/2 )/sum_all as avg_ta

from
(
  select * 
  from
  (
    select date_, lac, cellid, trx_number, sum_all, 
    tpr_timing_advance_1, tpr_timing_advance_2, tpr_timing_advance_3, tpr_timing_advance_4, 
    tpr_timing_advance_5, tpr_timing_advance_6, tpr_timing_advance_7, tpr_timing_advance_8,
    tpr_timing_advance_9, tpr_timing_advance_10,
    par_meas_stat_ta_0, par_meas_stat_ta_1, par_meas_stat_ta_2, par_meas_stat_ta_3, 
    par_meas_stat_ta_4, par_meas_stat_ta_5, par_meas_stat_ta_6, par_meas_stat_ta_7, 
    par_meas_stat_ta_8, par_meas_stat_ta_9, par_meas_stat_ta_10
    from ta_distr 
    where $where_date and lac>=$lac_begin and lac<=$lac_end

    union

    select date_, lac, cellid, 0 as trx_number, sum(sum_all), sum(tpr_timing_advance_1), 
    sum(tpr_timing_advance_2), sum(tpr_timing_advance_3), sum(tpr_timing_advance_4), 
    sum(tpr_timing_advance_5), sum(tpr_timing_advance_6), sum(tpr_timing_advance_7), 
    sum(tpr_timing_advance_8), sum(tpr_timing_advance_9), sum(tpr_timing_advance_10), 
    avg(par_meas_stat_ta_0), avg(par_meas_stat_ta_1), avg(par_meas_stat_ta_2), 
    avg(par_meas_stat_ta_3), avg(par_meas_stat_ta_4), avg(par_meas_stat_ta_5), 
    avg(par_meas_stat_ta_6), avg(par_meas_stat_ta_7), avg(par_meas_stat_ta_8), 
    avg(par_meas_stat_ta_9), avg(par_meas_stat_ta_10)
    from ta_distr
    where $where_date and lac>=$lac_begin and lac<=$lac_end
    
    group by date_, lac, cellid
  ) ta_summared
  where sum_all>0 ) as ta_final
order by date_, lac, cellid, trx_number
";