From: reza <reza.energy@gmail.com>

Date: Thu, 08 Dec 2011 00:12:52

also for

SELECT Wl_title,Count(Wl_title) FROM watchlist JOIN page ON page_title=Wl_title WHERE page_title="فرح_پهلوی" AND Wl_namespace=0 AND page_len>0 GROUP BY Wl_title;

and http://toolserver.org/~mzmcbride/watcher/?db=fawiki_p&titles=%D9%81%D8%B1%D8%AD_%D9%BE%D9%87%D9%84%D9%88%DB%8C

has different answers

From: Hoo man <hoo@online.de>

Date: Thu, 08 Dec 2011 22:46:24

In the query within the comment you forgot AND page_namespace=0
So the right query is:

SELECT Wl_title,Count(Wl_title) FROM watchlist JOIN page ON page_title=Wl_title WHERE page_title="فرح_پهلوی" AND Wl_namespace=0 AND page_len>0 AND page_namespace=0 GROUP BY Wl_title;

Which should be equal to

SELECT Wl_title,Count(Wl_title) FROM watchlist WHERE wl_title = 'فرح_پهلوی' AND wl_namespace = 0;

I think you did the same mistake in the queries within the description, but I don't have enough time to test that atm... It would be fine, if you could tell, if it's the solution.

From: reza <reza.energy@gmail.com>

Date: Thu, 08 Dec 2011 23:15:35

thank you now it is correct but why Fields are not the same as help and trunk?

From: Hoo man <hoo@online.de>

Date: Thu, 08 Dec 2011 23:21:34

Great ![][1]

The toolserver tables don't include all information the "real" databases do, mostly because of privacy reasons. So in the given example the timestamp is cropped so that only year, month and day can be seen.

[1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif

From: DaB. <dab@ts.wikimedia.org>

Date: Thu, 08 Dec 2011 23:27:12

Please notice that ts_wl_user_touched_cropped is not a cropped wl_notificationtimestamp, but a cropped user_touched (the watchlist-table is joined with the user-table for that view).

From: reza <reza.energy@gmail.com>

Date: Thu, 08 Dec 2011 23:58:20

Thank you

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: hoo@online.de
CC list: reza.energy@gmail.com, hoo@online.de, wikimedia-bugzilla@dabpunkt.eu