# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-29T12:00:31+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 'Green Chemistry') AND volume = 4 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
"7204407","24.9478","0.0009","6.0316","0.0002","8.3285","0.0003","90","","98.391","0.001","90","","1239.82","0.08","123","2","123","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","2-(5'-bromo-2'-hydroxyphenyl)-1,2,3,4-tetrahydroquinazoline","2-[(2'-amino-benzylimino)-methyl]-4-bromo-phenol","","- C14 H13 Br N2 O -","- C14 H13 Br N2 O -","- C56 H52 Br4 N8 O4 -","4","1","","Correa, Waldo H.; Papadopoulos, Stavroula; Radnidge, Peta; Roberts, Brett A.; Scott, Janet L.","Direct, efficient, solvent-free synthesis of 2-aryl-1,2,3,4-tetrahydroquinazolines","Green Chemistry","2002","4","3","245","","10.1039/b202729c","","","0.71073","MoKα","","0.0513","0.0422","","","0.106","0.1113","","","","","","1.051","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7204408","9.436","0.0005","10.4454","0.0005","12.0165","0.0008","99.837","0.002","98.858","0.002","101.754","0.004","1120.4","0.11","123","2","123","2","","","","","","","","3","P -1","-P 1","2","2-phenyl-1,2,3,4-tetrahydroquinazoline","2-phenyl-1,2,3,4-tetrahydroquinazoline","","- C14 H14 N2 -","- C14 H13 N2 -","- C56 H52 N8 -","4","2","","Correa, Waldo H.; Papadopoulos, Stavroula; Radnidge, Peta; Roberts, Brett A.; Scott, Janet L.","Direct, efficient, solvent-free synthesis of 2-aryl-1,2,3,4-tetrahydroquinazolines","Green Chemistry","2002","4","3","245","","10.1039/b202729c","","","0.71073","MoKα","","0.1408","0.0822","","","0.2063","0.2397","","","","","","1.032","","","","has coordinates","180375","2020-10-21","18:00:00",""
"7204409","12.1392","0.0002","7.7897","0.0002","13.5753","0.0003","90","","111.14","0.008","90","","1197.3","0.08","123","2","123","2","","","","","","","","4","P 1 21/c 1","-P 2ybc","14","2-(2'-nitrophenyl)-1,2,3,4-tetrahydroquinazoline","2-(2'-nitrophenyl)-1,2,3,4-tetrahydroquinazoline","","- C14 H13 N3 O2 -","- C14 H13 N3 O2 -","- C56 H52 N12 O8 -","4","1","","Correa, Waldo H.; Papadopoulos, Stavroula; Radnidge, Peta; Roberts, Brett A.; Scott, Janet L.","Direct, efficient, solvent-free synthesis of 2-aryl-1,2,3,4-tetrahydroquinazolines","Green Chemistry","2002","4","3","245","","10.1039/b202729c","","","0.71073","MoKα","","0.0635","0.045","","","0.1307","0.1524","","","","","","1.133","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7204410","11.3431","0.0004","8.7088","0.0002","23.4287","0.0005","90","","90","","90","","2314.4","0.11","123","2","123","2","","","","","","","","4","P b c a","-P 2ac 2ab","61","2-(4'-hydroxyphenyl)-1,2,3,4-tetrahydroquinazoline","4-(1,2,3,4-tetrahydro-quinazolin-2-yl)-phenol","","- C14 H14 N2 O -","- C14 H13.6 N2 O -","- C112 H108.8 N16 O8 -","8","1","","Correa, Waldo H.; Papadopoulos, Stavroula; Radnidge, Peta; Roberts, Brett A.; Scott, Janet L.","Direct, efficient, solvent-free synthesis of 2-aryl-1,2,3,4-tetrahydroquinazolines","Green Chemistry","2002","4","3","245","","10.1039/b202729c","","","0.71073","MoKα","","0.0754","0.0479","","","0.1116","0.1231","","","","","","1.045","","","","has coordinates,has disorder","180375","2020-10-21","18:00:00",""
"7204411","24.8822","0.0008","4.6291","0.0002","16.5755","0.0005","90","","106.263","0.002","90","","1832.81","0.11","123","2","123","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","N-2-[5'-bromosalicylideneimino)benzyl]-5''-bromosalicylideneimine","N-2-[5'-bromosalicylideneimino)benzyl]-5''-bromosalicylideneimine","","- C21 H16 Br2 N2 O2 -","- C21 H16 Br2 N2 O2 -","- C84 H64 Br8 N8 O8 -","4","1","","Correa, Waldo H.; Papadopoulos, Stavroula; Radnidge, Peta; Roberts, Brett A.; Scott, Janet L.","Direct, efficient, solvent-free synthesis of 2-aryl-1,2,3,4-tetrahydroquinazolines","Green Chemistry","2002","4","3","245","","10.1039/b202729c","","","0.71073","MoKα","","0.1609","0.0498","","","0.0758","0.0959","","","","","","0.901","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7204412","20.4722","0.0003","13.2281","0.0002","20.7521","0.0004","90","","90","","90","","5619.84","0.16","123","2","123","2","","","","","","","","4","P n a 21","P 2c -2n","33","2-(veratryl)-1,2,3,4-tetrahydroquinazoline","2-(3',4'-dimethoxyphenyl)-1,2,3,4-tetrahydroquinazoline","","- C16 H18 N2 O2 -","- C16 H18 N2 O2 -","- C256 H288 N32 O32 -","16","4","","Correa, Waldo H.; Papadopoulos, Stavroula; Radnidge, Peta; Roberts, Brett A.; Scott, Janet L.","Direct, efficient, solvent-free synthesis of 2-aryl-1,2,3,4-tetrahydroquinazolines","Green Chemistry","2002","4","3","245","","10.1039/b202729c","","","0.71073","MoKα","","0.1532","0.0639","","","0.0959","0.1197","","","","","","1.014","","","","has coordinates","180375","2020-10-21","18:00:00",""
"7204413","9.72","0.0002","14.037","0.0002","12.2058","0.0001","90","","97.056","0.002","90","","1652.74","0.04","123","2","123","2","","","","","","","","4","P 1 21/c 1","-P 2ybc","14","N-2[(salicylideneimino)benzyl]-salicylideneimine","N-2[(salicylideneimino)benzyl]-salicylideneimine","","- C21 H18 N2 O2 -","- C21 H18 N2 O2 -","- C84 H72 N8 O8 -","4","1","","Correa, Waldo H.; Papadopoulos, Stavroula; Radnidge, Peta; Roberts, Brett A.; Scott, Janet L.","Direct, efficient, solvent-free synthesis of 2-aryl-1,2,3,4-tetrahydroquinazolines","Green Chemistry","2002","4","3","245","","10.1039/b202729c","","","0.71073","MoKα","","0.0915","0.047","","","0.1074","0.1256","","","","","","0.987","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7205034","6.2418","0.0016","9.747","0.002","15.951","0.004","90","","90","","90","","970.4","0.4","173","2","173","2","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","1,3-dimethylimidazolium methylsulphate","","","- C6 H12 N2 O4 S -","- C6 H12 N2 O4 S -","- C24 H48 N8 O16 S4 -","4","1","","Holbrey, John D.; Reichert, W. Matthew; Swatloski, Richard P.; Broker, Grant A.; Pitner, William R.; Seddon, Kenneth R.; Rogers, Robin D.","Efficient, halide free synthesis of new, low cost ionic liquids: 1,3-dialkylimidazolium salts containing methyl- and ethyl-sulfate anions","Green Chemistry","2002","4","5","407","","10.1039/b204469b","","","0.71073","MoKα","","0.0347","0.0285","","","0.058","0.0605","","","","","","0.947","","","","has coordinates","202017","2020-10-21","18:00:00",""