viHistory Directory Search

SQL for ths search

SELECT "vdirectory".* , (SELECT count(id) from reclink
WHERE ((reclink.table1_name='directory' AND reclink.table1_id="vdirectory".business_record_id) or (reclink.table2_name='directory' AND reclink.table2_id="vdirectory".business_record_id))) as link_count from "vdirectory"
WHERE (upper(record_year) similar to '1892') AND (upper(business_description) similar to '%cigar%')
ORDER BY sort_name asc

Your search returned 3 items. Showing items 1 to 3. Showing results for year 1892.

+ + Sort ascending Sort descending Name Sort ascending Sort descending Year Sort ascending Sort descending City Sort ascending Sort descending Occupation Sort ascending Sort descending Employer Sort ascending Sort descending Address Sort ascending Sort descending Type  
+ Kurtz & Co 1892 Victoria 79 Government Business C
 
Business name Kurtz & Co Proprietor H F W Behnsen (manager)    
Business address 79 Government Description cigar manufacturers Record bd.1892:4569
Comments P O box 255
+ The Cigar Box 1892 Nanaimo Business CA
 
Business name The Cigar Box Proprietor B Aaronson (Merchant)    
Business address Unknown Description Cigar stand Record bd.1892:2627
Comments None
+ The Little Wonder 1892 Nanaimo Commercial Business C
 
Business name The Little Wonder Proprietor John H Hilbert (Storekeeper)    
Business address Commercial Description Cigar store Record bd.1892:2569
Comments None