Typo3 V9 select random DCE from whole page to show on specific page

Question

I have an own DCE element and I want to show a random one on the start page.
When I select the CType via 10 = CONTENT and select, I must type a pidInList.
But I want a CE from the whole site, not from a specific uid.

How can iI disable this in the sql statement?

my current code:

        10 = CONTENT
        10 {
            table = tt_content
            select {
                selectFields = *, rand() as virt_rnd
                pidInList = *
                where = colPos=0 and CType=dce_ref
                max = 1
                orderBy = virt_rnd
                languageField = sys_language_uid
            }

Answer 1

UPDATE for Typo3 v10

Typoscript:

lib.randomDCE = CONTENT
lib.randomDCE {
    table = tt_content
    select {
        pidInList = 1  // root page id
        recursive = 10
        where = {#colPos}=0 AND {#CType}='my_custom_element'
        max = 1
        languageField = sys_language_uid
        //orderBy = rand()    - does not work :-(
    }
}

Using in fluid template:

<f:cObject typoscriptObjectPath="lib.randomDCE" />

Answer 2

you could use:

  select {
    selectFields = *
    pidInList = root
    recursive = 10
    orderBy = rand()
    where = colPos=0 and CType=dce_ref
    max = 1
    languageField = sys_language_uid
  }

use the root page (uid = 0) and all pages 10 levels deep (or more if your pagetree is deeper)