How I can make this code to insert just first person, not all, how have the specified condition ??
And another question: I can make this code more optimum? and how ?

```
INSERT INTO TLP
            (LASTNAME, FIRSTNAME,  EMAIL1, USERID  ) 
SELECT NAME,  GIVEN_NAME, MAIL, LOGIN, SYSDATE

FROM   GLOB 
WHERE (( ( NOT EXISTS (SELECT EMAIL1 
                     FROM   TLP
                     WHERE  GLOB.mail = TLP.email1 ) 
         AND GLOB.mail IS NOT NULL )
         AND GLOB.COUNTRY='France' )
        OR (( NOT EXISTS (SELECT userid
                         FROM   TLP 
                         WHERE  GLOB.LOGIN = TLP.userid ) 

  AND GLOB.COUNTRY='Germany'))
  and ( exists (select FIRSTNAME
                  from TLP
                  where (gLOB.name not like '07_%' AND 
                 glob.name not like 'TR_%' AND
                 glob.name not like 'ST_%' AND                     
                    glob.name is not null))

                 ));

```