SELECT * FROM wikidatawiki_p.wbs_propertypairs WHERE pid1=31 AND qid1=5; |
7 years ago |
SELECT count(DISTINCT qid1) from wikidatawiki_p.wbs_propertypairs where pid1=31; |
7 years ago |
SELECT count(DISTINCT qid1) from wikidatawiki_p.wbs_propertypairs; |
7 years ago |
SELECT count(DISTINCT pid2) from wikidatawiki_p.wbs_propertypairs; |
7 years ago |
SELECT count(DISTINCT pid1) from wikidatawiki_p.wbs_propertypairs; |
7 years ago |
SELECT * from wikidatawiki_p.wbs_propertypairs where pid1=7631649; |
7 years ago |
SELECT * from wikidatawiki_p.wbs_propertypairs where pid1='7631649'; |
7 years ago |
SELECT * from wikidatawiki_p.wbs_propertypairs where pid1='7631649'; |
7 years ago |
SELECT * from wikidatawiki_p.wbs_propertypairs where pid1='Q7631649'; |
7 years ago |
show table frrom recoin_sample; |
7 years ago |
SELECT * from wikidatawiki_p.wbs_propertypairs; |
7 years ago |
SELECT * from wbs_propertypairs; |
7 years ago |