USE enwiki_p;
SELECT DISTINCT el_to, el_from
FROM externallinks... |
5 years ago |
USE enwiki_p;
SELECT DISTINCT el_to, el_from
FROM externallinks... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from
FROM externallinks
WHERE
el_from <=... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from
FROM externallinks
WHERE
el_from <=... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from
FROM externallinks
WHERE
el_from <=... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from
FROM externallinks
WHERE
el_from <=... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from, COUNT(*) as CNT
FROM externallinks... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from, COUNT(*) as CNT
FROM externallinks... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from, COUNT(*) as CNT
FROM externallinks... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from, COUNT(*) as CNT
FROM externallinks... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from, COUNT(*) as CNT
FROM externallinks... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from, COUNT(*) as CNT
FROM externallinks... |
5 years ago |
USE enwiki_p;
SELECT el_to, el_from
FROM externallinks
WHERE
el_from <=... |
5 years ago |
USE enwiki_p;
SELECT el_to AND el_from
FROM externallinks
WHERE
el_from <=... |
5 years ago |
USE enwiki_p;
SELECT el_to
FROM externallinks
WHERE
el_from <= 100
... |
5 years ago |
USE enwiki_p;
SELECT *
FROM externallinks
WHERE
el_to LIKE "%doi.org%"... |
5 years ago |
USE nowiki_p;
SELECT *
FROM externallinks
WHERE
el_to LIKE "%doi.org%" |
5 years ago |
USE nnwiki_p;
SELECT *
FROM externallinks
WHERE
el_to LIKE "%doi.org%" |
5 years ago |
USE nnwiki_p;
SELECT *
FROM externallinks
WHERE
el_to LIKE "%//doi.org/%" |
5 years ago |
USE enwiki_p;
SELECT count(*)
FROM externallinks
WHERE
el_to LIKE "%//doi.org/%" |
5 years ago |
USE enwiki_p;
SELECT el_to
FROM externallinks
WHERE
el_to LIKE "%//doi.org/%" |
5 years ago |
SELECT *
FROM externallinks
WHERE
el_to LIKE "%//doi.org/%" |
5 years ago |
USE enwiki_p;
SELECT *
FROM externallinks
WHERE
el_to LIKE "%//doi.org/%" |
5 years ago |
USE enwiki_p;
SELECT *
FROM externallinks
WHERE
el_to LIKE "%//doi.org/%" |
5 years ago |
USE enwiki_p;
SELECT *
FROM externallinks
WHERE
el_to LIKE "%//doi.org/%" |
5 years ago |
USE enwiki_p;
SELECT COUNT(*)
FROM externallinks
WHERE
el_to LIKE "%//doi.org/%" |
5 years ago |
SELECT COUNT(*) FROM externallinks WHERE el_index LIKE "%doi.org%" |
5 years ago |
SELECT COUNT(*) FROM externallinks WHERE el_index CONTAINS "%doi.org%" |
5 years ago |
SELECT COUNT(*) FROM externallinks WHERE el_index CONTAINS "%doi.org" |
5 years ago |