#
#
# patch "wiki/ProjectsUsingMonotone.mdwn"
#  from [f7b8db9a7c05b8b63002bb466af5202a6166a7ed]
#    to [f039c504719610b49429887cfb68b037391539c8]
#
============================================================
--- wiki/ProjectsUsingMonotone.mdwn	f7b8db9a7c05b8b63002bb466af5202a6166a7ed
+++ wiki/ProjectsUsingMonotone.mdwn	f039c504719610b49429887cfb68b037391539c8
@@ -11,41 +11,42 @@ Actually, it is better to show *database
 (sorted by revisions*files)
 
 [[!table data="""
-|<#5686b8> Project |<#5686b8> notes |<#5686b8> revisions |<#5686b8> files |<#5686b8> commits/month |<#5686b8> First commit |<#5686b8> Last update |<#5686b8> Other projects in database |
-| [Xaraya](http://www.xaraya.com/)|[#1 1]|±33900 |±58300 | 552 | 2002-09-28 | 2007-10-14 | |
-| [OpenEmbedded](http://openembedded.org/) | |±23000 |±14600 | 754 | 2005-06-30 | 2008-01-30 | [NSLU2-Linux](http://www.nslu2-linux.org/) |
-| [Pidgin (formerly Gaim)](http://pidgin.im/) | | ~23900 | ±6500 | 250 | 2000-03-23 | 2008-01-30 | |
-| [monotone](http://venge.net/monotone) | [#2 2] |~13800 | ~7740 | 258 | 2003-09-04 | 2008-01-30 | [Botan](http://botan.randombit.net) |
-| [Remobo](http://www.remobo.com/) | |±1415 |±39445 | ~30 | 2005-11-23 | 2008-03-16 | |
-| [Trig](http://trig.com/) | [#3 3] | ±7948 | ±2995 | ±637 | 2006-05-09 | 2007-01-30 | |
-| [ConquerSpace](http://www.conquer-space.net/) | | 2392 | 4449 | ~88 | 2005-11-26 | 2008-01-30 | private projects (total ~6717 revisions) |
-| [Ada-France](http://www.ada-france.org/article130.html) | | ~1390 | ~1270 | 74 | 2006-07-14 | 2008-01-30 | [Lovelace OS](http://www.lovelace.fr/) |
-| [GoTT](http://gott.evilhackerdu.de/)| | ±1716 | ±800 | ±100 | 2005-07-08 | 2007-01-13 | |
-| [Ajisai](http://www.randombit.net/projects/ajisai/monotone.html) | [#2 2]| 770 | 1118 | 45 | 2006-05-18 | 2007-10-14 | [Botan](http://botan.randombit.net) |
-| [Syndie](http://syndie.i2p.net/monotone_howto.html)| | 676 | 696 | 55 | 2006-10-12 | 2007-10-14 | |
-| [ATF](http://www.NetBSD.org/~jmmv/atf/)| | 504 | 409 | ±60 | 2007-06-25 | 2008-02-06 | |
-| [Dropbear SSH](http://matt.ucc.asn.au/dropbear/)| |±250 | ±600 | few | | | |
-| [guitone](http://guitone.thomaskeller.biz)|[#2 2]| 640 | 214 | 30 | 2006-04-06 | 2008-01-30 | |
-| [CTWM](http://ctwm.free.lp.se)| |±300 | ±350  |low traffic| | | |
-| [Pantomime](http://www.collaboration-world.com/pantomime/) and [GNUMail](http://www.collaboration-world.com/gnumail/)| | 150 | 781| 8 | 2006-04-29 | 2007-10-14 | |
-| [Bonsai](http://www.bonsai.com/wiki/index.php/Monotone_Distributed_Version_Control)|[#2 2],[#5 5]| 87 | 398 | 4 | 2005-12-18 | 2007-10-23 | |
-| [MetaTheme](http://www.metatheme.org/development.php)| | ? | ? | ? | | 2006-09-26 | |
-| [Clarens](http://clarens.sourceforge.net)|[#4 4]| ? | ? | ? | 2005-08-09 | 2006-12-13 | |
-| [NetCrypto](http://www.netcrypto.org/index-FileAccess.html)| | ? | ? | ? | ? | ? | |
-| [Peter Todd's Art Projects](http://petertodd.org/art/source-code)| | ±1500 | ? | ±100 | 2007-05-01 | 2007-09-09 | |
+Project |notes |revisions |files |commits/month |First commit |Last update |Other projects in database |
+[Xaraya](http://www.xaraya.com/)                                                                                     |1  |±33900|±58300| 552|2002-09-28|2007-10-14|
+[OpenEmbedded](http://openembedded.org/)                                                                             |   |±23000|±14600| 754|2005-06-30|2008-01-30|[NSLU2-Linux][]
+[Pidgin (formerly Gaim)](http://pidgin.im/)                                                                          |   |~23900| ±6500| 250|2000-03-23|2008-01-30|
+[monotone](http://venge.net/monotone)                                                                                |2  |~13800| ~7740| 258|2003-09-04|2008-01-30|[Botan][]
+[Remobo](http://www.remobo.com/)                                                                                     |   | ±1415|±39445| ~30|2005-11-23|2008-03-16|
+[Trig](http://trig.com/)                                                                                             |3  | ±7948| ±2995|±637|2006-05-09|2007-01-30|
+[ConquerSpace](http://www.conquer-space.net/)                                                                        |   |  2392|  4449| ~88|2005-11-26|2008-01-30|private projects (total ~6717 revisions)
+[Ada-France](http://www.ada-france.org/article130.html)                                                              |   | ~1390| ~1270|  74|2006-07-14|2008-01-30|[Lovelace OS][]
+[GoTT](http://gott.evilhackerdu.de/)                                                                                 |   | ±1716|  ±800|±100|2005-07-08|2007-01-13|
+[Ajisai](http://www.randombit.net/projects/ajisai/monotone.html)                                                     |2  |   770|  1118|  45|2006-05-18|2007-10-14|[Botan][]
+[Syndie](http://syndie.i2p.net/monotone_howto.html)                                                                  |   |   676|   696|  55|2006-10-12|2007-10-14|
+[ATF](http://www.NetBSD.org/~jmmv/atf/)                                                                              |   |   504|   409| ±60|2007-06-25|2008-02-06|
+[Dropbear SSH](http://matt.ucc.asn.au/dropbear/)                                                                     |   |  ±250|  ±600| few|          |          |
+[guitone](http://guitone.thomaskeller.biz)                                                                           |2  |   640|   214|  30|2006-04-06|2008-01-30|
+[CTWM](http://ctwm.free.lp.se)                                                                                       |   |  ±300|  ±350|low traffic|   |          |
+[Pantomime](http://www.collaboration-world.com/pantomime/) and [GNUMail](http://www.collaboration-world.com/gnumail/)|   |   150|   781|   8|2006-04-29|2007-10-14|[GNUMail](http://www.collaboration-world.com/gnumail/)
+[Bonsai](http://www.bonsai.com/wiki/index.php/Monotone_Distributed_Version_Control)                                  |2,5| 87   | 398  |   4|2005-12-18|2007-10-23|
+[MetaTheme](http://www.metatheme.org/development.php)                                                                |   | ?    | ?    | ?  |          |2006-09-26|
+[Clarens](http://clarens.sourceforge.net)                                                                            |4  | ?    | ?    | ?  |2005-08-09|2006-12-13|
+[NetCrypto](http://www.netcrypto.org/index-FileAccess.html)                                                          |   | ?    | ?    | ?  |?         |?         |
+[Peter Todd's Art Projects](http://petertodd.org/art/source-code)                                                    |   | ±1500| ?    |±100|2007-05-01|2007-09-09|
 """ ]]
- 1. [[Anchor(1)]]Aggregate number for Xaraya core, languages, themes and modules (4 different databases).
- 1. [[Anchor(2)]]Not counting private branches
- 1. [[Anchor(3)]]Only the main branch of the main app
- 1. [[Anchor(4)]]Refuses connections; server down?
- 1. [[Anchor(5)]]mtn.bonsai.com
+Notes:
+ 1. Aggregate number for Xaraya core, languages, themes and modules (4 different databases).
+ 1. Not counting private branches
+ 1. Only the main branch of the main app
+ 1. Refuses connections; server down?
+ 1. mtn.bonsai.com
 
 ## Tips
 
 To find the earliest revision in a database, use this query:
 
-{{{mtn db execute 'select value from revision_certs where name="date" order by value limit 1'}}}
+    mtn db execute "SELECT value FROM revision_certs WHERE name='date' ORDER BY value LIMIT 1;"
 
 To find the latest revision in a database, use the same query in descending order:
 
+    mtn db execute "SELECT value FROM revision_certs WHERE name='date' ORDER BY value DESC LIMIT 1;"
-{{{mtn db execute 'select value from revision_certs where name="date" order by value desc limit 1'}}}