SELECT 
    PARTNERS_ADDRESSES.ID, 
    PARTNERS_ADDRESSES.ID_FOREIGNKEY, 
    PARTNERS_ADDRESSES.ADDRESS_TYPE, 
    PARTNERS_ADDRESSES.STREET, 
    PARTNERS_ADDRESSES.POSTCODE, 
    PARTNERS_ADDRESSES.ID_CITIES, 
    PARTNERS_ADDRESSES.CITY, 
    PARTNERS_ADDRESSES.ID_STATES, 
    PARTNERS_ADDRESSES.FOREIGNKEY_TYPE, 
    PARTNERS_ADDRESSES.HOME_CONTACT, 
    PARTNERS_ADDRESSES.STREET_NO
FROM
     PARTNERS_ADDRESSES
WHERE
    PARTNERS_ADDRESSES.ID_FOREIGNKEY IN (1000061) AND (PARTNERS_ADDRESSES.FOREIGNKEY_TYPE = 2)


