[Koha-bugs] [Bug 24809] OAI PMH can fail on fetching deleted records

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24809

--- Comment #9 from Nick Clemens <nick at bywatersolutions.com> ---
(In reply to Marcel de Rooy from comment #7)
> Still not getting the point of the change completely:
> 
>         $sql .= "
>             UNION
>             SELECT deleteditems.timestamp FROM deleteditems JOIN biblio
> USING (biblionumber)
>             WHERE biblionumber=?
>             UNION
>             SELECT timestamp from items
>             WHERE biblionumber=?
>         ";

The goal of the query is the get the latest change for a record and return
undef if record is deleted. We need to check deleted items because deleting an
item will not update the biblioitems timestamp. We need to limit to deleted
items where the bib is not deleted. 

> Ambiguous now for biblionumber when adding the left join?1
> Why do you add the left join if you only want deleteditems ?

Where is the LEFT JOIN?

-- 
You are receiving this mail because:
You are watching all bug changes.