(
    SELECT
            txt.mmt_id AS id,
            txt.mmt_texto AS titulo,
            txt.mmt_insert AS data,
            1 AS origem_id,
            'Mural Texto' AS origem_nome
    FROM
            mod_mural_mult_texto txt
    WHERE
		(
				(txt.mmt_texto IS NOT NULL)
				AND (txt.mmt_texto != '')
		)
)
UNION ALL
	(
		SELECT
			frm.fpt_id AS id,
			frm.fpt_conteudo AS titulo,
			CONCAT(frm.fpt_date, ' ', frm.fpt_hora) AS data,
			2 AS origem_id,
			'Fórum' AS origem_nome
		FROM
			mod_forum_post AS frm
		WHERE
			(
				(frm.fpt_conteudo IS NOT NULL)
				AND (frm.fpt_conteudo != '')
			)
	)
UNION ALL
	(
		SELECT
			cs.scr_id AS id,
			cs.scr_texto AS titulo,
			cs.scr_datahora AS data,
			3 AS origem_id,
			'Citybook (Scrap)' AS origem_nome
		FROM
			rso_scrap cs
		WHERE
			(
				(cs.scr_texto IS NOT NULL)
				AND (cs.scr_texto != '')
			)
	)
UNION ALL
	(
		SELECT
			cf.fot_id AS id,
			cf.fot_titulo AS titulo,
			cf.fot_datahora AS data,
			4 AS origem_id,
			'Citybook (Foto)' AS origem_nome
		FROM
			rso_foto cf
		WHERE
			(
				(cf.fot_titulo IS NOT NULL)
				AND (cf.fot_titulo != '')
				AND (cf.fot_status = 1)
			)
	)