【資料名稱】：PMRG設置不合理查詢

【資料作者】：2012

【資料日期】：20120615

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡介】：

select
substr(o3.name,1,2) city,
o3.name bsc,
c.la_id_lac lac,
c.cell_id ci,
c.segment_id seg_id,
c.segment_name seg_name,
a.ho_margin_pbgt 正向pmrg,
b.ho_margin_pbgt 反向pmrg,
a.adj_cell_lac adj_lac,
a.adj_cell_ci adj_ci,
ao3.name adj_bsc,
c2.segment_id adj_seg,
c2.segment_name adj_segname
from
c_adjacent_cell a,c_bts c,objects o1,objects o2,objects o3,c_bts c2,objects ao1,objects ao2,objects ao3,c_adjacent_cell b,c_bts bc2,objects bo1,objects bo2,objects bo3
where
a.bts_int_id=c.int_id
and c.int_id=o1.int_id
and o1.parent_int_id=o2.int_id
and o2.parent_int_id=o3.int_id
and c2.int_id=ao1.int_id
and ao1.parent_int_id=ao2.int_id
and ao2.parent_int_id=ao3.int_id
and a.adj_cell_ci=c2.cell_id
and a.adj_cell_lac=c2.la_id_lac
and c2.MASTER_BTS=1
and bc2.MASTER_BTS=1
and a.conf_name='<ACTUAL>'
and c.conf_name='<ACTUAL>'
and c2.conf_name='<ACTUAL>'
and o3.name like 'LY%'
and o3.name not like 'BSC 0'
and o3.name not like 'BSC0'
and ao3.name not like 'BSC 0'
and ao3.name not like 'BSC0'
and b.bts_int_id=bc2.int_id
and bc2.int_id=bo1.int_id
and bo1.parent_int_id=bo2.int_id
and bo2.parent_int_id=bo3.int_id
and b.conf_name='<ACTUAL>'
and bc2.conf_name='<ACTUAL>'
and a.adj_cell_lac=bc2.la_id_lac
and a.adj_cell_ci=bc2.cell_id
and c.la_id_lac=b.adj_cell_lac
and c.cell_id=b.adj_cell_ci
and (a.ho_margin_pbgt+b.ho_margin_pbgt)<6
order by
o3.name,c.la_id_lac,c.cell_id,ao3.name,a.adj_cell_ci;