Válasszon az alábbi kategóriák közül, majd kattintson a nagyító ikonra!

Műfaj szerint

Helyszín szerint
május01-25.
Tovább...
2021. máj. 01. - 2022. máj. 25.
2021. máj. 01. - 2022. máj. 25.

Teszt kiemelt esemény

június10.-szeptember23.
Tovább...
2021. jún. 10. - 2022. szept. 23.
2021. jún. 10. - 2022. szept. 23.

Teszt kiemelt esemény 2

november29.-december10.
Tovább...
2021. nov. 29. - 2021. dec. 10.
2021. nov. 29. - 2021. dec. 10.

Program több hónapra

december02-15.
Tovább...
2021. dec. 2 - 15.
2021. dec. 2 - 15.

123 új

Hírek

290 query futott le 0.96991205215454 másodperc alatt

Array
(
    [query] => SELECT 
                    banner_item_image_id,
                    banner_item_url
                 FROM mod_banner  JOIN mod_banner_item ON  ( banner_item_banner_id = banner_id )    WHERE  ( banner_id = 2 ) AND  ( banner_status = 1 )      ORDER BY banner_item_order
    [begin] => 1638505862.542
    [end] => 1638505862.5441
    [time] => 0.0020968914031982
)
Array
(
    [query] => SELECT 
                    content_id,
                    content_id as id,
                    'content' as sliderItemType,
                    content_title as title,
                    content_active,
                    content_published,
                    content_public_id,
                    content_state,
                    content_image_content_id,
                    content_image_image_id as image_id,
                    content_image_order,
                    content_date as date,
                    content_image_title as image_title,
                    content_image_description as image_desc,
                    category_relation_foreign_id,
                    category_relation_category_id,
                    category_relation_type
                 FROM core_content  JOIN core_content_image ON  ( content_id = content_image_content_id )   JOIN mod_category_relation ON  ( category_relation_foreign_id = content_id )    WHERE  ( content_state = 1 ) AND  ( content_state != -1 ) AND  ( content_public_id = 0 ) AND  ( category_relation_category_id = 1 ) AND  ( content_image_order = 0 ) AND  ( category_relation_type = "core_content" )     
    [begin] => 1638505862.5996
    [end] => 1638505862.6056
    [time] => 0.0060229301452637
)
Array
(
    [query] => SELECT 
                    news_id,
                    news_id as id,
                    news_public_id,
                    news_title as title,
                    'news' as sliderItemType,
                    news_start_date as date,
                    news_end_date,
                    news_image_news_id,
                    news_image_image_id as image_id,
                    news_image_order,
                    news_image_title as image_title,
                    news_image_description as image_desc,
                    category_relation_foreign_id,
                    category_relation_category_id,
                    category_relation_type
                 FROM mod_news  JOIN mod_news_image ON  ( news_image_news_id = news_id )   JOIN mod_category_relation ON  ( category_relation_foreign_id = news_id )    WHERE  ( news_public_id = 0 AND news_start_date <= NOW() AND (news_end_date = 0000-00-00 OR news_end_date >= NOW()) ) AND  ( news_image_order = 0 ) AND  ( category_relation_category_id = 1 ) AND  ( category_relation_type = "mod_news" )     
    [begin] => 1638505862.6269
    [end] => 1638505862.6317
    [time] => 0.0047929286956787
)
Array
(
    [query] => SELECT 
                    program_basic_id,
                    program_basic_id as id,
                    program_basic_title as title,
                    'progBasic' as sliderItemType,
                    program_basic_status,
                    program_basic_delete_user_id,
                    program_basic_type,
                    program_basic_show_on_web,
                    program_extended_program_basic_id,
                    program_extended_id,
                    STR_TO_DATE(CONCAT(CAST(program_extended_start_date AS CHAR), ' ', program_extended_start_time, ':00'), '%Y-%m-%d %H:%i:%s') AS start_date,
                    STR_TO_DATE(CONCAT(CAST(program_extended_end_date AS CHAR), ' ', program_extended_end_time, ':00'), '%Y-%m-%d %H:%i:%s') AS end_date,
                    category_relation_category_id,
                    category_relation_foreign_id,
                    category_relation_type,
                    program_basic_hide_date,
                    program_extended_end_date,
                    program_extended_start_date,
                    program_extended_start_time,
                    program_extended_end_time,
                    program_extended_not_display_time_on_the_screen
                 FROM mod_program_basic  JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )   JOIN mod_category_relation ON  ( category_relation_foreign_id = program_basic_id )    WHERE  ( IFNULL(program_basic_delete_user_id,0) = 0 AND (program_basic_type = 0 OR program_basic_show_on_web = 1) ) AND  ( category_relation_category_id = 1 ) AND  ( category_relation_type = "mod_program_basic" ) AND  ( IFNULL(mod_program_basic.program_basic_delete_user_id, 0) = 0 AND IFNULL(mod_program_extended.program_extended_delete_user_id, 0) = 0 ) AND  ( CONCAT(CAST(program_extended_end_date AS CHAR), " ", program_extended_end_time, ":00") >= CURRENT_TIMESTAMP )      ORDER BY program_extended_start_date
    [begin] => 1638505862.6429
    [end] => 1638505862.6453
    [time] => 0.0024728775024414
)
Array
(
    [query] => SELECT * FROM core_image  LEFT JOIN mod_media ON  ( media_image_id = image_id )    WHERE  ( media_program_basic_id = 43 ) AND  ( media_deleted_time IS NULL ) AND  ( media_ispublic = 1 )      ORDER BY image_created_date DESC LIMIT 0, 1
    [begin] => 1638505862.6615
    [end] => 1638505862.6628
    [time] => 0.0012640953063965
)
Array
(
    [query] => SELECT * FROM core_image  LEFT JOIN mod_media ON  ( media_image_id = image_id )    WHERE  ( media_program_extended_id = 110 ) AND  ( media_deleted_time IS NULL ) AND  ( media_ispublic = 1 )      ORDER BY image_created_date DESC LIMIT 0, 1
    [begin] => 1638505862.6683
    [end] => 1638505862.6694
    [time] => 0.0011570453643799
)
Array
(
    [query] => SELECT config_id, config_value FROM core_config   WHERE  ( config_path = 'modulesettings.core.slider_order' )      LIMIT 0, 1
    [begin] => 1638505862.7781
    [end] => 1638505862.8069
    [time] => 0.028863906860352
)
Array
(
    [query] => SELECT STR_TO_DATE(CONCAT(CAST(program_extended_start_date AS CHAR), ' ', program_extended_start_time, ':00'), '%Y-%m-%d %H:%i:%s') AS 'min_date',
                                 STR_TO_DATE(CONCAT(CAST(program_extended_end_date AS CHAR), ' ', program_extended_end_time, ':00'), '%Y-%m-%d %H:%i:%s') AS 'end_date' FROM mod_program_basic  JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )   JOIN mod_category_relation ON  ( category_relation_foreign_id = program_basic_id AND category_relation_category_id = 2 AND category_relation_type LIKE "mod_program_basic" )    WHERE  ( IFNULL(program_basic_delete_user_id,0) = 0 AND (program_basic_id NOT IN(2,2,15,16,17,18,26,27,30,31,33,33,34,35,36,36,37,38,39,40,41,49,50,53,53,56,57,92,98,99)) ) AND  ( IFNULL(program_extended_delete_user_id,0) = 0 )     HAVING end_date > NOW()  
    [begin] => 1638505862.8435
    [end] => 1638505862.8605
    [time] => 0.016983032226562
)
Array
(
    [query] => SELECT *, STR_TO_DATE(CONCAT(CAST(program_extended_start_date AS CHAR), ' ', IF(program_extended_start_time!='',program_extended_start_time,'00:00'), ':00'), '%Y-%m-%d %H:%i:%s') AS 'min_date',
                                 STR_TO_DATE(CONCAT(CAST(program_extended_end_date AS CHAR), ' ', IF(program_extended_end_time!='',program_extended_end_time,'00:00'), ':00'), '%Y-%m-%d %H:%i:%s') AS 'end_date' FROM mod_program_basic  JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )   JOIN mod_category_relation ON  ( category_relation_foreign_id = program_basic_id AND category_relation_category_id = 2 AND category_relation_type LIKE "mod_program_basic" )    WHERE  ( IFNULL(program_basic_delete_user_id,0) = 0 AND (program_basic_id NOT IN(2,2,15,16,17,18,26,27,30,31,33,33,34,35,36,36,37,38,39,40,41,49,50,53,53,56,57,92,98,99)) ) AND  ( IFNULL(program_extended_delete_user_id,0) = 0 )     HAVING end_date > NOW()   ORDER BY program_extended_start_date, program_extended_start_time LIMIT 0, 4
    [begin] => 1638505862.8608
    [end] => 1638505862.8661
    [time] => 0.0052981376647949
)
Array
(
    [query] => SELECT * FROM core_image  LEFT JOIN mod_media ON  ( media_image_id = image_id )    WHERE  ( media_program_basic_id = 5 ) AND  ( media_deleted_time IS NULL ) AND  ( media_ispublic = 1 )      ORDER BY image_created_date DESC LIMIT 0, 1
    [begin] => 1638505862.871
    [end] => 1638505862.872
    [time] => 0.0010149478912354
)
Array
(
    [query] => SELECT * FROM mod_tag  LEFT JOIN mod_tag_relation ON  ( tag_relation_tag_id = tag_id )    WHERE  ( tag_relation_model = "ProgramBasic" ) AND  ( tag_relation_ref_id = 5 )     
    [begin] => 1638505862.9171
    [end] => 1638505863.0137
    [time] => 0.096651792526245
)
Array
(
    [query] => SELECT * FROM mod_program_basic  LEFT JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )   JOIN mod_category_relation ON  ( category_relation_foreign_id = program_basic_id )    WHERE  ( IFNULL(program_basic_delete_user_id,0) = 0 AND (program_basic_type = 0 OR program_basic_show_on_web = 1) ) AND  ( program_basic_id = 6 )      LIMIT 0, 1
    [begin] => 1638505863.0169
    [end] => 1638505863.0274
    [time] => 0.01053786277771
)
Array
(
    [query] => SELECT * FROM core_image  LEFT JOIN mod_media ON  ( media_image_id = image_id )    WHERE  ( media_program_basic_id = 6 ) AND  ( media_deleted_time IS NULL ) AND  ( media_ispublic = 1 )      ORDER BY image_created_date DESC LIMIT 0, 1
    [begin] => 1638505863.0277
    [end] => 1638505863.0287
    [time] => 0.0010139942169189
)
Array
(
    [query] => SELECT * FROM mod_program_basic  LEFT JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )   JOIN mod_category_relation ON  ( category_relation_foreign_id = program_basic_id )    WHERE  ( IFNULL(program_basic_delete_user_id,0) = 0 AND (program_basic_type = 0 OR program_basic_show_on_web = 1) ) AND  ( program_basic_id = 108 )      LIMIT 0, 1
    [begin] => 1638505863.0475
    [end] => 1638505863.0485
    [time] => 0.0010139942169189
)
Array
(
    [query] => SELECT * FROM mod_program_basic  LEFT JOIN mod_program_extended ON  ( program_extended_program_basic_id = program_basic_id )   JOIN mod_category_relation ON  ( category_relation_foreign_id = program_basic_id )    WHERE  ( IFNULL(program_basic_delete_user_id,0) = 0 AND (program_basic_type = 0 OR program_basic_show_on_web = 1) ) AND  ( program_basic_id = 106 )      LIMIT 0, 1
    [begin] => 1638505863.0629
    [end] => 1638505863.064
    [time] => 0.0010559558868408
)
Array
(
    [query] => SELECT news_id FROM mod_news  JOIN mod_category_relation ON  ( category_relation_foreign_id = news_id )    WHERE  ( category_relation_category_id = 38 ) AND  ( category_relation_type = "mod_news" ) AND  ( news_public_id = 0 ) AND  ( news_published = 1 )  GROUP BY news_id   
    [begin] => 1638505863.1284
    [end] => 1638505863.1303
    [time] => 0.0018658638000488
)
Array
(
    [query] => SELECT * FROM mod_news  LEFT JOIN mod_news_image ON  ( news_image_news_id = news_id )   LEFT JOIN core_image ON  ( news_image_image_id = image_id )    WHERE  ( news_public_id = 0 ) AND  ( news_published = 1 ) AND  ( news_id NOT IN(1,3,5,7,9,21) ) AND  ( news_public_id = 0 AND news_start_date <= NOW() AND (news_end_date = 0000-00-00 OR news_end_date >= NOW()) )  GROUP BY news_id    ORDER BY news_start_date DESC
    [begin] => 1638505863.1313
    [end] => 1638505863.1448
    [time] => 0.013476133346558
)
Array
(
    [query] => SELECT * FROM mod_news  LEFT JOIN mod_news_image ON  ( news_image_news_id = news_id )   LEFT JOIN core_image ON  ( news_image_image_id = image_id )    WHERE  ( news_public_id = 0 ) AND  ( news_published = 1 ) AND  ( news_id NOT IN(1,3,5,7,9,21) ) AND  ( news_public_id = 0 AND news_start_date <= NOW() AND (news_end_date = 0000-00-00 OR news_end_date >= NOW()) )  GROUP BY news_id    ORDER BY news_start_date DESC LIMIT 0, 3
    [begin] => 1638505863.1456
    [end] => 1638505863.1472
    [time] => 0.0016450881958008
)