'

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

január07-28.
Tovább...
2022. jan. 7 - 28.
február09-17.
Tovább...
2022. febr. 9 - 17.
2022. febr. 9 - 17.

Program naptárhoz új

Hírek

Az Aranyhomok Kistérségfejlesztési Egyesület is képviselteti magát a Téli Fényünnepen, Kecskeméten

A kecskeméti Téli Fényünnep és Csodaország karácsonyi vásárán az Aranyhomok Kistérségfejlesztési Egyesület is képviselteti magát egy faházzal. A Hírös Agóra új törekvése a városi együttműködések serkentése, továbbá a térségben lévő minőségi termékek megjelentetése a vásáron, így született a felkérés. 

286 query futott le 0.86181998252869 másodperc alatt

Array
(
    [query] => SELECT * FROM core_content   WHERE  ( content_id = '1' )      LIMIT 1
    [begin] => 1642667576.7652
    [end] => 1642667576.7662
    [time] => 0.0010290145874023
)
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] => 1642667576.8671
    [end] => 1642667576.8682
    [time] => 0.001054048538208
)
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] => 1642667576.9074
    [end] => 1642667576.9129
    [time] => 0.0054869651794434
)
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] => 1642667576.9442
    [end] => 1642667577.0036
    [time] => 0.059366941452026
)
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] => 1642667577.0227
    [end] => 1642667577.0261
    [time] => 0.0034558773040771
)
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] => 1642667577.0846
    [end] => 1642667577.086
    [time] => 0.00140380859375
)
Array
(
    [query] => SELECT config_id, config_value FROM core_config   WHERE  ( config_path = 'modulesettings.core.slider_order' )      LIMIT 0, 1
    [begin] => 1642667577.1412
    [end] => 1642667577.1812
    [time] => 0.039992094039917
)
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] => 1642667577.2609
    [end] => 1642667577.2628
    [time] => 0.0018470287322998
)
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] => 1642667577.2631
    [end] => 1642667577.2685
    [time] => 0.0053977966308594
)
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] => 1642667577.2731
    [end] => 1642667577.2742
    [time] => 0.0010449886322021
)
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] => 1642667577.3151
    [end] => 1642667577.379
    [time] => 0.06392502784729
)
Array
(
    [query] => SELECT COUNT(*) FROM mod_tag    
    [begin] => 1642667577.3792
    [end] => 1642667577.389
    [time] => 0.0097761154174805
)
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 = 111 )      LIMIT 0, 1
    [begin] => 1642667577.4179
    [end] => 1642667577.419
    [time] => 0.0011060237884521
)
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] => 1642667577.4739
    [end] => 1642667577.4757
    [time] => 0.0018200874328613
)
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] => 1642667577.4765
    [end] => 1642667577.4789
    [time] => 0.0024611949920654
)
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] => 1642667577.4802
    [end] => 1642667577.4826
    [time] => 0.0023338794708252
)