Cacher is the code snippet organizer for pro developers

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')