# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-28T22:46:18+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 'Bulletin of the Chemical Society of Japan') AND volume = 51 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 "5000200","5.415","0.002","25.964","0.011","35.183","0.013","69.82","0.04","113.14","0.04","121.15","0.03","3829.14","","","","","","","","","","","","","3","A -1","-P 1 (-x,-1/2*y+1/2*z,1/2*y+1/2*z)","2","","","","- C12 H24 O2 -","- C12 H23 O2 -","- C144 H276 O24 -","12","","","Goto, Midori; Asada, Eiichi","The Crystal Structure of the A-super Form of Laurie Acid","Bulletin of the Chemical Society of Japan","1978","51","1","70","74","10.1246/bcsj.51.70","","","","","","","","","","","","","","","","","","","","","has coordinates","175433","2020-10-21","18:00:00",""