{ "items" : [
    { "id" : "http://webisa.webdatacommons.org/278573970"
      "properties" : {
        "http://www.w3.org/1999/02/22-rdf-syntax-ns#type" : [ "http://www.w3.org/ns/prov#Entity" ] ,
        "http://www.w3.org/ns/prov#value" : [ "I tried that with create unique index created_subid_islive_ndx on leads (created, subid, is_live); and then re-ran both mine and your query and it didn't seem to change a thing other than adding the index to the possible_keys explain column (in my query), and removing the subid from possible_keys (in your query)." ] ,
        "http://www.w3.org/ns/prov#wasQuotedFrom" : [ "stackexchange.com" ] } },

    { "id" : "http://webisa.webdatacommons.org/prov/375693546"
      "properties" : {
        "http://www.w3.org/ns/prov#wasDerivedFrom" : [ "http://webisa.webdatacommons.org/278573970"] } } }
