[TYPO3-english] Complex Query in Typoscript

[Tomas Mrozek]

Try to start with this:

temp.updated = CONTENT
temp.updated {
  table = tt_content
  select {
    pidInList.cObject = CONTENT
    pidInList.cObject {
      table = pages
      select {
        selectFields = pages.uid
        leftjoin = pages AS p2 ON pages.pid = p2.uid
        where = p2.pid = 17523
      }
      renderObj = TEXT
      renderObj {
        field = uid
        wrap = |,
      }
    }
    orderBy = tstamp DESC
    max = 5
  }
  renderObj = TEXT
  renderObj {
    field = header
    typolink {
      parameter.field = pid
      section.dataWrap = c{field:uid}
    }
    wrap = <li>|</li>
  }
  wrap = <ul>|</ul>
}


I didn't test it at all so there's a good chance I made a mistake in it.
You'll have to play with it.

Tomas Mrozek