marc_export documentation sql example fix

[Josh Stompro]

I was just trying out an export using the example sql at
https://docs.evergreen-ils.org/3.2/_marc_export_exporting_bibliographic_records_into_marc_files.html

and noticed that the sql query there needs to exclude deleted asset.call_number entries or the results will be incorrect.

SELECT DISTINCT bre.id FROM biblio.record_entry AS bre
    JOIN asset.call_number AS acn ON acn.record = bre.id
    WHERE bre.deleted='false' and owning_lib=101 \g /home/opensrf/records.txt;

Should be

SELECT DISTINCT bre.id FROM biblio.record_entry AS bre
    JOIN asset.call_number AS acn ON acn.record = bre.id and not acn.deleted
    WHERE bre.deleted='false' and owning_lib=101 \g /home/opensrf/records.txt;

Need to update it at
https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=docs/modules/development/pages/support_scripts.adoc;hb=HEAD

[Josh Stompro (u-launchpad-stompro-org)]

Working branch at user/stompro/lp2029160_marc_export_doc_update

https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/stompro/lp2029160_marc_export_doc_update

[Jane Sandberg (sandbergja)]

Good catch, thanks, Josh! Pushed to rel_3_10 and above.