https://bugzilla.wikimedia.org/show_bug.cgi?id=59442
Web browser: ---
Bug ID: 59442
Summary: DBQ-171 Bug In wachlist Query
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: Unprioritized
Component: Database Queries
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
This issue was converted from https://jira.toolserver.org/browse/DBQ-171.
Summary: Bug In wachlist Query
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <h...@online.de>
-------------------------------------------------------------------------------
From: reza <reza.ene...@gmail.com>
Date: Thu, 08 Dec 2011 00:06:27
-------------------------------------------------------------------------------
I wanted to list fa.wiki notifications and I used these queries and I had
different answers.
SELECT Wl_title,Count(Wl_title),ts_wl_user_touched_cropped FROM watchlist
JOIN page ON page_title=Wl_title WHERE page_len>0 AND page_is_redirect=0 and
Wl_namespace=0 GROUP BY Wl_title ORDER BY count(Wl_title) DESC LIMIT 20;
SELECT Wl_title,Count(Wl_title) FROM watchlist JOIN page ON
page_title=Wl_title WHERE page_len>0 AND page_is_redirect=0 and Wl_namespace=0
GROUP BY Wl_title ORDER BY count(Wl_title) DESC LIMIT 20;
all of the Count numbers are different!
also according to
http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/tables.sql?view=markup
and
http://www.mediawiki.org/wiki/Manual:Watchlist_table
it have wl_user and wl_notificationtimestamp Fields but with describe command
it shows ts_wl_user_touched_cropped !
also none of my result are not equal with (page count)
http://toolserver.org/~mzmcbride/watcher/?db=fawiki_p
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
