# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-24T15:55:20+01:00 # Query: # SELECT data.* # FROM # data JOIN jaltnames # ON altname = journal # WHERE # (status is null or status != 'retracted') and # (journal_id IN (SELECT DISTINCT(journal_id) FROM jaltnames WHERE altname LIKE 'Journal of the Korean Chemical Society') AND volume = 43 AND duplicateof IS NULL AND (status is NULL OR status != 'errors') AND (method is NULL OR method != 'theoretical')) # ORDER BY file asc file,a,siga,b,sigb,c,sigc,alpha,sigalpha,beta,sigbeta,gamma,siggamma,vol,sigvol,celltemp,sigcelltemp,diffrtemp,sigdiffrtemp,cellpressure,sigcellpressure,diffrpressure,sigdiffrpressure,thermalhist,pressurehist,compoundsource,nel,sg,sgHall,sgNumber,commonname,chemname,mineral,formula,calcformula,cellformula,Z,Zprime,acce_code,authors,title,journal,year,volume,issue,firstpage,lastpage,doi,method,radiation,wavelength,radType,radSymbol,Rall,Robs,Rref,wRall,wRobs,wRref,RFsqd,RI,gofall,gofobs,gofgt,gofref,duplicateof,optimal,status,flags,svnrevision,date,time,onhold "1520967","24.883","","24.883","","24.883","","90","","90","","90","","15406.7","","","","","","","","","","","","","5","F d -3 :2","-F 2uv 2vw 3","203","","Ca18 Tl56 (Si100 Al92 O384)","","- Al92 Ca18 O384 Si100 Tl56 -","- Al91.9968 Ca18 O384 Si100.003 Tl56.0064 -","- Al91.9968 Ca18 O384 Si100.003 Tl56.0064 -","1","0.0104167","","Choi, E.-Y.; Kim, Y.","Two anhydrous zeolite X crystal structures, Ca18 Tl56 Si100 Al92 O384 and Ca32 Tl28 Si100 Al92 O384","Journal of the Korean Chemical Society","1999","43","","384","392","","","","","","","","","","","","","","","","","","","","","","has coordinates","140577","2020-10-21","18:00:00","" "1520969","24.973","","24.973","","24.973","","90","","90","","90","","15574.4","","","","","","","","","","","","","5","F d -3 :2","-F 2uv 2vw 3","203","","Ca32 Tl28 (Si100 Al92 O384)","","- Al92 Ca32 O384 Si100 Tl28 -","- Al91.9968 Ca32 O384 Si100.003 Tl27.9968 -","- Al91.9968 Ca32 O384 Si100.003 Tl27.9968 -","1","0.0104167","","Choi, E.-Y.; Kim, Y.","Two anhydrous zeolite X crystal structures, Ca18 Tl56 Si100 Al92 O384 and Ca32 Tl28 Si100 Al92 O384","Journal of the Korean Chemical Society","1999","43","","384","392","","","","","","","","","","","","","","","","","","","","","","has coordinates","140579","2020-10-21","18:00:00",""