| USE wikidatawiki_p;
#SELECT * FROM wbs_propertypairs WHERE pid2 = 138 AND... |
5 years ago |
| USE wikidatawiki_p;
#SELECT * FROM wbs_propertypairs WHERE pid2 = 138 AND... |
6 years ago |
| USE wikidatawiki_p;
#SELECT * FROM wbs_propertypairs WHERE pid2 = 138 AND... |
7 years ago |
| USE wikidatawiki_p;
#SELECT * FROM wbs_propertypairs WHERE pid2 = 138 AND... |
7 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs WHERE pid2 = 138 AND... |
7 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs WHERE pid2 = 138 AND... |
8 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs WHERE pid2 = 138 AND... |
8 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
WHERE pid2 = 138 AND... |
8 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
WHERE pid2 = 138 AND... |
8 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
WHERE pid2 = 138 AND... |
8 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
WHERE pid2 = 138
ORDER... |
8 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
WHERE pid1 = 31 AND qid1... |
8 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
WHERE pid1 = 31 AND qid1... |
8 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
WHERE pid1 = 69
ORDER BY... |
8 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
WHERE pid1 = 31
ORDER BY... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
WHERE pid1 = 31
ORDER BY... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
ORDER BY probability... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
ORDER BY probability DESC; |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
ORDER BY probability... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
ORDER BY probability... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
where pid2 IN... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
where pid2 IN... |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
where pid1 = 31
LIMIT 50; |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs where pid1 = 31; |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs
LIMIT 10; |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs; |
9 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_property_pairs; |
9 years ago |
| /*SELECT itwiki.page_title, frwiki.page_title,... |
9 years ago |
| /*SELECT itwiki.page_title, frwiki.page_title,... |
9 years ago |
| /*SELECT itwiki.page_title, frwiki.page_title,... |
9 years ago |
| SELECT itwiki.page_title, frwiki.page_title,... |
9 years ago |
| SELECT *# itwiki.page_title, frwiki.page_title,... |
9 years ago |
| SELECT *# itwiki.page_title, frwiki.page_title,... |
9 years ago |
| SELECT *# itwiki.page_title, frwiki.page_title,... |
9 years ago |
| SELECT *# itwiki.page_title, frwiki.page_title,... |
9 years ago |
| SELECT itwiki.page_title, frwiki.page_title,... |
9 years ago |
| SELECT itwiki.page_title, frwiki.page_title,... |
9 years ago |
| SELECT itwiki.page_title, frwiki.page_title,... |
9 years ago |
| SELECT page_title, SUBSTRING_INDEX(page_title, '_', -1)
FROM itwiki_p.page... |
9 years ago |
| SELECT page_title, SUBSTRING_INDEX(page_title, '_', -1)
FROM... |
9 years ago |
| SELECT page_title, SUBSTRING_INDEX(page_title,' ',-1)
FROM... |
9 years ago |
| SELECT page_title, SUBSTRING_INDEX(page_title,' ',-1)
FROM... |
9 years ago |
| SELECT page_title, SUBSTRING_INDEX(page_title,' ',-1)
FROM... |
9 years ago |
| SELECT page_title, SUBSTRING_INDEX(page_title,' ',-1)
FROM... |
9 years ago |
| USE wikidatawiki_p;
SELECT page_title, SUBSTRING_INDEX(page_title,'... |
9 years ago |
| USE wikidatawiki_p;
SELECT page_title, SUBSTRING_INDEX(page_title,'... |
9 years ago |
