diff options
-rw-r--r-- | lib/Multi/Wikidata.pm | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/lib/Multi/Wikidata.pm b/lib/Multi/Wikidata.pm index fea9dbb1..1681700f 100644 --- a/lib/Multi/Wikidata.pm +++ b/lib/Multi/Wikidata.pm @@ -34,10 +34,10 @@ sub fetch { SELECT id FROM wikidata WHERE id IN( - SELECT l_wikidata FROM producers WHERE l_wp IS NOT NULL AND NOT hidden - UNION SELECT l_wikidata FROM staff WHERE l_wp IS NOT NULL AND NOT hidden - UNION SELECT l_wikidata FROM vn WHERE l_wp IS NOT NULL AND NOT hidden) - AND (lastfetch IS NULL OR lastfetch < now()-($1 * '1 second'::interval)) + SELECT l_wikidata FROM producers WHERE l_wikidata IS NOT NULL AND NOT hidden + UNION SELECT l_wikidata FROM staff WHERE l_wikidata IS NOT NULL AND NOT hidden + UNION SELECT l_wikidata FROM vn WHERE l_wikidata IS NOT NULL AND NOT hidden) + AND (lastfetch IS NULL OR lastfetch < date_trunc('hour', now()-($1 * '1 second'::interval))) ORDER BY lastfetch NULLS FIRST LIMIT $2 }, [ $C{fetch_interval}, $C{fetch_number} ], sub { |