Top » Catalog » Books » 107202

$50.00

Hayes, T, J.: Grand Opera House Advertisement Booklet claymore whisky
[107202]

Hayes, T, J.: Grand Opera House Advertisement Booklet claymore whisky
Hayes, T, J.; Grand Opera House Advertisement Booklet claymore whisky
NEW YORK, T. J. HAYES, 1900 , HARD BACK
Overall Condition is: FAIR
minor wear to cover. a staplebound book. contains advertisements for different businesses and events, including The Oak Restaurant, Reinhardt's Millinery, Luft & Luft China, Glass Silver and Kitchen Supplies, Adelphi Hotel and much more. pages are very clean. black illustrations throughout text. 1900 CIRCA.
REF#:107202

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