Hi!
2009/1/20 Ankuj Gupta <ankuj2004(a)gmail.com>om>:
I have used the query
Select count(*) from pagelinks where pagelinks.pl_from=page.page_id;
But the results obtained from this query is diff as obtained from the
api.What i get is that pagelinks store forward link from a page not the
backward links(i may be wrong).Why so happens?
As I have told you already
(
http://lists.wikimedia.org/pipermail/wikipedia-l/2009-January/030982.html),
you need to match on pl_namespace and pl_title, if you want to search
for backlinks, not pl_from (which is used to search for forward links,
as its title suggests).
And, Wikipedia-L is not the best mailing list for this sort of
questions. Some technical list like mediawiki-l
(
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l) would be
better.
-- [[cs:User:Mormegil | Petr Kadlec]]