• Aktuality
• Podujatia
• Pre turistov
• Mapa mesta
• Mesačník mesta
  • Redakcia
• Galéria
• Fórum
• Kontakty

(SELECT h.coolurl as hurl, s.idsekcie AS idsekcie, '0' AS idpodujatie, s.nazov_sekcie AS nazov, s.perex_sekcie AS perex, s.coolurl AS surl, s.datum_sekcie AS datum, s.datum_sekcie AS datum_podujatie, s.zobrazit_datum AS zobrazit_datum, s.novinka AS novinka, s.von AS von, t.nazov AS nazov_podujatia, s.id_typ_podujatia AS id_typ_podujatia FROM sekcie s LEFT JOIN hlsekcie h ON s.id_hlsekcie = h.idhlsekcie LEFT JOIN typ_podujatia t ON s.id_typ_podujatia = t.idtyp_podujatia WHERE 1 AND s.von='ano' AND s.novinka='ano' ) UNION (SELECT 'podujatia' AS hurl, '0' AS idsekcie, p.idpodujatie AS idpodujatie, p.nazov AS nazov, p.perex AS perex, p.coolurl AS surl, p.datum AS datum, p.datum_podujatie AS datum_podujatie, 'datumcas' AS zobrazit_datum, p.novinka as novinka, p.von AS von, t.nazov AS nazov_podujatia, p.id_typ_podujatia AS id_typ_podujatia FROM podujatie p LEFT JOIN typ_podujatia t ON p.id_typ_podujatia = t.idtyp_podujatia WHERE 1 AND p.von='ano' AND p.novinka='ano' ) ORDER BY datum DESC LIMIT 6;