diff options
| author | Mario Vavti <mario@mariovavti.com> | 2023-02-16 16:56:57 +0100 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2023-02-16 16:56:57 +0100 |
| commit | 777fdeb462122b258c3f56d594ef419d61193e88 (patch) | |
| tree | ef3146ca4940ffe0c5c30522073f9958246c64b2 /Zotlabs/Module/Dirsearch.php | |
| parent | 1078b774aefcc8edd9199096f9cae69c76a854a5 (diff) | |
| download | volse-hubzilla-777fdeb462122b258c3f56d594ef419d61193e88.tar.gz volse-hubzilla-777fdeb462122b258c3f56d594ef419d61193e88.tar.bz2 volse-hubzilla-777fdeb462122b258c3f56d594ef419d61193e88.zip | |
realy make sure we will deduplicate even if there is a bogus second primary entry
Diffstat (limited to 'Zotlabs/Module/Dirsearch.php')
| -rw-r--r-- | Zotlabs/Module/Dirsearch.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/Zotlabs/Module/Dirsearch.php b/Zotlabs/Module/Dirsearch.php index 8b445d875..c0df8a1e3 100644 --- a/Zotlabs/Module/Dirsearch.php +++ b/Zotlabs/Module/Dirsearch.php @@ -263,7 +263,7 @@ class Dirsearch extends Controller { xprof.xprof_homepage as homepage, xprof.xprof_hometown as hometown, xprof.xprof_keywords as keywords - from xchan left join xprof on xchan_hash = xprof_hash left join hubloc on hubloc_id_url = xchan_url + from xchan left join xprof on xchan_hash = xprof_hash left join hubloc on (hubloc_id_url = xchan_url and hubloc_hash = xchan_hash) where hubloc_primary = 1 and hubloc_updated > %s - INTERVAL %s and ( $logic $sql_extra ) $hub_query and xchan_network = 'zot6' and xchan_system = 0 and xchan_hidden = 0 and xchan_orphan = 0 and xchan_deleted = 0 $safesql $order $qlimit", db_utcnow(), |