FridaV - User contributions [en]

Daily

2009-04-03T23:20:23Z

Root:

[http://frida.ljudmila.net/wiki/Daily?action=purge recompute!]

{{MediaWiki:FlotWidget|overview}}

<query id="overview">Overview</query>

MediaWiki:Query:Overview

2009-04-03T23:16:46Z

Root:

SELECT date, pings, positions, bssids, waypoints, tracks, itracks, media, pmedia,
xmlelement(name a, xmlattributes(city_url as href),city_url) as city
FROM frida.overview;

Daily

2009-04-03T23:11:23Z

Root:

[http://frida.ljudmila.net/wiki/Daily?action=purge recompute!]

{{MediaWiki:FlotWidget|overview}}

<query id="overview">Overview</query>

[[Image:Overview_plan.png|frame|none|SQL query plan]]

File:Overview plan.png

2009-04-03T23:05:20Z

Root:

News

2009-03-31T21:25:17Z

Root:

====SVN====
We have finaly managed to fix SVN permission problem. You need do something like:
chgrp -R subversion /var/svn
chmod -R g+w /var/svn/*/db

====Workflow====

We have implemented a neat workflow system for running shell commands on files. This is commonly needed when you have a bunch of files and you want to convert them to different formats or import them into databases. The workflow provides two commands, ''file-monitor''' and ''file-workflow'', which help with making processing scripts tremendously. They manage job queues. They can generate various file and path names and their parts for use in shell commands.

====MediaWiki hacking====
* MediaWiki extention for running SQL queries. Queries are stored in MediaWiki namespace. For examples, see [[Daily]] or [[Networks]].
* file_media() now works with Rotterdam media files

News

2009-03-31T21:22:50Z

Root:

====SVN====
We have finaly managed to fix SVN permission problem. You need do something like to:
chgrp -R subversion /var/svn
chmod -R g+w /var/svn/*/db

====Workflow====

We have implemented a neat workflow system for running shell commands on files. This is commonly needed when you have a bunch of files and you want to convert them to different formats or import them into databases. The workflow provides two commands, ''file-monitor''' and ''file-workflow'', which help with making processing scripts tremendously.

====MediaWiki hacking====
* MediaWiki extention for running SQL queries. Queries are stored in MediaWiki namespace. For examples, see [[Daily]] or [[Networks]].
* file_media() now works with Rotterdam media files

News

2009-03-31T21:20:56Z

Root:

====SVN====
We have finnaly managed to fix SVN permission problem. You need do something like to:
chgrp -R subversion /var/svn
chmod -R g+w /var/svn/*/db

====Workflow====

We have implemented a neat workflow system for running shell commands on files. This is commonly needed when you have a bunch of files and you want to convert them to different formats or import them into databases. The workflow provides two commands, ''file-monitor''' and ''file-workflow'', which help with making processing scripts tremendously.

====MediaWiki hacking====
* MediaWiki extention for running SQL queries. Queries are stored in MediaWiki namespace. For examples, see [[Daily]] or [[Networks]].
* file_media() now works with Rotterdam media files

News

2009-03-31T21:20:24Z

Root:

===SVN===
We have finnaly managed to fix SVN permission problem. You need do something like to:
chgrp -R subversion /var/svn
chmod -R g+w /var/svn/*/db

===Workflow===

We have implemented a neat workflow system for running shell commands on files. This is commonly needed when you have a bunch of files and you want to convert them to different formats or import them into databases. The workflow provides two commands, ''file-monitor''' and ''file-workflow'', which help with making processing scripts tremendously.

===MediaWiki hacking===
* MediaWiki extention for running SQL queries. Queries are stored in MediaWiki namespace. For examples, see [[Daily]] or [[Networks]].
* file_media() now works with Rotterdam media files

MediaWiki:Monobook.css

2009-03-31T20:54:01Z

Root:

/* CSS placed here will affect users of the Monobook skin */

body {
background: white;
overflow: hidden;
}

#footer {
position: fixed;
bottom: 0px;
z-index: 100;
width: 100%;
display: none;
}

#content {
position: fixed;
top: 0;
/* bottom: 70px; */
overflow: auto;
left: 0;
right: 0;
bottom: 2px;
}

#firstHeading {
background: white;
position: fixed;
left: 7em;
right: 1em;
}

#bodyContent {
margin-top: 3.8em;
}

.wdbi-result { font-size: 90%; }
.wdbi-result td {
background-color: #eee;
}

.wdbi-result th {
background-color: #ddd;
}

#toc {
float: right;
margin: 0 0 1em 1em;
}

.wdbi-thumbnail {
max-width: 100px;
max-height: 100px;
}

.wdbi-query { display: none; }

/* make a few corners round, only supported by moz/firefox/other gecko browsers for now */
#p-cactions ul li, #p-cactions ul li a { -moz-border-radius-topleft: 0.6em; -moz-border-radius-topright: 0.6em; }
#content {
-moz-border-radius-topleft: 0.8em;
-moz-border-radius-bottomleft: 0.8em;
-webkit-border-radius-topleft: 0.8em;
-webkit-border-radius-bottomleft: 0.8em;
}
div.pBody {
-moz-border-radius-topright: 0.6em;
-moz-border-radius-bottomright: 0.6em;
-webkit-border-radius-topright: 0.6em;
-webkit-border-radius-bottomright: 0.6em;
border-left: 0;
}

MediaWiki:Monobook.css

2009-03-30T22:30:46Z

Root:

/* CSS placed here will affect users of the Monobook skin */

body {
background: white;
}

#footer {
position: fixed;
bottom: 0px;
z-index: 100;
width: 100%;
display: none;
}

#content {
position: fixed;
top: 0;
/* bottom: 70px; */
overflow: auto;
left: 0;
right: 0;
bottom: 2px;
}

#firstHeading {
background: white;
position: fixed;
left: 7em;
right: 1em;
}

#bodyContent {
margin-top: 3.8em;
}

.wdbi-result { font-size: 90%; }
.wdbi-result td {
background-color: #eee;
}

.wdbi-result th {
background-color: #ddd;
}

#toc {
float: right;
margin: 0 0 1em 1em;
}

.wdbi-thumbnail {
max-width: 100px;
max-height: 100px;
}

.wdbi-query { display: none; }

/* make a few corners round, only supported by moz/firefox/other gecko browsers for now */
#p-cactions ul li, #p-cactions ul li a { -moz-border-radius-topleft: 0.6em; -moz-border-radius-topright: 0.6em; }
#content { -moz-border-radius-topleft: 0.8em; -moz-border-radius-bottomleft: 0.8em; }
div.pBody { -moz-border-radius-topright: 0.6em; -moz-border-radius-bottomright: 0.6em; border-left: 0; }

MediaWiki:Monobook.css

2009-03-30T20:53:10Z

Root:

/* CSS placed here will affect users of the Monobook skin */

body {
background: white;
}

#footer {
position: fixed;
bottom: 0px;
z-index: 100;
width: 100%;
display: none;
}

#content {
position: fixed;
top: 0;
/* bottom: 70px; */
overflow: auto;
left: 0;
right: 0;
bottom: 4px;
}

#firstHeading {
background: white;
position: fixed;
width: 84%;
}

#bodyContent {
margin-top: 3.8em;
}

.wdbi-result { font-size: 90%; }
.wdbi-result td {
background-color: #eee;
}

.wdbi-result th {
background-color: #ddd;
}

.wdbi-thumbnail {
max-width: 100px;
max-height: 100px;
}

.wdbi-query { display: none; }

/* make a few corners round, only supported by moz/firefox/other gecko browsers for now */
#p-cactions ul li, #p-cactions ul li a { -moz-border-radius-topleft: 0.6em; -moz-border-radius-topright: 0.6em; }
#content { -moz-border-radius-topleft: 0.8em; -moz-border-radius-bottomleft: 0.8em; }
div.pBody { -moz-border-radius-topright: 0.6em; -moz-border-radius-bottomright: 0.6em; border-left: 0; }

MediaWiki:Monobook.css

2009-03-30T20:52:18Z

Root:

/* CSS placed here will affect users of the Monobook skin */

body {
background: white;
}

#footer {
position: fixed;
bottom: 0px;
z-index: 100;
width: 100%;
display: none;
}

#content {
position: fixed;
top: 0;
/* bottom: 70px; */
overflow: auto;
left: 0;
right: 0;
bottom: 0px;
}

#firstHeading {
background: white;
position: fixed;
width: 84%;
}

#bodyContent {
margin-top: 3.8em;
}

.wdbi-result { font-size: 90%; }
.wdbi-result td {
background-color: #eee;
}

.wdbi-result th {
background-color: #ddd;
}

.wdbi-thumbnail {
max-width: 100px;
max-height: 100px;
}

.wdbi-query { display: none; }

/* make a few corners round, only supported by moz/firefox/other gecko browsers for now */
#p-cactions ul li, #p-cactions ul li a { -moz-border-radius-topleft: 0.6em; -moz-border-radius-topright: 0.6em; }
#content { -moz-border-radius-topleft: 0.8em; -moz-border-radius-bottomleft: 0.8em; }
div.pBody { -moz-border-radius-topright: 0.6em; -moz-border-radius-bottomright: 0.6em; border-left: 0; }

Software issues

2009-03-26T17:01:16Z

Root:

Implement E.T. Phone Home protocol. Log to table etph.

Add WDBI lists to wiki.

Devise a way to trigger MediaWiki query refreshes.

Tracks workflow.

Photos workflow.

Videos workflow.

== Big screen display ==
* web (html+js) based
* what software to use for display website?
* maps
* thumbnail gallery
* vehicle status
* find a way to switch displays

== Vehicle ==
* frida-configure - set initial variables, such as macaddr
* log splitter - split piped logs by hour/day/expression etc
* frida-etph - get ETPH url with current vars; set vars to new values returned from url.
* variables manager - shell+perl API. vars are now stored files. perhaps shm would be better?
* fix gps logger to use standard dates in filenames
* frida-recycle - cleanup old files to free space

vars:
* battery level
* clock status
* position (how?)

MediaWiki:Query:MediaThumbnails

2009-03-26T16:57:03Z

Root:

SELECT xmlelement(name a, xmlattributes(url as href),
xmlelement(name img, xmlattributes(frida.icon_from_url(url) as src, 'wdbi-thumbnail' as class))
) as thumbnail
FROM frida.media
ORDER BY rectime desc
LIMIT 400

MediaWiki:Query:MediaThumbnails

2009-03-26T16:52:23Z

Root:

Media

2009-03-26T16:42:17Z

Root:

<query skin="plain">MediaThumbnails</query>

MediaWiki:Query:MediaThumbnails

2009-03-26T16:35:32Z

Root:

Software issues

2009-03-26T16:34:00Z

Root:

Implement E.T. Phone Home protocol. Log to table etph.

Add WDBI lists to wiki.

Devise a way to trigger MediaWiki query refreshes.

Tracks workflow.

Photos workflow.

Videos workflow.

== Vehicle ==
* frida-configure - set initial variables, such as macaddr
* log splitter - split piped logs by hour/day/expression etc
* frida-etph - get ETPH url with current vars; set vars to new values returned from url.
* variables manager - shell+perl API. vars are now stored files. perhaps shm would be better?
* fix gps logger to use standard dates in filenames
* frida-recycle - cleanup old files to free space

vars:
* battery level
* clock status
* position (how?)

Software issues

2009-03-26T02:07:33Z

Root:

Implement E.T. Phone Home protocol. Log to table etph.

Add WDBI lists to wiki.

Devise a way to trigger MediaWiki query refreshes.

Tracks workflow.

Photos workflow.

Videos workflow.

== Vehicle ==
* configurator - set initial variables, such as macaddr
* log splitter - split piped logs by hour/day/expression etc
* frida-etph - get ETPH url with current vars; set vars to new values returned from url.
* variables manager - shell+perl API. vars are now stored files. perhaps shm would be better?
* fix gps logger to use standard dates in filenames

vars:
* battery level
* clock status
* position (how?)

Software issues

2009-03-23T22:42:57Z

Root:

Implement E.T. Phone Home protocol. Log to table etph.

Add WDBI lists to wiki.

Devise a way to trigger MediaWiki query refreshes.

Tracks workflow.

Photos workflow.

Videos workflow.

Bicycle:
* configurator - set initial variables, such as macaddr
* log splitter - split piped logs by hour/day/expression etc
* frida-etph - get ETPH url with current vars; set vars to new values returned from url.
* variables manager - shell+perl API. vars are now stored files. perhaps shm would be better?

vars:
* battery level
* clock status
* position (how?)

MediaWiki:Query:MediaThumbnails

2009-03-23T22:41:47Z

Root:

SELECT xmlelement(name a, xmlattributes(url as href),
xmlelement(name img, xmlattributes(url as src, 'wdbi-thumbnail' as class))
) as thumbnail
FROM frida.media
ORDER BY rectime desc
LIMIT 40

MediaWiki:Monobook.css

2009-03-22T02:11:13Z

Root:

/* CSS placed here will affect users of the Monobook skin */

body {
background: white;
}

#footer {
position: fixed;
bottom: 0px;
z-index: 100;
width: 100%;
}

#content {
position: fixed;
top: 0;
bottom: 70px;
overflow: auto;
left: 0;
right: 0;

}

#firstHeading {
background: white;
position: fixed;
width: 84%;
}

#bodyContent {
margin-top: 3.8em;
}

.wdbi-result { font-size: 90%; }
.wdbi-result td {
background-color: #eee;
}

.wdbi-result th {
background-color: #ddd;
}

.wdbi-thumbnail {
max-width: 100px;
max-height: 100px;
}

.wdbi-query { display: none; }

/* make a few corners round, only supported by moz/firefox/other gecko browsers for now */
#p-cactions ul li, #p-cactions ul li a { -moz-border-radius-topleft: 0.6em; -moz-border-radius-topright: 0.6em; }
#content { -moz-border-radius-topleft: 0.8em; -moz-border-radius-bottomleft: 0.8em; }
div.pBody { -moz-border-radius-topright: 0.6em; -moz-border-radius-bottomright: 0.6em; border-left: 0; }

MediaWiki:Monobook.css

2009-03-22T02:10:39Z

Root:

/* CSS placed here will affect users of the Monobook skin */

body {
background: #ccc;
}

#footer {
position: fixed;
bottom: 0px;
z-index: 100;
width: 100%;
}

#content {
position: fixed;
top: 0;
bottom: 70px;
overflow: auto;
left: 0;
right: 0;

}

#firstHeading {
background: white;
position: fixed;
width: 84%;
}

#bodyContent {
margin-top: 3.8em;
}

.wdbi-result { font-size: 90%; }
.wdbi-result td {
background-color: #eee;
}

.wdbi-result th {
background-color: #ddd;
}

.wdbi-thumbnail {
max-width: 100px;
max-height: 100px;
}

.wdbi-query { display: none; }

/* make a few corners round, only supported by moz/firefox/other gecko browsers for now */
#p-cactions ul li, #p-cactions ul li a { -moz-border-radius-topleft: 0.6em; -moz-border-radius-topright: 0.6em; }
#content { -moz-border-radius-topleft: 0.8em; -moz-border-radius-bottomleft: 0.8em; }
div.pBody { -moz-border-radius-topright: 0.6em; -moz-border-radius-bottomright: 0.6em; border-left: 0; }

MediaWiki:Monobook.css

2009-03-22T02:09:07Z

Root:

News

2009-03-22T02:06:15Z

Root:

* MediaWiki extention for running SQL queries. Queries are stored in MediaWiki namespace. For examples, see [[Daily]] or [[Networks]].
* file_media() now works with Rotterdam media files

News

2009-03-22T02:05:54Z

Root:

* MediaWiki extention for running SQL queries. Queries are stored in MediaWiki namespace. For examples, see [[Daily]] or [[Networks]].
* file_media() now work on Rotterdam files

News

2009-03-22T02:04:01Z

Root: /* Saturday */

* MediaWiki extention for querying SQL database. Queries are stored in MediaWiki namespace. Fore examples, see [[Daily]] or [[Networks]].

News

2009-03-22T02:03:38Z

Root: Created page with '== Saturday == * MediaWiki extention for querying SQL database. Queries are stored in MediaWiki namespace. Fore examples, see Daily or Networks.'

== Saturday ==
* MediaWiki extention for querying SQL database. Queries are stored in MediaWiki namespace. Fore examples, see [[Daily]] or [[Networks]].

Main Page

2009-03-22T02:02:09Z

Root:

===New prototype series===
[[Frida V]] ★
[[Frida V/Box Parts List]] ★
[[Camera Control]] ★
[[Software issues]] ★
[http://www.ljudmila.org/~luka/featureserver/alt3.html?zoom=2&lat=0&lon=17.05078&layers=BT Cities]

=== Some more navigation ===
[[Special:AllPages|All Pages]] ★
[[Special:NewFiles|New Media]] ★
[[Special:Categories|Categories]] ★
[[Special:PopularPages|Popular Pages]] ★
[[Special:Statistics|Statistics]]
old [http://twiki.ljudmila.org/bin/view/Luka/FridaV Frida V. homepage]

=== News ===
{{:News}}

Main Page

2009-03-22T01:58:25Z

Root:

Main Page

2009-03-22T01:58:04Z

Root:

===Razvoj nove prototipne serije===
[[Frida V]] ★
[[Frida V/Box Parts List]] ★
[[Camera Control]] ★
[[Software issues]] ★
[http://www.ljudmila.org/~luka/featureserver/alt3.html?zoom=2&lat=0&lon=17.05078&layers=BT Cities]

=== Some more navigation ===
[[Special:AllPages|All Pages]] ★
[[Special:NewFiles|New Media]] ★
[[Special:Categories|Categories]] ★
[[Special:PopularPages|Popular Pages]] ★
[[Special:Statistics|Statistics]]
old [http://twiki.ljudmila.org/bin/view/Luka/FridaV Frida V. homepage]

MediaWiki:Query:Overview

2009-03-22T00:38:21Z

Root:

SELECT date, pings, positions, bssids, waypoints, tracks, media, pmedia,
xmlelement(name a, xmlattributes(city_url as href),city_url) as city
FROM frida.overview;

MediaWiki:Query:Overview

2009-03-22T00:37:20Z

Root:

SELECT date, pings, positions, bssids, waypoints, tracks, media, pmedia,
xmlelement(name a, xmlattributes(city_url as href)) as city
FROM frida.overview;

Daily

2009-03-22T00:20:03Z

Root:

ke?

{{MediaWiki:FlotWidget|overview}}

<query id="overview">Overview</query>

Daily

2009-03-22T00:16:49Z

Root:

{{MediaWiki:FlotWidget|overview}}

<query id=overview>Overview</query>

MediaWiki:FlotWidget

2009-03-22T00:16:05Z

Root:

MediaWiki:FlotWidget

2009-03-22T00:13:39Z

Root:

<div class="plot">
</div>
<script>
alert('whoa');
</script>

MediaWiki:FlotWidget

2009-03-22T00:13:22Z

Root: Created page with '<html> <div class="plot"> </div> <script> alert('whoa'); </script> </html>'

<html>
<div class="plot">
</div>
<script>
alert('whoa');
</script>

</html>

Daily

2009-03-22T00:12:18Z

Root:

{{MediaWiki:FlotWidget}}

<query>Overview</query>

MediaWiki:Query:Networks

2009-03-21T23:55:10Z

Root:

select ssids,
max as last,
count,
vehicles,
-- ips,
-- min,
bssid,
network.manufacturer(bssid)
from frida.network_ping_view
order by max desc

MediaWiki:Query:Networks

2009-03-21T23:49:24Z

Root:

select ssids,
max,
count,
vehicles,
ips,
min,
bssid,
network.manufacturer(bssid)
from frida.network_ping_view
order by max desc

Networks

2009-03-21T23:42:43Z

Root: Created page with '<query>Networks</query>'

<query>Networks</query>

MediaWiki:Query:Networks

2009-03-21T23:40:37Z

Root:

select *
from frida.network_ping_view

MediaWiki:Query:Networks

2009-03-21T23:39:28Z

Root:

select *
from network_ping_view

MediaWiki:Query:Networks

2009-03-21T23:39:10Z

Root: Created page with 'select * from network_ving_view'

select *
from network_ving_view

MediaWiki:Query:Vehicles

2009-03-21T23:36:25Z

Root:

select *
from frida.vehicle
order by vehicle_id

Frida V

2009-03-21T23:35:40Z

Root:

Frida V.
Luka Frelih
participatorna, globalna in javna akcija

Welcome to this new site! We'll have more content soon!

==Vehicles==
<query>Vehicles</query>

==Kaj je Frida V.?==

“FRIDA V.” (Free Ride Data Acquisiton Vehicle) je robustno in udobno kolo opremljeno za učinkovito raziskovanje in kartiranje javnih urbanih prostorov.
Nosi majhen računalnik z brezžičnim omrežnim vmesnikom, GPS sprejemnik, kamero z mikrofonom in baterije.

Udeleženec v projektu prevzame vlogo voznika in soustvarjalca digitalnih vsebin. Sistem upravlja in nadzira prek enostavnega vmesnika na krmilu kolesa.

Usklajen nabor programske in strojne opreme omogoča samodejno kartiranje odkritih brezžičnih računalniških omrežij, enostavno snemanje z lokacijo in ikono označenih posnetkov in priložnostno sinhroniziranje s strežnikom na internetu.

Raziskovalec lahko analizira zbrane podatke in naredi zemljevide raziskanega območja, ki predstavijo nevidna informacijska polja v njem.

Vpogled v zbrane podatke in posnetke, analize, zemljevide in zaključke lahko udeleženci in drugi dobijo na razstavi, pa tudi na spletni strani. Iz njih nastajajo karte brezžičnih omrežij in posnetkov, so pa tudi zametek - vhodni podatki - za bodoče proste zemljevide mest.

Tudi dokumentacija o strojni in programski opremi, razvita v sklopu projekta, je prosto dostopna na spletni strani. Frida V. je tako popolnoma prosta eksperimentalna platforma primerna za nadgradnje in predelave.

===Podstrani===
{{Special:PrefixIndex/{{BASEPAGENAME}}/}}

===Razvoj nove prototipne serije===
[[Frida V/Box Parts List]] ★
[[Camera Control]] ★
[[Software issues]] ★
[http://www.ljudmila.org/~luka/featureserver/alt3.html?zoom=2&lat=0&lon=17.05078&layers=BT Cities]

=== Some more navigation ===
[[Special:AllPages|All Pages]] ★
[[Special:NewFiles|New Media]] ★
[[Special:Categories|Categories]] ★
[[Special:PopularPages|Popular Pages]] ★
[[Special:Statistics|Statistics]]

===Slikovno gradivo===
old [http://twiki.ljudmila.org/bin/view/Luka/FridaV Frida V. homepage]

[http://ljudmila.org/~luka/fridazadeviceart/ 6 nice pictures, most from New York]

[http://ljudmila.org/~luka/frida/fridav-photo-kolaz.jpg photo collage - bike photos from all around]

[http://ljudmila.org/~luka/frida/photo/ photo galleries from frida missions]

[http://ljudmila.org/~luka/fridav-buildup how to mount frida to a bicycle fotostrip]

[http://ljudmila.org/~luka/frida/ many files, also everything recorded on bikes and the scripts]

[http://ljudmila.org/~luka/frida-challenge/ some videos from ljubljana]

[http://ljudmila.org/~luka/frida/maptryone.png map of nyc tracks]

[http://ljudmila.org/~luka/frida-maptest/ some early map tests with slithy] and [http://ljudmila.org/~luka/frida-maptest/slithy-20030706/rafcollage.svg svg collage of raf aerial photos of ww2 rotterdam]

[http://ljudmila.org/~luka/frida-v/ not much except illustration in big tiffs]

Courtesy of flickrers:
http://www.flickr.com/photos/ajturner/879159309/
http://www.flickr.com/photos/chrisfleming/823206030/
http://www.flickr.com/photos/chrisfleming/823204544/
http://www.flickr.com/photos/lapetiteclaudine/58764356/
http://www.flickr.com/photos/lapetiteclaudine/58764354/
http://www.flickr.com/photos/lapetiteclaudine/58764352/

=== Frida V for Istanbul ===

[[Frida V/USB Parts List]]

=== Idea: [http://www.openstreetmap.org/ OSM] control panel ===

Arduino controlling:
*Nokia 3310 display
*2 analog knobs (key, value)
*4 buttons (start, stop, point, voicerecord)
*2 leds (network, gps)

MediaWiki:Query:Vehicles

2009-03-21T23:34:58Z

Root: Created page with 'select * from frida.vehicle'

select *
from frida.vehicle

MediaWiki:Monobook.css

2009-03-21T23:26:40Z

Root:

MediaWiki:Query:Media

2009-03-21T23:26:02Z

Root:

SELECT rectime,type,icon,
xmlelement(name a, xmlattributes(url as href), url) as link
FROM frida.media
order by rectime desc

MediaWiki:Query:MediaThumbnails

2009-03-21T23:25:28Z

Root:

SELECT xmlelement(name a, xmlattributes(url as href),
xmlelement(name img, xmlattributes(url as src, 'wdbi-thumbnail' as class))
) as thumbnail
FROM frida.interesting_media
ORDER BY rectime desc
LIMIT 40