SQLSTATE[42S22]: Column not found: 1054 Unknown column 'products.category_id' in 'where clause' (SQL: select categories.*, (select count(*) from productsinner joinproducts_versiononproducts.id=products_version.ref_idandproducts_version.version=products.latest_versionwherecategories.id=products.category_idandproducts_version.deleted_atis null) asproducts_countfromcategorieswhereid = 1 limit 1)

Hi there,

It does indeed appear that certain relations don't work. Fortunately I did just get hasMany relation working locally. I'm going to fix all relations, and put them under tests before committing them here.

For now you can use this hot fix on the model that has the hasMany relation, and replace it with hasManyVersioned.

trait HasVersionedRelationshipsTrait
{
    public function hasManyVersioned($related, $foreignKey = null, $localKey = null)
    {
        $instance = $this->newRelatedInstance($related);

        $foreignKey = $foreignKey ?: $this->getForeignKey();

        $localKey = $localKey ?: $this->getKeyName();

        return $this->newHasMany(
            $instance->newQuery(), $this, $instance->getVersionTable().'.'.$foreignKey, $localKey
        );
    }
}