Error:
  • Can't create/write to file '/tmp/#sql_a21_2.MYI' (Errcode: 28) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM hcp6j_content AS a LEFT JOIN hcp6j_categories AS c ON c.id = a.catid LEFT JOIN hcp6j_users AS ua ON ua.id = a.created_by LEFT JOIN hcp6j_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM hcp6j_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN hcp6j_categories as parent ON parent.id = c.parent_id LEFT JOIN hcp6j_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM hcp6j_categories AS cat JOIN hcp6j_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN hcp6j_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-01-26 00:10:59') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-01-26 00:10:59') AND a.language in ('en-GB','*') AND (contact.language in ('en-GB','*') OR contact.language IS NULL) GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, fp.ordering, a.created DESC
  • Roee Rosen, Pasta alla Putinesca - "Vladimir’s Night" e "Astrological Paranoia”

    Vladimir's Night - On Dirty Politics and Erotic Animism
    PAC Milano, 17 Novembre 2014 h. 19


    Pasta alla Putinesca — "Vladimir’s Night" e "Astrological Paranoia”
    Galleria Riccardo Crespi, Preview 18th Novembre 2014 h.18.30
    19 Novembre 2014 – 17 Gennaio 2015

    Galleria Riccardo Crespi is proud to present Roee Rosen's second solo exhibition in Italy. The Israeli-American artist masters painting, writing, video and film making, and his intricate projects often combine all these media in highly original ways. Rosen's art offers provocative articulations of the twilight zones of identity through the channelling of alternative artistic personae or by compelling the spectator to inhabit the body of a morally problematic historic figure. The most recent of Rosen's fictive and politically provocative figures, Maxim Komar-Myskin, will be at the centre of this exhibition: a paranoiac ex-Soviet artist who tried to do battle with Vladimir Putin by having him tortured and killed by animated objects.

    A special event with the artist, Vladimir's Night - On Dirty Politics and Erotic Animism, in collaboration with PAC Milano - within the exhibition GLITCH. Interferenze tra arte e cinema in Italia, ongoing at the Pavilion in Milan - will combine a lecture-performance exposing the exhibition, a special screening, and a book launch of the  artist’s last book, Vladimir's Night (Sternberg Press, 2014), in collaboration with Bookcity Milano. The film The Buried Alive Videos, premiered at the Rome International Film Festival 2013, where it was awarded with a special mention, will be projected on this occasion.


    Roee Rosen was born in Rehovot, Israel, in 1963. He lives and works in Israel. He is known for exceptionally complex and polemic works which enmeshes sexuality and politics, humor and horror, history and the present. Rosen has exhibited worldwide and won numerous awards. His film Tse [Out], won the Orizzonti Award for best medium-length film at the Venice Film Festival, 2010. His book Justine Frank, Sweet Sweat was listed as one of the best books of 2009 by Artforum magazine. Recent solo exhibitions include the CCA in Warsaw and INIVA in London. Profile screenings dedicated to his work were held by Tate Modern, London, the Museum of Modern Art, Vienna and the Oberhausen film festival, among others. Rosen's latest film, The Buried Alive Videos, premiered at the Rome Film Festival, 2013, and was awarded a special mention. His latest book, Maxim Komar-Myshkin, Vladimir's Night was published in 2014 by Sternberg Press. Rosen is a professor at Ha'Midrasha Art College, and at the Bezalel Art Academy, Israel. His retrospective is forthcoming at the Tel Aviv Museum in 2015.