User:SwMATHimport240215

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""",PairDiagSph

Links to wikidata

select qid, '"' || wikidata_id || '"' "P12"
from zz_mors_wikidata
         join zz_mors_mardi_software on swmath_id = swid;