SELECT COUNT(*) AS number FROM wb_items_per_site WHERE ips_site_id = 'cswiki'; |
3 years ago |
/*
SELECT COUNT(*) AS number FROM wb_terms
JOIN wb_items_per_site ON... |
3 years ago |
/*USE cswiki_p;
SELECT COUNT(*) AS number
FROM page_props
LEFT JOIN... |
6 years ago |
/*USE cswiki_p;
SELECT COUNT(*) AS number
FROM page_props
LEFT JOIN... |
6 years ago |
/*USE cswiki_p;
SELECT COUNT(*) AS number
FROM page_props
LEFT JOIN... |
6 years ago |
/*USE cswiki_p;
SELECT COUNT(*) AS number
FROM page_props
LEFT JOIN... |
6 years ago |
/*USE cswiki_p;
SELECT COUNT(*) AS number
FROM page_props
LEFT JOIN... |
6 years ago |
USE cswiki_p;
SELECT COUNT(*) AS number
FROM page_props
LEFT JOIN... |
6 years ago |
USE cswiki_p;
SELECT COUNT(*) AS number
FROM page_props
LEFT JOIN... |
6 years ago |
blank query |
6 years ago |
blank query |
6 years ago |
USE wikidatawiki_p;
SELECT page_title, rd_title FROM page JOIN redirect ON... |
6 years ago |
USE wikidatawiki_p;
SELECT page_title, rd_title FROM page JOIN redirect ON... |
8 years ago |
USE wikidatawiki_p;
SELECT page_title, rd_title FROM page JOIN redirect ON... |
8 years ago |
USE wikidatawiki_p;
SELECT * FROM page JOIN redirect ON rd_from = page_id... |
8 years ago |
USE wikidatawiki_p;
DESCRIBE redirect; |
8 years ago |
USE wikidatawiki_p;
DESCRIBE redirect; |
8 years ago |