# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-10-01T06:04:45+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 'New journal of chemistry = Nouveau journal de chimie') AND volume = 40 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 "7055354","8.2966","0.0004","23.4782","0.0012","25.175","0.0011","90","","90","","90","","4903.8","0.4","100","0.5","100","0.5","","","","","","","","7","P 21 21 21","P 2ac 2ab","19","","","","- C24 H23 B Cl2 F2 I2 N2 -","- C24 H23 B Cl2 F2 I2 N2 -","- C192 H184 B8 Cl16 F16 I16 N16 -","8","2","","Meng, Qianli; Fronczek, Frank R.; Vicente, M Graça H","Synthesis and spectroscopic properties of β,β'-dibenzo-3,5,8-triaryl-BODIPYs.","New journal of chemistry = Nouveau journal de chimie","2016","40","7","5740","5751","10.1039/C5NJ03324A","","","0.71073","MoKα","","0.0548","0.0527","","","0.1231","0.124","","","","","","1.221","","","","has coordinates","187158","2020-10-21","18:00:00","" "7055355","11.0477","0.0015","14.069","0.002","17.029","0.003","90","","90","","90","","2646.8","0.7","100","0.5","100","0.5","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","","","","- C35 H31 B F2 N2 -","- C35 H31 B F2 N2 -","- C140 H124 B4 F8 N8 -","4","1","","Meng, Qianli; Fronczek, Frank R.; Vicente, M Graça H","Synthesis and spectroscopic properties of β,β'-dibenzo-3,5,8-triaryl-BODIPYs.","New journal of chemistry = Nouveau journal de chimie","2016","40","7","5740","5751","10.1039/C5NJ03324A","","","0.71073","MoKα","","0.04","0.0327","","","0.0738","0.0771","","","","","","1.029","","","","has coordinates","187158","2020-10-21","18:00:00","" "7055356","15.788","0.0006","12.5007","0.0006","15.9397","0.0007","90","","116.931","0.004","90","","2804.7","0.2","90","0.5","90","0.5","","","","","","","","6","C 1 2/c 1","-C 2yc","15","","","","- C35 H29 B F2 N4 O4 -","- C35 H29 B F2 N4 O4 -","- C140 H116 B4 F8 N16 O16 -","4","0.5","","Meng, Qianli; Fronczek, Frank R.; Vicente, M Graça H","Synthesis and spectroscopic properties of β,β'-dibenzo-3,5,8-triaryl-BODIPYs.","New journal of chemistry = Nouveau journal de chimie","2016","40","7","5740","5751","10.1039/C5NJ03324A","","","0.71073","MoKα","","0.0675","0.0468","","","0.1155","0.1278","","","","","","1.01","","","","has coordinates","187158","2020-10-21","18:00:00","" "7055357","9.7694","0.0008","13.1321","0.001","13.2027","0.0008","93.757","0.005","104.793","0.004","102.323","0.004","1587","0.2","90","0.5","90","0.5","","","","","","","","6","P -1","-P 1","2","","","","- C38 H31 B Cl2 F2 N4 -","- C38 H31 B Cl2 F2 N4 -","- C76 H62 B2 Cl4 F4 N8 -","2","1","","Meng, Qianli; Fronczek, Frank R.; Vicente, M Graça H","Synthesis and spectroscopic properties of β,β'-dibenzo-3,5,8-triaryl-BODIPYs.","New journal of chemistry = Nouveau journal de chimie","2016","40","7","5740","5751","10.1039/C5NJ03324A","","","0.71073","MoKα","","0.1145","0.0576","","","0.1243","0.1484","","","","","","1.022","","","","has coordinates","187158","2020-10-21","18:00:00","" "7055358","8.1559","0.0009","13.0389","0.0014","15.7981","0.0018","114.011","0.004","91.649","0.005","102.179","0.005","1487.7","0.3","90","0.5","90","0.5","","","","","","","","5","P -1","-P 1","2","","","","- C37 H29 B F8 N2 -","- C37 H29 B F8 N2 -","- C74 H58 B2 F16 N4 -","2","1","","Meng, Qianli; Fronczek, Frank R.; Vicente, M Graça H","Synthesis and spectroscopic properties of β,β'-dibenzo-3,5,8-triaryl-BODIPYs.","New journal of chemistry = Nouveau journal de chimie","2016","40","7","5740","5751","10.1039/C5NJ03324A","","","0.71073","MoKα","","0.0503","0.0411","","","0.1117","0.1187","","","","","","1.033","","","","has coordinates,has disorder","187158","2020-10-21","18:00:00","" "7055359","9.5919","0.0002","34.432","0.0006","13.4607","0.0002","90","","107.899","0.001","90","","4230.47","0.13","90","0.5","90","0.5","","","","","","","","7","P 1 21/n 1","-P 2yn","14","","","","- C52 H45 B Cl2 F2 N2 O4 -","- C52 H45 B Cl2 F2 N2 O4 -","- C208 H180 B4 Cl8 F8 N8 O16 -","4","1","","Meng, Qianli; Fronczek, Frank R.; Vicente, M Graça H","Synthesis and spectroscopic properties of β,β'-dibenzo-3,5,8-triaryl-BODIPYs.","New journal of chemistry = Nouveau journal de chimie","2016","40","7","5740","5751","10.1039/C5NJ03324A","","","0.71073","MoKα","","0.0823","0.0544","","","0.1318","0.1468","","","","","","1.039","","","","has coordinates","187158","2020-10-21","18:00:00","" "7055360","8.9607","0.0014","10.4013","0.0015","14.964","0.003","98.262","0.009","106.17","0.006","107.413","0.009","1238.3","0.4","90","0.5","90","0.5","","","","","","","","5","P -1","-P 1","2","","","","- C35 H23 B F2 N2 -","- C35 H23 B F2 N2 -","- C70 H46 B2 F4 N4 -","2","1","","Meng, Qianli; Fronczek, Frank R.; Vicente, M Graça H","Synthesis and spectroscopic properties of β,β'-dibenzo-3,5,8-triaryl-BODIPYs.","New journal of chemistry = Nouveau journal de chimie","2016","40","7","5740","5751","10.1039/C5NJ03324A","","","0.71073","MoKα","","0.0686","0.0444","","","0.1017","0.1139","","","","","","1.029","","","","has coordinates","187158","2020-10-21","18:00:00","" "7055361","12.2985","0.0006","12.9578","0.0006","18.4622","0.0009","90","","108.407","0.002","90","","2791.6","0.2","90","0.5","90","0.5","","","","","","","","6","P 1 21/c 1","-P 2ybc","14","","","","- C35 H21 B F2 N4 O4 -","- C35 H21 B F2 N4 O4 -","- C140 H84 B4 F8 N16 O16 -","4","1","","Meng, Qianli; Fronczek, Frank R.; Vicente, M Graça H","Synthesis and spectroscopic properties of β,β'-dibenzo-3,5,8-triaryl-BODIPYs.","New journal of chemistry = Nouveau journal de chimie","2016","40","7","5740","5751","10.1039/C5NJ03324A","","","0.71073","MoKα","","0.0748","0.0532","","","0.1246","0.136","","","","","","1.011","","","","has coordinates","187158","2020-10-21","18:00:00","" "7055362","13.2913","0.0016","16.431","0.002","13.4762","0.0016","90","","107.238","0.002","90","","2810.9","0.6","90","0.5","90","0.5","","","","","","","","6","P 1 21 1","P 2yb","4","","","","- C37 H20.95 B Cl0.05 F2 N4 -","- C37 H20.952 B Cl0.048 F2 N4 -","- C148 H83.808 B4 Cl0.192 F8 N16 -","4","2","","Meng, Qianli; Fronczek, Frank R.; Vicente, M Graça H","Synthesis and spectroscopic properties of β,β'-dibenzo-3,5,8-triaryl-BODIPYs.","New journal of chemistry = Nouveau journal de chimie","2016","40","7","5740","5751","10.1039/C5NJ03324A","","","0.71073","MoKα","","0.0489","0.0401","","","0.095","0.0999","","","","","","1.035","","","","has coordinates,has disorder","187158","2020-10-21","18:00:00",""