Top » Catalog » Books » 073967

$300.00

Allen, John C.: Letters to Home WWII U. S. S. Tanner 1917 to 1941 40 plus h...
[073967]

Allen, John C.: Letters to Home WWII U. S. S. Tanner 1917 to 1941 40 plus h...
Allen, John C.; Letters to Home WWII U. S. S. Tanner 1917 to 1941 40 plus handwritten letters HOTEL STATLER
, , 1917 ,
Overall Condition is: GOOD
40 plus handwritten letters (and envelopes) to friends and family, postcards, Holiday cards (Christmas, Valentine's, etc) from all over the world. B&W Photography of John Allen in uniform dated 12/04/1917 World War I (Photo credit Max Kirscht, Pleasantville, NJ) 4x5 Black & White Photo: U. S. S. Tanner (Stamped Official U. S. Navy Photograph, not for publication unless official released); Bulletin of the Chamber of Commerce, Atlantic City, NJ dated July 22, 1936; Letter for US Antietam Celebration Commission dated March 8, 1937; The New Jersey Exchangite Newsletter, Volume 1. Issue No. 1 dated November - December 1936; Handwritten letter on Hotel Statler (Detroit) letterhead; Atlantic City Exchange Club dated Nov 30, 1936; Atlantic City Lodge, No. 276 (BPO Elks Lodge); Hotel President (New York, NY, July 1947); Marine Trust Company dated Dec 18 1929; John A, Clement Chapter No 106 Order of the Eastern Star (Masonic Temple) Invitation dated Sept 1946; Letter dated Dec 18, 1925 Atlantic City; Postal Telegraph dated Jan 30 1941; Hartford City dated Feb 1908 handwritten letter; Egg Harbor Township dated Jan 3, 1936
REF#:073967

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 = '92707' and opa.orders_id = opb.orders_id and opb.products_id != '92707' 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]