Typo in "Constructing SQL..." -> Subqueries example

[Former user]

In Constructing SQL Queries via Python Expressions -> Subqueries paragraph example is wrong. Instead of this:

# now select all addresses for those users
sqladdresses.select(addresses.c.address_id.in_(s)).execute()

it should be:

# now select all addresses for those users
sqladdresses.select(addresses.c.user_id.in_(s)).execute()

[Former user]

Sorry! Of course it's {{{addresses}}}, not {{{sqladdresses}}}. I have copied {{{sql}}} link to the clipboard by mistake...

# now select all addresses for those users
addresses.select(addresses.c.user_id.in_(s)).execute()

[Former user]

Alternatively you can take a look at documenation source in trac. For fix change from

<&formatting.myt:poplink&>addresses.select(addresses.c.address_id.in_(s)).execute()

to

<&formatting.myt:poplink&>addresses.select(addresses.c.user_id.in_(s)).execute()

[Former user]

Patch for this ticket

[Former user]

fixed in eebf468b35d5ecf0178edb6a4e59f575435573d9