Johann Nepomuk Hofzinser

(19th July 1806 - 11th March 1875)

Born in Vienna, Austria. Learned magic by 1828. Government bureaucrat. Amateur magician, then semi-pro from 1854, then full-time pro since 1865 (when he retired from government job).

Invented Envelope Card (1847), Shell Coin (by 1847), Book Test (early 1850s), Everywhere and Nowhere (c1860), Black Art Table (1872), Slit Glass (by 1875), Spring Balls (by 1875), probably Flags of All Nations (by 1875), probably Flag Pole (by 1875), Card Frame, Card Star, probably Floating Wand, Dancing Cane, Mirror Glass, and probably the Small Packet Trick.

Johann Nepomuk Hofzinser products

Displaying 1 to 4 (of 4 products)

Result Pages: 1

1054 - Unknown column 'pd.products_price' in 'order clause'

select /* index.php 22 */ p.products_status, p.products_image, pd.products_name, pd.products_description_short, m.manufacturers_name, m.multi_author_ids, m.all_author_ids, p.products_date_added, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p2c.categories_id, count(distinct pa.options_values_id) as arg_count from products p left join products_attributes pa on (p.products_id=pa.products_id) left join products_to_categories p2c on (p.products_id = p2c.products_id), products_description pd, manufacturers m where p.products_status >= '1' and pd.products_id = p.products_id and p.manufacturers_id = m.manufacturers_id and (m.manufacturers_id in (19,337,339)) group by p.products_id order by pd.products_price limit 0, 20

[TEP STOP]