# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-28T16:49:38+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 'Zeitschrift fur Kristallographie') AND volume = 122 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 "8103481","7.11","","7.11","","4.02","","90","","90","","90","","203.219","","","","","","","","","","","","","2","P 4/m b m","-P 4 2ab","127","","Y B4","","- B4 Y -","- B4 Y -","- B16 Y4 -","4","0.25","","Giese, Jr., R. F.; Matkovic, V. I.; Economy, J.","The crystal structure of YB~4~","Zeitschrift für Kristallographie","1965","122","5-6","423","432","10.1524/zkri.1965.122.5-6.423","","","","","","","","","","","","","","","","","","","","","has coordinates","176466","2020-10-21","18:00:00","" "9008113","9.072","","12.212","","6.113","","90","","104.83","","90","","654.683","","","","","","","","","","","","Synthetic","5","P 1 21/a 1","-P 2yab","14","","","Picromerite","- H12 K2 Mg O14 S2 -","- H12 K2 Mg O14 S2 -","- H24 K4 Mg2 O28 S4 -","2","0.5","","Kannan, K. K.; Viswamitra, M. A.","Crystal structure of magnesium potassium sulfate hexahydrate MgK2(SO4)2*6(H2O) Locality: synthetic","Zeitschrift fur Kristallographie","1965","122","","161","174","10.1524/zkri.1965.122.3-4.161","","","","","","","","","","","","","","","","","","","","","has coordinates","291455","2024-05-02","11:21:05","" "9008114","7.19","","7.19","","7.367","","90","","90","","120","","329.822","","","","","","","","","","","","Synthetic","2","P -3 c 1","-P 3 2""c","165","","","Fluocerite-(La)","- F3 La -","- F3 La -","- F18 La6 -","6","0.5","","Mansmann, M.","Die kristallstruktur von lanthantrifluorid","Zeitschrift fur Kristallographie","1965","122","","375","398","","","","","","","","","","","","","","","","","","","","","","has coordinates","291455","2024-05-02","11:21:05","" "9008115","25.16","","7.94","","8.47","","90","","100.47","","90","","1663.88","","","","","","","","","","","","Lengenbach quarry, Binnatal, Switzerland","3","P 1 21/a 1","-P 2yab","14","","","Rathite","- As5 Pb3 S10 -","- As5 Pb3 S10 -","- As20 Pb12 S40 -","4","1","","Marumo, F.; Nowacki, W.","The crystal structure of rathite-I","Zeitschrift fur Kristallographie","1965","122","","433","456","","","","","","","","","","","","","","","","","","","","","","has coordinates","291455","2024-05-02","11:21:05","" "9014352","10.158","","8.333","","8.551","","90","","112.333","","90","","669.521","","","","","","","","","","","","Chinchon (Madrid), Spain","4","C 1 2/c 1","-C 2yc","15","","","Glauberite","- Ca Na2 O8 S2 -","- Ca Na2 O8 S2 -","- Ca4 Na8 O32 S8 -","4","0.5","","Cocco, G.; Corazza, E.; Sabelli, C.","The crystal structure of glauberite, CaNa2(SO4)2","Zeitschrift fur Kristallographie","1965","122","","175","184","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:17","" "9015276","12.75","","12.75","","5.14","","90","","90","","120","","723.626","","","","","","","","","","","","Litchfield, USA","8","P 63","P 6c","173","","","Cancrinite","- C0.74 H2.46 Al3 Ca0.44 Fe0.04 Na3.16 O15.45 Si3 -","- C0.74 H2.46 Al3 Ca0.44 Fe0.04 Na3.16 O15.45 Si3 -","- C1.48 H4.92 Al6 Ca0.88 Fe0.08 Na6.32 O30.9 Si6 -","2","0.333333","","Jarchow, O.","Atomanordnung und Strukturverfeinerung von Cancrinit","Zeitschrift fur Kristallographie","1965","122","","407","422","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:51",""