HOME » Advanced Search » Results	Log In  |  Affiliates |  My Account  |  Cart Contents  |  Checkout

CONTACT US   CALL: 11AM - 9PM PST 604.913.2428 OR E-MAIL US   INUIT ART SEARCH   ITEM #, ARTIST, SUBJECT COMMUNITY, PRINT TITLE  Advanced Search   NEW ARRIVALS   ON SALE   SIMON'S PIECES INUIT SCULPTURE  BEARS  CONTEMPORARY  INUKSHUK GALLERY  IVORY / BONE  ACCESSORIES  VINTAGE: Pre 2000 INUIT PRINTS  ARCTIC QUEBEC  ARNAKTAUYOK  BAKER LAKE->  CAPE DORSET->  HOLMAN->  ORIGINAL GRAPHICS  PANGNIRTUNG->  WALL HANGINGS 1ST NATION GALLERIES  CREE / WOODLAND  NORTHWEST COAST OTHER BASES / PLAQUES GIFT CERTIFICATES

Items meeting the criteria CLICK THE THUMBNAIL FOR MORE DETAILS 0 - select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%irene%' or p.products_model like '%irene%' or m.manufacturers_name like '%irene%') and (pd.products_name like '%avaalaaqiaq%' or p.products_model like '%avaalaaqiaq%' or m.manufacturers_name like '%avaalaaqiaq%') ) [TEP STOP]