Re: [Connotea-code-devel] about tags

[Martin F. <ma...@ne...>]

Hi Marko,

Just responding to the count discrepancy at the moment:

Marko Sepp=E4nen wrote:
> I tried following, but they weren't quite what I was looking for:
> http://www.connotea.org/data/tags/tag/memory (gives only count details =
and=20
> strangely this tells that postcount is 229, when site search tells ther=
e's=20
> 809 posts)

There are 229 public posts. I confirmed it in the database.

mysql> select tag_id from tag where name =3D 'memory';
+--------+
| tag_id |
+--------+
|     13 |
+--------+
1 row in set (0.00 sec)

mysql> select count(*) from user_bookmark ub left join user_bookmark_tag=20
ubt on (ubt.user_bookmark =3D ub.user_bookmark_id) where ub.private =3D 0=
=20
and ub.private_gang is null and ub.private_until is null and ubt.tag =3D =
13;
+----------+
| count(*) |
+----------+
|      229 |
+----------+
1 row in set (0.04 sec)

There are actually 16 more that are private in some way.

mysql> select count(*) from user_bookmark_tag where tag =3D 13; +--------=
--+
| count(*) |
+----------+
|      245 |
+----------+
1 row in set (0.00 sec)

If you type memory in the search box that is a full text search on lots=20
of fields, not just a tag search, so you'll get more (I also get 809).

I think you may have led me to a bug of some kind though - the page
http://www.connotea.org/tag/memory?num=3D1000
...says 202 at the bottom but there are 229 instances of "Posted by" on=20
the page as found in grep. That can't be right. I'll examine it tomorrow.

Martin