SELECT 
    PARTNERS_CONTACTS.ID, 
    PARTNERS_CONTACTS.ID_PARTNERS, 
    PARTNERS_CONTACTS.TITLE_BEFORE_NAME, 
    PARTNERS_CONTACTS.FORNAME, 
    PARTNERS_CONTACTS.SURNAME, 
    PARTNERS_CONTACTS.TITLE_BEHIND_NAME, 
    PARTNERS_CONTACTS.SEX, 
    PARTNERS_CONTACTS.FORNAME2, 
    PARTNERS_CONTACTS.BIRTH_SURNAME, 
    PARTNERS_CONTACTS.NICKNAME, 
    PARTNERS_CONTACTS.JOB_FUNCTION, 
    PARTNERS_CONTACTS.OTHER_DATA1, 
    PARTNERS_CONTACTS.OTHER_DATA2, 
    PARTNERS_CONTACTS.IS_DEFAULT, 
    PARTNERS_CONTACTS.JOB_SECTION, 
    PARTNERS_CONTACTS.DESCRIPTION, 
    PARTNERS_CONTACTS.DATE_BIRTH, 
    PARTNERS_CONTACTS.NAME_DAY, 
    PARTNERS_CONTACTS.ID_CODELIST_TRANS_DATA1TYPE, 
    PARTNERS_CONTACTS.ID_CODELIST_TRANS_DATA2TYPE, 
    PARTNERS_CONTACTS.SYS, 
    PARTNERS_CONTACTS.FULL_NAME, 
    PARTNERS_CONTACTS.FLAG, 
    PARTNERS_CONTACTS.ID_MASTER
FROM
     PARTNERS_CONTACTS
WHERE
    PARTNERS_CONTACTS.ID_PARTNERS IN (1000086) AND (PARTNERS_CONTACTS.FLAG = 1)


