Bollywood Data

This query is marked as a draft This query has been published by Jaxk3.

Bollywood

SQL

show tables;
select * from content limit 10;
select * from pagelinks limit 10;
use enwiki_p;
select * from 
content c inner join content_models cm on c.content_model = cm.model_id
limit 10;
select cat.* 
from page p
inner join pagelinks pl on p.page_id = pl.pl_from 
inner join category cat on cat.cat_pages = pl.pl_from
where p.page_title like 'List_of_Bollywood_films_of_the_1980s' limit 10;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...