zh:notes:education
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 | ||
|
zh:notes:education [2024/06/23 15:41] pzczxs [Citation Information] |
zh:notes:education [2024/06/24 10:05] (当前版本) pzczxs [Extract Simple Cycles] |
||
|---|---|---|---|
| 行 197: | 行 197: | ||
| <code sql> | <code sql> | ||
| > SELECT ta_ca.target_article_id AS target_artice_id, ca.wos_id AS cited_article_id FROM target_article as ta, target_article_cited_article AS ta_ca, cited_article AS ca WHERE ta.id = ta_ca.target_article_id AND ta_ca.cited_article_id = ca.id AND ca.wos_id IS NOT NULL AND ta.publication_year <= 2020 And ta.publication_year != 0 AND ta.type IN ("Article; Proceedings Paper", "Reprint", "Article; Early Access", "Article", "Review", "Database Review") ORDER by ta_ca.target_article_id ASC; | > SELECT ta_ca.target_article_id AS target_artice_id, ca.wos_id AS cited_article_id FROM target_article as ta, target_article_cited_article AS ta_ca, cited_article AS ca WHERE ta.id = ta_ca.target_article_id AND ta_ca.cited_article_id = ca.id AND ca.wos_id IS NOT NULL AND ta.publication_year <= 2020 And ta.publication_year != 0 AND ta.type IN ("Article; Proceedings Paper", "Reprint", "Article; Early Access", "Article", "Review", "Database Review") ORDER by ta_ca.target_article_id ASC; | ||
| + | </code> | ||
| + | |||
| + | education technology: | ||
| + | <code sql> | ||
| + | > INSERT INTO citation (citing_doi, citing_publication_year, cited_doi, cited_publication_year) | ||
| + | > SELECT a.doi AS citing_doi, a.publication_year as citing_year, ca.doi AS cited_doi, ca.publication_year AS cited_year FROM article AS a, article_cited_article AS a_ca, cited_article AS ca | ||
| + | > WHERE a.id = a_ca.article_id AND a_ca.cited_article_id = ca.id | ||
| + | > AND a.TYPE IN ("Article", "Article; Early Access", "Article; Proceedings Paper", "Database Review", "Reprint", "Review", "Review; Early Access") | ||
| + | > AND a.doi is not null and ca.doi IS NOT NULL AND flag = 0 | ||
| + | > AND ca.journal_id IS NOT NULL | ||
| + | > ORDER BY citing_doi ASC, cited_doi ASC; | ||
| + | |||
| + | > DELETE FROM citation WHERE citing_doi = cited_doi; | ||
| </code> | </code> | ||
zh/notes/education.1719128496.txt.gz · 最后更改: 2024/06/23 15:41 由 pzczxs