CREATE OR REPLACE VIEW `search_data` as 
SELECT concat(plv.id, 'p') as id, plv.title AS `title`, Null AS `preview`, plv.content AS `content`, plv.id_language as `id_language`, plv.id_page as `id_object`, 0 as `type` FROM page_language_values AS plv
UNION
SELECT concat(pc.id, 'r') as id, pc.title AS `title`, pc.preview AS `preview`, pc.body AS `content`, pc.id_language as `id_language`, pc.id_press as `id_object`, 1 as `type` FROM press_content AS pc