Skip to content

Instantly share code, notes, and snippets.

@rptynan

rptynan/gist:fcb4dc445a72525a416a

Created February 10, 2016 21:23
Show Gist options
  • Save rptynan/fcb4dc445a72525a416a to your computer and use it in GitHub Desktop.
Save rptynan/fcb4dc445a72525a416a to your computer and use it in GitHub Desktop.
Download ZIP
Sample results of IBProject
Raw
gistfile1.txt
SQL Query:
SELECT name, title
FROM wikiarticles
INNER JOIN trends_wikiarticles_junction
ON wikiarticles.wikiarticle_id = trends_wikiarticles_junction.wikiarticle_id
INNER JOIN trends
ON trends.trend_id = trends_wikiarticles_junction.trend_id;
Some of the English trends and the articles they had stored under them:
| #IfIHadTrumpsMoney | AOL |
| #IfIHadTrumpsMoney | Chicago |
| #IfIHadTrumpsMoney | Inter Milan |
| #IfIHadTrumpsMoney | Luftwaffe |
| #IfIHadTrumpsMoney | Marsupial |
| #IfIHadTrumpsMoney | Norway |
| #IfIHadTrumpsMoney | University of Chicago |
| #IfIHadTrumpsMoney | Vertebrate |
| #IfIHadTrumpsMoney | Have Gun – Will Travel |
| #IfIHadTrumpsMoney | FairTax |
| #IfIHadTrumpsMoney | Trump International Hotel and Tower (Chicago) |
| #IfIHadTrumpsMoney | Trump International Hotel and Tower |
| #IfIHadTrumpsMoney | English modal verbs |
| #IfIHadTrumpsMoney | Dancing with the Stars |
| #IfIHadTrumpsMoney | AOL Explorer |
| #IfIHadTrumpsMoney | The Trump Organization |
| #IfIHadTrumpsMoney | Build-A-Bear Workshop |
| #IfIHadTrumpsMoney | Donald Trump |
| #IfIHadTrumpsMoney | Donald Trump, Jr. |
| #IfIHadTrumpsMoney | Amphignathodontidae |
| #IfIHadTrumpsMoney | Journal of Vertebrate Paleontology |
| #IfIHadTrumpsMoney | Build-A-Bear Workshop (video game) |
| #IfIHadTrumpsMoney | Australia–Norway relations |
| #IfIHadTrumpsMoney | Dancing with the Stars (Albanian TV series) |
| #IfIHadTrumpsMoney | Inter Milan in international football |
| #IfIHadTrumpsMoney | Ranks and insignia of the Luftwaffe (1935–1945) |
| #IfIHadTrumpsMoney | Have Gun, Will Travel (band) |
| #IfIHadTrumpsMoney | Gundam Build Fighters |
| #IfIHadTrumpsMoney | Trump Productions |
| #IfIHadTrumpsMoney | Gundam Build Fighters Try |
| #AshWednesday | Water |
| #AshWednesday | Cremation |
| #AshWednesday | Today |
| #AshWednesday | USA Today |
| #AshWednesday | List of water sports |
| #AshWednesday | RT |
| #AshWednesday | Pyre |
| #AshWednesday | 2005 Ashes series |
| #AshWednesday | Propidium iodide |
| #AshWednesday | Your Song |
| #AshWednesday | How I Met Your Mother |
| #AshWednesday | Ashes to Ashes |
| #AshWednesday | Right Reverend |
| #AshWednesday | Higurashi When They Cry |
| #AshWednesday | September 11 attacks |
| #AshWednesday | Your Song (TV series) |
| #AshWednesday | Zoé |
| #AshWednesday | When It Started |
| #AshWednesday | Javier Hernández |
| #AshWednesday | List of Higurashi When They Cry chapters |
| #AshWednesday | BioLegend |
| #AshWednesday | How I Met Your Mother (season 1) |
| #AshWednesday | Javier Hernández (footballer, born 1961) |
| #AshWednesday | St. Joseph's Chapel (New York City) |
| #AshWednesday | Is This It |
| #AshWednesday | List of international cricket centuries by Kevin Pietersen |
| #AshWednesday | Ashes to Ashes (mixtape) |
| #AshWednesday | Zoé Metthez |
| #JustinBieberBRITs | Ferrari |
| #JustinBieberBRITs | Justin Martyr |
| #JustinBieberBRITs | Works Progress Administration |
| #JustinBieberBRITs | Justin Timberlake |
| #JustinBieberBRITs | Alstom |
| #JustinBieberBRITs | Tengu |
| #JustinBieberBRITs | Emoji |
| #JustinBieberBRITs | Springville Museum of Art |
| #JustinBieberBRITs | Cry Me a River (Justin Timberlake song) |
| #JustinBieberBRITs | Bieber (disambiguation) |
| #JustinBieberBRITs | Alstom Coradia LINT |
| #JustinBieberBRITs | First Apology of Justin Martyr |
| #JustinBieberBRITs | Justin Bieber |
| #JustinBieberBRITs | Ferrari 458 |
| #JustinBieberBRITs | Never Let You Go (Justin Bieber song) |
| #JustinBieberBRITs | Lil B |
| #JustinBieberBRITs | Haley Reinhart |
| #JustinBieberBRITs | Christopher Bieber |
| #JustinBieberBRITs | Apple Color Emoji |
| #JustinBieberBRITs | Bieber (surname) |
| #JustinBieberBRITs | Scott Bradlee |
| YOU ARE BEAUTIFUL SELENA | Food and Agriculture Organization |
| YOU ARE BEAUTIFUL SELENA | Operation Barbarossa |
| YOU ARE BEAUTIFUL SELENA | A Beautiful Mind |
| YOU ARE BEAUTIFUL SELENA | Attack on Pearl Harbor |
| YOU ARE BEAUTIFUL SELENA | Selena |
| YOU ARE BEAUTIFUL SELENA | Life Is Beautiful |
| YOU ARE BEAUTIFUL SELENA | The Bold and the Beautiful |
| YOU ARE BEAUTIFUL SELENA | Beautiful |
| YOU ARE BEAUTIFUL SELENA | AP Stylebook |
| YOU ARE BEAUTIFUL SELENA | Crisis: The Japanese Attack on Pearl Harbor and Southeast Asia |
| YOU ARE BEAUTIFUL SELENA | List of awards and nominations received by Selena |
| YOU ARE BEAUTIFUL SELENA | September 11 attacks |
| YOU ARE BEAUTIFUL SELENA | Food and Agriculture Organization Corporate Statistical Database |
| YOU ARE BEAUTIFUL SELENA | Selena Gomez |
| YOU ARE BEAUTIFUL SELENA | Twitter |
| YOU ARE BEAUTIFUL SELENA | Life Is Beautiful (disambiguation) |
| YOU ARE BEAUTIFUL SELENA | Associated Press |
| YOU ARE BEAUTIFUL SELENA | St. Joseph's Chapel (New York City) |
| YOU ARE BEAUTIFUL SELENA | CTB v News Group Newspapers Ltd |
| YOU ARE BEAUTIFUL SELENA | The Bold and the Beautiful characters (2015) |
| YOU ARE BEAUTIFUL SELENA | Operation Otto |
| MILEY OUR QUEEN | Food and Agriculture Organization |
| MILEY OUR QUEEN | World Heritage Site |
| MILEY OUR QUEEN | Queen Elizabeth The Queen Mother |
| MILEY OUR QUEEN | Queen Victoria |
| MILEY OUR QUEEN | Status quo |
| MILEY OUR QUEEN | AP Stylebook |
| MILEY OUR QUEEN | Status quo ante |
| MILEY OUR QUEEN | Chase |
| MILEY OUR QUEEN | Queen Victoria Gardens |
| MILEY OUR QUEEN | Hannah Montana |
| MILEY OUR QUEEN | Food and Agriculture Organization Corporate Statistical Database |
| MILEY OUR QUEEN | Ahora |
| MILEY OUR QUEEN | Miley Cyrus |
| MILEY OUR QUEEN | Twitter |
| MILEY OUR QUEEN | Elizabeth II |
| MILEY OUR QUEEN | Chase YC-122 Avitruc |
| MILEY OUR QUEEN | Associated Press |
| MILEY OUR QUEEN | Flags of Elizabeth II |
| MILEY OUR QUEEN | List of Arizona Diamondbacks Opening Day starting pitchers |
| MILEY OUR QUEEN | List of songs recorded by Miley Cyrus |
| MILEY OUR QUEEN | Ahora (network) |
| MILEY OUR QUEEN | CTB v News Group Newspapers Ltd |
| MILEY OUR QUEEN | Hannah Montana 2: Meet Miley Cyrus |
| MILEY OUR QUEEN | Wade Miley |
| MILEY OUR QUEEN | 2002 Demise Honours |
| MILEY OUR QUEEN | Lists of World Heritage Sites in Europe |
| MILEY OUR QUEEN | Ahora Noticias |
| MILEY OUR QUEEN | En Busca de un Ídolo 2013 |
| MILEY OUR QUEEN | Ahora o nunca |
| MILEY OUR QUEEN | 2015 Illapel earthquake |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment