User:SwMATHimport240215: Difference between revisions
From MaRDI portal
No edit summary |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
quick statements | quick statements generation SQL command | ||
<syntaxhighlight lang=sql> | <syntaxhighlight lang=sql> | ||
SELECT '' as "qid", '"' || cast(id as text) || '"' as "P13", name as "Len" | SELECT '' as "qid", '"' || cast(id as text) || '"' as "P13", name as "Len" | ||
| Line 26: | Line 26: | ||
"","""45475""",PairDiagSph | "","""45475""",PairDiagSph | ||
</syntaxhighlight> | </syntaxhighlight> | ||
== Links to wikidata == | |||
<syntaxhighlight lang='sql'> | |||
select qid, '"' || wikidata_id || '"' "P12" | |||
from zz_mors_wikidata | |||
join zz_mors_mardi_software on swmath_id = swid; | |||
</syntaxhighlight> | |||
Latest revision as of 20:27, 20 February 2024
quick statements generation SQL command
SELECT '' as "qid", '"' || cast(id as text) || '"' as "P13", name as "Len"
from swmath_software
where id not in (Select swid from zz_mors_mardi_software)
Example data
qid,P13,Len
"","""45040""",Disco
"","""41172""",CANS+
"","""41159""",SPECTOR3D
"","""42240""",VecDualSPHysics
"","""46232""",GPT-4
"","""45587""",groupICA
"","""44347""",SymSpin
"","""46610""",HYSPLIT
"","""41774""",GENE-3D
"","""42090""",FeatureScout
"","""46144""",PARETO
"","""45275""",ScaFi
"","""46052""",SearchCol
"","""44452""",CALIMA
"","""46722""",Juno
"","""45475""",PairDiagSphLinks to wikidata
select qid, '"' || wikidata_id || '"' "P12"
from zz_mors_wikidata
join zz_mors_mardi_software on swmath_id = swid;
