'$date' ) LEFT JOIN surnames2ppl AS s2p ON ppl.ppl_id = s2p.ppl_id AND ( s2p.established = 0 OR ( SELECT date FROM datenodes WHERE datenode_id = s2p.established ) <= '$date' ) AND ( s2p.disestablished = 0 OR ( SELECT date FROM datenodes WHERE datenode_id = s2p.disestablished ) > '$date' ) LEFT JOIN phonenumbers2ppl AS p2p ON ppl.ppl_id = p2p.ppl_id AND ( p2p.established = 0 OR ( SELECT date FROM datenodes WHERE datenode_id = p2p.established ) <= '$date' ) AND ( p2p.disestablished = 0 OR ( SELECT date FROM datenodes WHERE datenode_id = p2p.disestablished ) > '$date' ) LEFT JOIN email2ppl AS e2p ON ppl.ppl_id = e2p.ppl_id AND ( e2p.established = 0 OR ( SELECT date FROM datenodes WHERE datenode_id = e2p.established ) <= '$date' ) AND ( e2p.disestablished = 0 OR ( SELECT date FROM datenodes WHERE datenode_id = e2p.disestablished ) > '$date' ) LEFT JOIN addresses2ppl AS a2p ON ppl.ppl_id = a2p.ppl_id AND ( a2p.established = 0 OR ( SELECT date FROM datenodes WHERE datenode_id = a2p.established ) <= '$date' ) AND ( a2p.disestablished = 0 OR ( SELECT date FROM datenodes WHERE datenode_id = a2p.disestablished ) > '$date' ) WHERE ( ( SELECT date FROM datenodes WHERE datenode_id = date_of_birth ) <= '$date' OR date_of_birth = 0 ) AND ( date_of_death = 0 OR ( SELECT date FROM datenodes WHERE datenode_id = date_of_death ) > '$date' ) ORDER BY f_priority DESC, a_priority DESC, s_priority DESC EOT; $query = <<') aid, GROUP_CONCAT(naam SEPARATOR ', ') naam, street, number, zipcode, city FROM ( $outer_query ) sub1 GROUP BY address_id EOT; $result = mysqli_query_safe($outer_outer_query); //header('Content-Type: text/html'); //echo(sprint_table($result)); //exit; html_head('Family, Friends & Vague Aquiantances DB', <<