https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24809
--- Comment #9 from Nick Clemens <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
