# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-28T06:48:13+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 'Materials Letters') AND volume = 41 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 "1522006","8.2","","8.2","","5.123","","90","","90","","120","","298.32","","","","","","","","","","","","","4","P 3 2 1","P 3 2""","150","","La3 (Mo0.25 Ga0.75) Ga5 O14","","- Ga5.75 La3 Mo0.25 O14 -","- Ga5.75 La3 Mo0.25 O14 -","- Ga5.75 La3 Mo0.25 O14 -","1","0.166667","","Takeda, H.; Fukuda, T.; Sato, J.; Kato, T.; Morikoshi, H.; Shimamura, K.","Synthesis and structure of La3 (M1/3 Ga2/3) Ga5 O14 (M = Mo(6+) and W(6+)) crystals","Materials Letters","1999","41","","104","111","","","","","","","","","","","","","","","","","","","","","","has coordinates","142225","2020-10-21","18:00:00","" "1522007","8.208","","8.208","","5.126","","90","","90","","120","","299.078","","","","","","","","","","","","","4","P 3 2 1","P 3 2""","150","","La3 (W0.256 Ga0.744) Ga5 O14","","- Ga5.744 La3 O14 W0.256 -","- Ga5.744 La3 O14 W0.256 -","- Ga5.744 La3 O14 W0.256 -","1","0.166667","","Takeda, H.; Shimamura, K.; Morikoshi, H.; Sato, J.; Kato, T.; Fukuda, T.","Synthesis and structure of La3 (M1/3 Ga2/3) Ga5 O14 (M = Mo(6+) andW(6+)) crystals","Materials Letters","1999","41","","104","111","","","","","","","","","","","","","","","","","","","","","","has coordinates","142226","2020-10-21","18:00:00",""