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?
Hi!
2009/1/20 Ankuj Gupta ankuj2004@gmail.com:
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]]
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@gmail.com wrote:
Hi!
2009/1/20 Ankuj Gupta ankuj2004@gmail.com:
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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikipedia-l
wikipedia-l@lists.wikimedia.org