Exclusive members area

New User

We offer exclusive Japanese works of art every month to our members. Login or register to see what is available this month.

resgister now

Japanese Shibayama

A simple definition of the Japanese art form generically known as “Shibayama” is “the inlay of a design into an ivory, wood or lacquer base using a variety of carved natural materials of varying textures and colours, most often comprising numerous sea-shells, horn, stained ivory and wood”.

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  LEFT JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id AND mt1.meta_key = 'exclusive_art' )  LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )  LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (38)
) AND ( 
  ( 
    ( 
      ( wp_postmeta.meta_key = 'exclusive_art' AND CAST(wp_postmeta.meta_value AS CHAR) = 'no' ) 
      OR 
      mt1.post_id IS NULL
    ) 
    AND 
    ( 
      mt2.meta_key = 'order_number' 
      AND 
      mt3.meta_key = '_price'
    )
  )
) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY CAST(mt2.meta_value AS SIGNED) ASC, CAST(mt3.meta_value AS SIGNED) DESC LIMIT 0, 8
SORT BY: