# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-03T08:13:28+02: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 'Jiegon Huaxue') AND volume = 21 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 "1511738","7.731","","17.043","","9.019","","90","","90","","90","","1188.34","","","","","","","","","","","","","4","P n m a","-P 2ac 2n","62","","Ba3 La2 (B O3)4","","- B4 Ba3 La2 O12 -","- B4 Ba3 La2 O12 -","- B16 Ba12 La8 O48 -","4","0.5","","Wang, G.-F.; Pan, S.-K.; Huang, Z.-X.","Synthesis and structure of Ba3 La2 (B O3)4 crystal","Jiegon Huaxue","2002","21","","382","384","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00","" "1531879","7.685","","6.656","","6.377","","90","","90","","90","","326.192","","","","","","","","","","","","","3","P m n 21","P 2ac -2","31","","Cu3 (P Se4)","","- Cu3 P Se4 -","- Cu3 P Se4 -","- Cu6 P2 Se8 -","2","0.5","","Ma, H.-W.; Guo, G.-C.; Huang, J.-S.; Wang, M.-S.; Zhou, G.-W.; Dong Zhenchao; Lin, S.-H.","Synthesis and re-refinement of Cu3 P Se4","Jiegon Huaxue","2002","21","","288","291","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1532380","9.251","","9.251","","7.189","","90","","90","","120","","532.815","","","","","","","","","","","","","4","R 3 2 :H","R 3 2""","155","","Yb Al3 (B O3)4","","- Al3 B4 O12 Yb -","- Al3 B4 O12 Yb -","- Al9 B12 O36 Yb3 -","3","0.166667","","Xu, Y.-Y.; Chen, Y.-J.; Huang, Y.-D.; Luo, Z.-D.; Chen, J.-T.","Growth and crystal structure of Yb Al3 (B O3)4","Jiegon Huaxue","2002","21","","402","404","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1532429","11.666","","11.666","","13.593","","90","","90","","90","","1849.95","","","","","","","","","","","","","4","I 41/a m d :2","-I 4bd 2","141","","Ho4 S3 (Si2 O7)","","- Ho4 O7 S3 Si2 -","- Ho4 O7 S3 Si2 -","- Ho32 O56 S24 Si16 -","8","0.25","","Zeng, H.-Y.; Mao, J.-G.; Dong Zhenchao; Guo, G.-C.; Huang, J.-S.","Synthesis and crystal structure of Ho4 S3 Si2 O7","Jiegon Huaxue","2002","21","","157","160","","","","","","","","","","","","","","","","","","","","","","has coordinates","158141","2020-10-21","18:00:00","" "1532430","4.089","","14.498","","16.977","","90","","90","","90","","1006.44","","","","","","","","","","","","","4","C m c m","-C 2c 2","63","","Rb Er2 Cu3 Se5","","- Cu3 Er2 Rb Se5 -","- Cu3 Er2 Rb Se5 -","- Cu12 Er8 Rb4 Se20 -","4","0.25","","Zeng, H.-Y.; Guo, G.-C.; Dong Zhenchao; Mao, J.-G.; Huang, J.-S.","Synthesis annd single crystal structure of Rb Er2 Cu3 Se5","Jiegon Huaxue","2002","21","","497","500","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""