'$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 = <<', ppl_id, '') id, CONCAT(firstname, ' ', IF(prefix != '', CONCAT(prefix, ' '), ''), surname) name, date_of_birth, IFNULL(CONCAT(street, ' ', number), '-') street_number, IFNULL(zipcode, '-') zipcode, IFNULL(city, '-') city, IFNULL(email, '-') email, IF(phonenumber IS NULL, '-', IF(phonenumber LIKE '+31(0)%%', CONCAT('0', SUBSTRING(phonenumber, 7)), phonenumber)) phonenumber FROM ( $sub_query ) sub LEFT JOIN addresses USING (address_id) LEFT JOIN firstnames USING (firstname_id) LEFT JOIN surnames USING (surname_id) LEFT JOIN email USING (email_id) LEFT JOIN phonenumbers USING (phonenumber_id) GROUP BY ppl_id ORDER BY city, street, number, date_of_birth, surname, firstname, prefix EOT; $result = mysqli_query_safe($query); html_head('Family, Friends & Vague Aquiantances DB', <<

invoeren, calendar, labels per persoon labels per adres