Top » Catalog » Books » 047654

$500.00

Grabau, Amadeus W.; Shimer, Hervey W...: North American Index Fossils Inverte...
[047654]

Grabau, Amadeus W.; Shimer, Hervey W...: North American Index Fossils Inverte...
Grabau, Amadeus W.; Shimer, Hervey Woodburn; North American Index Fossils Invertebrates Vols. I & II
NEW YORK, NY, A.G. SEILER, 1909 , HARD BACK
Overall Condition is: READING COPY ONLY
Both volumes have very worn covers, wear thru at edges and corners. Gilt lettering on spines is bearly readable in spots. VOLUME ONE: pencil writing on front end pages, published in 1909, pages are yellowed but clean, binding is good, Volume covers protozoa, porifera, hydrozoa, anthozoa, bryozoa, brachiopoda, pelecypoda, scaphopoda, and gastropoda. VOLUME TWO: Front cover is detatched, cover on spine is hanging by back cover hinge. Library stamp on front end page. Pages are yellowed but clean, binding is good. Covers conulardia, pteropoda, cephalopoda, annelida, trilobita, phyllopoda, ostracoda, cirripedia, malacostraca, merostomata, arachnida, myriopoda, insecta, cystoidea, blastoidea, crinoidea, ophiuroidea, asteroidea, echinoidea, and appendices.
REF#:047654

Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'princet_osc.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '84343' and opa.orders_id = opb.orders_id and opb.products_id != '84343' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]