User:WhatamIdoing/Med redirects

Talks pages in Category:Medicine articles by importance where the subject-space page is a redirect. Data as of 23:05, 15 August 2009 (UTC).

Sample query (for reference).

SELECT
  pg1.page_title
FROM page AS pg1
JOIN categorylinks
ON cl_from = pg1.page_id
WHERE pg1.page_namespace = 1
AND cl_to = 'Top-importance_medicine_articles'
AND EXISTS (SELECT
              1
            FROM page AS pg2
            WHERE pg2.page_title = pg1.page_title
            AND pg2.page_namespace = 0
            AND pg2.page_is_redirect = 1);

Mid-importance medicine articles

break

1. Talk:Autistic_savant
2. Talk:Cryptogenic_organizing_pneumonitis
3. Talk:Cystercosis
4. Talk:Breast_implant_controversy
5. Talk:Dermatological_lesions
6. Talk:Euphoria_(emotion)
7. Talk:Pyogenic_osteomyelitis
8. Talk:Macrocytic_anaemia
9. Talk:Sulfhemoglobinaemia
10. Talk:Myleofibrosis
11. Talk:Hepatitis_G
12. Talk:Malabsorption_syndrome
13. Talk:Aneisokonia
14. Talk:Colonic_polyps
15. Talk:Prevention_(medical)
16. Talk:Hyperlipemia
17. Talk:Diffuse_lymphoma
18. Talk:Soiling
19. Talk:Surrogate_markers
20. Talk:Grief_therapy
21. Talk:Hypoadrenia
22. Talk:Creatinine_clearance
23. Talk:Paroxysm
24. Talk:Nut_allergy
25. Talk:Bacterial_disease
26. Talk:Intra-axial_hematoma
27. Talk:Specificity_(tests)
28. Talk:Sensitivity_(tests)
29. Talk:Cervical_dysplasia
30. Talk:Temporal_arteritis
31. Talk:Test_sensitivity
32. Talk:Biological_inheritance
33. Talk:Medical_prefixes,_suffixes,_and_combining_forms
34. Talk:Perinatal_period
35. Talk:Catecholamine_reuptake_inhibitor
36. Talk:Genetics_and_violence
37. Talk:Jactatio_capitas_nocturna
38. Talk:Wheat_allergies
39. Talk:Cortef
40. Talk:Dysphasia
41. Talk:Dyspraxia
42. Talk:Sudden_antenatal_death_syndrome
43. Talk:Symptomatic
44. Talk:Chronic_monocytic_leukemia
45. Talk:Photoallergy
46. Talk:Septate_uterus
47. Talk:Small_cell_lymphoma
48. Talk:Core_temperature
49. Talk:AV_reentrant_tachycardia
50. Talk:Disorder_(medicine)
51. Talk:Parathyroid_cancer
52. Talk:File_drawer_problem
53. Talk:Evacuation_of_retained_products_of_conception
54. Talk:Pinealocytoma
55. Talk:Executive_system
56. Talk:Seborrheic_keratoses
57. Talk:Muscular_disease
58. Talk:Novorapid
59. Talk:Oculocephalic_reflex

here

1. Talk:Gallium_imaging
2. Talk:Rebound_insomnia
3. Talk:Remission_(medicine)
4. Talk:Reference_values
5. Talk:Cyclothymic_personality
6. Talk:Cancer_stem_cells
7. Talk:Body_fat_meter
8. Talk:Brodmann_area_17
9. Talk:Primary_visual_cortex
10. Talk:Senses
11. Talk:Miller_Fisher_syndrome
12. Talk:Interictal
13. Talk:Extra-axial_hemorrhage
14. Talk:Malignant_peripheral_nerve_sheath_tumour
15. Talk:Arachnoid_cysts
16. Talk:Behcet's_disease
17. Talk:Bloch-Sulzberger_syndrome
18. Talk:Causalgia
19. Talk:Cerebral_gigantism
20. Talk:Chiari_malformation
21. Talk:Cumulative_trauma_disorder
22. Talk:Cytomegalovirus_infection
23. Talk:Dejerine-Sottas_disease
24. Talk:Diffuse_sclerosis
25. Talk:Gerstmann's_syndrome
26. Talk:Globoid_cell_leukodystrophy
27. Talk:HTLV-1_associated_myelopathy
28. Talk:Hallervorden-Spatz_disease
29. Talk:Herpes_zoster_oticus
30. Talk:Hypercortisolism
31. Talk:Infantile_spasms
32. Talk:Kinsbourne_syndrome
33. Talk:Klippel_Feil_syndrome
34. Talk:Learning_disabilities
35. Talk:Lewy_body_dementia
36. Talk:Mucopolysaccharidoses
37. Talk:Myotubular_myopathy
38. Talk:Overuse_syndrome
39. Talk:Paraneoplastic_disease
40. Talk:Pervasive_developmental_disorders
41. Talk:Polio
42. Talk:Prion_diseases
43. Talk:Pseudotumor_cerebri
44. Talk:Reflex_sympathetic_dystrophy_syndrome
45. Talk:Refsum_disease
46. Talk:Repetitive_stress_injury
47. Talk:Shingles
48. Talk:Spinal_cord_tumors
49. Talk:Stiff-person_syndrome
50. Talk:Todd's_paralysis
51. Talk:Transmissible_spongiform_encephalopathies
52. Talk:Wallenberg's_syndrome
53. Talk:Wallenberg_syndrome

breaks

1. Talk:Anterior_cingulate
2. Talk:Anterior_lobe
3. Talk:Anterior_nuclear_group
4. Talk:Apneustic_centre
5. Talk:Brodmann_area_1
6. Talk:Brodmann_area_2
7. Talk:Brodmann_area_3
8. Talk:Brodmann_area_41
9. Talk:Brodmann_area_42
10. Talk:Central_nucleus
11. Talk:Cerebellar_hemispheres
12. Talk:Cerebellar_nuclei
13. Talk:Cornu_ammonis
14. Talk:Cranial_nerve_nuclei
15. Talk:Crus_cerebri
16. Talk:Dopamine_system
17. Talk:Facial_nerve_nucleus
18. Talk:Indusium_griseum
19. Talk:Inferior_temporal_cortex
20. Talk:Lateral_geniculate_body
21. Talk:Mammillary_bodies
22. Talk:Medial_geniculate_body
23. Talk:Medial_nucleus
24. Talk:Medullary_pyramids
25. Talk:Mesencephalic_duct
26. Talk:Motor_nucleus_for_the_trigeminal_nerve
27. Talk:Myenteric_plexus
28. Talk:Neopallium
29. Talk:Nucleus_lentiformis
30. Talk:Paraventricular_nucleus
31. Talk:Pneumotactic_centre
32. Talk:Posterior_lobe
33. Talk:Primary_sensory_cortex
34. Talk:Primary_somatosensory_cortex
35. Talk:Pyramidal_tract
36. Talk:Retrosplenial_cortex
37. Talk:Serotonin_system
38. Talk:Subgenual_area_25
39. Talk:Submucosal_plexus
40. Talk:Superior_salivatory_nucleus
41. Talk:Tectum
42. Talk:Telencephalon
43. Talk:Tuberomamillary_nucleus
44. Talk:Ventral_posterior_lateral_nucleus
45. Talk:Ventral_posterior_medial_nucleus
46. Talk:Ventral_tegmental_area
47. Talk:Senile
48. Talk:Epithelial_hyperplasia
49. Talk:Sexual_infantilism
50. Talk:Acneiform_eruptions
51. Talk:Cherry_angiomas
52. Talk:Molecular_pathology
53. Talk:Shy-Drager_syndrome
54. Talk:Multiple_osteochondromatosis
55. Talk:Lichen_planus-lupus_erythematosus_overlap_syndrome
56. Talk:Flu-like_syndrome
57. Talk:Cutaneous_columnar_cysts
58. Talk:Clinical_latency
59. Talk:Palmoplantar_pustulosis
60. Talk:Cronkhite–Canada_syndrome
61. Talk:Experientia_docet
62. Talk:Minimal_incision
63. Talk:Nonne-Milroy-Meige_syndrome
64. Talk:Miliaria_rubra
65. Talk:Abdominal_fat
66. Talk:Nitrous_oxide_50%-oxygen_50%
67. Talk:Anti-aging
68. Talk:Primary_hyperlipoproteinemia

Low-importance medicine articles

1. Talk:Brain_zaps
2. Talk:Bihilar_lymphadenopathy
3. Talk:Oxygen_intoxication
4. Talk:Undergraduate_Medicine_&_Health_Sciences_Admission_Test
5. Talk:Hemodiafiltration
6. Talk:Visual_evoked_potential
7. Talk:CIOMS_Guidelines
8. Talk:Duke_University_Medical_Center
9. Talk:Blastocystis_hominis
10. Talk:Ketostix
11. Talk:Montezuma's_Revenge_(illness)
12. Talk:Wireless_capsule_endoscopy
13. Talk:Port-a-Cath
14. Talk:Phycomycosis
15. Talk:Hereditary_factors_in_childhood_obesity
16. Talk:Electrical_devices_in_alternative_medicine
17. Talk:Comprehensive_Care_Management
18. Talk:Arterial_blood_gas_sampling
19. Talk:Amoebic_meningitis
20. Talk:Aspartylglycosaminuria
21. Talk:MEF2A
22. Talk:Nursing_informatics
23. Talk:BTCP
24. Talk:Ulysses_contract
25. Talk:Sulzberger_Institute_for_Dermatologic_Education
26. Talk:C_syndrome
27. Talk:EGBUS
28. Talk:Detectable_warning
29. Talk:Kugelberg-Welander_disease
30. Talk:Macrophage_colony-stimulating_factor_receptor
31. Talk:Canal_of_Hering
32. Talk:Veno-occlusive_disease
33. Talk:Whitehead_acne
34. Talk:Class_switch_recombination
35. Talk:OptiMedica
36. Talk:Healix
37. Talk:Acatalasemia
38. Talk:Axokine
39. Talk:Werdnig-Hoffman_disease
40. Talk:TMC-278
41. Talk:SMA_syndrome
42. Talk:Scissors_gait
43. Talk:Striatonigral_degeneration
44. Talk:Pachyonychia
45. Talk:Neurolysis
46. Talk:DynaMed
47. Talk:Bassen-Kornzweig_syndrome
48. Talk:Cordoma
49. Talk:Clyster
50. Talk:Emergency_medicine_in_France
51. Talk:Dalrymple_sign
52. Talk:Kikuchi-Fujimoto_disease
53. Talk:Brittle_nails
54. Talk:Ocular_prosthetic
55. Talk:Anti_CCP_antibody
56. Talk:Icterus_(medicine)
57. Talk:Fahr's_disease
58. Talk:Hirudotherapy
59. Talk:Antiphospholipid-Antibody_Syndrome_(APL)
60. Talk:Gerson_therapy
61. Talk:Gero-Informatics
62. Talk:Cteph
63. Talk:Differin
64. Talk:Heart_tumor
65. Talk:Hemorrhagic_disease_of_newborn
66. Talk:Brodie's_abscess
67. Talk:Bedrest
68. Talk:Contrast_sensitivity
69. Talk:Naegeli_syndrome
70. Talk:Master_of_Physician_Assistant_Studies
71. Talk:Novalis_radiosurgery
72. Talk:Tooth_squeeze
73. Talk:Natural_birth_control
74. Talk:Kegel_exerciser
75. Talk:Salivary_duct_calculus
76. Talk:Simmonds'_disease
77. Talk:Slipped_Upper_Femoral_Epiphysis
78. Talk:Somatosensory_evoked_potentials
79. Talk:Lazarus_phenomenon
80. Talk:Vasogenic_edema
81. Talk:Dysaesthesiae
82. Talk:History_of_Down_syndrome
83. Talk:Psychiatric_nosology

and

1. Talk:Seropositivity
2. Talk:Health_reform
3. Talk:Health_policy_analysis
4. Talk:Natural_health
5. Talk:Health_issues_in_animal_hoarding
6. Talk:Health_care_informatics
7. Talk:Pseudolymphoma
8. Talk:Neurobiological_brain_disorder
9. Talk:Medical_roots_and_their_derivations
10. Talk:Receptor_(immunology)
11. Talk:Evolutionary_nutrition
12. Talk:Focal_neurologic_symptom
13. Talk:Colposcopic_biopsy
14. Talk:Lipaemia
15. Talk:Gravida/para
16. Talk:MassHealth
17. Talk:Bioengineering
18. Talk:Follicular_unit_transplantation
19. Talk:Autologous
20. Talk:Advanced_Neuromodulation_System
21. Talk:Thrombolysis_In_Myocardial_Infarction
22. Talk:Actuarial_escape_velocity
23. Talk:Incisive_foramina
24. Talk:Long_root_of_the_ciliary_ganglion
25. Talk:Amen_classification
26. Talk:Chandelier_neuron
27. Talk:Oroya_fever
28. Talk:Flavin-containing_monooxygenase_system
29. Talk:Medical_audit
30. Talk:Fomite
31. Talk:Kink_(medicine)
32. Talk:Symphatomimetic_amines
33. Talk:Steady-state_evoked_potential
34. Talk:Short_interspersed_nuclear_element
35. Talk:Whole_food_supplements
36. Talk:Showering
37. Talk:Cowchock_Wapner_Kurtz_syndrome
38. Talk:Natural_alleviation_of_the_common_cold
39. Talk:Anterior_spinal_syndrome
40. Talk:Pediatric_pseudotumor_cerebri
41. Talk:Standing_(position)
42. Talk:Doctors'_mess
43. Talk:Inhibitory_postsynaptic_current
44. Talk:Lamina_multiformis
45. Talk:Tonic_receptor
46. Talk:Placenta_bag
47. Talk:Drug_binge
48. Talk:Cold_hemagglutinin_disease
49. Talk:Feature_Detectors
50. Talk:Emergency_medical_services_in_Northern_Ireland
51. Talk:Emergency_medical_services_in_Wales
52. Talk:Dyflos
53. Talk:Clinicaltrials.gov
54. Talk:Lipoid_proteinosis
55. Talk:Low_grade_squamous_intraepithelial_lesion
56. Talk:High_grade_squamous_intraepithelial_lesion
57. Talk:Rest_cure
58. Talk:Moral_inventory
59. Talk:Carmustine_implant
60. Talk:Direct_brain_interfaces
61. Talk:J_Ethnopharmacol
62. Talk:Bidirectional_shunt
63. Talk:Sexually_transmitted_infections_in_Pakistan
64. Talk:Aarskog_syndrome
65. Talk:Arginemia
66. Talk:Episodic_Ataxia_Type-1
67. Talk:PSI_(prion)
68. Talk:Cadastral_gene
69. Talk:International_Classification_of_Headache_Disorders
70. Talk:Riverview_Hospital_(Red_Bank)
71. Talk:Hemorheologic-hemodynamic_theory_of_atherosclerosis
72. Talk:Exophthalmic_goiter
73. Talk:National_Collegiate_EMS_Foundation
74. Talk:Calabar_swelling
75. Talk:Digital_radiography_detectors
76. Talk:Fiber_scaffold
77. Talk:Ben_Hardwicke
78. Talk:Lyn_Redwood
79. Talk:2009_flu_pandemic_in_China
80. Talk:2009_flu_pandemic_in_Chile
81. Talk:Kaiser_Foundation_Hospital_-_South_Sacramento