# Queries

## Joinedload current translation

    import sqlalchemy as sa

    articles = (
        session.query(Article)
        .options(sa.orm.joinedload(Article.current_translation))
    )

    print articles[0].name

## Joinedload arbitrary translations

    import sqlalchemy as sa

    articles = (
        session.query(Article)
        .options(sa.orm.joinedload(Article.translations['fi']))
        .options(sa.orm.joinedload(Article.translations['en']))
    )

You can also use attribute accessors:

    articles = (
        session.query(Article)
        .options(sa.orm.joinedload(Article.translations.fi))
        .options(sa.orm.joinedload(Article.translations.en))
    )

## Joinedload all translations

    articles = (
        session.query(Article)
        .options(sa.orm.joinedload(Article.translations))
    )