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 'Brandholzite%')

the size of the result array is 2

the size of the diff result array is 0

The total results from the merged set is 2

The total number of rows in result set is 2

The paginate value is 1

entering paginate loop

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

the file_query is

Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('02452.amc', '19929.amc') order by fileno

	Brandholzite
	Friedrich A, Wildner M, Tillmanns E, Merz P L
	American Mineralogist 85 (2000) 593-599
	Crystal chemistry of the new mineral brandholzite, Mg(H2O)6[Sb(OH)6]2,
	and of the synthetic analogues M(H2O)6[Sb(OH)6]2 (Me=Mg,Co)
	_database_code_amcsd 0002426
	16.119 16.119 9.868 90 90 120 P3
	atom x y z Uiso
	Sb1 0 0 0 .0109
	Sb2 2/3 1/3 -.08211 .0107
	Sb3 1/3 2/3 .00883 .0104
	Sb4 0 0 .49757 .0103
	Sb5 2/3 1/3 .42305 .0101
	Sb6 1/3 2/3 .50490 .0100
	Sb7 .32739 -.00737 .47077 .0113
	Sb8 .66781 .00662 .45371 .0108
	Mg1 .33825 .00882 -.03108 .0142
	Mg2 .66274 -.00884 -.04466 .0149
	H21 .528 .297 .555 .037
	H22 .575 .185 .328 .037
	H23 .271 .513 .607 .037
	H24 .360 .806 .375 .037
	H25 .286 .096 .356 .037
	H26 .429 .149 .558 .037
	H27 .474 .025 .349 .037
	H28 .363 -.110 .597 .037
	H29 .221 -.145 .358 .037
	H30 .198 -.046 .595 .037
	H31 .568 .050 .573 .037
	H32 .704 .145 .308 .037
	H33 .812 .116 .572 .037
	H34 .769 -.042 .356 .037
	H35 .643 -.134 .581 .037
	H36 .514 -.096 .366 .037
	H01 .017 .099 -.187 .037
	H02 .101 .100 .181 .037
	H03 .573 .239 -.263 .037
	H04 .672 .239 .085 .037
	H05 .329 .571 .196 .037
	H06 .337 .771 -.182 .037
	H071 .330 .150 -.122 .037
	H072 .339 .118 -.222 .037
	H081 .464 .169 .074 .037
	H082 .433 .104 .178 .037
	H091 .447 .010 -.228 .037
	H092 .495 .090 -.153 .037
	H101 .349 -.089 .169 .037
	H102 .363 -.126 .040 .037
	H111 .233 -.101 -.250 .037
	H112 .205 -.146 -.131 .037
	H121 .178 -.023 .051 .037
	H122 .228 -.003 .170 .037
	H131 .529 .012 .042 .037
	H132 .568 .009 .153 .037
	H141 .671 .106 -.229 .037
	H142 .687 .154 -.114 .037
	H151 .818 .060 .089 .037
	H152 .765 .087 .156 .037
	H161 .775 .009 -.244 .037
	H162 .795 -.045 -.155 .037
	H171 .576 -.162 .086 .037
	H172 .654 -.109 .165 .037
	H181 .500 -.136 -.158 .037
	H182 .552 -.107 -.250 .037
	H19 .033 .132 .372 .037
	H20 .156 .096 .599 .037
	O1 .0335 .1144 -.1107 .0176
	O2 .1132 .0835 .1123 .0186
	O3 .5822 .2204 -.1939 .0172
	O4 .6962 .2494 .0283 .0170
	O5 .3049 .5543 .1205 .0175
	O6 .3635 .7805 -.1021 .0176
	O7 .3147 .0983 -.1531 .0241
	O8 .4311 .1157 .0942 .0277
	O9 .4532 .0333 -.1505 .0204
	O10 .3626 -.0845 .0861 .0208
	O11 .2517 -.1062 -.1534 .0226
	O12 .2227 -.0206 .0869 .0223
	O13 .5762 .0190 .0784 .0233
	O14 .6914 .1107 -.1570 .0207
	O15 .7782 .0775 .0751 .0195
	O16 .7547 -.0277 -.1709 .0218
	O17 .6328 -.1266 .0706 .0231
	O18 .5524 -.0982 -.1673 .0281
	O19 .0648 .1141 .3770 .0157
	O20 .1135 .0411 .6127 .0166
	O21 .5522 .2693 .5424 .0154
	O22 .6218 .2189 .3076 .0173
	O23 .2648 .5522 .6189 .0174
	O24 .3946 .7809 .3844 .0160
	O25 .2607 .0407 .3524 .0193
	O26 .3740 .1100 .5807 .0166
	O27 .4435 .0564 .3556 .0163
	O28 .3965 -.0510 .5901 .0182
	O29 .2803 -.1236 .3575 .0183
	O30 .2117 -.0734 .5860 .0173
	O31 .6215 .0747 .5732 .0177
	O32 .7343 .1190 .3335 .0164
	O33 .7842 .0595 .5679 .0165
	O34 .7100 -.0652 .3390 .0169
	O35 .6074 -.1073 .5751 .0167
	O36 .5500 -.0413 .3456 .0153
	Download AMC data (View Text File) Download CIF data (View Text File) Download diffraction data (View Text File) View JMOL 3-D Structure (permalink)
	Brandholzite
	Beintema J
	Proceedings of the Koninklijke Nederlandse Academie van Wetenschappen 39 (1936) 241-252
	On the crystal-structure of magnesium- and nickelantimonate.
	_cod_database_code 1010069
	_database_code_amcsd 0017004
	16.079 16.079 9.841 90 90 120 P-31m
	atom x y z
	Mg1 1/3 0 0
	Sb1 0 0 0
	Sb2 0 0 .5
	Sb3 1/3 2/3 0
	Sb4 1/3 2/3 .5
	Sb5 1/3 0 .5
	O1 .1111 0 .125
	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.214'

Line 943: Update statistic set count=count + '2' where hostname='216.73.216.214'