$lang = "en";
require("../adm/init_web.php");
$sql = "(SELECT not_tipo as tipo, not_imagen as imagen, not_id as id, not_subtitulo_".$lang." as subtitulo, not_titulo_".$lang." as titulo, not_resumen_".$lang." as resumen, not_descripcion_".$lang." as descripcion FROM azi_noticias WHERE not_activar = 'Y' AND not_tipo = 'opinion' ORDER BY not_fecha DESC LIMIT 2)
UNION (SELECT not_tipo as tipo, not_imagen as imagen, not_id as id, not_subtitulo_".$lang." as subtitulo, not_titulo_".$lang." as titulo, not_resumen_".$lang." as resumen, not_descripcion_".$lang." as descripcion FROM azi_noticias WHERE not_activar = 'Y' AND not_tipo = 'social' ORDER BY not_fecha DESC LIMIT 2)
UNION (SELECT not_tipo as tipo, not_imagen as imagen, not_id as id, not_subtitulo_".$lang." as subtitulo, not_titulo_".$lang." as titulo, not_resumen_".$lang." as resumen, not_descripcion_".$lang." as descripcion FROM azi_noticias WHERE not_activar = 'Y' AND not_tipo = 'turismo' ORDER BY not_fecha DESC LIMIT 2)
UNION (SELECT not_tipo as tipo, not_imagen as imagen, not_id as id, not_subtitulo_".$lang." as subtitulo, not_titulo_".$lang." as titulo, not_resumen_".$lang." as resumen, not_descripcion_".$lang." as descripcion FROM azi_noticias WHERE not_activar = 'Y' AND not_tipo = 'eventos' ORDER BY not_fecha DESC LIMIT 2)";
$resp_not = $mysql->sql_query($sql);
$count_not = $mysql->sql_numrows($resp_not);
if($count_not){
while($row_not = $mysql->sql_fetchrow($resp_not)){
if($_tmp_tipo != $row_not['tipo'])
$list_noticias .= '