SELECT 
    PARTNERS_ADDRESSES.ID, 
    PARTNERS_ADDRESSES.ID_FOREIGNKEY, 
    PARTNERS_ADDRESSES.ADDRESS_TYPE, 
    PARTNERS_ADDRESSES.FORNAME_SURNAME, 
    PARTNERS_ADDRESSES.NAME, 
    PARTNERS_ADDRESSES.STREET, 
    PARTNERS_ADDRESSES.POSTCODE, 
    PARTNERS_ADDRESSES.ID_CITIES, 
    PARTNERS_ADDRESSES.CITY, 
    PARTNERS_ADDRESSES.ID_STATES, 
    PARTNERS_ADDRESSES.DESCRIPTION, 
    PARTNERS_ADDRESSES.IS_CONTACT_ADDRESS, 
    PARTNERS_ADDRESSES.IS_INVOICE_ADDRESS, 
    PARTNERS_ADDRESSES.IS_POSTCARD_ADDRESS, 
    PARTNERS_ADDRESSES.IS_DELIVERY_ADDRESS, 
    PARTNERS_ADDRESSES.IS_DEFAULT_FOR_TYPE, 
    PARTNERS_ADDRESSES.FOREIGNKEY_TYPE, 
    PARTNERS_ADDRESSES.HOME_CONTACT, 
    PARTNERS_ADDRESSES.STREET_NO, 
    PARTNERS_ADDRESSES.ID_MASTER, 
    PARTNERS_ADDRESSES.CENTER, 
    PARTNERS_ADDRESSES.DEPARTMENT, 
    PARTNERS_ADDRESSES.FINAL_RECIPIENT, 
    PARTNERS_ADDRESSES.DESTINATION, 
    PARTNERS_ADDRESSES.DELIVERY_PLACE_EAN, 
    PARTNERS_ADDRESSES.BILLING_PLACE_EAN
FROM
     PARTNERS_ADDRESSES
WHERE
    PARTNERS_ADDRESSES.ID_FOREIGNKEY IN (1000086) AND (PARTNERS_ADDRESSES.FOREIGNKEY_TYPE = 1)


