# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-07T06:55:23+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 'Crystal Research and Technology') AND volume = 37 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
"1511459","10.123","","10.123","","10.123","","90","","90","","90","","1037.36","","","","","","","","","","","","","3","I 2 3","I 2 2 3","197","","Bi24.5 B O38.25","","- B Bi24.5 O38.25 -","- B Bi24.48 O38.24 -","- B Bi24.48 O38.24 -","1","0.0416667","","Muehlberg, M.; Held, P.; Burianek, M.","Improved single crystal growth of the boron sillenite ""Bi24 B2 O39"" and investigation of the crystal structure","Crystal Research and Technology","2002","37","","785","796","10.1002/1521-4079(200208)37:8<785::AID-CRAT785>3.0.CO;2-R","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1531633","3.8872","","3.8872","","11.521","","90","","90","","90","","174.086","","","","","","","","","","","","","6","P 4/m m m","-P 4 2","123","","(Cr0.62 Cu0.38) (Sr1.80 La0.20) (La0.54 Ca0.46) Cu2 O7.78","","- Ca0.46 Cr0.62 Cu2.38 La0.74 O7.78 Sr1.8 -","- Ca0.46 Cr0.62 Cu2.38 La0.74 O7.78 Sr1.8 -","- Ca0.46 Cr0.62 Cu2.38 La0.74 O7.78 Sr1.8 -","1","0.0625","","Kuz'micheva, G.M.; Esaulova, Yu.V.; Alsarraf, A.H.R.M.; Andreenko, A.S.; Palewski, T.; Kostyleva, I.E.; Khlybov, E.P.","Crystal structure of (Cr, Cu) (Sr, La)2 (La, A) Cu2 O8-d (1212- type) and (Cr, Cu) Sr2 (Y, Ce)2 Cu2 O10-d (1222-type) phases","Crystal Research and Technology","2002","37","","612","626","","","","","","","","","","","","","","","","","","","","","","has coordinates","157151","2020-10-21","18:00:00",""
"1531634","3.8437","","3.8437","","28.226","","90","","90","","90","","417.012","","","","","","","","","","","","","6","I 4/m m m","-I 4 2","139","","(Cr0.68 Cu0.32) Sr2 (Y1.26 Ce0.74) Cu2 O9.74","","- Ce0.74 Cr0.68 Cu2.32 O9.74 Sr2 Y1.26 -","- Ce0.74 Cr0.68 Cu2.32 O9.74 Sr2 Y1.26 -","- Ce1.48 Cr1.36 Cu4.64 O19.48 Sr4 Y2.52 -","2","0.0625","","Kuz'micheva, G.M.; Kostyleva, I.E.; Alsarraf, A.H.R.M.; Esaulova, Yu.V.; Palewski, T.; Andreenko, A.S.; Khlybov, E.P.","Crystal structure of (Cr, Cu) (Sr, La)2 (La, A) Cu2 O8-d (1212- type) and (Cr, Cu) Sr2 (Y, Ce)2 Cu2 O10-d (1222-type) phases","Crystal Research and Technology","2002","37","","612","626","","","","","","","","","","","","","","","","","","","","","","has coordinates","157154","2020-10-21","18:00:00",""
"1531949","12.513","","12.513","","11.231","","90","","90","","90","","1758.5","","","","","","","","","","","","","3","I 41","I 4bw","80","","Bi0.875 W0.125 O1.688","","- Bi0.875 O1.688 W0.125 -","- Bi0.875 O1.688 W0.125 -","- Bi35 O67.52 W5 -","40","5","","Nespolo, M.; Watanabe, A.; Suetsugu, Y.","Re-investigation of the structure of 7(Bi2 O3) * 2(W O3) by single-crystal X-ray diffraction","Crystal Research and Technology","2002","37","","414","422","","","","","","","","","","","","","","","","","","","","","","has coordinates","157547","2020-10-21","18:00:00",""