User:Topbanana/Reports/Scripts/extract nowiki.sql

This page describes a subscript used in the creation of a link analysis database.

You'll need to generate the whole thing yourself, it's too large to sensibly store here. 400 repeats definately catches all links as of June 2004.



INSERT INTO special_text ( special_id, art_id, pos, start ) SELECT 0, art.art_id, s2.pos+1, locate( '<nowiki>', art_text, start ) + 8 FROM special_text s2 JOIN art on s2.art_id = art.art_id WHERE s2.special_id = 0 AND locate( '<nowiki>', art_text, start ) > 0 AND s2.pos = 1;
INSERT INTO special_text ( special_id, art_id, pos, start ) SELECT 0, art.art_id, s2.pos+1, locate( '<nowiki>', art_text, start ) + 8 FROM special_text s2 JOIN art on s2.art_id = art.art_id WHERE s2.special_id = 0 AND locate( '<nowiki>', art_text, start ) > 0 AND s2.pos = 2;
INSERT INTO special_text ( special_id, art_id, pos, start ) SELECT 0, art.art_id, s2.pos+1, locate( '<nowiki>', art_text, start ) + 8 FROM special_text s2 JOIN art on s2.art_id = art.art_id WHERE s2.special_id = 0 AND locate( '<nowiki>', art_text, start ) > 0 AND s2.pos = 3;
INSERT INTO special_text ( special_id, art_id, pos, start ) SELECT 0, art.art_id, s2.pos+1, locate( '<nowiki>', art_text, start ) + 8 FROM special_text s2 JOIN art on s2.art_id = art.art_id WHERE s2.special_id = 0 AND locate( '<nowiki>', art_text, start ) > 0 AND s2.pos = 4;
INSERT INTO special_text ( special_id, art_id, pos, start ) SELECT 0, art.art_id, s2.pos+1, locate( '<nowiki>', art_text, start ) + 8 FROM special_text s2 JOIN art on s2.art_id = art.art_id WHERE s2.special_id = 0 AND locate( '<nowiki>', art_text, start ) > 0 AND s2.pos = 5;


... and repeat as necessary, increasing 'pos' each time.

Navigation

  • Art and Cultures
    • Art (https://academickids.com/encyclopedia/index.php/Art)
    • Architecture (https://academickids.com/encyclopedia/index.php/Architecture)
    • Cultures (https://www.academickids.com/encyclopedia/index.php/Cultures)
    • Music (https://www.academickids.com/encyclopedia/index.php/Music)
    • Musical Instruments (http://academickids.com/encyclopedia/index.php/List_of_musical_instruments)
  • Biographies (http://www.academickids.com/encyclopedia/index.php/Biographies)
  • Clipart (http://www.academickids.com/encyclopedia/index.php/Clipart)
  • Geography (http://www.academickids.com/encyclopedia/index.php/Geography)
    • Countries of the World (http://www.academickids.com/encyclopedia/index.php/Countries)
    • Maps (http://www.academickids.com/encyclopedia/index.php/Maps)
    • Flags (http://www.academickids.com/encyclopedia/index.php/Flags)
    • Continents (http://www.academickids.com/encyclopedia/index.php/Continents)
  • History (http://www.academickids.com/encyclopedia/index.php/History)
    • Ancient Civilizations (http://www.academickids.com/encyclopedia/index.php/Ancient_Civilizations)
    • Industrial Revolution (http://www.academickids.com/encyclopedia/index.php/Industrial_Revolution)
    • Middle Ages (http://www.academickids.com/encyclopedia/index.php/Middle_Ages)
    • Prehistory (http://www.academickids.com/encyclopedia/index.php/Prehistory)
    • Renaissance (http://www.academickids.com/encyclopedia/index.php/Renaissance)
    • Timelines (http://www.academickids.com/encyclopedia/index.php/Timelines)
    • United States (http://www.academickids.com/encyclopedia/index.php/United_States)
    • Wars (http://www.academickids.com/encyclopedia/index.php/Wars)
    • World History (http://www.academickids.com/encyclopedia/index.php/History_of_the_world)
  • Human Body (http://www.academickids.com/encyclopedia/index.php/Human_Body)
  • Mathematics (http://www.academickids.com/encyclopedia/index.php/Mathematics)
  • Reference (http://www.academickids.com/encyclopedia/index.php/Reference)
  • Science (http://www.academickids.com/encyclopedia/index.php/Science)
    • Animals (http://www.academickids.com/encyclopedia/index.php/Animals)
    • Aviation (http://www.academickids.com/encyclopedia/index.php/Aviation)
    • Dinosaurs (http://www.academickids.com/encyclopedia/index.php/Dinosaurs)
    • Earth (http://www.academickids.com/encyclopedia/index.php/Earth)
    • Inventions (http://www.academickids.com/encyclopedia/index.php/Inventions)
    • Physical Science (http://www.academickids.com/encyclopedia/index.php/Physical_Science)
    • Plants (http://www.academickids.com/encyclopedia/index.php/Plants)
    • Scientists (http://www.academickids.com/encyclopedia/index.php/Scientists)
  • Social Studies (http://www.academickids.com/encyclopedia/index.php/Social_Studies)
    • Anthropology (http://www.academickids.com/encyclopedia/index.php/Anthropology)
    • Economics (http://www.academickids.com/encyclopedia/index.php/Economics)
    • Government (http://www.academickids.com/encyclopedia/index.php/Government)
    • Religion (http://www.academickids.com/encyclopedia/index.php/Religion)
    • Holidays (http://www.academickids.com/encyclopedia/index.php/Holidays)
  • Space and Astronomy
    • Solar System (http://www.academickids.com/encyclopedia/index.php/Solar_System)
    • Planets (http://www.academickids.com/encyclopedia/index.php/Planets)
  • Sports (http://www.academickids.com/encyclopedia/index.php/Sports)
  • Timelines (http://www.academickids.com/encyclopedia/index.php/Timelines)
  • Weather (http://www.academickids.com/encyclopedia/index.php/Weather)
  • US States (http://www.academickids.com/encyclopedia/index.php/US_States)

Information

  • Home Page (http://academickids.com/encyclopedia/index.php)
  • Contact Us (http://www.academickids.com/encyclopedia/index.php/Contactus)

  • Clip Art (http://classroomclipart.com)
Toolbox
Personal tools