Page History

...

Sample 1:

FROM folio_derived.instance_ext AS instext
LEFT JOIN folio_source_record.marc__t AS sm ON instext.instance_id = sm.instance_id
LEFT JOIN folio_source_record.records_lb AS rec ON sm.instance_id = rec.external_id
WHERE rec.state = 'ACTUAL' 

Here is an example of a query that uses 'ACTUAL' :

...

FROM folio_derived.instance_ext 
    LEFT JOIN folio_source_record.marc__t
    ON instance_ext.instance_id = marc__t.instance_id
    
    LEFT JOIN folio_source_record.records_lb 
    ON marc__t.instance_id = records_lb.external_id
        AND marc__t.srs_id = records_lb.id

WHERE instance_ext.instance_hrid = '11023049'

...

FROM folio_derived.instance_ext 
    LEFT JOIN folio_source_record.marc__t
    ON instance_ext.instance_id = marc__t.instance_id
    
    LEFT JOIN folio_source_record.records_lb 
    ON marc__t.instance_id = records_lb.external_id
        AND marc__t.srs_id = records_lb.id

WHERE instance_ext.instance_hrid = '11023049'
and records_lb.state = 'ACTUAL'

...