| use eswiki_p;
describe eswiki_p
; |
3 years ago |
| use eswiki_p;
SELECT *
FROM hit_counter
LIMIT 100
; |
3 years ago |
| use eswiki_p;
SELECT *
FROM hit_counter
LIMIT 100
; |
3 years ago |
| use eswiki_p;
SELECT *
FROM page_restrictions
LIMIT 100
; |
3 years ago |
| use eswiki_p;
SELECT *
FROM page_restrictions
COUNT 100
; |
3 years ago |
| use eswiki_p;
SELECT DISTINCT pp_propname
FROM page_props
; |
3 years ago |
| use eswiki_p;
SELECT count(DISTINCT pp_propname)
FROM page_props
; |
3 years ago |
| use eswiki_p;
SELECT count(DISTINCTpp_propname)
FROM page_props
; |
3 years ago |
| use eswiki_p;
SELECT DISTINCT(pp_propname), count(pp_propname)
FROM page_props
; |
3 years ago |
| use eswiki_p;
SELECT DISTINCT(pp_prop_name), count(pp_prop_name)
FROM page_props
; |
3 years ago |
| use eswiki_p;
SELECT DISTINCT(prop_name), count(prop_name)
FROM page_props
; |
3 years ago |
| use eswiki_p;
SELECT *
FROM page_props
LIMIT 100
; |
3 years ago |
| use eswiki_p;
SELECT count(*)
FROM page_props
LIMIT 100
; |
3 years ago |
| use eswiki_p;
SELECT count(*)
FROM page_props
WHERE pp_propname LIKE 'A%'
; |
3 years ago |
| use eswiki_p;
SELECT count(*)
FROM page_props
WHERE pp_propname LIKE 'C%'
; |
3 years ago |
| use eswiki_p;
SELECT count(*)
FROM page_props
WHERE pp_propname LIKE 'Categor%'
; |
3 years ago |
| use eswiki_p;
SELECT *
FROM page_props
LIMIT 100
; |
3 years ago |
| use eswiki_p;
SELECT count(*)
FROM page_props
; |
3 years ago |
| use eswiki_p;
SELECT *
FROM page_props
LIMIT 200
; |
3 years ago |
| use eswiki_p;
SELECT *
FROM site_stats
LIMIT 200
; |
3 years ago |
| use eswiki_p;
SELECT *
FROM content
LIMIT 200
; |
3 years ago |
| use eswiki_p;
SELECT *
FROM page_props
LIMIT 200
; |
3 years ago |
