text: /* interactive-complex-9 */
  select p2.p_personid, p2.p_firstname, p2.p_lastname, m_creationdate, m_content, m_creationdate
  from person p1 JOIN (
      knows k1 JOIN (
              person p2 JOIN message ON p2.p_personid=m_creatorid)
              ON k1.k_person2id=p2.p_personid)
      ON p1.p_personid=k1.k_person1id
  where p1.id=4398046516895
      and m_creationdate < '2012-06-03 00:00:00'
  ;
  