', wallet_desc, '') wallet, CONCAT(IFNULL(owner_names, '-'), ' edit') owners,
IF(walletpaths IS NULL, '-', GROUP_CONCAT(IFNULL(path, 'non HD') SEPARATOR ', ')) paths
FROM wallets
LEFT JOIN (
SELECT wallet_id, CONCAT('(', GROUP_CONCAT(owner_name ORDER BY owner_name), ')') owner_names
FROM owners
JOIN owners2wallets USING (owner_id)
GROUP BY wallet_id
) AS bla USING (wallet_id)
LEFT JOIN (
SELECT wallet_id, COUNT(walletpath_id) walletpaths, xpub_id, CONCAT(root, '/{', GROUP_CONCAT(leaf ORDER BY leaf), '}') path
FROM walletpaths
LEFT JOIN paths USING (path_id)
LEFT JOIN xpubs USING (xpub_id)
GROUP BY wallet_id, xpub_id
) AS bla2 USING (wallet_id)
GROUP BY wallet_id
EOQ);
html_start();
?>