SELECT
   id,
   parent_id,
   details
FROM books
WHERE details->'_translated' -> 'en_US' -> 'is_draft' ='false' ;