# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-01T14:45:25+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 'Croatica Chemica Acta') AND volume = 77 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 "9015550","7.80411","","7.82272","","7.9231","","90","","90","","90","","483.7","","","","","","","","","","","","Synthetic","4","C m m m","-C 2 2","65","Compound 3","","","- La0.741 Nb1.778 O6 Ti0.222 -","- La0.741 Nb1.778 O6 Ti0.222 -","- La2.964 Nb7.112 O24 Ti0.888 -","4","0.25","","Golobic, A.; Skapin, S. D.; Suvorov, D.; Meden, A.","Solving Structural Problems of Ceramic Materials","Croatica Chemica Acta","2004","77","3","435","446","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19","" "9015573","11.2041","","8.85114","","5.2718","","90","","115.328","","90","","472.544","","","","","","","","","","","","Synthetic","4","C 1 2/c 1","-C 2yc","15","Compound 1","","","- La Nb O6 Ti -","- La Nb O6 Ti -","- La4 Nb4 O24 Ti4 -","4","0.5","","Golobic, A.; Skapin, S. D.; Suvorov, D.; Meden, A.","Solving Structural Problems of Ceramic Materials","Croatica Chemica Acta","2004","77","3","435","446","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19","" "9015897","10.96305","","7.58996","","5.46833","","90","","90","","90","","455.015","","","","","","","","","","","","Synthetic","4","P n m a","-P 2ac 2n","62","Compound 2","","Aeschynite-(La)","- La0.924 Nb1.228 O6 Ti0.772 -","- La0.924 Nb1.228 O6 Ti0.772 -","- La3.696 Nb4.912 O24 Ti3.088 -","4","0.5","","Golobic, A.; Skapin, S. D.; Suvorov, D.; Meden, A.","Solving Structural Problems of Ceramic Materials","Croatica Chemica Acta","2004","77","3","435","446","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:54",""