10:04:07 swh-scheduler@db1:5432=> select first_seen, url from listed_origins where visit_type='bzr' and url like 'http://%' order by first_seen desc; select first_seen, url from listed_origins where visit_type='bzr' and url like 'http://%' order by first_seen desc; +-------------------------------+--------------------------------------------------------------------+ | first_seen | url | +-------------------------------+--------------------------------------------------------------------+ | 2022-02-15 02:58:23.893595+00 | http://pydstool.bzr.sourceforge.net/bzrroot/pydstool | | 2022-02-15 02:27:59.513476+00 | http://vapor.bzr.sourceforge.net/bzrroot/vapor | | 2022-02-15 02:25:03.332243+00 | http://fastformat.bzr.sourceforge.net/bzrroot/fastformat | | 2022-02-15 02:20:39.016164+00 | http://amyunix2.bzr.sourceforge.net/bzrroot/amyunix2 | | 2022-02-15 02:20:38.222131+00 | http://yanshinaung7.bzr.sourceforge.net/bzrroot/yanshinaung7 | | 2022-02-15 02:20:37.053261+00 | http://textencrypter.bzr.sourceforge.net/bzrroot/textencrypter | | 2022-02-15 02:20:36.303807+00 | http://wednus.bzr.sourceforge.net/bzrroot/wednus | | 2022-02-15 02:20:30.845962+00 | http://mrbp-tutorials.bzr.sourceforge.net/bzrroot/mrbp-tutorials | | 2022-02-15 02:20:29.814592+00 | http://madali.bzr.sourceforge.net/bzrroot/madali | | 2022-02-15 02:20:29.287587+00 | http://tughchi.bzr.sourceforge.net/bzrroot/tughchi | | 2022-02-15 02:20:05.101464+00 | http://vmukti.bzr.sourceforge.net/bzrroot/vmukti | | 2022-02-15 02:19:57.493738+00 | http://tmphysical.bzr.sourceforge.net/bzrroot/tmphysical | | 2022-02-15 02:19:54.318986+00 | http://jetcat.bzr.sourceforge.net/bzrroot/jetcat | | 2022-02-15 02:19:36.150134+00 | http://kristyzhang.bzr.sourceforge.net/bzrroot/kristyzhang | | 2022-02-15 02:19:34.215099+00 | http://kghtest1.bzr.sourceforge.net/bzrroot/kghtest1 | | 2022-02-15 02:18:01.794574+00 | http://setiyabudiu.bzr.sourceforge.net/bzrroot/setiyabudiu | | 2022-02-15 02:17:58.258801+00 | http://prozgui.bzr.sourceforge.net/bzrroot/prozgui | | 2022-02-15 02:17:57.908941+00 | http://proyectozeus.bzr.sourceforge.net/bzrroot/proyectozeus | | 2022-02-15 02:17:44.530347+00 | http://openonions.bzr.sourceforge.net/bzrroot/openonions | | 2022-02-15 02:17:42.051986+00 | http://ezop-project.bzr.sourceforge.net/bzrroot/ezop-project | | 2022-02-15 02:16:47.506928+00 | http://vtd-xml.bzr.sourceforge.net/bzrroot/vtd-xml | | 2022-02-15 02:16:13.310518+00 | http://heureka.bzr.sourceforge.net/bzrroot/heureka | | 2022-02-15 02:16:12.865792+00 | http://camaroes.bzr.sourceforge.net/bzrroot/camaroes | | 2022-02-15 02:14:37.345721+00 | http://crumplezone.bzr.sourceforge.net/bzrroot/crumplezone | | 2022-02-15 02:12:20.766998+00 | http://catkin.bzr.sourceforge.net/bzrroot/catkin | | 2022-02-15 02:10:06.991515+00 | http://prologphysicsim.bzr.sourceforge.net/bzrroot/prologphysicsim | | 2022-02-15 01:57:44.957213+00 | http://cppqed.bzr.sourceforge.net/bzrroot/cppqed | | 2022-02-15 01:56:28.823614+00 | http://webchess.bzr.sourceforge.net/bzrroot/webchess | | 2022-02-15 01:55:20.380925+00 | http://processpriority.bzr.sourceforge.net/bzrroot/processpriority | | 2022-02-15 01:55:15.455149+00 | http://vii2010.bzr.sourceforge.net/bzrroot/vii2010 | | 2022-02-15 01:47:32.737905+00 | http://xmule.bzr.sourceforge.net/bzrroot/xmule | | 2022-02-15 01:44:10.302277+00 | http://tv-viewer.bzr.sourceforge.net/bzrroot/tv-viewer | | 2022-02-15 01:35:48.710817+00 | http://pyspacebattle.bzr.sourceforge.net/bzrroot/pyspacebattle | | 2022-02-15 01:33:14.876737+00 | http://osve.bzr.sourceforge.net/bzrroot/osve | | 2022-02-15 01:30:40.172815+00 | http://libpostal.bzr.sourceforge.net/bzrroot/libpostal | | 2022-02-15 01:25:26.993744+00 | http://macgolf.bzr.sourceforge.net/bzrroot/macgolf | | 2022-02-15 01:20:12.550843+00 | http://gmousetool.bzr.sourceforge.net/bzrroot/gmousetool | | 2022-02-15 01:17:14.09917+00 | http://crashdc.bzr.sourceforge.net/bzrroot/crashdc | | 2022-02-15 00:58:22.593252+00 | http://ixpress.bzr.sourceforge.net/bzrroot/ixpress | | 2022-02-15 00:49:39.174609+00 | http://wordflashreader.bzr.sourceforge.net/bzrroot/wordflashreader | | 2022-02-15 00:38:01.757959+00 | http://ultumix.bzr.sourceforge.net/bzrroot/ultumix | | 2022-02-15 00:37:10.490036+00 | http://x3cms.bzr.sourceforge.net/bzrroot/x3cms | | 2022-02-15 00:35:42.516915+00 | http://nntp2nntp.bzr.sourceforge.net/bzrroot/nntp2nntp | | 2022-02-15 00:35:40.216399+00 | http://netactview.bzr.sourceforge.net/bzrroot/netactview | | 2022-02-15 00:35:32.261944+00 | http://datagam.bzr.sourceforge.net/bzrroot/datagam | | 2022-02-15 00:34:39.912007+00 | http://fastweb.bzr.sourceforge.net/bzrroot/fastweb | | 2022-02-15 00:34:38.873848+00 | http://fasttrack3d.bzr.sourceforge.net/bzrroot/fasttrack3d | | 2022-02-15 00:34:34.009062+00 | http://ehcp.bzr.sourceforge.net/bzrroot/ehcp | | 2022-02-15 00:20:38.516478+00 | http://thegoldenhasweg.bzr.sourceforge.net/bzrroot/thegoldenhasweg | | 2022-02-15 00:18:06.720012+00 | http://bworkstation.bzr.sourceforge.net/bzrroot/bworkstation | | 2022-02-15 00:17:56.143619+00 | http://apreta.bzr.sourceforge.net/bzrroot/apreta | | 2022-02-15 00:15:06.659974+00 | http://previewerfortex.bzr.sourceforge.net/bzrroot/previewerfortex | | 2022-02-15 00:14:58.886532+00 | http://pceeg.bzr.sourceforge.net/bzrroot/pceeg | | 2022-02-15 00:11:52.465465+00 | http://whyteboard.bzr.sourceforge.net/bzrroot/whyteboard | | 2022-02-15 00:03:35.108602+00 | http://mmource.bzr.sourceforge.net/bzrroot/mmource | | 2022-02-14 23:57:15.503126+00 | http://predocs.bzr.sourceforge.net/bzrroot/predocs | | 2022-02-14 23:55:36.422832+00 | http://thedatamaster.bzr.sourceforge.net/bzrroot/thedatamaster | | 2022-02-14 23:54:56.460511+00 | http://simcricket.bzr.sourceforge.net/bzrroot/simcricket | | 2022-02-14 23:54:51.631764+00 | http://pigmod.bzr.sourceforge.net/bzrroot/pigmod | | 2022-02-14 23:52:00.515855+00 | http://ticketed-upload.bzr.sourceforge.net/bzrroot/ticketed-upload | | 2022-02-14 23:50:00.837432+00 | http://tellurian-scene.bzr.sourceforge.net/bzrroot/tellurian-scene | | 2022-02-14 23:38:18.864422+00 | http://oedtk.bzr.sourceforge.net/bzrroot/oedtk | | 2022-02-14 23:17:38.81395+00 | http://glou.bzr.sourceforge.net/bzrroot/glou | | 2022-02-14 23:17:04.103372+00 | http://goom.bzr.sourceforge.net/bzrroot/goom | | 2022-02-14 23:05:29.988521+00 | http://codemaster2.bzr.sourceforge.net/bzrroot/codemaster2 | | 2022-02-14 19:38:38.879695+00 | http://qi-tools.bzr.sourceforge.net/bzrroot/qi-tools | | 2022-02-14 19:36:26.007619+00 | http://visualhunter.bzr.sourceforge.net/bzrroot/visualhunter | | 2022-02-14 19:23:45.040994+00 | http://jerichohtml.bzr.sourceforge.net/bzrroot/jerichohtml | | 2022-02-14 19:21:45.387189+00 | http://diskscanner.bzr.sourceforge.net/bzrroot/diskscanner | | 2022-02-14 19:10:13.628756+00 | http://mh-e.bzr.sourceforge.net/bzrroot/mh-e | | 2022-02-14 18:59:51.649377+00 | http://entrippy.bzr.sourceforge.net/bzrroot/entrippy | | 2022-02-14 18:59:36.400265+00 | http://pythonreports.bzr.sourceforge.net/bzrroot/pythonreports | | 2022-02-14 18:45:55.415942+00 | http://minecraftm.bzr.sourceforge.net/bzrroot/minecraftm | | 2022-02-14 18:44:31.936478+00 | http://openpm-org.bzr.sourceforge.net/bzrroot/openpm-org | +-------------------------------+--------------------------------------------------------------------+ (74 rows) Time: 666.507 ms