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