SELECT *
FROM wbt_text_in_lang
#FROM wb_items_per_site as w1
#WHERE... |
1 year ago |
SELECT *
FROM wbt_property_terms
#FROM wb_items_per_site as w1
#WHERE... |
1 year ago |
SELECT *
FROM wbt_text
#FROM wb_items_per_site as w1
#WHERE w1.ips_site_page... |
1 year ago |
SELECT *
FROM wbt_item_terms
#FROM wb_items_per_site as w1
#WHERE... |
1 year ago |
SELECT *
FROM wbc_entity_usage
#FROM wb_items_per_site as w1
#WHERE... |
1 year ago |
SHOW TABLES; |
1 year ago |
SELECT *
FROM text
#FROM wb_items_per_site as w1
#WHERE w1.ips_site_page NOT... |
1 year ago |
SELECT *
FROM content
#FROM wb_items_per_site as w1
#WHERE w1.ips_site_page... |
1 year ago |
SELECT *
FROM revision
#FROM wb_items_per_site as w1
#WHERE w1.ips_site_page... |
1 year ago |
SELECT *
FROM page
#FROM wb_items_per_site as w1
#WHERE w1.ips_site_page NOT... |
1 year ago |
SELECT *
FROM page_props
#FROM wb_items_per_site as w1
#WHERE... |
1 year ago |
SELECT *
FROM page_props
#FROM wb_items_per_site as w1
#WHERE... |
1 year ago |
SELECT *
FROM wb_items_per_site as w1
WHERE w1.ips_site_page NOT LIKE '%:%'... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT w1.ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w1,... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT COUNT(DISTINCT ll_from)
FROM langlinks as ll, page as p
WHERE... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT * #COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT * #COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT * #COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT * #COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT * #COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT * #COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w
WHERE... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w, page as... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w, page as... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w, page as... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w, page a... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w, page a... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w, page a... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site as w, page a... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site
WHERE ips_site_id... |
1 year ago |
SELECT COUNT(DISTINCT ips_item_id)
FROM wb_items_per_site |
1 year ago |
SELECT *
FROM wb_items_per_site
WHERE ips_item_id = '1000'
|
1 year ago |
SELECT *
FROM wb_items_per_site
#WHERE ips_item_id = 'Q1000'
LIMIT 10 |
1 year ago |
SELECT *
FROM wb_items_per_site
#WHERE ips_item_id = 'Q1000' |
1 year ago |
SELECT *
FROM wb_items_per_site
WHERE ips_item_id = 'Q1000' |
1 year ago |
SELECT *
FROM wb_items_per_site
WHERE ips_item_id = 'Q1000000' |
1 year ago |
SELECT *
FROM wb_items_per_site
WHERE ips_item_id = 'Q100000' |
1 year ago |
SELECT *
FROM wb_items_per_site
WHERE page_id = 102611 |
1 year ago |
SELECT *
FROM wb items per site
WHERE page_id = '102611' |
1 year ago |
SELECT *
FROM wb items per site
WHERE page_id = '102611' |
1 year ago |
SELECT *
FROM wb items per site
WHERE page_id = 102611 |
1 year ago |
SELECT *
FROM page as p
WHERE p.page_namespace = 0
AND p.page_is_redirect =... |
1 year ago |
SELECT *
FROM page as p
WHERE p.page_namespace = 0
AND p.page_is_redirect =... |
1 year ago |
SELECT *
FROM langlinks as ll, page as p
WHERE p.page_namespace = 0
AND... |
1 year ago |
SELECT *
FROM langlinks as ll
LIMIT 100 |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from), (SELECT COUNT(*) from page as p WHERE... |
1 year ago |
SELECT count(distinct ll_from), (SELECT COUNT(*) from page WHERE... |
1 year ago |
SELECT count(distinct ll_from) / (SELECT COUNT(*) from page WHERE... |
1 year ago |
SELECT (SELECT COUNT(*) from page WHERE p.page_namespace = 0
AND... |
1 year ago |
SELECT count(distinct ll_from)
FROM langlinks as ll, page as p
WHERE... |
1 year ago |
SELECT p.page_title, ll.* #count(distinct iwl_from)
FROM langlinks as ll,... |
1 year ago |
SELECT p.page_title, ll.* #count(distinct iwl_from)
FROM langlinks as ll,... |
1 year ago |
SELECT p.page_title, iw.* #count(distinct iwl_from)
FROM iwlinks as iw, page... |
1 year ago |
SELECT p.page_title, iw.* #count(distinct iwl_from)
FROM iwlinks as iw, page... |
1 year ago |
SELECT count(distinct iwl_from)
FROM iwlinks as iw, page as p
WHERE... |
1 year ago |
SELECT count(distinct iwl_from)
FROM iwlinks as iw, page as p
WHERE... |
1 year ago |
SELECT count(distinct iwl_from)
FROM iwlinks as iw, page as p
WHERE... |
1 year ago |
SELECT count(distinct iwl_from)
FROM iwlinks as iw, page as p
WHERE... |
1 year ago |
SELECT iw.*
FROM iwlinks as iw, page as p
WHERE p.page_namespace = 0
AND... |
1 year ago |
SELECT iw.*
FROM iwlinks as iw, page as p
WHERE p.page_namespace = 0
AND... |
1 year ago |
SELECT *
FROM iwlinks
LIMIT 100 |
1 year ago |
SELECT *
FROM iwlinks
LIMIT 10 |
1 year ago |
SELECT count(*)
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0 |
1 year ago |
SELECT count(*)
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0 |
1 year ago |
SELECT count(*)
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0 |
1 year ago |
SELECT count(*)
FROM page
WHERE page_namespace = 0 |
1 year ago |
SELECT count(*)
FROM page
LIMIT 10 |
1 year ago |
SELECT *
FROM langlinks
LIMIT 10 |
1 year ago |
SELECT
table_name
FROM
user_tables; |
1 year ago |