Válasszon az alábbi kategóriák közül, majd kattintson a nagyító ikonra!
Műfaj szerint
Helyszín szerint
Programok
2021. ápr. 19. - 2022. máj. 31.
Drámapedagógiai programok
Kecskeméten és a térségben dolgozó drámapedagógusok öntevékeny közössége. Módszertani képzések, tehetséggondozó programok, művészeti találkozók, táborok tartoznak a Műhely tevékenységi körébe.
2021. máj. 01. - 2022. máj. 25.
Teszt kiemelt esemény
Nulla eget eros velit. Nullam quis lobortis nisl. Vivamus porttitor felis ut felis efficitur molestie. Integer vitae diam varius, vehicula enim at, ullamcorper ante. Quisque ut condimentum velit. Quisque nec dui iaculis, euismod felis et, rutrum ante. Donec at aliquam ante. Quisque vehicula mollis ligula vel efficitur.
Fordította: Csukás Barnabás és Csukás Márton
A Madách Színház előadása
366 query futott le 0.51807999610901 másodperc alatt
Array
(
[query] => SELECT
program_extended_program_basic_id,
program_basic_id,
category_relation_foreign_id,
category_relation_type,
category_relation_category_id,
program_basic_description,
program_basic_short_description,
category_id,
program_basic_title,
program_basic_short_title,
program_location_relation_program_extended_id,
program_extended_id,
program_location_relation_location_id,
location_id,
program_extended_start_date,
program_extended_end_date,
program_extended_start_time,
program_extended_end_time,
STR_TO_DATE(CONCAT(CAST(program_extended_start_date AS CHAR), " ", program_extended_start_time, ":00"), "%Y-%m-%d %H:%i:%s") AS "date",
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",
program_basic_hide_date,
mod_program_extended.program_extended_delete_user_id,
mod_program_basic.program_basic_delete_user_id
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_extended_program_basic_id AND category_relation_type='mod_program_basic' ) JOIN core_category ON ( category_relation_category_id = category_id ) LEFT JOIN mod_program_location_relation ON ( program_location_relation_program_extended_id = program_extended_id ) LEFT JOIN mod_location ON ( program_location_relation_location_id = location_id ) WHERE ( 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 ) AND ( category_relation_type = "mod_program_basic" ) AND ( category_relation_category_id NOT IN(5) ) GROUP BY program_basic_id ORDER BY start_date ASC
[begin] => 1653315451.954
[end] => 1653315451.9793
[time] => 0.025364875793457
)
Array
(
[query] => SELECT COUNT(*) FROM (SELECT COUNT(*) FROM mod_program_basic LEFT JOIN mod_program_extended ON ( program_extended_program_basic_id = program_basic_id ) LEFT JOIN mod_category_relation ON ( category_relation_foreign_id = program_extended_program_basic_id ) LEFT JOIN core_category ON ( category_relation_category_id = category_id ) LEFT JOIN mod_program_location_relation ON ( program_location_relation_program_extended_id = program_extended_id ) LEFT JOIN mod_location ON ( program_location_relation_location_id = location_id ) WHERE ( 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 ) AND ( category_relation_category_id NOT IN(5) ) GROUP BY program_basic_id ) tt
[begin] => 1653315451.9944
[end] => 1653315452.0061
[time] => 0.011724948883057
)
Array
(
[query] => SELECT
program_extended_program_basic_id,
program_basic_id,
category_relation_foreign_id,
category_relation_type,
program_basic_description,
program_basic_short_description,
category_relation_category_id,
category_id,
program_basic_is_ticket,
program_basic_ticket_info,
program_basic_ticket_link,
program_basic_description,
program_basic_title,
program_location_relation_program_extended_id,
program_extended_id,
program_location_relation_location_id,
location_id,
program_extended_start_date,
program_extended_end_date,
program_extended_start_time,
program_extended_end_time,
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",
DATE_FORMAT(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"), "%Y-%m-%d %H:%i:%s") AS "start_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 LEFT JOIN mod_program_extended ON ( program_extended_program_basic_id = program_basic_id ) LEFT JOIN mod_category_relation ON ( category_relation_foreign_id = program_extended_program_basic_id ) LEFT JOIN core_category ON ( category_relation_category_id = category_id ) LEFT JOIN mod_program_location_relation ON ( program_location_relation_program_extended_id = program_extended_id ) LEFT JOIN mod_location ON ( program_location_relation_location_id = location_id ) WHERE ( 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 ) AND ( category_relation_category_id NOT IN(5) ) GROUP BY program_basic_id ORDER BY program_extended_start_date, program_extended_start_time ASC LIMIT 0, 15
[begin] => 1653315452.0061
[end] => 1653315452.0203
[time] => 0.014175891876221
)
Array
(
[query] => SELECT * FROM core_image LEFT JOIN mod_media ON ( media_image_id = image_id ) WHERE ( media_program_basic_id = 12 ) AND ( media_deleted_time IS NULL ) AND ( media_ispublic = 1 ) ORDER BY image_created_date DESC LIMIT 0, 1
[begin] => 1653315452.0444
[end] => 1653315452.0466
[time] => 0.0021839141845703
)
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] => 1653315452.1444
[end] => 1653315452.1455
[time] => 0.0010740756988525
)
Array
(
[query] => SELECT * FROM core_image LEFT JOIN mod_media ON ( media_image_id = image_id ) WHERE ( media_program_extended_id = 60 ) AND ( media_deleted_time IS NULL ) AND ( media_ispublic = 1 ) ORDER BY image_created_date DESC LIMIT 0, 1
[begin] => 1653315452.3351
[end] => 1653315452.3362
[time] => 0.0011022090911865
)
Array
(
[query] => SELECT * FROM core_route WHERE ( route_md5 = 'd1469bd60dad2bbecd7d3dea009a6b25' ) ORDER BY route_id DESC LIMIT 0, 1
[begin] => 1653315452.3643
[end] => 1653315452.3658
[time] => 0.0014691352844238
)
