Román Csarnok

2016. február 19. 10:16
Most van itt az ideje, hogy újragondoljuk a Szépművészeti Múzeum küldetését, profilját, ha úgy tetszik, ars poeticáját.
Mandiner.fesztivál
2015. február 9. 13:57
Hamarosan kezdődik a Szépművészeti Múzeum három éves rekonstrukciója. A zárás előtt különleges programok várnak a vendégekre.
(SELECT nodes.StrId, nodes.Title, nodes.SubTitle, nodes.MediumId, nodes.Lead, nodes.Link, nodes.UTDate, (SELECT StrId FROM nodes AS parnodes WHERE parnodes.Id=nodes.ParentId) AS ParentStrId, DATE_FORMAT( nodes.CreationDate, '%Y. %M %e. %H:%i' ) AS CreationDate, DATE_FORMAT( nodes.StartDate, '%Y. %M %e. %H:%i' ) AS StartDate, IFNULL( nodes.StartDate, nodes.CreationDate ) AS pubDate, nodes.SubdomainId, NULL AS HostName, 'http://mandiner.hu' AS Host FROM node_tag JOIN nodes ON node_tag.NodeId = nodes.Id AND ( nodes.StartDate IS NULL OR nodes.StartDate <= NOW() ) AND ( nodes.EndDate IS NULL OR nodes.EndDate > NOW() ) AND nodes.Public IS NOT NULL AND nodes.Deleted IS NULL WHERE node_tag.TagId = 18 ORDER BY UTDate DESC LIMIT 500 ) UNION (SELECT nodes.StrId, nodes.Title, nodes.SubTitle, nodes.MediumId, nodes.Lead, nodes.Link, nodes.UTDate, (SELECT StrId FROM nodes AS parnodes WHERE parnodes.Id=nodes.ParentId) AS ParentStrId, DATE_FORMAT( nodes.CreationDate, '%Y. %M %e. %H:%i' ) AS CreationDate, DATE_FORMAT( nodes.StartDate, '%Y. %M %e. %H:%i' ) AS StartDate, IFNULL( nodes.StartDate, nodes.CreationDate ) AS pubDate, nodes.SubdomainId, subdomains.Name AS HostName, CONCAT('http://', subdomains.StrId,'.mandiner.hu') AS Host FROM `mandiner_subdomains`.node_tag JOIN `mandiner_subdomains`.nodes ON node_tag.NodeId = nodes.Id AND ( nodes.StartDate IS NULL OR nodes.StartDate <= NOW() ) AND ( nodes.EndDate IS NULL OR nodes.EndDate > NOW() ) AND nodes.Public IS NOT NULL AND nodes.Deleted IS NULL JOIN `mandiner`.subdomains ON subdomains.Id=nodes.SubdomainId WHERE node_tag.TagId = 18 ORDER BY UTDate DESC LIMIT 500) ORDER BY UTDate DESC LIMIT 18 OFFSET 0