| SQL Id | SQL Text |
|---|
| 168vc2m26j64h | Select Contenttype,
Decode(Contenttype,
1,
'咨询',
2,
'投诉',
3,
'建议',
4,
'救援',
5,
'报料',
6,
'举报',
7,
'调度指令',
8,
'突发性交通事件',
9,
'计划性交通事件',
10,
'内部通知',
11,
'外部公告') As Contenttypename,
Contenttitle,
a.Contenttitlename,
Count(1) Alertgroupno
From (Select Contenttype, Contenttitle, t.Contentid, t.Userid
From Alert t
Where t.Userid = '768'
And t.Alerttime <= Sysdate
And t.Flags In (0, 2)
Group By t.Contenttype, t.Contenttitle, t.Userid, t.Contentid)
Left Join Alertcontenttitle a
On Contenttitle = a.Contenttitleid
Group By Contenttype, Contenttitle, a.Contenttitlename Order By Contenttype |
| 18tv6uua2pk4u | Select T.LISTNO, T.VEHPLATE,
C.DEVICENAME,
A.AREANAME,
B.ROADNAME,
D.LANENAME,
To_Char(T.OPTIME, 'yyyy-mm-dd HH24:mi:ss') OPTIME,
E.DIRECTIONNAME,
C.MILEPOST,
T.VEHSPEED
From (Select T.LISTNO, T.DEVICEID,
T.VEHPLATE,
T.DIRECTIONNO,
T.LANENO,
T.OPTIME,
T.VEHSPEED
From CAPTURELIST T
Where LISTNO In
(Select * From (Select LISTNO From VEHPLATEBLACKMAIN Where STATUSCODE='3' And LISTNO Is Not Null And OPTIME Is Not Null And VEHPLATE In (Select VEHPLATE From EMPLATTENTION Where EMPLCODE='e7f4c6ae-fa3b-4359-bc16-05f85fc7843c' Union Select VEHPLATE From COMATTENTION Where COMPANYID='23') And OPTIME>=To_Date('2013-09-16 13:20:07', 'yyyy-mm-dd hh24:mi:ss') Order By OPTIME Desc) Where rownum<=10)) T,
AREA A,
ROADBASE B,
DEVICE C,
LANECODE D,
(select * from ROADDIRECTION ss where ss.directiontype=2 ) E
Where T.DEVICEID = C.DEVICEID
And A.AREANO = B.AREANO
And B.ROADNO = C.ROADNO
And T.LANENO = D.LANENO(+)
And C.DIRECTIONNO = E.DIRECTIONCODE(+)
And C.ROADNO = E.ROADNO(+)
Order By T.OPTIME Desc |
| 3sa2dd8a6bcj8 | select * from Device where DeviceID = (select DeviceID from CaptureList where ListNo ='DA7CE95C-3760-4BE6-881D-A0F99F0EFDA7') |
| b3tu17s4g0212 | ** SQL Text Not Available ** |
| bqd0hjuhdryab | select * from Device where DeviceID = (select DeviceID from CaptureList where ListNo ='8E532350-8565-472c-8EC5-0175BF486581') |
| fk74sca79bshx | Select Contenttype,
Decode(Contenttype,
1,
'咨询',
2,
'投诉',
3,
'建议',
4,
'救援',
5,
'报料',
6,
'举报',
7,
'调度指令',
8,
'突发性交通事件',
9,
'计划性交通事件',
10,
'内部通知',
11,
'外部公告') As Contenttypename,
Contenttitle,
a.Contenttitlename,
Count(1) Alertgroupno
From (Select Contenttype, Contenttitle, t.Contentid, t.Userid
From Alert t
Where t.Userid = 'f7d2e7e3-a857-4e2f-8875-75744daf0109'
And t.Alerttime <= Sysdate
And t.Flags In (0, 2)
Group By t.Contenttype, t.Contenttitle, t.Userid, t.Contentid)
Left Join Alertcontenttitle a
On Contenttitle = a.Contenttitleid
Group By Contenttype, Contenttitle, a.Contenttitlename Order By Contenttype |
| fu62y7yg0v9gp | Select T.LISTNO, T.VEHPLATE,
C.DEVICENAME,
A.AREANAME,
B.ROADNAME,
D.LANENAME,
To_Char(T.OPTIME, 'yyyy-mm-dd HH24:mi:ss') OPTIME,
E.DIRECTIONNAME,
C.MILEPOST,
T.VEHSPEED
From (Select T.LISTNO, T.DEVICEID,
T.VEHPLATE,
T.DIRECTIONNO,
T.LANENO,
T.OPTIME,
T.VEHSPEED
From CAPTURELIST T
Where LISTNO In
(Select * From (Select LISTNO From VEHPLATEBLACKMAIN Where STATUSCODE='3' And LISTNO Is Not Null And OPTIME Is Not Null And VEHPLATE In (Select VEHPLATE From EMPLATTENTION Where EMPLCODE='1b14eadb-f924-4994-b529-acb5424e330b' Union Select VEHPLATE From COMATTENTION Where COMPANYID='121') And OPTIME>=To_Date('2013-09-16 14:15:07', 'yyyy-mm-dd hh24:mi:ss') Order By OPTIME Desc) Where rownum<=10)) T,
AREA A,
ROADBASE B,
DEVICE C,
LANECODE D,
(select * from ROADDIRECTION ss where ss.directiontype=2 ) E
Where T.DEVICEID = C.DEVICEID
And A.AREANO = B.AREANO
And B.ROADNO = C.ROADNO
And T.LANENO = D.LANENO(+)
And C.DIRECTIONNO = E.DIRECTIONCODE(+)
And C.ROADNO = E.ROADNO(+)
Order By T.OPTIME Desc |
| gkv61pqza3c68 | ** SQL Text Not Available ** |