Thanx for the help. I was able to retrieve the baclinks count.
Ankuj
On Wed, Jan 21, 2009 at 2:57 PM, Petr Kadlec <petr.kadlec(a)gmail.com> wrote:
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]]
_______________________________________________
Wikipedia-l mailing list
Wikipedia-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikipedia-l