SELECT
    s.IDENTIFITIER,
    ss.TECHSERVICE_LOCALSYSTEMID ,
    ss.STARTDATE,
    ss.ENDDATE
FROM
    MDM6.SUBSCRIBER s
        INNER JOIN
    MDM6.SUBSCRIBERSERVICE ss
        ON ss.SUBSCRIBER_LOCALSYSTEMID = s.LOCALSYSTEMID
        AND ss.SUBSCRIBER_APP_PKID = s.APP_PKID
        AND ss.SUBSCRIBER_VERSION = s.VERSION
WHERE 1=1
    AND s.DELETED = 0
    AND ss.DELETED = 0
    AND s.VERSION = 0
    AND ss.VERSION = 0
    AND s.IDENTIFITIER = ?
    AND ss.TECHSERVICE_LOCALSYSTEMID = '369300148'