<!-- 
                                SELECT SQL_CALC_FOUND_ROWS                                
                                    box_hir.TABLE_ID,
                                    box_hir.teaserID,
                                    box_hir.cim,
                                    box_hir.alcim,
                                    box_hir.lead,
                                    box_hir.dok1,
                                    box_hir.dok2,
                                    box_hir.dok3,
                                    box_hir.link1,
                                    box_hir.link2,
                                    box_hir.link3,
                                    box_hir.link1_url,
                                    box_hir.link2_url,
                                    box_hir.link3_url,
                                    box_hir.datumIdo2,
                                    box_hir.kiskep,
                                    box_hir.kep,
                                    box_hir.kep2,
                                    box_hir.megyeID,
                                    box_hir.helyszin,
                                    box_hir.azonosito,
                                    box_hir.subteaserID,
                                    box_hir.kep3,
                                    box_hir.ct,
                                    box_hir.metaKeys,
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID)),
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID))                                    
                                    ) AS urlrewrite, 
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        CONCAT(box_teaser.publikacio, '/' ),
                                        CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/')                                    
                                    ) AS urlrewrite2,
                                    box_hir.publikacio AS hir_publikacio,
                                    YEAR(box_hir.datumIdo) as ev,
                                    DATE_FORMAT(box_hir.datumIdo, '%m') as honap,
                                    DATE_FORMAT(box_hir.datumIdo, '%d') as nap,
                                    DATE_FORMAT(box_hir.datumIdo, '%H') as ora,
                                    DATE_FORMAT(box_hir.datumIdo, '%i') as perc,
                                    DATE_FORMAT(box_hir.datumIdo, '%w') as hetnapja,
									YEAR(box_hir.datumIdo2) as ev2,
									DATE_FORMAT(box_hir.datumIdo2, '%m') as honap2,
									DATE_FORMAT(box_hir.datumIdo2, '%d') as nap2,
									DATE_FORMAT(box_hir.datumIdo2, '%H') as ora2,
									DATE_FORMAT(box_hir.datumIdo2, '%i') as perc2,
									DATE_FORMAT(box_hir.datumIdo2, '%w') as hetnapja2,  									
                                    box_subteaser.megnevezes AS alrovat,
                                    box_subteaser.megnevezes AS subteasertitle,
									box_subteaser.publikacio AS subteaserurl,
                                    box_teaser.megnevezes AS teasertitle,
									box_teaser.publikacio AS teaserurl2,
                                    box_teaser.noSelfVars,
                                    box_teaser.csoportID
                                FROM itworx.box_hir
                                INNER JOIN itworx.box_teaser ON box_teaser.TABLE_ID = box_hir.teaserID
                                LEFT JOIN itworx.box_subteaser ON box_subteaser.TABLE_ID = box_hir.subteaserID
                                
                                
                                WHERE box_hir.teaserID = '2003' AND allapot = '1' AND (box_hir.archivum != '1' OR box_hir.archivum IS NULL)    AND subteaserID = '348'    
                                GROUP BY box_hir.TABLE_ID
                                ORDER BY  cim  
                                LIMIT 0, 100; -->
<!-- 
                                SELECT SQL_CALC_FOUND_ROWS                                
                                    box_hir.TABLE_ID,
                                    box_hir.teaserID,
                                    box_hir.cim,
                                    box_hir.alcim,
                                    box_hir.lead,
                                    box_hir.dok1,
                                    box_hir.dok2,
                                    box_hir.dok3,
                                    box_hir.link1,
                                    box_hir.link2,
                                    box_hir.link3,
                                    box_hir.link1_url,
                                    box_hir.link2_url,
                                    box_hir.link3_url,
                                    box_hir.datumIdo2,
                                    box_hir.kiskep,
                                    box_hir.kep,
                                    box_hir.kep2,
                                    box_hir.megyeID,
                                    box_hir.helyszin,
                                    box_hir.azonosito,
                                    box_hir.subteaserID,
                                    box_hir.kep3,
                                    box_hir.ct,
                                    box_hir.metaKeys,
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID)),
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID))                                    
                                    ) AS urlrewrite, 
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        CONCAT(box_teaser.publikacio, '/' ),
                                        CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/')                                    
                                    ) AS urlrewrite2,
                                    box_hir.publikacio AS hir_publikacio,
                                    YEAR(box_hir.datumIdo) as ev,
                                    DATE_FORMAT(box_hir.datumIdo, '%m') as honap,
                                    DATE_FORMAT(box_hir.datumIdo, '%d') as nap,
                                    DATE_FORMAT(box_hir.datumIdo, '%H') as ora,
                                    DATE_FORMAT(box_hir.datumIdo, '%i') as perc,
                                    DATE_FORMAT(box_hir.datumIdo, '%w') as hetnapja,
									YEAR(box_hir.datumIdo2) as ev2,
									DATE_FORMAT(box_hir.datumIdo2, '%m') as honap2,
									DATE_FORMAT(box_hir.datumIdo2, '%d') as nap2,
									DATE_FORMAT(box_hir.datumIdo2, '%H') as ora2,
									DATE_FORMAT(box_hir.datumIdo2, '%i') as perc2,
									DATE_FORMAT(box_hir.datumIdo2, '%w') as hetnapja2,  									
                                    box_subteaser.megnevezes AS alrovat,
                                    box_subteaser.megnevezes AS subteasertitle,
									box_subteaser.publikacio AS subteaserurl,
                                    box_teaser.megnevezes AS teasertitle,
									box_teaser.publikacio AS teaserurl2,
                                    box_teaser.noSelfVars,
                                    box_teaser.csoportID
                                FROM itworx.box_hir
                                INNER JOIN itworx.box_teaser ON box_teaser.TABLE_ID = box_hir.teaserID
                                LEFT JOIN itworx.box_subteaser ON box_subteaser.TABLE_ID = box_hir.subteaserID
                                
                                
                                WHERE box_hir.teaserID = '2003' AND allapot = '1' AND (box_hir.archivum != '1' OR box_hir.archivum IS NULL)    AND subteaserID = '349'    
                                GROUP BY box_hir.TABLE_ID
                                ORDER BY  cim  
                                LIMIT 0, 100; -->
<!-- 
                                SELECT SQL_CALC_FOUND_ROWS                                
                                    box_hir.TABLE_ID,
                                    box_hir.teaserID,
                                    box_hir.cim,
                                    box_hir.alcim,
                                    box_hir.lead,
                                    box_hir.dok1,
                                    box_hir.dok2,
                                    box_hir.dok3,
                                    box_hir.link1,
                                    box_hir.link2,
                                    box_hir.link3,
                                    box_hir.link1_url,
                                    box_hir.link2_url,
                                    box_hir.link3_url,
                                    box_hir.datumIdo2,
                                    box_hir.kiskep,
                                    box_hir.kep,
                                    box_hir.kep2,
                                    box_hir.megyeID,
                                    box_hir.helyszin,
                                    box_hir.azonosito,
                                    box_hir.subteaserID,
                                    box_hir.kep3,
                                    box_hir.ct,
                                    box_hir.metaKeys,
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID)),
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID))                                    
                                    ) AS urlrewrite, 
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        CONCAT(box_teaser.publikacio, '/' ),
                                        CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/')                                    
                                    ) AS urlrewrite2,
                                    box_hir.publikacio AS hir_publikacio,
                                    YEAR(box_hir.datumIdo) as ev,
                                    DATE_FORMAT(box_hir.datumIdo, '%m') as honap,
                                    DATE_FORMAT(box_hir.datumIdo, '%d') as nap,
                                    DATE_FORMAT(box_hir.datumIdo, '%H') as ora,
                                    DATE_FORMAT(box_hir.datumIdo, '%i') as perc,
                                    DATE_FORMAT(box_hir.datumIdo, '%w') as hetnapja,
									YEAR(box_hir.datumIdo2) as ev2,
									DATE_FORMAT(box_hir.datumIdo2, '%m') as honap2,
									DATE_FORMAT(box_hir.datumIdo2, '%d') as nap2,
									DATE_FORMAT(box_hir.datumIdo2, '%H') as ora2,
									DATE_FORMAT(box_hir.datumIdo2, '%i') as perc2,
									DATE_FORMAT(box_hir.datumIdo2, '%w') as hetnapja2,  									
                                    box_subteaser.megnevezes AS alrovat,
                                    box_subteaser.megnevezes AS subteasertitle,
									box_subteaser.publikacio AS subteaserurl,
                                    box_teaser.megnevezes AS teasertitle,
									box_teaser.publikacio AS teaserurl2,
                                    box_teaser.noSelfVars,
                                    box_teaser.csoportID
                                FROM itworx.box_hir
                                INNER JOIN itworx.box_teaser ON box_teaser.TABLE_ID = box_hir.teaserID
                                LEFT JOIN itworx.box_subteaser ON box_subteaser.TABLE_ID = box_hir.subteaserID
                                
                                
                                WHERE box_hir.teaserID = '2003' AND allapot = '1' AND (box_hir.archivum != '1' OR box_hir.archivum IS NULL)    AND subteaserID = '350'    
                                GROUP BY box_hir.TABLE_ID
                                ORDER BY  cim  
                                LIMIT 0, 100; -->
<!-- 
                                SELECT SQL_CALC_FOUND_ROWS                                
                                    box_hir.TABLE_ID,
                                    box_hir.teaserID,
                                    box_hir.cim,
                                    box_hir.alcim,
                                    box_hir.lead,
                                    box_hir.dok1,
                                    box_hir.dok2,
                                    box_hir.dok3,
                                    box_hir.link1,
                                    box_hir.link2,
                                    box_hir.link3,
                                    box_hir.link1_url,
                                    box_hir.link2_url,
                                    box_hir.link3_url,
                                    box_hir.datumIdo2,
                                    box_hir.kiskep,
                                    box_hir.kep,
                                    box_hir.kep2,
                                    box_hir.megyeID,
                                    box_hir.helyszin,
                                    box_hir.azonosito,
                                    box_hir.subteaserID,
                                    box_hir.kep3,
                                    box_hir.ct,
                                    box_hir.metaKeys,
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID)),
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID))                                    
                                    ) AS urlrewrite, 
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        CONCAT(box_teaser.publikacio, '/' ),
                                        CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/')                                    
                                    ) AS urlrewrite2,
                                    box_hir.publikacio AS hir_publikacio,
                                    YEAR(box_hir.datumIdo) as ev,
                                    DATE_FORMAT(box_hir.datumIdo, '%m') as honap,
                                    DATE_FORMAT(box_hir.datumIdo, '%d') as nap,
                                    DATE_FORMAT(box_hir.datumIdo, '%H') as ora,
                                    DATE_FORMAT(box_hir.datumIdo, '%i') as perc,
                                    DATE_FORMAT(box_hir.datumIdo, '%w') as hetnapja,
									YEAR(box_hir.datumIdo2) as ev2,
									DATE_FORMAT(box_hir.datumIdo2, '%m') as honap2,
									DATE_FORMAT(box_hir.datumIdo2, '%d') as nap2,
									DATE_FORMAT(box_hir.datumIdo2, '%H') as ora2,
									DATE_FORMAT(box_hir.datumIdo2, '%i') as perc2,
									DATE_FORMAT(box_hir.datumIdo2, '%w') as hetnapja2,  									
                                    box_subteaser.megnevezes AS alrovat,
                                    box_subteaser.megnevezes AS subteasertitle,
									box_subteaser.publikacio AS subteaserurl,
                                    box_teaser.megnevezes AS teasertitle,
									box_teaser.publikacio AS teaserurl2,
                                    box_teaser.noSelfVars,
                                    box_teaser.csoportID
                                FROM itworx.box_hir
                                INNER JOIN itworx.box_teaser ON box_teaser.TABLE_ID = box_hir.teaserID
                                LEFT JOIN itworx.box_subteaser ON box_subteaser.TABLE_ID = box_hir.subteaserID
                                
                                
                                WHERE box_hir.teaserID = '2003' AND allapot = '1' AND (box_hir.archivum != '1' OR box_hir.archivum IS NULL)    AND subteaserID = '351'    
                                GROUP BY box_hir.TABLE_ID
                                ORDER BY  cim  
                                LIMIT 0, 100; -->
<!-- 
                                SELECT SQL_CALC_FOUND_ROWS                                
                                    box_hir.TABLE_ID,
                                    box_hir.teaserID,
                                    box_hir.cim,
                                    box_hir.alcim,
                                    box_hir.lead,
                                    box_hir.dok1,
                                    box_hir.dok2,
                                    box_hir.dok3,
                                    box_hir.link1,
                                    box_hir.link2,
                                    box_hir.link3,
                                    box_hir.link1_url,
                                    box_hir.link2_url,
                                    box_hir.link3_url,
                                    box_hir.datumIdo2,
                                    box_hir.kiskep,
                                    box_hir.kep,
                                    box_hir.kep2,
                                    box_hir.megyeID,
                                    box_hir.helyszin,
                                    box_hir.azonosito,
                                    box_hir.subteaserID,
                                    box_hir.kep3,
                                    box_hir.ct,
                                    box_hir.metaKeys,
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID)),
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID))                                    
                                    ) AS urlrewrite, 
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        CONCAT(box_teaser.publikacio, '/' ),
                                        CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/')                                    
                                    ) AS urlrewrite2,
                                    box_hir.publikacio AS hir_publikacio,
                                    YEAR(box_hir.datumIdo) as ev,
                                    DATE_FORMAT(box_hir.datumIdo, '%m') as honap,
                                    DATE_FORMAT(box_hir.datumIdo, '%d') as nap,
                                    DATE_FORMAT(box_hir.datumIdo, '%H') as ora,
                                    DATE_FORMAT(box_hir.datumIdo, '%i') as perc,
                                    DATE_FORMAT(box_hir.datumIdo, '%w') as hetnapja,
									YEAR(box_hir.datumIdo2) as ev2,
									DATE_FORMAT(box_hir.datumIdo2, '%m') as honap2,
									DATE_FORMAT(box_hir.datumIdo2, '%d') as nap2,
									DATE_FORMAT(box_hir.datumIdo2, '%H') as ora2,
									DATE_FORMAT(box_hir.datumIdo2, '%i') as perc2,
									DATE_FORMAT(box_hir.datumIdo2, '%w') as hetnapja2,  									
                                    box_subteaser.megnevezes AS alrovat,
                                    box_subteaser.megnevezes AS subteasertitle,
									box_subteaser.publikacio AS subteaserurl,
                                    box_teaser.megnevezes AS teasertitle,
									box_teaser.publikacio AS teaserurl2,
                                    box_teaser.noSelfVars,
                                    box_teaser.csoportID
                                FROM itworx.box_hir
                                INNER JOIN itworx.box_teaser ON box_teaser.TABLE_ID = box_hir.teaserID
                                LEFT JOIN itworx.box_subteaser ON box_subteaser.TABLE_ID = box_hir.subteaserID
                                
                                
                                WHERE box_hir.teaserID = '2003' AND allapot = '1' AND (box_hir.archivum != '1' OR box_hir.archivum IS NULL)    AND subteaserID = '352'    
                                GROUP BY box_hir.TABLE_ID
                                ORDER BY  cim  
                                LIMIT 0, 100; -->
<!-- 
                                SELECT SQL_CALC_FOUND_ROWS                                
                                    box_hir.TABLE_ID,
                                    box_hir.teaserID,
                                    box_hir.cim,
                                    box_hir.alcim,
                                    box_hir.lead,
                                    box_hir.dok1,
                                    box_hir.dok2,
                                    box_hir.dok3,
                                    box_hir.link1,
                                    box_hir.link2,
                                    box_hir.link3,
                                    box_hir.link1_url,
                                    box_hir.link2_url,
                                    box_hir.link3_url,
                                    box_hir.datumIdo2,
                                    box_hir.kiskep,
                                    box_hir.kep,
                                    box_hir.kep2,
                                    box_hir.megyeID,
                                    box_hir.helyszin,
                                    box_hir.azonosito,
                                    box_hir.subteaserID,
                                    box_hir.kep3,
                                    box_hir.ct,
                                    box_hir.metaKeys,
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID)),
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID))                                    
                                    ) AS urlrewrite, 
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        CONCAT(box_teaser.publikacio, '/' ),
                                        CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/')                                    
                                    ) AS urlrewrite2,
                                    box_hir.publikacio AS hir_publikacio,
                                    YEAR(box_hir.datumIdo) as ev,
                                    DATE_FORMAT(box_hir.datumIdo, '%m') as honap,
                                    DATE_FORMAT(box_hir.datumIdo, '%d') as nap,
                                    DATE_FORMAT(box_hir.datumIdo, '%H') as ora,
                                    DATE_FORMAT(box_hir.datumIdo, '%i') as perc,
                                    DATE_FORMAT(box_hir.datumIdo, '%w') as hetnapja,
									YEAR(box_hir.datumIdo2) as ev2,
									DATE_FORMAT(box_hir.datumIdo2, '%m') as honap2,
									DATE_FORMAT(box_hir.datumIdo2, '%d') as nap2,
									DATE_FORMAT(box_hir.datumIdo2, '%H') as ora2,
									DATE_FORMAT(box_hir.datumIdo2, '%i') as perc2,
									DATE_FORMAT(box_hir.datumIdo2, '%w') as hetnapja2,  									
                                    box_subteaser.megnevezes AS alrovat,
                                    box_subteaser.megnevezes AS subteasertitle,
									box_subteaser.publikacio AS subteaserurl,
                                    box_teaser.megnevezes AS teasertitle,
									box_teaser.publikacio AS teaserurl2,
                                    box_teaser.noSelfVars,
                                    box_teaser.csoportID
                                FROM itworx.box_hir
                                INNER JOIN itworx.box_teaser ON box_teaser.TABLE_ID = box_hir.teaserID
                                LEFT JOIN itworx.box_subteaser ON box_subteaser.TABLE_ID = box_hir.subteaserID
                                
                                
                                WHERE box_hir.teaserID = '2003' AND allapot = '1' AND (box_hir.archivum != '1' OR box_hir.archivum IS NULL)    AND subteaserID = '353'    
                                GROUP BY box_hir.TABLE_ID
                                ORDER BY  cim  
                                LIMIT 0, 100; -->
<!-- 
                                SELECT SQL_CALC_FOUND_ROWS                                
                                    box_hir.TABLE_ID,
                                    box_hir.teaserID,
                                    box_hir.cim,
                                    box_hir.alcim,
                                    box_hir.lead,
                                    box_hir.dok1,
                                    box_hir.dok2,
                                    box_hir.dok3,
                                    box_hir.link1,
                                    box_hir.link2,
                                    box_hir.link3,
                                    box_hir.link1_url,
                                    box_hir.link2_url,
                                    box_hir.link3_url,
                                    box_hir.datumIdo2,
                                    box_hir.kiskep,
                                    box_hir.kep,
                                    box_hir.kep2,
                                    box_hir.megyeID,
                                    box_hir.helyszin,
                                    box_hir.azonosito,
                                    box_hir.subteaserID,
                                    box_hir.kep3,
                                    box_hir.ct,
                                    box_hir.metaKeys,
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID)),
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID))                                    
                                    ) AS urlrewrite, 
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        CONCAT(box_teaser.publikacio, '/' ),
                                        CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/')                                    
                                    ) AS urlrewrite2,
                                    box_hir.publikacio AS hir_publikacio,
                                    YEAR(box_hir.datumIdo) as ev,
                                    DATE_FORMAT(box_hir.datumIdo, '%m') as honap,
                                    DATE_FORMAT(box_hir.datumIdo, '%d') as nap,
                                    DATE_FORMAT(box_hir.datumIdo, '%H') as ora,
                                    DATE_FORMAT(box_hir.datumIdo, '%i') as perc,
                                    DATE_FORMAT(box_hir.datumIdo, '%w') as hetnapja,
									YEAR(box_hir.datumIdo2) as ev2,
									DATE_FORMAT(box_hir.datumIdo2, '%m') as honap2,
									DATE_FORMAT(box_hir.datumIdo2, '%d') as nap2,
									DATE_FORMAT(box_hir.datumIdo2, '%H') as ora2,
									DATE_FORMAT(box_hir.datumIdo2, '%i') as perc2,
									DATE_FORMAT(box_hir.datumIdo2, '%w') as hetnapja2,  									
                                    box_subteaser.megnevezes AS alrovat,
                                    box_subteaser.megnevezes AS subteasertitle,
									box_subteaser.publikacio AS subteaserurl,
                                    box_teaser.megnevezes AS teasertitle,
									box_teaser.publikacio AS teaserurl2,
                                    box_teaser.noSelfVars,
                                    box_teaser.csoportID
                                FROM itworx.box_hir
                                INNER JOIN itworx.box_teaser ON box_teaser.TABLE_ID = box_hir.teaserID
                                LEFT JOIN itworx.box_subteaser ON box_subteaser.TABLE_ID = box_hir.subteaserID
                                
                                
                                WHERE box_hir.teaserID = '2003' AND allapot = '1' AND (box_hir.archivum != '1' OR box_hir.archivum IS NULL)    AND subteaserID = '354'    
                                GROUP BY box_hir.TABLE_ID
                                ORDER BY  cim  
                                LIMIT 0, 100; -->
<!-- 
                                SELECT SQL_CALC_FOUND_ROWS                                
                                    box_hir.TABLE_ID,
                                    box_hir.teaserID,
                                    box_hir.cim,
                                    box_hir.alcim,
                                    box_hir.lead,
                                    box_hir.dok1,
                                    box_hir.dok2,
                                    box_hir.dok3,
                                    box_hir.link1,
                                    box_hir.link2,
                                    box_hir.link3,
                                    box_hir.link1_url,
                                    box_hir.link2_url,
                                    box_hir.link3_url,
                                    box_hir.datumIdo2,
                                    box_hir.kiskep,
                                    box_hir.kep,
                                    box_hir.kep2,
                                    box_hir.megyeID,
                                    box_hir.helyszin,
                                    box_hir.azonosito,
                                    box_hir.subteaserID,
                                    box_hir.kep3,
                                    box_hir.ct,
                                    box_hir.metaKeys,
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID)),
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID))                                    
                                    ) AS urlrewrite, 
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        CONCAT(box_teaser.publikacio, '/' ),
                                        CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/')                                    
                                    ) AS urlrewrite2,
                                    box_hir.publikacio AS hir_publikacio,
                                    YEAR(box_hir.datumIdo) as ev,
                                    DATE_FORMAT(box_hir.datumIdo, '%m') as honap,
                                    DATE_FORMAT(box_hir.datumIdo, '%d') as nap,
                                    DATE_FORMAT(box_hir.datumIdo, '%H') as ora,
                                    DATE_FORMAT(box_hir.datumIdo, '%i') as perc,
                                    DATE_FORMAT(box_hir.datumIdo, '%w') as hetnapja,
									YEAR(box_hir.datumIdo2) as ev2,
									DATE_FORMAT(box_hir.datumIdo2, '%m') as honap2,
									DATE_FORMAT(box_hir.datumIdo2, '%d') as nap2,
									DATE_FORMAT(box_hir.datumIdo2, '%H') as ora2,
									DATE_FORMAT(box_hir.datumIdo2, '%i') as perc2,
									DATE_FORMAT(box_hir.datumIdo2, '%w') as hetnapja2,  									
                                    box_subteaser.megnevezes AS alrovat,
                                    box_subteaser.megnevezes AS subteasertitle,
									box_subteaser.publikacio AS subteaserurl,
                                    box_teaser.megnevezes AS teasertitle,
									box_teaser.publikacio AS teaserurl2,
                                    box_teaser.noSelfVars,
                                    box_teaser.csoportID
                                FROM itworx.box_hir
                                INNER JOIN itworx.box_teaser ON box_teaser.TABLE_ID = box_hir.teaserID
                                LEFT JOIN itworx.box_subteaser ON box_subteaser.TABLE_ID = box_hir.subteaserID
                                
                                
                                WHERE box_hir.teaserID = '2003' AND allapot = '1' AND (box_hir.archivum != '1' OR box_hir.archivum IS NULL)    AND subteaserID = '355'    
                                GROUP BY box_hir.TABLE_ID
                                ORDER BY  cim  
                                LIMIT 0, 100; -->
<!-- 
                                SELECT SQL_CALC_FOUND_ROWS                                
                                    box_hir.TABLE_ID,
                                    box_hir.teaserID,
                                    box_hir.cim,
                                    box_hir.alcim,
                                    box_hir.lead,
                                    box_hir.dok1,
                                    box_hir.dok2,
                                    box_hir.dok3,
                                    box_hir.link1,
                                    box_hir.link2,
                                    box_hir.link3,
                                    box_hir.link1_url,
                                    box_hir.link2_url,
                                    box_hir.link3_url,
                                    box_hir.datumIdo2,
                                    box_hir.kiskep,
                                    box_hir.kep,
                                    box_hir.kep2,
                                    box_hir.megyeID,
                                    box_hir.helyszin,
                                    box_hir.azonosito,
                                    box_hir.subteaserID,
                                    box_hir.kep3,
                                    box_hir.ct,
                                    box_hir.metaKeys,
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID)),
                                        IF(box_hir.publikacio != '', CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/', box_hir.publikacio), CONCAT(box_teaser.publikacio, '/', box_hir.TABLE_ID))                                    
                                    ) AS urlrewrite, 
                                    IF(box_hir.subteaserID IS NULL OR box_hir.subteaserID = 0,
                                        CONCAT(box_teaser.publikacio, '/' ),
                                        CONCAT(box_teaser.publikacio, '/', box_subteaser.publikacio, '/')                                    
                                    ) AS urlrewrite2,
                                    box_hir.publikacio AS hir_publikacio,
                                    YEAR(box_hir.datumIdo) as ev,
                                    DATE_FORMAT(box_hir.datumIdo, '%m') as honap,
                                    DATE_FORMAT(box_hir.datumIdo, '%d') as nap,
                                    DATE_FORMAT(box_hir.datumIdo, '%H') as ora,
                                    DATE_FORMAT(box_hir.datumIdo, '%i') as perc,
                                    DATE_FORMAT(box_hir.datumIdo, '%w') as hetnapja,
									YEAR(box_hir.datumIdo2) as ev2,
									DATE_FORMAT(box_hir.datumIdo2, '%m') as honap2,
									DATE_FORMAT(box_hir.datumIdo2, '%d') as nap2,
									DATE_FORMAT(box_hir.datumIdo2, '%H') as ora2,
									DATE_FORMAT(box_hir.datumIdo2, '%i') as perc2,
									DATE_FORMAT(box_hir.datumIdo2, '%w') as hetnapja2,  									
                                    box_subteaser.megnevezes AS alrovat,
                                    box_subteaser.megnevezes AS subteasertitle,
									box_subteaser.publikacio AS subteaserurl,
                                    box_teaser.megnevezes AS teasertitle,
									box_teaser.publikacio AS teaserurl2,
                                    box_teaser.noSelfVars,
                                    box_teaser.csoportID
                                FROM itworx.box_hir
                                INNER JOIN itworx.box_teaser ON box_teaser.TABLE_ID = box_hir.teaserID
                                LEFT JOIN itworx.box_subteaser ON box_subteaser.TABLE_ID = box_hir.subteaserID
                                
                                
                                WHERE box_hir.teaserID = '2003' AND allapot = '1' AND (box_hir.archivum != '1' OR box_hir.archivum IS NULL)    AND subteaserID = '356'    
                                GROUP BY box_hir.TABLE_ID
                                ORDER BY  cim  
                                LIMIT 0, 100; -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><title>K&ouml;z&eacute;rdek� adatok - 2. Tev&eacute;kenys&eacute;gre, m�k&ouml;d&eacute;sre vonatkoz&oacute; adatok - 2.4. Hat&oacute;s&aacute;gi &uuml;gyek int&eacute;z&eacute;s&eacute;vel kapcsolatos adatok - V&aacute;ros&uuml;zemeltet&eacute;si Oszt&aacute;ly V&aacute;ros&uuml;zemeltet&eacute;si Csoport - Keszthely.hu</title><link href="/kek.css" rel="stylesheet" type="text/css"/><link href="/stilus.css" rel="stylesheet" type="text/css"/><script src="http://maps.google.com/maps?file=api&amp;v=2&amp;key=ABQIAAAA8WT-eENEOuV5qo8xTF2C4RSOeBN-SwQTG-MxmGQwyn2meSpwcxTskjf9WJqztMfX-UppE7OlApn0lw" type="text/javascript"></script><script language="JavaScript" type="text/javascript" src="/markermanager.js"></script><script>

function addFav() {

  if(document.all) {

    window.external.AddFavorite(location.href,document.title)

  } else {

    if(window.sidebar) {

      window.sidebar.addPanel(document.title,location.href,'');

    }

  }

}

</script><!--
#############################################################################
	  
       Az oldalt a Webmark Europe Kft. IT Worx CMS rendszere publik�lta
                                  www.itworx.hu
               
                               Webmark Europe Kft.
	  
                            www pont webmark pont hu
                           info kukac webmark pont hu
	  
                      weboldalak - port�lok - web�ruh�zak
		
                                 �len e t�ren!
	    
############################################################################  
 --><meta http-equiv="Content-Type" content="text/html; iso-8859-2"/><meta http-equiv="Expires" content="0"/><meta http-equiv="content-language" content="hu"/><meta name="language" content="hungarian"/><meta name="publisher" content="Webmark Webst�di� - www.webmark.hu"/><meta name="author" content="Webmark Webst�di� - www.webmark.hu"/><meta name="copyright" content="Webmark Webst�di� - www.webmark.hu"/><meta name="revisit" content="2 days"/><meta name="revisit-after" content="2 days"/><meta name="resource-type" content="document"/><meta name="classification" content="document"/><meta name="page-topic" content="all, alle,"/><meta name="title" content="K&ouml;z&eacute;rdek� adatok - 2. Tev&eacute;kenys&eacute;gre, m�k&ouml;d&eacute;sre vonatkoz&oacute; adatok - 2.4. Hat&oacute;s&aacute;gi &uuml;gyek int&eacute;z&eacute;s&eacute;vel kapcsolatos adatok - V&aacute;ros&uuml;zemeltet&eacute;si Oszt&aacute;ly V&aacute;ros&uuml;zemeltet&eacute;si Csoport - Keszthely.hu - A Balaton F�v�rosa"/><meta name="description" content="�zemi, szabadid�s l�tes�tm�ny zajkibocs�t�si hat�r�rt�k�nek meg�llap�t�sa, Helyileg v�dett ter�letek gondoz�sa, Telepek nyilv�ntart�sba v�tele, Kereskedelmi egys�gek nyilv�ntart�sa, K�t l�tes�t�s, K�zm�ves iv�v�z �s szennyv�z szolg�ltat�ssal kapcsolatos jogok k�telezetts�gek, V�zelvezet�si panasz, Behajt�si enged�lyek, Utat �rint� telekmegoszt�s, �tkezel� hozz�j�rul�s k�z�t �rk�ba, csatorn�ba k�z�t ter�let�n k�v�lr�l �rkez� csapad�kv�z bek�t�s�hez, �tkezel� hozz�j�rul�s k�z�t felbont�s�hoz, annak ter�let�n, alatt, vagy felett �p�tm�ny elhelyez�s�hez, egy�b, nem k�zleked�si c�l� ig�nybev�tel�hez, �tkezel� hozz�j�rul�s meghat�rozott j�rm�vek k�zleked�s�hez, �tkezel� hozz�j�rul�s �tcsatlakoz�s l�tes�t�s�hez, Fakiv�g�si �s p�tl�si enged�ly, Z�ldter�let rendeltet�st�l elt�r� haszn�lat�nak enged�lyez�se, Befizet�si igazol�s ki�ll�t�sa, "/><meta name="keywords" content="keszthely, a Balaton F�v�rosa, balaton "/><meta name="robots" content="index, follow"/><link rel="alternate" type="application/rss+xml" title="H�rek - Keszthely.hu - A Balaton F�v�rosa" href="/cgi-bin/rss.cgi?id=213&amp;rssid=760"/><link rel="alternate" type="application/rss+xml" title="P�ly�zatok - Keszthely.hu - A Balaton F�v�rosa" href="/cgi-bin/rss.cgi?id=213&amp;rssid=1080"/></head><body onload="Init(); map_load()" onunload="GUnload()" id="fullheight" link="#97afdb" alink="#97afdb" vlink="#97afdb"><script src="http://www.webmark.hu/AC_RunActiveContent.js" language="javascript" type="text/javascript"></script><script language="JavaScript" type="text/javascript" src="/swfobject.js"></script><script language="JavaScript" type="text/javascript" src="/commonFunc2.js"></script><script type="text/javascript">/*<![CDATA[*/function kep(id,name){document.getElementById(id).src="/art/"+name}function printIt(){javascript:window.open('/cgi-bin/keszthely/index.cgi?print=1&amp;view=kozerdeku22d&amp;tID=1&amp;nID=&amp;nyelv=hu','agprint')}/*]]>*/</script><link type="text/css" href="http://dev.itworx.hu/jquery/themes/ui-lightness/ui.all.css" rel="stylesheet"/><script type="text/javascript" src="http://dev.itworx.hu//jquery/jquery-1.3.2.min.js"></script><script type="text/javascript" src="http://dev.itworx.hu//jquery/ui/ui.core.js"></script><script type="text/javascript" src="http://dev.itworx.hu//jquery/ui/ui.draggable.js"></script><script type="text/javascript" src="http://dev.itworx.hu//jquery/ui/ui.resizable.js"></script><script type="text/javascript" src="http://dev.itworx.hu//jquery/ui/ui.dialog.js"></script><!--END --><table width="100%" border="0" cellspacing="0" cellpadding="0" class="hdr"><tr><td align="left" valign="top"><!-- --><table width="1000" border="0" cellspacing="0" cellpadding="0" align="center"><tr><td><script language="javascript" type="text/javascript">/*<![CDATA[*/if(AC_FL_RunContent==0){alert("This page requires AC_RunActiveContent.js.")}else{AC_FL_RunContent('codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0','width','1000','height','326','src','/flash/header','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','align','middle','play','true','loop','true','scale','showall','wmode','transparent','devicefont','false','id','fejlec','bgcolor','#ffffff','name','fejlec','menu','true','allowFullScreen','false','allowScriptAccess','sameDomain','movie','/flash/header','salign','')}/*]]>*/</script><noscript><a href="/hirek">H�rek</a> - <a href="/varosunk">V�rosunk</a> - <a href="/onkormanyzat">�nkorm�nyzat</a> - <a href="/hivatal">Polg�rmesteri Hivatal </a></noscript></td></tr></table></td></tr></table><!-- --><table width="1000" border="0" align="center" cellpadding="0" cellspacing="0" style="background-image:url(/art/belso_bg.jpg); background-repeat:repeat-y"><tr><td width="768" class="title_bg1" style="background-repeat:repeat; padding-left:12px; font-size:11px;"><strong>Navig�ci�:</strong>&nbsp;&nbsp; <span style="font-size:13px;"><a href="/kozerdeku_adatok">K&ouml;z&eacute;rdek� adatok</a> -> <a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok">2. Tev&eacute;kenys&eacute;gre, m�k&ouml;d&eacute;sre vonatkoz&oacute; adatok </a> -> 2.4. Hat&oacute;s&aacute;gi &uuml;gyek int&eacute;z&eacute;s&eacute;vel kapcsolatos adatok - V&aacute;ros&uuml;zemeltet&eacute;si Oszt&aacute;ly V&aacute;ros&uuml;zemeltet&eacute;si Csoport </span></td><td width="232" class="kereses_top"><img src="/art/sp.gif" width="232" height="32" alt=""/></td></tr><tr><td colspan="2" valign="top"  class="belso_bottom"><!-- --><table id="belso" width="100%" border="0" cellspacing="0" cellpadding="0" class="belso_inner_top"><tr><td width="770" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td style="background-image:url(/art/hircimbg.jpg); height:49px; font-size:13px; padding-left:10px;"><span style="font-size:14px"><strong>2.4. Hat�s�gi �gyek int�z�s�vel kapcsolatos adatok - V�ros�zemeltet�si Oszt�ly V�ros�zemeltet�si Csoport</strong></span></td></tr><tr><td style="height:10px"></td></tr></table> <br/> <table width="100%" border="0" cellpadding="5" cellspacing="0"><tr><td width="50"><img src="/art/ikon/Image19.jpg" width="48" height="48" alt=""/></td><td style="font-size:14px"><strong>Zaj-�s rezg�sv�delmi �gyek</strong></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/zaj-es-rezgesvedelmi-ugyek/zemi_szabadidos_letesitmeny_zajkibocsatasi_hatarertekenek_megallapitasa"><strong>�zemi, szabadid�s l�tes�tm�ny zajkibocs�t�si hat�r�rt�k�nek meg�llap�t�sa</strong></a></td></tr></table></td></tr></table><table width="100%" border="0" cellpadding="5" cellspacing="0"><tr><td width="50"><img src="/art/ikon/Image19.jpg" width="48" height="48" alt=""/></td><td style="font-size:14px"><strong>Term�szetv�delem</strong></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/termeszetvedelem/helyileg_vedett_teruletek_gondozasa"><strong>Helyileg v�dett ter�letek gondoz�sa</strong></a></td></tr></table></td></tr></table><table width="100%" border="0" cellpadding="5" cellspacing="0"><tr><td width="50"><img src="/art/ikon/Image19.jpg" width="48" height="48" alt=""/></td><td style="font-size:14px"><strong>Telepenged�lyez�s</strong></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/telepengedelyezes/telepek_nyilvantartasba_vetele"><strong>Telepek nyilv�ntart�sba v�tele</strong></a></td></tr></table></td></tr></table><table width="100%" border="0" cellpadding="5" cellspacing="0"><tr><td width="50"><img src="/art/ikon/Image19.jpg" width="48" height="48" alt=""/></td><td style="font-size:14px"><strong>Kereskedelmi enged�lyez�si elj�r�s</strong></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/kereskedelmi-engedelyezesi-eljaras/kereskedelmi_egysegek_nyilvantartasa"><strong>Kereskedelmi egys�gek nyilv�ntart�sa</strong></a></td></tr></table></td></tr></table><table width="100%" border="0" cellpadding="5" cellspacing="0"><tr><td width="50"><img src="/art/ikon/Image19.jpg" width="48" height="48" alt=""/></td><td style="font-size:14px"><strong>V�z�gyi enged�lyez�s</strong></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/vizugyi-engedelyezes/kut_letesites"><strong>K�t l�tes�t�s</strong></a></td></tr></table></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/vizugyi-engedelyezes/kozmuves_ivoviz_es_szennyviz_szolgaltatassal_kapcsolatos_jogok_kotelezettsegek"><strong>K�zm�ves iv�v�z �s szennyv�z szolg�ltat�ssal kapcsolatos jogok k�telezetts�gek</strong></a></td></tr></table></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/vizugyi-engedelyezes/vizelvezetesi_panasz"><strong>V�zelvezet�si panasz</strong></a></td></tr></table></td></tr></table><table width="100%" border="0" cellpadding="5" cellspacing="0"><tr><td width="50"><img src="/art/ikon/Image19.jpg" width="48" height="48" alt=""/></td><td style="font-size:14px"><strong>�t�gyi igazgat�si �gyek</strong></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/utugyi-igazgatasi-ugyek/behajtasi_engedelyek"><strong>Behajt�si enged�lyek</strong></a></td></tr></table></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/utugyi-igazgatasi-ugyek/utat_erinto_telekmegosztas"><strong>Utat �rint� telekmegoszt�s</strong></a></td></tr></table></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/utugyi-igazgatasi-ugyek/tkezelo_hozzajarulas_kozut_arkaba_csatornaba_kozut_teruleten_kivulrol_erkezo_csapadekviz_bekotesehez"><strong>�tkezel� hozz�j�rul�s k�z�t �rk�ba, csatorn�ba k�z�t ter�let�n k�v�lr�l �rkez� csapad�kv�z bek�t�s�hez</strong></a></td></tr></table></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/utugyi-igazgatasi-ugyek/tkezelo_hozzajarulas_kozut_felbontasahoz_annak_teruleten_alatt_vagy_felett_epitmeny_elhelyezesehez_egyeb_nem_kozlekedesi_celu_igenybevetelehez"><strong>�tkezel� hozz�j�rul�s k�z�t felbont�s�hoz, annak ter�let�n, alatt, vagy felett �p�tm�ny elhelyez�s�hez, egy�b, nem k�zleked�si c�l� ig�nybev�tel�hez</strong></a></td></tr></table></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/utugyi-igazgatasi-ugyek/tkezelo_hozzajarulas_meghatarozott_jarmuvek_kozlekedesehez"><strong>�tkezel� hozz�j�rul�s meghat�rozott j�rm�vek k�zleked�s�hez</strong></a></td></tr></table></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/utugyi-igazgatasi-ugyek/tkezelo_hozzajarulas_utcsatlakozas_letesitesehez"><strong>�tkezel� hozz�j�rul�s �tcsatlakoz�s l�tes�t�s�hez</strong></a></td></tr></table></td></tr></table><table width="100%" border="0" cellpadding="5" cellspacing="0"><tr><td width="50"><img src="/art/ikon/Image19.jpg" width="48" height="48" alt=""/></td><td style="font-size:14px"><strong>K�zter�leten l�v� f�s sz�r� n�v�nyek kiv�g�sa �s p�tl�sa</strong></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/kozteruleten-levo-fas-szaru-novenyek-kivagasa-es-potlasa/fakivagasi_es_potlasi_engedely"><strong>Fakiv�g�si �s p�tl�si enged�ly</strong></a></td></tr></table></td></tr></table><table width="100%" border="0" cellpadding="5" cellspacing="0"><tr><td width="50"><img src="/art/ikon/Image19.jpg" width="48" height="48" alt=""/></td><td style="font-size:14px"><strong>V�rosi z�ldter�letek, parkok haszn�lata �s v�delme</strong></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/varosi-zoldteruletek--parkok-hasznalata-es-vedelme/zoldterulet_rendeltetestol_eltero_hasznalatanak_engedelyezese"><strong>Z�ldter�let rendeltet�st�l elt�r� haszn�lat�nak enged�lyez�se</strong></a></td></tr></table></td></tr></table><table width="100%" border="0" cellpadding="5" cellspacing="0"><tr><td width="50"><img src="/art/ikon/Image19.jpg" width="48" height="48" alt=""/></td><td style="font-size:14px"><strong>K�zm� fejleszt�si �gyek</strong></td></tr></table><table width="80%" border="0" cellspacing="3" cellpadding="0" align="center"><tr><td align="left" valign="top"><!-- --><table width="100%" border="0" cellspacing="2" cellpadding="0"><tr><td style="font-size:13px;" width="20"><img src="/art/tovabb.jpg" alt="" width="10" height="9" border="0" align="absmiddle"></td><td style="font-size:12px"><a href="/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly/kozmu-fejlesztesi-ugyek/befizetesi_igazolas_kiallitasa"><strong>Befizet�si igazol�s ki�ll�t�sa</strong></a></td></tr></table></td></tr></table><div><iframe src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fwww.keszthely.hu/kozerdeku_adatok/tevekenysegre_mukodesre_vonatkozo_adatok/hatosagi_ugyek_intezesevel_kapcsolatos_adatok_varosuzemeltetesi-osztaly&amp;layout=standard&amp;show_faces=true&amp;width=450&amp;action=like&amp;colorscheme=light&amp;height=80" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:450px; height:80px;" allowTransparency="true"></iframe></div><div align="center"></div></td><td width="230" valign="top" class="full_right"><!-- --><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td style="background-image:url(/art/search.jpg); height:49px;"><form id="keresoFrm" name="keresoFrm" method="get" action="/cgi-bin/keszthely/index.cgi" style="margin-bottom:0px"><input name="view" type="hidden" id="view" value="kereses"/><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="84" style="height:26px;"></td><td valign="bottom"><input type="text" name="mit" id="mit" style="width:126; font-family:Tahoma, Arial; font-size:10px; border:0px; background-color:transparent"/></td></tr><tr><td colspan="2"><img src="/art/sp.gif" width="79" height="5" alt=""/><input type="image" name="btn_keres" id="btn_keres" src="/art/osszetett.gif" onmouseover="kep('btn_keres', 'osszetett_a.gif')" onmouseout="kep('btn_keres', 'osszetett.gif')" width="136" height="20"/></td></tr></table></form></td></tr><tr><td class="newsletter"><form id="hirlevelFrm" name="hirlevelFrm" method="get" action="http://dev.itworx.hu/cgi-bin/itworx/lib/hirlevel/adduser.cgi" style="margin-bottom:0px"><input type="hidden" name="vID" value="148"/><input type="hidden" name="csID" value="205"/><input type="hidden" name="email" value="hirlevel@keszthely.hu"/><input type="hidden" name="subject" value="Feliratkoz�s a keszthely.hu h�rlevel�re"/><input type="hidden" name="redirect" value="http://www.keszthely.hu/cgi-bin/keszthely/index.cgi?view=hirlevel"/><input type="hidden" name="confirm" value="Tisztelt H�lgyem/Uram!K�sz�nj�k fel szeretne iratkozni Keszthely v�ros h�rlevel�re! A v�gleges�t�shez k�rem kattintson erre a linkre: "/><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="84" style="height:48px;"></td><td valign="bottom"><input type="text" name="useremail" id="useremail" style="width:126; font-family:Tahoma, Arial; font-size:10px; border:0px; background-color:transparent"/></td></tr><tr><td colspan="2"><img src="/art/sp.gif" width="79" height="5" alt=""/><input type="image" name="btn_hirlevel" id="btn_hirlevel" src="/art/kek/feliratkozas.gif" onmouseover="kep('btn_hirlevel', 'kek/feliratkozas_a.gif')" onmouseout="kep('btn_hirlevel', 'kek/feliratkozas.gif')" width="136" height="20"/></td></tr></table></form></td></tr><tr><td style="padding-left:10px"><script language="JavaScript" type="text/javascript">/*<![CDATA[*/if(AC_FL_RunContent==0){alert("This page requires AC_RunActiveContent.js.")}else{AC_FL_RunContent('codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0','width','210','height','480','src','/flash/menu_hu','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','align','middle','play','true','loop','true','scale','showall','wmode','transparent','devicefont','false','id','fejlec','bgcolor','#ffffff','name','fejlec','menu','true','allowFullScreen','false','allowScriptAccess','sameDomain','movie','/flash/menu_hu','salign','')}/*]]>*/</script><noscript>No flash</noscript></td></tr><tr><td style="padding-left:30px;"><img src="/art/bluedoubledot.gif" width="175" height="4" alt=""/></td></tr><tr><td style="padding-left:32px; padding-top:10px; padding-bottom10px"><img src="/art/kamera.jpg" alt="" border="1" align="center" onClick="javascript:window.open('http://www.tvkeszthely.hu/epulet.html','kamera','width=500,height=316,toolbar=no,scrollbars=no,menubar=no,status=no,location=no,resizable=0')" onmouseover="this.style.cursor='pointer';"></td></tr><tr><td style="padding-left:30px;"><img src="/art/bluedoubledot.gif" width="175" height="4" alt=""/></td></tr><tr><td style="padding-left:32px; padding-top:20px"><form class=naptarForm name='naptar' action=''> <input type=hidden name="view" value="programok"/><table class='naptarTabla' cellspacing=1 cellpadding=2><tr><td colspan=7 align=center class=fejNap><span class='fejText'><a href='/programok/2012/4' class='fejText'><<</a> 2012. m�jus <a href='/programok/2012/6' class='fejText'>>></a></span></td></tr><tr><td align=center class=fejNap><b>H</b></td><td align=center class=fejNap><b>K</b></td><td align=center class=fejNap><b>SZ</b></td><td align=center class=fejNap><b>CS</b></td><td align=center class=fejNap><b>P</b></td><td align=center class=fejNap><b>SZO</b></td><td align=center class=fejNap><b>V</b></td></tr><tr><td class=kifutonap>30</td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/1" class=nap title=''>1</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/2" class=nap title=''>2</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/3" class=nap title=''>3</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/4" class=nap title=''>4</a></td><td valign=top width=14% class=hetvege title=''><a href="/programok/2012/5/5" class=nap title=''>5</a></td><td valign=top width=14% class=hetvege title=''><a href="/programok/2012/5/6" class=nap title=''>6</a></td></tr><tr><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/7" class=nap title=''>7</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/8" class=nap title=''>8</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/9" class=nap title=''>9</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/10" class=nap title=''>10</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/11" class=nap title=''>11</a></td><td valign=top width=14% class=hetvege title=''><a href="/programok/2012/5/12" class=nap title=''>12</a></td><td valign=top width=14% class=hetvege title=''><a href="/programok/2012/5/13" class=nap title=''>13</a></td></tr><tr><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/14" class=nap title=''>14</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/15" class=nap title=''>15</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/16" class=nap title=''>16</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/17" class=nap title=''>17</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/18" class=nap title=''>18</a></td><td valign=top width=14% class=hetvege title=''><a href="/programok/2012/5/19" class=nap title=''>19</a></td><td valign=top width=14% class=hetvege title=''><a href="/programok/2012/5/20" class=nap title=''>20</a></td></tr><tr><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/21" class=nap title=''>21</a></td><td valign=top width=14% class=aktivNap title=''><a href="/programok/2012/5/22" class=nap title=''>22</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/23" class=nap title=''>23</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/24" class=nap title=''>24</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/25" class=nap title=''>25</a></td><td valign=top width=14% class=hetvege title=''><a href="/programok/2012/5/26" class=nap title=''>26</a></td><td valign=top width=14% class=hetvege title=''><a href="/programok/2012/5/27" class=nap title=''>27</a></td></tr><tr><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/28" class=nap title=''>28</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/29" class=nap title=''>29</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/30" class=nap title=''>30</a></td><td width=14% valign=top class=hetkoznap title=''><a href="/programok/2012/5/31" class=nap title=''>31</a></td><td width=14% valign=top class=kifutonap>1</td><td width=14% valign=top class=kifutonaphetvege>2</td><td width=14% valign=top class=kifutonaphetvege>3</td> </tr></table></form></td></tr><tr><td style="padding-left:30px;"><img src="/art/bluedoubledot.gif" width="175" height="4" alt=""/></td></tr><tr><td style="padding-left:22px; padding-top:12px; padding-right:16px; color:#CCCCCC"><table width="100%" border="0" cellspacing="0" cellpadding="3"><tr><td align="center"><img src="http://www.google.com/ig/images/weather/thunderstorm.gif" alt="Viharos" title="Viharos"/></td><td colspan="2"><div class="c">19 &deg;C</div>Viharos</br> Sz�l: D 6 km/�</br> P�ratartalom: 88%</td></tr><tr><td width="33%" align="center" valign="top">Sze</br> <img src="http://www.google.com/ig/images/weather/thunderstorm.gif" alt="Viharos" title="Viharos"/></br> 14&deg; 25&deg;</br> Viharos</td><td width="33%" align="center" valign="top">Cs</br> <img src="http://www.google.com/ig/images/weather/chance_of_storm.gif" alt="El�fordulhat vihar" title="El�fordulhat vihar"/></br> 11&deg; 27&deg;</br> El�fordulhat vihar</td><td width="33%" align="center" valign="top">P</br> <img src="http://www.google.com/ig/images/weather/chance_of_storm.gif" alt="El�fordulhat vihar" title="El�fordulhat vihar"/></br> 9&deg; 24&deg;</br> El�fordulhat vihar</td></tr></table></td></tr></table></td></tr></table></td></tr><tr><td colspan="2" class="lablec"><table width="100%" border="0" cellspacing="0" cellpadding="0" style="height:80px"><tr><td colspan="2">&nbsp;</td></tr><tr><td style="color:#999999"><a href="/impresszum" class="szurke">Impresszum</a></td><td width="400" style="color:#999999">Copyright &copy; <a href="/impresszum" class="szurke">Keszthely V�ros �nkorm�nyzata</a> �s <a href="http://www.webmark.hu" target="_blank" class="szurke">WebMark</a></td></tr></table></td></tr></table><script language="JavaScript" type="text/javascript">/*<![CDATA[*/function Init(){magassag("belso",326+32+80,800)}var map;var mgr;var icons={};var allmarkers=[];function map_load(){}var divs=document.getElementsByTagName("div");for(x=0;x<divs.length;x++){if((divs[x].lang!=null)&&(divs[x].lang!='')){divs[x].id="itwgaleria"+divs[x].lang;var so=new SWFObject("/flash/itwgallery.swf?galeriaID="+divs[x].lang,"mymovie"+divs[x].lang,"550","500","8","");so.addParam("wmode","transparent");so.write("itwgaleria"+divs[x].lang)}}/*]]>*/</script><script type="text/javascript">/*<![CDATA[*/var gaJsHost=(("https:"==document.location.protocol)?"https://ssl.":"http://www.");document.write(unescape("%3Cscript src='"+gaJsHost+"google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));/*]]>*/</script><script type="text/javascript">/*<![CDATA[*/try{var pageTracker=_gat._getTracker("UA-3853620-37");pageTracker._trackPageview()}catch(err){}/*]]>*/</script><img src="http://cdn1.itworx.hu/sites/stat.php?siteID=148" title="" alt=""/></body></html>