# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-26T20:34:32+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 'Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE') 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 "1548498","28.309","0.0013","24.2881","0.0011","10.6225","0.0005","90","","95.253","0.001","90","","7273.1","0.6","295","2","295","2","","","","","","","","8","C 1 2/m 1","-C 2y","12","","","","- C114 H82 Au4 F12 N4 O12 P4 S4 -","- C114 H82 Au4 F12 N4 O12 P4 S4 -","- C228 H164 Au8 F24 N8 O24 P8 S8 -","2","0.25","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.0945","0.0659","","","0.2158","0.2375","","","","","","1.04","","","","has coordinates","204399","2020-10-21","18:00:00","" "1548499","27.4266","0.0017","21.6592","0.0015","23.647","0.0016","90","","90","","90","","14047.2","1.6","295","2","295","2","","","","","","","","9","P n n m","-P 2 2n","58","","","","- C118 H90 Au4 Br F12 N4 O13 P4 S4 -","- C118 H90 Au4 Br F12 N4 O13 P4 S4 -","- C472 H360 Au16 Br4 F48 N16 O52 P16 S16 -","4","0.5","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.1191","0.066","","","0.2076","0.2444","","","","","","1.047","","","","has coordinates","204400","2020-10-21","18:00:00","" "1548500","28.242","0.004","24.405","0.004","10.3082","0.0016","90","","96.392","0.003","90","","7060.7","1.9","193","2","193","2","","","","","","","","8","C 1 2/m 1","-C 2y","12","","","","- C100 H72 Au4 F12 N4 O16.8 P4 S4 -","- C100 H72 Au4 F12 N4 O16.8 P4 S4 -","- C200 H144 Au8 F24 N8 O33.6 P8 S8 -","2","0.25","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.1365","0.0748","","","0.2187","0.2426","","","","","","0.968","","","","has coordinates,has disorder","204402","2020-10-21","18:00:00","" "1548501","28.406","0.002","24.235","0.0016","10.7465","0.0008","90","","94.496","0.002","90","","7375.3","0.9","295","2","295","2","","","","","","","","9","C 1 2/m 1","-C 2y","12","","","","- C117 H84 Au4 Cl2 F12 N4 O12 P4 S4 -","- C117 H80.6 Au4 Cl2 F12 N4 O12 P4 S4 -","- C234 H161.2 Au8 Cl4 F24 N8 O24 P8 S8 -","2","0.25","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.1452","0.0705","","","0.1948","0.2321","","","","","","0.941","","","","has coordinates","204403","2020-10-21","18:00:00","" "1548502","21.247","0.003","18.09","0.002","20.065","0.002","90","","90","","90","","7712.1","1.6","223","2","223","2","","","","","","","","6","P c c n","-P 2ab 2ac","56","","","","- C40 H33 Au2 N2 O6.5 P2 -","- C40 H33 Au2 N2 O6.5 P2 -","- C320 H264 Au16 N16 O52 P16 -","8","1","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.0753","0.053","","","0.1215","0.1323","","","","","","1.055","","","","has coordinates,has disorder","204404","2020-10-21","18:00:00","" "1548503","14.092","0.002","9.7574","0.0015","29.812","0.005","90","","101.907","0.004","90","","4011","1.1","223","2","223","2","","","","","","","","8","P 1 21/c 1","-P 2ybc","14","","","","- C42 H32.5 Ag F3 N1.5 O3 P2 S -","- C42 H32.5 Ag F3 N1.5 O3 P2 S -","- C168 H130 Ag4 F12 N6 O12 P8 S4 -","4","1","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.1091","0.0664","","","0.1698","0.1868","","","","","","0.954","","","","has coordinates","204405","2020-10-21","18:00:00","" "1548504","9.7009","0.0006","14.5954","0.001","24.0063","0.0016","90","","90","","90","","3399","0.4","223","2","223","2","","","","","","","","7","P 21 21 21","P 2ac 2ab","19","","","","- C40 H31 Ag Cl N O4 P2 -","- C40 H31 Ag Cl N O4 P2 -","- C160 H124 Ag4 Cl4 N4 O16 P8 -","4","1","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.0772","0.0708","","","0.1853","0.192","","","","","","1.054","","","","has coordinates","216710","2020-10-21","18:00:00","" "1548505","19.4287","0.0007","36.4741","0.0012","42.9932","0.0015","90","","90","","90","","30466.9","1.8","223","2","223","2","","","","","","","","6","F d d d :2","-F 2uv 2vw","70","","","","- C156 H120 Ag4 Cl12 O16 P8 -","- C156 H120 Ag4 Cl12 O16 P8 -","- C1248 H960 Ag32 Cl96 O128 P64 -","8","0.25","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.11","0.0843","","","0.2108","0.2263","","","","","","1.087","","","","has coordinates,has disorder","204407","2020-10-21","18:00:00","" "1548506","9.7572","0.0005","14.8314","0.0008","24.1685","0.0014","90","","90","","90","","3497.5","0.3","223","2","223","2","","","","","","","","6","P 21 21 21","P 2ac 2ab","19","","","","- C40 H31 Ag F6 N P3 -","- C40 H31 Ag F6 N P3 -","- C160 H124 Ag4 F24 N4 P12 -","4","1","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.0558","0.052","","","0.1233","0.1256","","","","","","1.148","","","","has coordinates","216710","2020-10-21","18:00:00","" "1548507","18.7319","0.0008","18.51","0.0008","25.8368","0.0011","90","","90","","90","","8958.3","0.7","293","2","293","2","","","","","","","","8","P m n 21","P 2ac -2","31","","","","- C90.45 H83.9 Ag2 Cl0.7 F12 N4 O1.5 P6 -","- C90.45 H83.9 Ag2 Cl0.7 F12 N4 O1.5 P6 -","- C361.8 H335.6 Ag8 Cl2.8 F48 N16 O6 P24 -","4","1","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.0473","0.0412","","","0.1158","0.1211","","","","","","1.061","","","","has coordinates,has disorder","204409","2020-10-21","18:00:00","" "1548508","15.7878","0.0014","39.138","0.004","21.1625","0.0017","90","","111.148","0.002","90","","12195.7","1.9","223","2","223","2","","","","","","","","7","C 1 c 1","C -2yc","9","","","","- C131 H127 Ag3 B3 F12 O5 P6 -","- C131 H127 Ag3 B3 F12 O5 P6 -","- C524 H508 Ag12 B12 F48 O20 P24 -","4","1","","Lin Rong Er","Gold rectangle, silver rings and helices - A study of self-assembly and molecular recognition of metallo-supramolecules","Ph.D Thesis - NATIONAL UNIVERSITY OF SINGAPORE","2005","","","1","","","","","0.71073","MoKα","","0.1134","0.066","","","0.1513","0.1727","","","","","","0.966","","","","has coordinates,has disorder","204410","2020-10-21","18:00:00",""