How to represent this relationship in DataMapper

[eluser]WanWizard[/eluser]
Your query shows it's using "authored_id", which is a field that does not exist.

With this configuration, either name your FK like this, or use the "join_self"/"join_other" fields of the relationship definition to control the name of the FK.

Note that the column MUST end on "_id", and the name you specify in the relationship definition MUST NOT.