mess9

Untitled

Aug 4th, 2021
1,896
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     s.IDENTIFITIER,
  3.     ss.TECHSERVICE_LOCALSYSTEMID ,
  4.     ss.STARTDATE,
  5.     ss.ENDDATE
  6. FROM
  7.     MDM6.SUBSCRIBER s
  8.         INNER JOIN
  9.     MDM6.SUBSCRIBERSERVICE ss
  10.         ON ss.SUBSCRIBER_LOCALSYSTEMID = s.LOCALSYSTEMID
  11.         AND ss.SUBSCRIBER_APP_PKID = s.APP_PKID
  12.         AND ss.SUBSCRIBER_VERSION = s.VERSION
  13. WHERE 1=1
  14.     AND s.DELETED = 0
  15.     AND ss.DELETED = 0
  16.     AND s.VERSION = 0
  17.     AND ss.VERSION = 0
  18.     AND s.IDENTIFITIER = ?
  19.     AND ss.TECHSERVICE_LOCALSYSTEMID = '369300148'
RAW Paste Data