10 = CONTENT
10{
    table = tx_myclients
    select{
        pidInList = 37
        orderBy = name
        selectFields = SUBSTRING(name,1,1) as firstLetter
        groupBy = firstLetter
    }

    renderObj = COA
    renderObj{

        #Initial letter
        10 = TEXT
        10.field = firstLetter
        10.wrap = <span class="huge-letter">|</span>

        20 = CONTENT
        20{
            table = tx_myclients
            select{
                pidInList = 37
                begin = 0
                selectFields = uid as clientUID, name as clientName, category as clientCategory, projects as clientProjects
                andWhere.stdWrap.cObject = TEXT
                andWhere.stdWrap.cObject{
                    field = firstLetter
                    wrap = name LIKE '|%'
                }
            }
            renderObj = COA
            renderObj{

                20 = TEXT
                20.field = clientName

                30 = CONTENT
                30{
                    wrap = <div>|</div>
                    table = pages
                    select{
                        pidInList = 43
                        begin = 0

            #This where clause is not right. Just for testing purpose
                        where = title LIKE 'A%'
                    }

                    renderObj = COA
                    renderObj{
                        50 = TEXT
                        50.field = title
                    }
                }

            }
        }
    }
}