Top » Catalog » Books » 100516

$12.50

Emerson Piano Co.: Compliments of the Emerson Piano Co.; Victorian Advertisin...
[100516]

Emerson Piano Co.: Compliments of the Emerson Piano Co.; Victorian Advertisin...
Emerson Piano Co.; Compliments of the Emerson Piano Co.; Victorian Advertising Card
BOSTON AND NEW YORK, EMERSON PIANO CO., 1880 , PAPERBACK
Overall Condition is: Good
1880 CIRCA 2 cards 1st card: color illustration of children ice skating on front, O. H. Shepard stamp on front, black and white illustration of piano with info on reverse 2nd card:color illustration of child playng piano and other child dancing with a dog on front, sellers stamp on front, black and white illustration of piano with info on reverse
REF#:100516

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