SELECT * FROM lbtEvents WHERE EventId = '835493'--'834789'
---
SELECT s_Name, ATM1_Id, ATM2_Id, ATM3_Id FROM lbtSiteMas WHERE s_Name NOT IN
(
SELECT T0.s_Name
FROM
lbtSiteMas T0
INNER JOIN
lbtBankInput T1
ON T0.s_Name = T1.s_Name
WHERE T0.qStatus = 1 AND T0.s_Status = 1 AND T0.BankCode IN ('16', '25')
) AND qStatus = 1 AND s_Status = 1 AND BankCode IN ('16', '25')
SELECT T0.s_Name, T1.b_Head_Name, T1.b_Head_MobNo, T1.b_Head_Email
FROM
lbtSiteMas T0
INNER JOIN
lbtBankInput T1
ON T0.s_Name = T1.s_Name
WHERE T0.qStatus = 1 AND T0.s_Status = 1 AND T0.BankCode IN ('16', '25')
SELECT T0.s_Name, T1.b_Head_Name, T1.b_Head_MobNo, T1.b_Head_Email
FROM
lbtSiteMas T0
INNER JOIN
lbtBankInput T1
ON T0.ATM2_Id = T1.s_Name
WHERE T0.qStatus = 1 AND T0.s_Status = 1 AND T0.BankCode IN ('16', '25')
--Total Hdcf + KVB
SELECT COUNT(*)
FROM
lbtSiteMas
WHERE BankCode IN ('16', '25')
SELECT s_Name, ATM1_Id, ATM2_Id, ATM3_Id FROM lbtSiteMas WHERE
s_Name IN (
'S1AC0112002',
'S1AC0115201',
'S1AC0112016',
'S1AC0128802',
'S1AC0111403')
SELECT * FROM lbtBankInput WHERE s_Name IN --('S1AC0112002', 'S1AC0112001')
(
'S1AC0112002',
'S1AC0115201',
'S1AC0112016',
'S1AC0128802',
'S1AC0111403')
SELECT * FROM lbtBankInput WHERE s_Name IN
('S1AC0111404'
,'S1AC0112001'
,'S1AC0112007'
,'S1AC0115209'
,'S1AC0128803')