Select multiple EID in wisski_salz_id2uri

selectMutlipleEIDsFromWisski_salz_id2uri.sql

# SELECT SQL STATEMENT (SAVE RESULT)
SELECT t1.eid
FROM wisski_salz_id2uri t1 
INNER JOIN (
	SELECT uri, count(eid), adapter_id, rid
	FROM wisski_salz_id2uri 
	GROUP BY uri, adapter_id 
	HAVING 
		COUNT(eid) > 1 
		AND adapter_id = "boehler_backend") AS t2
WHERE t1.uri = t2.uri 
AND t1.adapter_id = t2.adapter_id 
AND t1.rid > t2.rid;

# DELETE EIDS
DELETE t1 FROM wisski_salz_id2uri t1 
INNER JOIN (
    SELECT uri, count(eid), adapter_id, rid
    FROM wisski_salz_id2uri 
    GROUP BY uri, adapter_id 
    HAVING 
        COUNT(eid) > 1 
        AND adapter_id = "boehler_backend") AS t2
WHERE t1.uri = t2.uri 
AND t1.adapter_id = t2.adapter_id 
AND t1.rid > t2.rid;


# DELETE THE CORRESPONDING RDF STATEMENTS
DELETE WHERE {
	?s <http://boehler.zikg.eu/content/eid> ?o .
  	FILTER (?o IN (<EID LIST>))
}

Searches for multiple EIDs for a URI and find the highest EID from wisski_salz_id2uri table.