Last modified: 2011-06-24 17:10:47 UTC
It can be helpful, to find pages which links to a specific language or language and title. (like iwbacklinks, but with the langlinks table) prefix: lbl * lbllang * lbltitle * lblcontinue * lbllimit * lblprop with lllang|lltitle (default) and url Thanks.
-- -- Track interlanguage links -- CREATE TABLE /*_*/langlinks ( -- page_id of the referring page ll_from int unsigned NOT NULL default 0, -- Language code of the target ll_lang varbinary(20) NOT NULL default '', -- Title of the target, including namespace ll_title varchar(255) binary NOT NULL default '' ) /*$wgDBTableOptions*/; CREATE UNIQUE INDEX /*i*/ll_from ON /*_*/langlinks (ll_from, ll_lang); CREATE INDEX /*i*/ll_lang ON /*_*/langlinks (ll_lang, ll_title); It seems we're probably missing an index or 2 to be able to do do all these possible combinations nicely... Though, looking at the IWBacklinks module, if you're wanting to filter on title, you've got to provide a prefix (in this case language) Probably not going to be that bad, by putting some common restrictions
Don't think this needs to block. I'll look at it maybe tomorrow and then will know
r88047 and it's followups
