本日のEXHIBITION&EVENT 展示とイベント


 
select distinct * from ( ( SELECT DISTINCT ROW_NUMBER() OVER (ORDER BY m1.start DESC) as rno, wp_posts.*, m1.start as start, m1.end as end, '1' as type FROM wp_posts INNER JOIN ( SELECT pm.post_id, pm.meta_value AS 'start', pm1.meta_value AS 'end' FROM wp_postmeta pm INNER JOIN wp_postmeta AS pm1 ON ( pm.post_id = pm1.post_id AND pm.meta_key LIKE 'setting-dates\_%\_period\_%\_start' AND pm1.meta_key LIKE 'setting-dates\_%\_period\_%\_end' AND SUBSTRING_INDEX(pm.meta_key, '_', 4) = SUBSTRING_INDEX(pm1.meta_key, '_', 4) ) ) AS m1 ON ( m1.post_id = wp_posts.ID AND wp_posts.post_type = 'event' ) WHERE (m1.start = '20190525' AND (m1.end IS NULL OR m1.end = '') OR m1.start <= '20190525' AND m1.end >= '20190525') AND wp_posts.post_status = 'publish' AND (wp_posts.post_title = '' OR wp_posts.post_title LIKE '%![:ja!]%' ESCAPE '!' OR wp_posts.post_title LIKE '%%' OR (wp_posts.post_title NOT LIKE '%![:!]%' ESCAPE '!' AND wp_posts.post_title NOT LIKE '%%')) ORDER BY rno ASC limit 10000 ) union all ( SELECT DISTINCT ROW_NUMBER() OVER (ORDER BY m2.start ASC) as rno, wp_posts.*, m2.start as start, m2.end as end, '2' as type FROM wp_posts INNER JOIN ( SELECT pm.post_id, pm.meta_value AS 'start', pm1.meta_value AS 'end' FROM wp_postmeta pm INNER JOIN wp_postmeta AS pm1 ON ( pm.post_id = pm1.post_id AND pm.meta_key LIKE 'setting-dates\_%\_period\_%\_start' AND pm1.meta_key LIKE 'setting-dates\_%\_period\_%\_end' AND SUBSTRING_INDEX(pm.meta_key, '_', 4) = SUBSTRING_INDEX(pm1.meta_key, '_', 4) ) ) AS m2 ON ( m2.post_id = wp_posts.ID AND wp_posts.post_type = 'event' ) WHERE (m2.start > '20190525') AND wp_posts.post_status = 'publish' AND (wp_posts.post_title = '' OR wp_posts.post_title LIKE '%![:ja!]%' ESCAPE '!' OR wp_posts.post_title LIKE '%%' OR (wp_posts.post_title NOT LIKE '%![:!]%' ESCAPE '!' AND wp_posts.post_title NOT LIKE '%%')) group by wp_posts.id ORDER BY rno ASC limit 10000 ) union all ( SELECT DISTINCT ROW_NUMBER() OVER (ORDER BY start ASC) as rno, wp_posts.*, wp_posts.post_date AS start, wp_posts.post_date AS end, '3' as type FROM wp_posts INNER JOIN ( SELECT pt.ID as 'post_id', pt.post_date as 'post_date' FROM wp_posts pt INNER JOIN wp_term_relationships AS tr ON (tr.object_id = pt.ID) INNER JOIN wp_term_taxonomy AS tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = 'eventcat') INNER JOIN wp_terms AS ts ON (tt.term_id = ts.term_id AND ts.slug = 'permanent') WHERE pt.post_type = 'event') AS tm ON (tm.post_id = wp_posts.ID) ORDER BY wp_posts.post_date DESC limit 10000 )) AS combine where 1 = 1 and combine.post_status = 'publish' and (combine.post_title='' OR combine.post_title LIKE '%![:en!]%' ESCAPE '!' OR combine.post_title LIKE '%%') GROUP BY ID ORDER BY type ASC, rno ASC LIMIT 0,100;

USER GUIDE

Hours / Fees / Access

Museum Hours
10:00 – 18:00 (admission until 17:30)
Closures
Every Wednesdays (or, if Wednesday is a national holiday, the following Thursday) during the New Year’s holiday and maintenance periods. There may be changes to the museum opening and closing times without notice. Please contact us in advance.
Admission Fees
  Adults High and Junior High School Students Elementary School Students
Individuals 800yen 300yen 100yen
Groups Discount (20 people or more) 640yen 240yen 80yen
  • The group rate will be applied in cases where admission fees are collectively paid for a group of 20 people or more who enter the museum at the same time.
  • Not applicable with other discounts.
  • Unaccompanied elementary school children are not permitted entry to the museum. Please ensure that they are accompanied by someone of at least junior high school age or above.
  • Tickets permit multiple re-entry throughout the day

banner-seikabanner-imrc banner-karasumamiyu banner-mamyu

TO TOP