Cacher is the code snippet organizer for pro developers

SELECT EMPL.DEPT,
  IERP.EMPLOYEE_ID,
  EMPL.LAST_NAME,
  EMPL.FIRST_NAME,
  EMPL.POS_CODE,
  EMPL.TITLE AS POS_TITLE,
  IERP.ROW_ID,
  IERP.DATE_MODIFIED,
  IERP.AUTHORS,
  IERP.TITLE,
  IERP.CONFERENCE,
  IERP.CITY,
  IERP.STATE,
  IERP.SETTING,
  IERP.PRES_DATE,
  IERP.PRES_TYPE,
  IERP.FACILITY
FROM IER_PRESENTATIONS IERP
JOIN ACTIVE_UNIQUE_SMH_EMPLS EMPL
ON IERP.EMPLOYEE_ID        = EMPL.EMPLOYEE_ID
WHERE EMPL.POS_CODE       IN (8464,8471)
AND lower(IERP.TITLE) NOT IN ('na','n/a','n\a')
AND IERP.TITLE NOT LIKE ('Verified%by%')
AND lower(IERP.AUTHORS) NOT IN ('na','n/a','n\a')
ORDER BY IERP.PRES_DATE, EMPL.DEPT, EMPL.POS_CODE, EMPL.LAST_NAME;