Typoscript sql query between 3 tables and an input value

marker {
        fichier1 = CONTENT
        fichier1 {
            table = sys_file
            select {
                pidInList = 13
                #recursive = 10
                #orderBy = crdate ASC
                selectFields = sys_file.uid, sys_file.identifier
                JOIN sys_file_reference ON sys_file.uid = sys_file_reference.uid_local
                JOIN tx_news_domain_model_news ON sys_file_reference.uid_foreign = tx_news_domain_model_news.uid
                # possible conditions
                where tx_news_domain_model_news.uid = sys_file_reference.uid_foreign AND sys_file_reference.tablenames = tx_news_domain_model_news
                andWhere {
                    cObject = COA
                    cObject {
                        1 = TEXT
                        1.data = GP:FormEditnews|title
                        1.sanitize = 1
                        1.wrap = tx_news_domain_model_news.title="|"
                    #   1.wrap = title="|"
                    #   2 = TEXT
                    #   2.data = debug:data
                    #   2.wrap = debug : |
                    }
                }
            }

            renderObj = COA
            renderObj {
                #value
                10.wrap = |
                10 = TEXT
                10.field = identifier
            }
        }
}