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

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. 

226 query futott le 0.23385906219482 másodperc alatt

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] => 1653318545.0532
    [end] => 1653318545.0553
    [time] => 0.0021698474884033
)
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
                 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] => 1653318545.0711
    [end] => 1653318545.0735
    [time] => 0.0024280548095703
)
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] => 1653318545.1008
    [end] => 1653318545.1027
    [time] => 0.0019118785858154
)
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] => 1653318545.1029
    [end] => 1653318545.1085
    [time] => 0.0055739879608154
)
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_created_date DESC
    [begin] => 1653318545.1609
    [end] => 1653318545.1633
    [time] => 0.0024199485778809
)
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_created_date DESC LIMIT 0, 3
    [begin] => 1653318545.1639
    [end] => 1653318545.1662
    [time] => 0.0022978782653809
)