# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-10-14T01:35:31+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 'Acta Crystallographica, Section C: Crystal Structure Communications') AND volume = 42 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 "1100277","6.056","0.001","14.434","0.006","21.298","0.004","90","","90","","90","","1861.71","","","","","","","","","","","","","3","P 21 21 21","P 2ac 2ab","19","","","","- C19 H24 O8 -","- C19 H24 O8 -","- C76 H96 O32 -","4","1","","Harms, K.; Sheldrick, G. M.; Glüsenkamp, K.-H.; Tietze, L.-F.","An enantiospecific hetero Diels-Alder product","Acta Crystallographica, Section C: Crystal Structure Communications","1986","42","9","1268","1269","10.1107/S0108270186092636","","","","","","","","","","","","","","","","","","","","","has coordinates","176922","2020-10-21","18:00:00","" "1100281","10.34","0.005","10.809","0.005","13.613","0.001","97.53","0.04","101.65","0.04","113.84","0.03","1324.01","","","","","","","","","","","","","4","P -1","-P 1","2","","","","- C30 H32 N4 O4 -","- C30 H32 N4 O4 -","- C60 H64 N8 O8 -","2","1","","Harms, K.; Sheldrick, G. M.; Brüggemann, K.; Tietze, L. F.","Structure of an unexpected indole photolysis product","Acta Crystallographica, Section C: Crystal Structure Communications","1986","42","9","1264","1266","10.1107/S010827018609265X","","","","","","","","","","","","","","","","","","","","","has coordinates","176920","2020-10-21","18:00:00","" "1100282","8.424","0.001","14.773","0.002","22.165","0.002","90","","90","","90","","2758.38","","","","","","","","","","","","","3","P 21 21 21","P 2ac 2ab","19","","","","- C31 H32 O7 -","- C31 H32 O7 -","- C124 H128 O28 -","4","1","","Harms, K.; Sheldrick, G. M.; Glüsenkamp, K. H.; Tietze, L. F.","Structure of a photolysis product","Acta Crystallographica, Section C: Crystal Structure Communications","1986","42","9","1269","1271","10.1107/S0108270186092624","","","","","","","","","","","","","","","","","","","","","has coordinates","176916","2020-10-21","18:00:00","" "1100283","14.462","0.002","17.405","0.001","17.299","0.002","90","","90","","90","","4354.35","","","","","","","","","","","","","5","P b c a","-P 2ac 2ab","61","","","","- C23 H29 Cl N4 O3 -","- C23 H29 Cl N4 O3 -","- C184 H232 Cl8 N32 O24 -","8","1","","Harms, K.; Sheldrick, G. M.; Schul, W.; Tietze, L. F.","Structure of an indolochinolizine derivative","Acta Crystallographica, Section C: Crystal Structure Communications","1986","42","11","1665","1667","10.1107/S0108270186091023","","","","","","","","","","","","","","","","","","","","","has coordinates","176919","2020-10-21","18:00:00","" "1100284","7.779","0.006","9.332","0.003","19.627","0.009","90","","90","","90","","1424.8","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C16 H16 N2 O4 -","- C16 H16 N2 O4 -","- C64 H64 N8 O16 -","4","1","","Harms, K.; Sheldrick, G. M.; Tietze, L.-F.","Stereochemistry of a hetero-Diels-Alder product","Acta Crystallographica, Section C: Crystal Structure Communications","1986","42","11","1664","1665","10.1107/S0108270186091035","","","","","","","","","","","","","","","","","","","","","has coordinates","176923","2020-10-21","18:00:00","" "1100285","8.745","0.002","33.451","0.005","8.845","0.002","90","","90","","90","","2587.42","","","","","","","","","","","","","4","P b c a","-P 2ac 2ab","61","","","","- C12 H18 O4 S -","- C12 H18 O4 S -","- C96 H144 O32 S8 -","8","1","","Harms, K.; Sheldrick, G. M.; Reichert, U.; Tietze, L. F.","Structure of a cycloheptenone derivative","Acta Crystallographica, Section C: Crystal Structure Communications","1986","42","11","1662","1663","10.1107/S0108270186091047","","","","","","","","","","","","","","","","","","","","","has coordinates","176917","2020-10-21","18:00:00","" "1100286","5.615","0.002","8.013","0.001","16.673","0.004","89.98","0.02","87.9","0.02","85.07","0.02","746.89","","","","","","","","","","","","","3","P -1","-P 1","2","","","","- C14 H18 O7 -","- C14 H18 O7 -","- C28 H36 O14 -","2","1","","Harms, K.; Jones, P. G.; Sheldrick, G. M.","Structure of an iridoid-like photolysis product","Acta Crystallographica, Section C: Crystal Structure Communications","1986","42","11","1661","1662","10.1107/S0108270186091059","","","","","","","","","","","","","","","","","","","","","has coordinates","176915","2020-10-21","18:00:00","" "2020756","11.512","0.003","3.564","0.001","4.368","0.001","90","","90","","90","","179.21","0.08","","","292","","","","","","","","","2","P m m n :2","-P 2ab 2a","59","","","","- O5 V2 -","- O5 V2 -","- O10 V4 -","2","0.25","","Enjalbert, Renee; Galy, Jean","A refinement of the structure of V~2~O~5~","Acta Crystallographica, Section C: Crystal Structure Communications","1986","42","11","1467","1469","10.1107/s0108270186091825","","x-ray","0.71069","MoKα","","","0.02","","","0.027","","","","","","","","","","","has coordinates","200783","2020-10-21","18:00:00","" "2020897","7.8586","0.0002","7.8586","0.0002","7.8586","0.0002","90","","90","","90","","485.33","0.02","","","","","","","","","","","","3","P a -3","-P 2ac 2ab 3","205","","Lead(II) nitrate","","- N2 O6 Pb -","- N2 O6 Pb -","- N8 O24 Pb4 -","4","0.166667","","Nowotny, H.; Heger, G.","Structure refinement of lead nitrate","Acta Crystallographica, Section C: Crystal Structure Communications","1986","42","2","133","135","10.1107/s0108270186097032","","neutron","0.8313","","","0.034","0.019","","0.037","0.015","","","","","","","","","","","has coordinates","205203","2020-10-21","18:00:00",""