Hi! 2009/1/20 Ankuj Gupta <[email protected]>: > 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikipedia-l
