{
      "documents": [
          {
            "pos": 1,
            "docid": 858,
            "uri": "https://beta-documents.el-una.org/id/document/858",
            "content": "presentation",
            "mime_type": "application/pdf",
            "files": [
                {
                  "datasetid": "document",
                  "uri": "https://beta-documents.el-una.org/id/file/12063",
                  "objectid": 858,
                  "fileid": 12063,
                  "mime_type": "application/pdf",
                  "filename": "Outer_Joins_by_Example-Salika.pdf",
                  "mtime": "2016-05-27 21:05:24",
                  "filesize": 1416793
                }
            ],
            "relation": [
              {
                "uri": "/id/document/2224",
                "type": "http://eprints.org/relation/hasVolatileVersion"
              },
              {
                "uri": "/id/document/2224",
                "type": "http://eprints.org/relation/haspreviewThumbnailVersion"
              },
              {
                "uri": "/id/document/2224",
                "type": "http://eprints.org/relation/hasVersion"
              }
            ],
            "format": "application/pdf",
            "rev_number": 4,
            "eprintid": 670,
            "language": "en",
            "main": "Outer_Joins_by_Example-Salika.pdf",
            "security": "validuser"
          }
      ],
      "status_changed": "2011-05-31 16:48:18",
      "eprint_status": "archive",
      "divisions": [
        "eluna_conf"
      ],
      "subjects": [
        "voyager"
      ],
      "refereed": "FALSE",
      "creators": [
        {
          "name": {
            "lineage": null,
            "given": "Cathy",
            "family": "Salika",
            "honourific": null
          }
        }
      ],
      "date_type": "published",
      "type": "conference_item",
      "metadata_visibility": "show",
      "date": "2011-05",
      "abstract": "Outer joins are a technique for dealing with inconsistencies in your data when you write queries. What if some items aren\u2019t barcoded? What if some bibs aren\u2019t indexed by title? What if some items are in temporary locations? Outer joins can also improve your statistics by making sure that odd cases aren\u2019t dropped. In this session, we\u2019ll look at lots of queries that make use of outer joins and see how helpful they can be. ",
      "event_type": "conference",
      "dir": "disk0/00/00/06/70",
      "event_dates": "11-13 May 2011",
      "event_title": "ELUNA 2011",
      "lastmod": "2016-05-27 21:05:24",
      "rev_number": 12,
      "title": "Outer Joins by Example",
      "item_issues_count": 0,
      "pres_type": "lecture",
      "datestamp": "2011-05-31 16:48:18",
      "event_location": "Milwaukee, Wisconsin",
      "uri": "https://beta-documents.el-una.org/id/eprint/670",
      "ispublished": "pub",
      "userid": 23,
      "full_text_status": "restricted",
      "eprintid": 670
    }