The query is now

select distinct Amc_Table.fileno from Amc_Table LEFT JOIN Amc_Author ON Amc_Table.fileno=Amc_Author.fileno LEFT JOIN atomic_data ON Amc_Table.fileno = atomic_data.fileno WHERE ( Mineral LIKE 'Bariopharmacoalumite%')

the size of the result array is 3

the size of the diff result array is 0

The total results from the merged set is 3

The total number of rows in result set is 3

The paginate value is 1

entering paginate loop

The total number to display on this page is 3 3 matching records for this search.

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('18517.amc', '18518.amc', '18718.amc') order by fileno

	Bariopharmacoalumite
	Mills S J, Rumsey M S, Favreau G, Spratt J, Raudsepp M, Dini M
	Mineralogical Magazine 75 (2011) 135-144
	Bariopharmacoalumite, a new mineral species from Cap Garonne, France and Mina Grande, Chile
	Locality: Cap Garonne, France
	_database_code_amcsd 0018374
	7.772 7.772 7.772 90 90 90 P-43m
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	As1 .5 0 0 .0315 .0258 .0344 .0344 0 0 0
	Al1 .1421 .1421 .1421 .78 .028 .028 .028 .028 -.0039 -.0039 -.0039
	Fe1 .1421 .1421 .1421 .22 .028 .028 .028 .028 -.0039 -.0039 -.0039
	O1 .1259 .3809 .1259 .038 .036 .036 .043 -.004 .004 .004
	O2 .8881 .8881 .8881 .026
	H2 .829 .829 .829 .031
	Ba1 0 .5 .5 .17 .049
	O3 .5 .120 .5 .19 .017
	O4 .686 .686 .686 .44 .051
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Bariopharmacoalumite
	Mills S J, Rumsey M S, Favreau G, Spratt J, Raudsepp M, Dini M
	Mineralogical Magazine 75 (2011) 135-144
	Bariopharmacoalumite, a new mineral species from Cap Garonne, France and Mina Grande, Chile
	Locality: Mina Grande, Chile
	_database_code_amcsd 0018375
	7.850 7.850 7.850 90 90 90 P-43m
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	As1 .5 0 0 .0237 .019 .0259 .0259 0 0 0
	Al1 .1427 .1427 .1427 .58 .0115 .0115 .0115 .0115 -.0017 -.0017 -.0017
	Fe1 .1427 .1427 .1427 .42 .0115 .0115 .0115 .0115 -.0017 -.0017 -.0017
	O1 .127 .393 .127 .040 .047 .026 .047 .001 .009 .001
	O2 .8878 .8878 .8878 .023 .023 .023 .023 -.006 -.006 -.006
	H2 .829 .829 .829 .028
	Ba1 0 .5 .5 .17 .031
	O3 .5 .137 .5 .2 .02
	O4 .690 .690 .690 .2 .02
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Bariopharmacoalumite
	Grey I E, Mumme W G, Price J R, Mills S J, Macrae C M, Favreau G
	Mineralogical Magazine 78 (2014) 851-860
	BaCu ordering in bariopharmacoalumite-Q2a2b2c from Cap Garonne, France
	Locality: South mine, Cap Garonne, France
	_database_code_amcsd 0020526
	15.405 15.405 15.553 90 90 90 I-42m
	atom x y z occ Uiso U(1,1) U(2,2) U(3,3) U(1,2) U(1,3) U(2,3)
	Ba1 0 0 .25014 .812 .0182 .0154 .0154 .0238 -.0005 0 0
	Ba2 .2525 .5 0 .042 .060
	Ba3 .2520 .5 .5 .042 .060
	Cu .5 0 .3637 .100 .073
	As1 .24522 .24522 -.0006 .945 .0223 .0235 .0235 .0198 -.0147 -.0032 -.0032
	Al1 .24522 .24522 -.0006 .055 .0223 .0235 .0235 .0198 -.0147 -.0032 -.0032
	As2 .00045 .25021 .25502 .945 .0207 .0148 .0220 .0251 .0010 .0003 -.0004
	Al2 .00045 .25021 .25502 .055 .0207 .0148 .0220 .0251 .0010 .0003 -.0004
	Al3 .3212 .3212 .3169 .0193 .0175 .0175 .023 -.0010 .0016 .0016
	Al4 .8187 .3223 .3203 .0192 .0157 .0139 .0278 .0007 -.0005 -.0011
	Al5 .8175 .8175 .3222 .0194 .0162 .0162 .026 -.0006 .0036 .0036
	O1A .3179 .3179 .4358 .029 .029 .029 .029 -.020 .004 .004
	O1B .8091 .3190 .4386 .0254 .029 .019 .028 .006 .000 -.005
	O1C .8104 .8104 .4399 .031 .035 .035 .023 -.024 .000 .000
	O2A .3182 .4399 .3059 .0225 .026 .018 .023 .001 -.002 .002
	O2B .8146 .4401 .3094 .0290 .029 .022 .036 .005 -.007 .000
	O2C .3138 .9386 .3178 .0285 .035 .019 .031 .005 -.013 .001
	O2D .8144 .9368 .3165 .0271 .032 .016 .034 .001 -.009 .002
	OH3A .1919 .1919 .1956 .019 .019 .019 .019 -.004 .003 .003
	OH3B .6946 .1928 .1925 .0211 .021 .013 .030 -.004 -.001 -.001
	OH3C .6946 .6946 .1894 .027 .027 .027 .026 -.003 .003 .003
	O4 .5 0 .25 .100 .073
	O5 .5 0 .5 .100 .073
	Wat1A .0847 .0847 .6133 .034
	Wat1B .5844 .5844 .6153 .031
	Wat1C .5789 .1392 .5721 .54 .069
	Wat1D .5770 .0900 .6180 .46 .069
	Wat2A .3077 .5 0 .81 .0302
	Wat2B .3094 .5 .5 .81 .0302
	Wat3 0 0 0 .21 .06
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)

Download in: Amc Format Cif Format Diffraction data

Multiple datasets can be concatenated into a single downloadable file by selecting the datasets and then clicking

Multiple datasets can be downloaded as individual files inside a ZIP archive by selecting the datasets and then clicking

Line 935: Select count from statistic where hostname='216.73.216.218'

Line 943: Update statistic set count=count + '3' where hostname='216.73.216.218'