SELECT *, ll_lang
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE NOT... |
7 years ago |
SELECT *, ll_lang
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE NOT... |
7 years ago |
SELECT *, ll_lang
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE NOT... |
7 years ago |
SELECT *, ll_lang
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE NOT... |
7 years ago |
SELECT *, ll_lang
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE NOT... |
8 years ago |
SELECT *, ll_lang
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE NOT... |
8 years ago |
SELECT *
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE NOT p.page_is_new... |
8 years ago |
SELECT *
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE NOT p.page_is_new... |
8 years ago |
SELECT ll.ll_lang
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE NOT... |
8 years ago |
SELECT p.page_title, ll.ll_lang, count(*) AS 'nombre iw'
FROM cawiki_p.page... |
8 years ago |
SELECT p.page_title, ll.iwl_prefix, count(*) AS 'nombre iw'
FROM... |
8 years ago |
SELECT p.page_title, ll.iwl_prefix, count(*) AS 'nombre iw'
FROM... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*) AS 'nombre iw'
FROM cawiki_p.page p,... |
8 years ago |
SELECT p.page_title, count(*)
FROM cawiki_p.page p, cawiki_p.langlinks... |
8 years ago |
SELECT count(*)
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE... |
8 years ago |
SELECT count(ll.*)
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE... |
8 years ago |
SELECT ll.*
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE p.page_title =... |
8 years ago |
SELECT ll.*
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE p.page_title =... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE p.page_title =... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.langlinks ll
WHERE p.page_title =... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE p.page_title =... |
8 years ago |
SELECT *
FROM cawiki_p.iwlinks iw;
|
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE p.page_title =... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE p.page_title =... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE p.page_title =... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE p.page_title =... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE p.page_title... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE p.page_title... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE p.page_title... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE p.page_title... |
8 years ago |
SELECT iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE p.page_title... |
8 years ago |
SELECT p.*, iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw
WHERE... |
8 years ago |
SELECT p.*, iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw,
WHERE... |
8 years ago |
SELECT p.*, iw.*
FROM cawiki_p.page p, cawiki_p.iwlinks iw,
WHERE... |
8 years ago |
SELECT *
FROM cawiki_p.page p, cawiki_p.iwlinks iw,
WHERE p.page_title LIKE... |
8 years ago |
SELECT *
FROM cawiki_p.page p
WHERE p.page_title LIKE "Quim_Monzó" AND NOT... |
8 years ago |
SELECT *
FROM cawiki_p.page p
WHERE p.page_title LIKE "Quim_Monzó" AND NOT... |
8 years ago |
SELECT p.page_lang
FROM cawiki_p.page p
WHERE p.page_title LIKE "Quim_Monzó"... |
8 years ago |
SELECT *
FROM cawiki_p.page p
WHERE p.page_title LIKE "Quim_Monzó" AND NOT... |
8 years ago |
SELECT *
FROM cawiki_p.page p
WHERE p.page_title LIKE "Quim Monz" AND NOT... |
8 years ago |
SELECT *
FROM cawiki_p.page p
WHERE p.page_title LIKE "Quim Monzó" AND NOT... |
8 years ago |
SELECT *
FROM cawiki_p.page p
WHERE p.page_title = "Quim Monzó" AND NOT... |
8 years ago |
SELECT *
FROM cawiki_p.page p
WHERE p.page_title = "Barcelona" AND NOT... |
8 years ago |
SELECT *
FROM cawiki_p.page p
WHERE p.page_title = "Barcelona" AND NOT... |
8 years ago |
SELECT *
FROM cawiki_p.page p
WHERE p.page_title = "Barcelona";
|
8 years ago |
SELECT *
FROM cawiki_p.page p
WHERE p.page_title = "Víctor Mora i Pujadas";
|
8 years ago |
SELECT p.page_id
FROM cawiki_p.page p
WHERE p.page_title = "Víctor Mora i Pujadas";
|
8 years ago |
SELECT p.page_id
FROM cawiki_p.page p
WHERE p.page_id = 10501;
|
8 years ago |
SELECT p.page_id
FROM wikidatawiki.page p
WHERE p.page_id = 10501;
|
8 years ago |
USE metawiki_p;
SELECT COUNT(*)
FROM revision_userindex r
WHERE
... |
8 years ago |
USE wikidatawiki;
SELECT COUNT(*)
FROM revision_userindex r
WHERE
... |
8 years ago |
USE wikidatawiki;
SELECT COUNT(*)
FROM revision_userindex
WHERE
... |
8 years ago |
USE wikidatawiki;
SELECT COUNT(*)
FROM revision_userindex
WHERE
... |
8 years ago |
USE metawiki_p;
SELECT COUNT(*)
FROM revision_userindex
WHERE
... |
8 years ago |
USE wikidatawiki;
SELECT p.page_id
FROM page p
WHERE p.page_id = 10501; |
8 years ago |
USE wikidatawiki;
SELECT p.page_id
FROM page p
WHERE p.page_id = 10501; |
8 years ago |
USE wikidatawiki;
SELECT p.page_id
FROM page p
WHERE p.page_id = 10501; |
8 years ago |
USE wikidatawiki;
SELECT p.page_id
FROM page p
WHERE p.page_id = 10086788; |
8 years ago |
USE wikidatawiki
SELECT p.page_id
FROM page p
WHERE p.page_id = 10086788; |
8 years ago |
SELECT p.page_id
FROM page p
WHERE p.page_id = 10086788; |
8 years ago |
USE wikidatawiki; SELECT p.page_id
FROM page p
WHERE p.page_id = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT p.page_id
FROM page p
WHERE p.page_id = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT p.page_id
FROM page p
WHERE
p.page_id = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT page_id
FROM page p
WHERE
p.page_id = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT *
FROM page p
WHERE
p.page_id = 10086788; |
8 years ago |
USE metawiki_p;
SELECT COUNT(*)
FROM revision_userindex
WHERE
... |
8 years ago |
USE wikidatawiki;
SELECT *
FROM page p
WHERE
p.page_id = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT count(*)
FROM page p
WHERE
p.page_id = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT *
FROM page p
WHERE
p.page_id = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT *
FROM page p
WHERE
p.page_id = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT count(*)
FROM page p
WHERE
p.page_id = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT count(*)
FROM page p
WHERE
p.page_id = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT count(*)
FROM page p
WHERE
p.page = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT count(*)
FROM page p
WHERE
p.page = 10086788; |
8 years ago |
USE wikidatawiki;
SELECT count(*)
FROM page p
WHERE
p.page_id = "Q10086788"; |
8 years ago |
USE wikidatawiki;
SELECT count(*)
FROM page p
WHERE
p.page_id = "Q10086788"; |
8 years ago |
USE wikidatawiki;
SELECT *
FROM page p
WHERE
p.page_id = "Q10086788"; |
8 years ago |
USE wikidatawiki;
SELECT *
FROM page p
WHERE
p.page_id = "Q10086788"; |
8 years ago |
USE wikidatawiki;
SELECT *
FROM page
WHERE
page_id = "Q10086788"; |
8 years ago |
SHOW TABLES FROM wikidatawiki; |
8 years ago |
SHOW TABLES FROM cawiki_p; |
8 years ago |
SHOW TABLES FROM enwiki_p; |
8 years ago |
SHOW TABLES FROM wikidata; |
8 years ago |
SHOW TABLES FROM wikidata_p; |
8 years ago |