T1.NAME AS URL1_title,
       T1.URL AS URL1,
       T1.REQUEST_TYPE,
       T2.REFERENCE_ID AS REFERENCE_ID1,
       T2.NAME AS URL2_title,
       T2.URL AS URL2,
       T2.REQUEST_TYPE AS REQUEST_TYPE1,
       T3.REFERENCE_ID AS REFERENCE_ID2,
       T3.NAME AS URL3_title,
       T3.URL AS URL3,
       T3.REQUEST_TYPE AS REQUEST_TYPE2,
       T3.SUMMARY
FROM RIDW.VW_REQUEST T1
LEFT OUTER JOIN RIDW.VW_REQUEST_RELATIONAL_LINK LT1
ON (T1.REQUEST_ID = LT1.REQUEST2_ID AND LT1.ISSOFTDELETED = 0) AND LT1.NAME = 'com.ibm.team.workitem.linktype.parentworkitem'
  LEFT OUTER JOIN RIDW.VW_REQUEST T2
  ON (LT1.REQUEST1_ID = T2.REQUEST_ID) AND LT1.NAME = 'com.ibm.team.workitem.linktype.parentworkitem'
    LEFT OUTER JOIN RIDW.VW_REQUEST_RELATIONAL_LINK LT2
    ON (T2.REQUEST_ID = LT2.REQUEST2_ID AND LT2.ISSOFTDELETED = 0) AND LT2.NAME = 'com.ibm.team.workitem.linktype.parentworkitem'
      LEFT OUTER JOIN RIDW.VW_REQUEST T3
      ON (LT2.REQUEST1_ID = T3.REQUEST_ID) AND LT2.NAME = 'com.ibm.team.workitem.linktype.parentworkitem'
        LEFT OUTER JOIN RICALM.VW_RQST_STRING_EXT T4
        ON T4.REQUEST_ID=T1.REQUEST_ID AND T4.NAME='com.tsys.process.primaryApplication'
          LEFT OUTER JOIN RICALM.VW_RQST_ENUMERATION T4_1
          ON T4_1.EXTERNAL_ID=T4.VAL AND T4_1.PROJECT_ID=T1.PROJECT_ID
            LEFT OUTER JOIN RICALM.VW_RQST_STRING_M_EXT T5
            ON T5.REQUEST_ID=T1.REQUEST_ID AND T5.NAME='com.tsys.process.AreasofImpact'
              LEFT OUTER JOIN RICALM.VW_RQST_ENUMERATION T5_1
              ON T5.VAL LIKE CONCAT(CONCAT('%|',T5_1.EXTERNAL_ID), '|%') AND T5_1.PROJECT_ID=T1.PROJECT_ID
WHERE (T1.PROJECT_ID = 196 OR T1.PROJECT_ID = 77) AND
  (T2.PROJECT_ID = 196 OR T2.PROJECT_ID = 77 OR (T2.PROJECT_ID=-1 OR T2.PROJECT_ID IS NULL)) AND
  (T3.PROJECT_ID = 196 OR T3.PROJECT_ID = 77 OR (T3.PROJECT_ID=-1 OR T3.PROJECT_ID IS NULL))  AND
(  T1.REQUEST_TYPE = 'Project Request'  AND
  (
    T4_1.LITERAL_NAME = 'Commercial Card' OR
    T5_1.LITERAL_NAME = 'Commercial Card' 
  )AND
  (T2.REQUEST_TYPE = 'Epic'  OR (T2.REQUEST_TYPE='Info not available' OR T2.REQUEST_TYPE='Unassigned' OR T2.REQUEST_TYPE=' ' OR T2.REQUEST_TYPE IS NULL))  AND
  (
    (T3.REQUEST_TYPE = 'Story'  OR (T3.REQUEST_TYPE='Info not available' OR T3.REQUEST_TYPE='Unassigned' OR T3.REQUEST_TYPE=' ' OR T3.REQUEST_TYPE IS NULL)) AND
    (LOWER(T3.SUMMARY) LIKE '%implementation%'  OR (T3.SUMMARY='Info not available' OR T3.SUMMARY='Unassigned' OR T3.SUMMARY=' ' OR T3.SUMMARY IS NULL)) 
  )
) AND
(T1.ISSOFTDELETED = 0) AND
(T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL)