use tawikisource_p;
#select * from page where page_title like... |
4 years ago |
use tawikisource_p;
#select * from page where page_title like... |
4 years ago |
use tawikisource_p;
select * from page where page_title like... |
4 years ago |
use tawikisource_p;
select * from page where page_title like... |
4 years ago |
use tawikisource_p;
select * from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select * from pr_index# where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
#select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select page_id from page where page_title like... |
4 years ago |
use tawikisource_p;
select * from pr_index# Where page_namespace Like "0"... |
4 years ago |
use tawikisource_p;
select * from pr_index# Where page_namespace Like "0"... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use mlwiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where pl_title =... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where pl_title =... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where pl_title =... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where pl_title = Q7532310
limit... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where pl_title =... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks #where... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where pl_title="Q7532310" limit... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where pl_title="Q456" limit... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks limit 10;
#Select * from... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where pl_title ="India" limit... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where pl_title like "%Ind%"... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks where pl_title like "Ind%" limit... |
4 years ago |
use wikidatawiki_p;
select * from pagelinks limit 10;
Select * from... |
4 years ago |
use wikidatawiki_p;
Select * from wbt_item_terms where wbit_item_id ="830"
|
4 years ago |
use wikidatawiki_p;
Select * from wbt_text where wbit_item_id ="830" |
4 years ago |
use wikidatawiki_p;
select * from wb_property_info limit 20;
Select... |
4 years ago |
use wikidatawiki_p;
select * from transcode limit 20;
Select wbit_item_id... |
4 years ago |
use wikidatawiki_p;
select * from transcode limit 20;
Select wbit_item_id... |
4 years ago |
use wikidatawiki_p;
select * from slots limit 20;
Select wbit_item_id from... |
4 years ago |
use wikidatawiki_p;
select * from ores_model limit 20;
Select wbit_item_id... |
4 years ago |
SHOW TABLES FROM wikidatawiki_p; |
4 years ago |
use wikidatawiki_p;
Select wbit_item_id from wbt_text
LEFT JOIN... |
4 years ago |
use wikidatawiki_p;
Select wbit_item_id from wbt_text
LEFT JOIN... |
4 years ago |
use wikidatawiki_p;
Select wbit_item_id from wbt_text
LEFT JOIN... |
4 years ago |
use wikidatawiki_p;
Select wbit_item_id from wbt_text
LEFT JOIN... |
4 years ago |
use wikidatawiki_p;
Select wbit_item_id from wbt_text
LEFT JOIN... |
4 years ago |
use wikidatawiki_p;
Select wbit_itwm_id from wbt_text
LEFT JOIN... |
4 years ago |
use wikidatawiki_p;
Select * from wbt_text
LEFT JOIN wbt_text_in_lang ON... |
4 years ago |
use wikidatawiki_p;
Select * from wbt_text
LEFT JOIN wbt_text_in_lang ON... |
4 years ago |
use wikidatawiki_p;
Select * from wbt_text
LEFT JOIN wbt_text_in_lang ON... |
4 years ago |
use wikidatawiki_p;
Select * from wbt_text
LEFT JOIN wbt_text_in_lang ON... |
4 years ago |
use wikidatawiki_p;
Select * from wbt_text where wbx_text=... |
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang limit 5;
select * from... |
4 years ago |
use wikidatawiki_p;
select * from wbt_item_terms
LEFT JOIN wbt_term_in_lang... |
4 years ago |
use wikidatawiki_p;
select * from wbt_item_terms WHERE wbit_item_id =... |
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang WHERE wbit_item_id =... |
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang WHERE wbit_item_id =... |
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang limit 2;
SELECT
... |
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang limit 2;
SELECT
... |
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang limit 2;
select * from... |
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang limit 2;
select distinct... |
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang limit 2;
select * from... |
4 years ago |
use wikidatawiki_p;
SELECT
wbit_item_id as id,
wby_name as type,
... |
4 years ago |
use wikidatawiki_p;
SELECT
wbit_item_id as id,
wby_name as type,
... |
4 years ago |
use wikidatawiki_p;
select * from wbt_item_terms
limit 2;
select * from... |
4 years ago |
use wikidatawiki_p;
select * from wbt_item_terms
limit 20;
SELECT
... |
4 years ago |
use wikidatawiki_p;
select * from wbt_item_terms
limit 20;
SELECT
... |
4 years ago |
use wikidatawiki_p;
select * from wbt_item_terms
limit 20;
SELECT
... |
4 years ago |
use wikidatawiki_p;
select * from wbt_item_terms
limit 20;
SELECT
... |
4 years ago |
use wikidatawiki_p;
select * from wbt_item_terms
limit 20;
SELECT
... |
4 years ago |
use wikidatawiki_p;
select * from wbt_property_terms
limit 20;
SELECT
... |
4 years ago |
use wikidatawiki_p;
SELECT
wbpt_property_id as id,
wby_name as type,
... |
4 years ago |
SELECT
wbpt_property_id as id,
wby_name as type,
wbxl_language as... |
4 years ago |
SELECT
wbpt_property_id as id,
wby_name as type,
wbxl_language as... |
4 years ago |
use wikidatawiki_p;
SELECT * from wbt_text_in_lang where... |
4 years ago |
use wikidatawiki_p;
SELECT * from wbt_text_in_lang where wbxl_language="ta"
limit 50; |
4 years ago |
use wikidatawiki_p;
SELECT * from wbt_text_in_lang where... |
4 years ago |
use wikidatawiki_p;
SELECT * from wbt_text_in_lang
limit 200; |
4 years ago |
use wikidatawiki_p;
SELECT * from wbt_text
limit 200; |
4 years ago |
use wikidatawiki_p;
SELECT * from wbt_term_in_lang
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wbt_property_terms
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wbt_item_terms
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wbs_propertypairs
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wbqc_constraints
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wbc_entity_usage
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_property_info
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_terms
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_terms
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_items_per_site
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_items_per_site
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_id_counters
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_changes
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_changes
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from page_compat
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from linter
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from page
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from pages
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wbs_propertypairs
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT distinct ips_site_id from wb_items_per_site |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_items_per_site where ips_site_id... |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_items_per_site where ips_site_id... |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_items_per_site
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT * from wb_items_per_site
limit 20; |
4 years ago |
use wikidatawiki_p;
SELECT
# output for Quickstatement tool
CONCAT('Q',... |
4 years ago |
use wikidatawiki_p;
SELECT
# output for Quickstatement tool
CONCAT('Q',... |
4 years ago |
use wikidatawiki_p;
SELECT
# output for Quickstatement tool
CONCAT('Q',... |
4 years ago |
use wikidatawiki_p;
SELECT
# output for Quickstatement tool
CONCAT('Q',... |
4 years ago |
use wikidatawiki_p;
select * from wb_entity_per_page
limit 20;
SELECT... |
4 years ago |
use wikidatawiki_p;
select * from wb_entity_per_page
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wb_entity_per_page
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wb_entity_per_page
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wb_terms
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wb_terms
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wb_terms
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wbt
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wbt
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wbt_term_in_lang
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wbt_text
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from wbt_text
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from page_props
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from interwiki
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from content
limit 20;
|
4 years ago |
use wikidatawiki_p;
select * from actor
limit 20;
|
4 years ago |
use tawiktionary_p;
select page_title from page Where page_namespace Like... |
4 years ago |
use tawiktionary_p;
select * from page Where page_namespace Like "0" and... |
4 years ago |
use tawiktionary_p;
select * from page Where page_namespace Like "0" and... |
4 years ago |
use tawiktionary_p;
select * from page Where page_namespace Like "0" and... |
4 years ago |
use tawiktionary_p;
select * from page Where page_namespace Like "0" and... |
4 years ago |
use tawiktionary_p;
select * from page Where page_namespace Like "0" and... |
4 years ago |
use tawiktionary_p;
select count(page_title) from page Where page_namespace... |
4 years ago |
use tawiktionary_p;
select * from page Where page_namespace Like "0" and... |
4 years ago |
use tawiktionary_p;
select * from page Where page_namespace Like "0" and... |
4 years ago |
use tawiktionary_p;
select * from page Where page_namespace Like 0#... |
4 years ago |
use tawiktionary_p;
select * from page Where page_namespace == 0# page_title... |
4 years ago |
use tawiktionary_p;
select * from page Where page_title like "bramble"
LIMIT 100;
|
4 years ago |
use tawiktionary_p;
select * from page
LIMIT 100;
|
4 years ago |
use tawiki_p;
select page_id, page_title, page_len from page where... |
5 years ago |
use tawiki_p;
select page_id, page_title page_len from page where... |
5 years ago |
use tawiki_p;
select page_id, page_title pahe_len from page where... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_namespace =2... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_namespace =2... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_namespace =2... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_namespace =2... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_namespace =2... |
5 years ago |
use tawiki_p;
select * from page limit 1;
select page_id, page_title from... |
5 years ago |
use tawiki_p;
select * from content where... |
5 years ago |
use tawiki_p;
select * from content where content_address=tt:291162;
select... |
5 years ago |
use tawiki_p;
select * from content where content_id=291162;
select... |
5 years ago |
SHOW TABLES FROM tawiki_p;
use tawiki_p;
select * from content Limit... |
5 years ago |
SHOW TABLES FROM tawiki_p;
use tawiki_p;
select page_id, page_title from... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_namespace =2... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_namespace =2... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_title like... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_title like... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_title like... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_title like "*... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_title like "*... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_title like "%... |
5 years ago |
use tawiki_p;
select page_id, page_title from page where page_title like "%... |
5 years ago |
use tawiki_p;
Select concat('#[[',page_title,']]') as name from page
where... |
5 years ago |
use tawiki_p;
Select concat('#[[',page_title,']]') as name from page
where... |
5 years ago |
use tawiki_p;
Select concat('#[[',page_title,']]') as name from page
where... |
5 years ago |
use tawiki_p;
Select page_title from page
where page_namespace = 0 and... |
5 years ago |
use tawiki_p;
Select page_title from page
where page_namespace = 0 and... |
5 years ago |
use tawiki_p;
Select page_title from page
where page_namespace = 0 and... |
5 years ago |
use tawiki_p;
Select page_title from page
where page_namespace = 0 and... |
5 years ago |
use tawiki_p;
Select page_title from page
where page_namespace = 0 and... |
5 years ago |
use tawiki_p;
Select page_title from page
where page_namespace = 0 and... |
5 years ago |
use tawiki_p;
Select page_title, page_touched from page
where... |
5 years ago |
use tawiki_p;
Select page_title, page_touched from page
where... |
5 years ago |
use tawiki_p;
Select page_title from page
where page_namespace = 0 and... |
5 years ago |
use tawiki_p;
Select count(page_title), page_namespace from page
where... |
5 years ago |
use tawiki_p;
Select page_title, page_namespace from page
where... |
5 years ago |
use tawiki_p;
Select page_title, page_namespace from page
where... |
5 years ago |
use tawiki_p;
Select page_title, page_namespace from page
where... |
5 years ago |
use tawiki_p;
#Select page_title, page_namespace from page
#where... |
5 years ago |
use tawiki_p;
#Select page_title, page_namespace from page
#where... |
5 years ago |
use tawiki_p;
#Select page_title, page_namespace from page
#where... |
5 years ago |
use tawiki_p;
#Select page_title, page_namespace from page
#where... |
5 years ago |
use tawiki_p;
#Select page_title, page_namespace from page
#where... |
5 years ago |
use tawiki_p;
Select page_title, page_namespace from page
where... |
5 years ago |
use tawiki_p;
Select page_title, page_content_model, page_namespace from... |
5 years ago |
use tawiki_p;
Select page_title, page_content_model, page_namespace from... |
5 years ago |
use tawiki_p;
Select page_title,page_content_model from page
where... |
5 years ago |
use tawiki_p;
Select page_title,page_content_model from page
where... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
#Select Concat('#[[',page_title,']]') as Name from page... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
#Select Concat('#[[',page_title,']]') as Name from page... |
5 years ago |
use tawiki_p;
#Select Concat('#[[',page_title,']]') as Name from page... |
5 years ago |
use tawiki_p;
#Select Concat('#[[',page_title,']]') as Name from page... |
5 years ago |
use tawiki_p;
#Select Concat('#[[',page_title,']]') as Name from page... |
5 years ago |
use tawiki_p;
#Select Concat('#[[',page_title,']]') as Name from page... |
5 years ago |
use tawiki_p;
#Select Concat('#[[',page_title,']]') as Name from page... |
5 years ago |
use tawiki_p;
#Select Concat('#[[',page_title,']]') as Name from page... |
5 years ago |
use tawiki_p;
#Select Concat('#[[',page_title,']]') as Name from page... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('#[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select Concat('[[',page_title,']]') as Name from page
where... |
5 years ago |
use tawiki_p;
Select page_id, page_title from page
where page_id in (SELECT... |
5 years ago |
use tawiki_p;
Select page_id, page_title from page
where page_id in (SELECT... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
Select page_id, page_title from page
where page_id in (SELECT... |
5 years ago |
use tawiki_p;
Select page_id, page_title from page
where page_id in (SELECT... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
#Select page_id, page_title from page
#where page_id in... |
5 years ago |
use tawiki_p;
Select page_id, page_title from page
where page_id in (SELECT... |
5 years ago |
use tawiki_p;
Select * from page where page_id in
(SELECT cl_from FROM... |
5 years ago |
use tawiki_p;
Select * from page where page_id in
(SELECT cl_from FROM... |
5 years ago |
use tawiki_p;
Select * from page where page_id in
(SELECT cl_from FROM... |
5 years ago |
use tawiki_p;
SELECT *
FROM categorylinks where cl_to =... |
5 years ago |
use tawiki_p;
SELECT *
FROM categorylinks #where cat_title =... |
5 years ago |
use tawiki_p;
SELECT *
FROM categorylinks where cat_title =... |
5 years ago |
use tawiki_p;
SELECT *
FROM category where cat_title =... |
5 years ago |
use tawiki_p;
SELECT *
FROM category where cat_title = '1984 தமிழ்த்... |
5 years ago |
use tawiki_p;
SELECT *
FROM category
limit 10;
|
5 years ago |
use tawikisource_p;
SELECT distinct page_title, rev_user_text,... |
5 years ago |
use tawiki_p;
SELECT page.page_title FROM page
limit 10; |
6 years ago |
use commonswiki_p;
select * from image
where img_name REGEXP "ta-[அ-ன]+"
limit 10; |
6 years ago |
use commonswiki_p;
select * from image
where img_name like "$ta-%"
limit 10; |
6 years ago |
use commonswiki_p;
select * from image
where img_name like "^ta-%"
limit 10; |
6 years ago |
use commonswiki_p;
select * from image
where img_name like "%ta-%"
limit 10; |
6 years ago |
use commonswiki_p;
select * from image
where img_name like "ta-%"
limit 10; |
6 years ago |
use commonswiki_p;
select * from image
limit 10; |
6 years ago |
use commonswiki_p
select * from image
limit 10; |
6 years ago |
use tawiki_p;
#SELECT * from page WHERE page_namespace =0 AND... |
7 years ago |
use tawiki_p;
#SELECT * from page WHERE page_namespace =0 AND... |
7 years ago |
use tawiki_p;
#SELECT * from page WHERE page_namespace =0 AND... |
7 years ago |
use tawiki_p;
SELECT * from page WHERE page_namespace =0 AND... |
7 years ago |
use tawiki_p;
SELECT * from page WHERE page_namespace =0 AND... |
7 years ago |
use tawiki_p;
SELECT * from page WHERE page_namespace =0 ORDER BY... |
7 years ago |
use tawiki_p;
SELECT * from page ORDER BY page_touched ASC limit 10;# ORDER... |
7 years ago |
use tawiki_p;
SELECT * from page ORDER BY page_touched DESC limit 10;# ORDER... |
7 years ago |
use tawiki_p;
SELECT * from page ORDER BY page_touched DESC limit 100;#... |
7 years ago |
use tawiki_p;
SELECT * from page ORDER BY editcounts DESC limit 100;# ORDER... |
7 years ago |
use tawiki_p;
SELECT * from page limit 100 ORDER BY page_touched asc; |
7 years ago |
use tawiki_p;
SELECT * from page limit 100 ORDER BY page_touched; |
7 years ago |
use tawiki_p;
SELECT * from page limit 100; |
7 years ago |
use tawiki_p;
SELECT * from page limit 100000; |
7 years ago |
use tawiki_p;
SELECT * from page limit 10; |
7 years ago |