SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_NOTIF_PROP_TYPE WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_NOTIF_PROP_KIND WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_NOTIF_PRICE WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_NOTIF_LOCATION WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_NOTIF_KLADR WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_NOTIF_CONC_OBJECT WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_NOTIF_BIORESOURCE WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_NOTIF_BID_TYPE WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_NOTIF_BID_ORG WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_NOTIF_ARTICLE WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID, USER_NAME FROM FDC_SUBSCRIB_NEWS WHERE USER_NAME = 'mawa87@mail.ru'
UNION ALL
SELECT ID,
  USER_NAME
FROM FDC_SUBSCRIB_CONTRACT_TYPE WHERE USER_NAME = 'mawa87@mail.ru';