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 Lacquer

Let me at the outset say that in the opinion of many Japanese collectors, fine quality lacquer is currently the most undervalued, under-rated and unrecognised of all the Japanese Arts. Exquisite items can still be found for very modest outlays, items that have taken a master craftsman weeks, even months to create.

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 (45)
) 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: