gistfile1.txt

SELECT DISTINCT
wb_v_latest_triples.triple_order, wb_v_latest_triples.subject, 
wb_v_latest_triples.predicate, wb_v_latest_triples.obj_value, 
wb_v_latest_triples.obj_type, wb_v_latest_triples.obj_lang, 
wb_v_latest_triples.obj_datatype FROM wb_v_latest_triples 
JOIN wb_v_latest_triples AS j_1 ON (wb_v_latest_triples.subject = j_1.subject)  
JOIN wb_v_latest_triples AS j_2 ON (wb_v_latest_triples.subject = j_2.subject)  
JOIN wb_v_latest_triples AS j_3 ON (wb_v_latest_triples.subject = j_3.subject)  
WHERE
(j_1.predicate = 'type' AND j_1.obj_value = 'http://indx.ecs.soton.ac.uk/ontology/root-box/#server')
OR (j_2.predicate = 'box' AND j_2.obj_value = j_3.subject)