Top » Catalog » Books » 071057

$13.00

Richards, Frederick B.: The Black Watch at Ticonderoga and Major Campbell of ...
[071057]

Richards, Frederick B.: The Black Watch at Ticonderoga and Major Campbell of ...
Richards, Frederick B.; The Black Watch at Ticonderoga and Major Campbell of Inverawe, Scotland
BOWIE MD, HERITAGE BOOKS, 1999 FACSIMILE, PAPER BACK
Overall Condition is: AS NEW
The Black Watch at Ticonderoga and Major Campbell of Inverawe, Scotland; fold-out map of plan and town Carillon at Ticonderoga ; facsimile reprint 1999; book like new The Black Watch Regiment gained fame for its fearless charge during Maj. Gen.ames Abercrombie's futile attach on Ticonderoga in 1758, in which mosre than half of the 1000 Highlanders were killed or wounded in one of the most dramatic battles of the French and Indian War.
REF#:071057

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