| select wbit_item_id, count(*) as cnt
from wbt_item_terms
where wbit_item_id... |
2 years ago |
| select wbit_item_id, count(*) as cnt
from wbt_item_terms
where wbit_item_id... |
2 years ago |
| select *
from wbt_item_terms
limit 50;
select *
from wbt_term_in_lang
limit 40; |
2 years ago |
| select *
from wbt_item_terms
limit 50 |
2 years ago |
| select *
from wbt_property_terms
limit 50 |
2 years ago |
| SELECT page_id
FROM pa_ge
-- join page_props on page_id=pp_page AND... |
2 years ago |
| SELECT page_id
FROM page
-- join page_props on page_id=pp_page AND... |
2 years ago |
| SELECT *
FROM pa_ge
-- join page_props on page_id=pp_page AND... |
2 years ago |
| SELECT *
FROM page
-- join page_props on page_id=pp_page AND... |
2 years ago |
| SELECT page.page_title
FROM page
join page_props on page_id=pp_page AND... |
2 years ago |
| SELECT ips_item_id
FROM wb_items_per_site
where ips_site_id='lvwiki'
limit 5 |
2 years ago |
| SELECT *
FROM pag_e
join page_props on page_id=pp_page AND... |
2 years ago |
| SELECT *
FROM page
join page_props on page_id=pp_page AND... |
2 years ago |
| SELECT *
FROM wb_items_per_site
limit 20 |
2 years ago |
| SELECT *
FROM page
join page_props on page_id=pp_page AND... |
2 years ago |
| SELECT *
FROM page
limit 20 |
2 years ago |
| SELECT *
FROM wb_items_per_site
where ips_site_id='lvwiki'
limit 20 |
2 years ago |
|
SELECT
wbt_item_terms.*
FROM wbt_item_terms
JOIN wbt_term_in_lang ON... |
2 years ago |
|
SELECT
wbit_item_id as id
FROM wbt_item_terms
JOIN wbt_term_in_lang ON... |
2 years ago |
| select *
from page_props
WHERE pp_propname='wb-claims' AND pp_sortkey=0
limit 25 |
2 years ago |
| select distinct pp_propname
from page_props |
2 years ago |
| select *
from page_props
limit 5 |
2 years ago |
| select distinct pp_page
from page_props
limit 5 |
2 years ago |
| select *
from page_props
limit 5 |
2 years ago |
| select *
from page_props
where pp_propname='wb-claims'
limit 5 |
2 years ago |
| select *
from page_props
where pp_propname='wb-claims'
limit 5 |
2 years ago |
| select page_title
from page
join page_props on page_id=pp_page and... |
2 years ago |
| select page_title
from page
where page_namespace=0 and page_is_redirect=0
limit 5 |
2 years ago |
| select page_title
from page
where page_namespace=0 and page_is_redirect=0 ... |
2 years ago |
| select page_title
from page
where page_namespace=0 and page_is_redirect=0 ... |
2 years ago |
| select page_title
from page
join page_props on page_id=pp_page
where... |
2 years ago |
| select page_title
from page
join page_props on page_id=pp_page
where... |
2 years ago |
| select page_title
from page
join page_props on page_id=pp_page
where... |
2 years ago |
