# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2025-12-11T15:52:34+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 'Organic Process Research & Development') AND volume = 9 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
"1506789","8.879","0.001","9.416","0.001","22.361","0.002","90","","95.98","0.007","90","","1859.3","0.3","293","2","293","2","","","","","","","","5","P 1 21/n 1","-P 2yn","14","tazarotene","6-(2-(4,4-dimethyl-thiochroman-6yl)ethynyl)-nicotinic acid ethyl ester","","- C21 H21 N O2 S -","- C21 H21 N O2 S -","- C84 H84 N4 O8 S4 -","4","1","","Frigoli, Samuele; Fuganti, Claudio; Malpezzi, Luciana; Serra, Stefano","A Practical and Efficient Process for the Preparation of Tazarotene","Organic Process Research & Development","2005","9","5","646","","10.1021/op050080x","","","1.54179","CuKα","","0.0644","0.0592","","","0.1585","0.1648","","","","","","1.057","","","","has coordinates","301775","2025-08-18","14:03:03",""
"1506790","10.066","0.002","28.719","0.005","4.831","0.001","90","","103.45","0.01","90","","1358.3","0.5","120","2","120","2","","","","","","","","4","P 1 21/c 1","-P 2ybc","14","carbamazepine dihydrate","5H-dibenz(b,f)azepine-5-carboxamide, dihydrate","","- C15 H16 N2 O3 -","- C15 H16 N2 O3 -","- C60 H64 N8 O12 -","4","1","","Harris, Robin K.; Ghi, Phuong Y.; Puschmann, Horst; Apperley, David C.; Griesser, Ulrich J.; Hammond, Robert B.; Ma, Caiyun; Roberts, Kevin J.; Pearce, Greg J.; Yates, Jonathan R.; Pickard, Chris J.","Structural Studies of the Polymorphs of Carbamazepine, Its Dihydrate, and Two Solvates","Organic Process Research & Development","2005","9","6","902","","10.1021/op0500990","","","0.71073","MoKα","","0.0916","0.0729","","","0.1926","0.214","","","","","","0.85","","","","has coordinates","301775","2025-08-18","14:03:03",""