'$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 = <<', firstname) ORDER BY date_of_birth SEPARATOR ', '), ' ', IFNULL(surname, '')) naam, street, number, zipcode, city FROM ( $query ) sub0 GROUP BY address_id, surname_id UNION SELECT address_id, CONCAT(GROUP_CONCAT(DISTINCT CONCAT('', 'Familie', UPPER(LEFT(surname, 2)), SUBSTRING(surname, 3)))) naam, street, number, zipcode, city FROM ( $query ) sub0 GROUP BY address_id, surname_id EOT; $outer_outer_query = <<T') sel, 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', <<

sintaldi