Wikipedia talk:Disambiguation pages with links

This page was generated using the following SQL query (plus a bit of spreadsheet manipulation):

 SELECT cur1.cur_title, COUNT(*) as co FROM cur cur1, links links1, links links2, cur cur2
 WHERE links2.l_from=cur2.cur_title AND cur2.cur_namespace=0
 AND links2.l_to = cur1.cur_id
 AND links1.l_from="Wikipedia:Links_to_disambiguating_pages"
 AND links1.l_to = cur1.cur_id
 GROUP BY cur1.cur_title ORDER BY co DESC LIMIT 101

Enchanter 02:25 Feb 8, 2003 (UTC)

---

Remove from this list? Isn't this list auto generated? And doesn't this list link to other lists, etc.? Sorry for my confusion, still getting started. -- Bobdobbs1723

---

No, this list is not auto-generated. Enchanter made it, using the Search Database feature (unfortunately he did not say with which search, otherwise I would have liked to re-do the list, to get the items on which have a somewhat lower count or which got links to them recently). The pages that are being checked here, are those that appear on Wikipedia:Links to disambiguating pages, so they should be disambiguation pages; if they're not (but I think I have checked them all), you should remove them both there and from that page. By the way, if you check the 'history' of this page, you can see that we've gone quite some end already in getting rid of these... Andre Engels

P.S.: I have added your pseudonym to your remark, it makes it easier for people to talk to you. As for your apology: Dumb is not he who does not know, but he who does not learn.

---

The LMS page is listed on the as having a staggering 978 links. However, virtually all of these are not from the article namespace and therefore link to Larry's page. Should we just redirect this page to there? Jeronimo

It's a good question - I certainly would not want to take up that one myself, nor advise anyone else to do it. An alternative might be to only do those links that are from the main namespace, and then consider that one done. In one or two main edits (that is, redoing the search to fill up the page again), I (if I am the one to do it) will probably restrict the search to the main namespace only anyway - there are too many articles that are linked from 'Talk' pages just as being examples of pages that are disambiguated or need disambiguation. Andre Engels

Good idea. I think I already moved all LMS occurences from the article-namespace, except when intended to be a link to this page (acronym) or really being about LMS. Most of the other pages also have many links only from talk or wikipedia pages. Jeronimo

---

I have made a new search that only searches the main namespace, because on the Talk: and User: namespaces sometimes a disambiguation page is linked to because it is a disambiguation page and such links of course do not need to be disambiguated. The new search was:

 SELECT cur1.cur_title, COUNT(*) as co FROM cur cur1, links links1, links links2, cur cur2
 WHERE links2.l_from=cur2.cur_title AND cur2.cur_namespace=0
 AND links2.l_to = cur1.cur_id
 AND (links1.l_from="Wikipedia:Links_to_disambiguating_pages"
  OR links1.l_from="Wikipedia:Multiple-place_names")
 AND links1.l_to = cur1.cur_id
 GROUP BY cur1.cur_title ORDER BY co DESC LIMIT 101

---

Can't remove things from the links page after doing the edits, as it is protected.

Thanks for the notice - unprotecting does not work, unfortunately. I hope the problem will soon be solved nevertheless. Andre Engels 23:26 Oct 3, 2002 (UTC)

It's not presently protected. Did anyone else touch it? --Brion 23:46 Oct 3, 2002 (UTC)

Probably my unprotect worked without me realizing it. Anyway, it should be okay now.Andre Engels 07:53 Oct 4, 2002 (UTC)

---

There is one left on "orange". I don't know where this one should link to, so I've left it alone. Can anyone help? Sannse 17:02 Jan 7, 2003 (UTC)

---

Is it acceptable to edit user pages to fix links to disambiguation pages? I don't want to offend if this is a no-no Sannse 16:32 Jan 22, 2003 (UTC)

yup, it's fine. -- Tarquin 17:06 Jan 22, 2003 (UTC)

Thanks Tarquin. I'll carry on once things are moving again round here. Sannse 17:43 Jan 22, 2003 (UTC)

---

The Prince page is not really a disambiguation page, just a list of definitions of the various ways a prince can be a prince, along with a disambiguation block re: Prince Rogers Nelson and The Prince. However, since people are likely to keep linking to [[Prince]] when they mean [[Prince Rogers Nelson]], I'm inclined to leave it on the Wikipedia:Links_to_disambiguating_pages list so that links to it get listed here and reviewed every now and then.... what say others? Catherine 03:00 Mar 25, 2003 (UTC)