string(425) "SELECT DISTINCT `as`.`activities_id` as `id` FROM `activities_` as `as` LEFT JOIN `activities_to_date_` `t0` ON `t0`.`activities_id`=`as`.`activities_id` LEFT JOIN `activities_to_activity_` `t12` ON `t12`.`activities_id`=`as`.`activities_id` WHERE 1 AND `t12`.`activity_id` IN (-1,0) AND `as`.`status`=1 AND `t0`.`status`=1 AND `t0`.`date_sale_end`>='2025-06-13 04:53:00' ORDER BY `as`.`sort_order` ASC, `t0`.`date_start` ASC"
string(307) "SELECT DISTINCT `b`.`city_id` as `id` FROM `activities_` as `as` LEFT JOIN `activities_to_date_` `t0` ON `t0`.`activities_id`=`as`.`activities_id` LEFT JOIN `building` `b` ON `b`.`building_id`=`t0`.`building_id` WHERE 1 AND `as`.`status`=1 AND `t0`.`status`=1 AND `t0`.`date_sale_end`>='2025-06-13 04:53:00'"
string(2566) "SELECT DISTINCT `t1`.`category_id` as `id` FROM `activities_` as `as` LEFT JOIN `activities_to_date_` `t0` ON `t0`.`activities_id`=`as`.`activities_id` LEFT JOIN `activities_to_category_` `t1` ON `t1`.`activities_id`=`as`.`activities_id` WHERE 1 AND (`t0`.`building_id` IN (-1,3,4,5,10,15,20,22,24,28,35,39,40,42,43,47,54,82,83,106,108,119,129,134,141,176,192,200,208,220,226,231,238,241,252,263,265,266,279,332,429,452,488,605,626,635,639,640,642,653,694,700,924,1043,1044,1045,1047,1049,1050,1054,1056,1058,1093,1100,1101,1102,1106,1109,1112,1114,1115,1116,1117,1118,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1137,1138,1139,1140,1141,1142,1144,1145,1150,1152,1153,1154,1157,1159,1161,1162,1163,1168,1169,1170,1173,1174,1176,1177,1178,1179,1181,1184,1185,1189,1193,1198,1201,1202,1206,1214,1215,1216,1217,1221,1241,1244,1249,1250,1254,1255,1256,1257,1258,1259,1262,1263,1265,1266,1291,1294,1295,1309,1310,1312,1316,1318,1322,1328,1330,1332,1333,1338,1346,1347,1351,1365,1366,1367,1368,1371,1404,1407,1408,1409,1410,1415,1417,1434,1449,1476,1477,1479,1480,1481,1487,1488,1500,1502,1503,1517,1521,1529,1542,1545,1556,1559,1567,1571,1574,1577,1583,1586,1589,1591,1593,1594,1626,1630,1632,1636,1637,1638,1639,1640,1641,1642,1653,1691,1692,1704,1714,1717,1719,1736,1741,1748,1763,1767,1773,1774,1783,1784,1785,1789,1793,1794,1797,1798,1800,1802,1807,1809,1821,1824,1830,1833,1834,1836,1840,1844,1852,1866,1867,1872,1873,1874,1880,1881,1882,1884,1885,1894,1895,1896,1897,1905,1909,1912,1913,1914,1916,1917,1919,1923,1926,1927,1928,1929,1933,1943,1944,1946,1960,1961,1964,1965,1966,1971,1974,1975,1976,1978,1982,1983,1990,2003,2007,2008,2014,2015,2018,2019,2020,2021,2022,2023,2060,2062,2089,2091,2094,2096,2097,2100,2123,2126,2127,2128,2129,2132,2133,51928,84634,93629,160425,215751,225235,242606,243509,243533,243564,250062,250098,250153,254114,255700,265367,277970,307327,440804,460634,461362,485358,499693,501271,506596,523393,527537,589690,616631,754701,764537,770080,790039,790049,850882,878345,887833,895544,957980,959640,1039799,1185466,1200077,1200092,1273522,1298280,1370247,1389210,1417928,1418168,1445633,2187018,2209436,2277642,2277662,2352989,2402615,2414760,2421949,2428384,2484431,2530149,2532682,2553554,2573003,2575874,2591338,2594720,2648766,2664747,2689264,2752949,2767874,2770778,2775407,2789637,2806994,2909551,2951019,2952191,2955258,2966070,3008657,3068186,3089013,3095092,3120787,3216547,3240023)
OR `as`.`activities_id` in (-1)) AND `as`.`status`=1 AND `t0`.`status`=1 AND `t0`.`date_sale_end`>='2025-06-13 04:53:00'"
string(2528) "SELECT DISTINCT `t12`.`activity_id` as `id` FROM `activities_` as `as` LEFT JOIN `activities_to_date_` `t0` ON `t0`.`activities_id`=`as`.`activities_id` LEFT JOIN `activities_to_activity_` `t12` ON `t12`.`activities_id`=`as`.`activities_id` WHERE 1 AND `t0`.`building_id` IN (-1,3,4,5,10,15,20,22,24,28,35,39,40,42,43,47,54,82,83,106,108,119,129,134,141,176,192,200,208,220,226,231,238,241,252,263,265,266,279,332,429,452,488,605,626,635,639,640,642,653,694,700,924,1043,1044,1045,1047,1049,1050,1054,1056,1058,1093,1100,1101,1102,1106,1109,1112,1114,1115,1116,1117,1118,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1137,1138,1139,1140,1141,1142,1144,1145,1150,1152,1153,1154,1157,1159,1161,1162,1163,1168,1169,1170,1173,1174,1176,1177,1178,1179,1181,1184,1185,1189,1193,1198,1201,1202,1206,1214,1215,1216,1217,1221,1241,1244,1249,1250,1254,1255,1256,1257,1258,1259,1262,1263,1265,1266,1291,1294,1295,1309,1310,1312,1316,1318,1322,1328,1330,1332,1333,1338,1346,1347,1351,1365,1366,1367,1368,1371,1404,1407,1408,1409,1410,1415,1417,1434,1449,1476,1477,1479,1480,1481,1487,1488,1500,1502,1503,1517,1521,1529,1542,1545,1556,1559,1567,1571,1574,1577,1583,1586,1589,1591,1593,1594,1626,1630,1632,1636,1637,1638,1639,1640,1641,1642,1653,1691,1692,1704,1714,1717,1719,1736,1741,1748,1763,1767,1773,1774,1783,1784,1785,1789,1793,1794,1797,1798,1800,1802,1807,1809,1821,1824,1830,1833,1834,1836,1840,1844,1852,1866,1867,1872,1873,1874,1880,1881,1882,1884,1885,1894,1895,1896,1897,1905,1909,1912,1913,1914,1916,1917,1919,1923,1926,1927,1928,1929,1933,1943,1944,1946,1960,1961,1964,1965,1966,1971,1974,1975,1976,1978,1982,1983,1990,2003,2007,2008,2014,2015,2018,2019,2020,2021,2022,2023,2060,2062,2089,2091,2094,2096,2097,2100,2123,2126,2127,2128,2129,2132,2133,51928,84634,93629,160425,215751,225235,242606,243509,243533,243564,250062,250098,250153,254114,255700,265367,277970,307327,440804,460634,461362,485358,499693,501271,506596,523393,527537,589690,616631,754701,764537,770080,790039,790049,850882,878345,887833,895544,957980,959640,1039799,1185466,1200077,1200092,1273522,1298280,1370247,1389210,1417928,1418168,1445633,2187018,2209436,2277642,2277662,2352989,2402615,2414760,2421949,2428384,2484431,2530149,2532682,2553554,2573003,2575874,2591338,2594720,2648766,2664747,2689264,2752949,2767874,2770778,2775407,2789637,2806994,2909551,2951019,2952191,2955258,2966070,3008657,3068186,3089013,3095092,3120787,3216547,3240023) AND `as`.`status`=1 AND `t0`.`status`=1 AND `t0`.`date_sale_end`>='2025-06-13 04:53:00'"
string(2521) "SELECT DISTINCT `t2`.`artist_id` as `id` FROM `activities_` as `as` LEFT JOIN `activities_to_date_` `t0` ON `t0`.`activities_id`=`as`.`activities_id` LEFT JOIN `activities_to_artist_` `t2` ON `t2`.`activities_id`=`as`.`activities_id` WHERE 1 AND `t0`.`building_id` IN (-1,3,4,5,10,15,20,22,24,28,35,39,40,42,43,47,54,82,83,106,108,119,129,134,141,176,192,200,208,220,226,231,238,241,252,263,265,266,279,332,429,452,488,605,626,635,639,640,642,653,694,700,924,1043,1044,1045,1047,1049,1050,1054,1056,1058,1093,1100,1101,1102,1106,1109,1112,1114,1115,1116,1117,1118,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1137,1138,1139,1140,1141,1142,1144,1145,1150,1152,1153,1154,1157,1159,1161,1162,1163,1168,1169,1170,1173,1174,1176,1177,1178,1179,1181,1184,1185,1189,1193,1198,1201,1202,1206,1214,1215,1216,1217,1221,1241,1244,1249,1250,1254,1255,1256,1257,1258,1259,1262,1263,1265,1266,1291,1294,1295,1309,1310,1312,1316,1318,1322,1328,1330,1332,1333,1338,1346,1347,1351,1365,1366,1367,1368,1371,1404,1407,1408,1409,1410,1415,1417,1434,1449,1476,1477,1479,1480,1481,1487,1488,1500,1502,1503,1517,1521,1529,1542,1545,1556,1559,1567,1571,1574,1577,1583,1586,1589,1591,1593,1594,1626,1630,1632,1636,1637,1638,1639,1640,1641,1642,1653,1691,1692,1704,1714,1717,1719,1736,1741,1748,1763,1767,1773,1774,1783,1784,1785,1789,1793,1794,1797,1798,1800,1802,1807,1809,1821,1824,1830,1833,1834,1836,1840,1844,1852,1866,1867,1872,1873,1874,1880,1881,1882,1884,1885,1894,1895,1896,1897,1905,1909,1912,1913,1914,1916,1917,1919,1923,1926,1927,1928,1929,1933,1943,1944,1946,1960,1961,1964,1965,1966,1971,1974,1975,1976,1978,1982,1983,1990,2003,2007,2008,2014,2015,2018,2019,2020,2021,2022,2023,2060,2062,2089,2091,2094,2096,2097,2100,2123,2126,2127,2128,2129,2132,2133,51928,84634,93629,160425,215751,225235,242606,243509,243533,243564,250062,250098,250153,254114,255700,265367,277970,307327,440804,460634,461362,485358,499693,501271,506596,523393,527537,589690,616631,754701,764537,770080,790039,790049,850882,878345,887833,895544,957980,959640,1039799,1185466,1200077,1200092,1273522,1298280,1370247,1389210,1417928,1418168,1445633,2187018,2209436,2277642,2277662,2352989,2402615,2414760,2421949,2428384,2484431,2530149,2532682,2553554,2573003,2575874,2591338,2594720,2648766,2664747,2689264,2752949,2767874,2770778,2775407,2789637,2806994,2909551,2951019,2952191,2955258,2966070,3008657,3068186,3089013,3095092,3120787,3216547,3240023) AND `as`.`status`=1 AND `t0`.`status`=1 AND `t0`.`date_sale_end`>='2025-06-13 04:53:00'"
string(307) "SELECT DISTINCT `b`.`city_id` as `id` FROM `activities_` as `as` LEFT JOIN `activities_to_date_` `t0` ON `t0`.`activities_id`=`as`.`activities_id` LEFT JOIN `building` `b` ON `b`.`building_id`=`t0`.`building_id` WHERE 1 AND `as`.`status`=1 AND `t0`.`status`=1 AND `t0`.`date_sale_end`>='2025-06-13 04:53:00'"
string(307) "SELECT DISTINCT `b`.`city_id` as `id` FROM `activities_` as `as` LEFT JOIN `activities_to_date_` `t0` ON `t0`.`activities_id`=`as`.`activities_id` LEFT JOIN `building` `b` ON `b`.`building_id`=`t0`.`building_id` WHERE 1 AND `as`.`status`=1 AND `t0`.`status`=1 AND `t0`.`date_sale_end`>='2025-06-13 04:53:00'"
string(307) "SELECT DISTINCT `b`.`city_id` as `id` FROM `activities_` as `as` LEFT JOIN `activities_to_date_` `t0` ON `t0`.`activities_id`=`as`.`activities_id` LEFT JOIN `building` `b` ON `b`.`building_id`=`t0`.`building_id` WHERE 1 AND `as`.`status`=1 AND `t0`.`status`=1 AND `t0`.`date_sale_end`>='2025-06-13 04:53:00'"
string(2490) "SELECT distinct left(`t0`.`date_start`,10) AS `list` FROM `activities_` as `as` LEFT JOIN `activities_to_date_` `t0` ON `t0`.`activities_id`=`as`.`activities_id` WHERE 1 AND (`t0`.`building_id` IN (-1,3,4,5,10,15,20,22,24,28,35,39,40,42,43,47,54,82,83,106,108,119,129,134,141,176,192,200,208,220,226,231,238,241,252,263,265,266,279,332,429,452,488,605,626,635,639,640,642,653,694,700,924,1043,1044,1045,1047,1049,1050,1054,1056,1058,1093,1100,1101,1102,1106,1109,1112,1114,1115,1116,1117,1118,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1137,1138,1139,1140,1141,1142,1144,1145,1150,1152,1153,1154,1157,1159,1161,1162,1163,1168,1169,1170,1173,1174,1176,1177,1178,1179,1181,1184,1185,1189,1193,1198,1201,1202,1206,1214,1215,1216,1217,1221,1241,1244,1249,1250,1254,1255,1256,1257,1258,1259,1262,1263,1265,1266,1291,1294,1295,1309,1310,1312,1316,1318,1322,1328,1330,1332,1333,1338,1346,1347,1351,1365,1366,1367,1368,1371,1404,1407,1408,1409,1410,1415,1417,1434,1449,1476,1477,1479,1480,1481,1487,1488,1500,1502,1503,1517,1521,1529,1542,1545,1556,1559,1567,1571,1574,1577,1583,1586,1589,1591,1593,1594,1626,1630,1632,1636,1637,1638,1639,1640,1641,1642,1653,1691,1692,1704,1714,1717,1719,1736,1741,1748,1763,1767,1773,1774,1783,1784,1785,1789,1793,1794,1797,1798,1800,1802,1807,1809,1821,1824,1830,1833,1834,1836,1840,1844,1852,1866,1867,1872,1873,1874,1880,1881,1882,1884,1885,1894,1895,1896,1897,1905,1909,1912,1913,1914,1916,1917,1919,1923,1926,1927,1928,1929,1933,1943,1944,1946,1960,1961,1964,1965,1966,1971,1974,1975,1976,1978,1982,1983,1990,2003,2007,2008,2014,2015,2018,2019,2020,2021,2022,2023,2060,2062,2089,2091,2094,2096,2097,2100,2123,2126,2127,2128,2129,2132,2133,51928,84634,93629,160425,215751,225235,242606,243509,243533,243564,250062,250098,250153,254114,255700,265367,277970,307327,440804,460634,461362,485358,499693,501271,506596,523393,527537,589690,616631,754701,764537,770080,790039,790049,850882,878345,887833,895544,957980,959640,1039799,1185466,1200077,1200092,1273522,1298280,1370247,1389210,1417928,1418168,1445633,2187018,2209436,2277642,2277662,2352989,2402615,2414760,2421949,2428384,2484431,2530149,2532682,2553554,2573003,2575874,2591338,2594720,2648766,2664747,2689264,2752949,2767874,2770778,2775407,2789637,2806994,2909551,2951019,2952191,2955258,2966070,3008657,3068186,3089013,3095092,3120787,3216547,3240023)
OR `as`.`activities_id` in (-1)) AND `as`.`status`=1 AND `t0`.`status`=1 AND `t0`.`date_sale_end`>='2025-06-13 04:53:00'"
string(257) "SELECT distinct left(`t0`.`date_start`,10) AS `list` FROM `activities_` as `as` LEFT JOIN `activities_to_date_` `t0` ON `t0`.`activities_id`=`as`.`activities_id` WHERE 1 AND `as`.`status`=1 AND `t0`.`status`=1 AND `t0`.`date_sale_end`>='2025-06-13 04:53:00'"
ᐅ Концерт Джаз на Даху – Історії з Олексієм Коганом в Києві - афіша, купити квиток на концерт
Вирушаймо у музичну подорож понад шумом міста на джазовий концерт JAZZ in KYIV BAND, наповнений затишними історіями легендарного Олексія Когана.
На вас чекає вишукана та розмаїта програма: від блюзових мотивів до латиноамериканських танців у стилі Viva Latina. А також атмосфера повного занурення та взаємодії, де імпровізація стає одкровенням, а пауза – медитацією.Для кожного твору, який прозвучить, ми розповімо невелику історію, що дозволить глибше сприйняти музику, розширити своє уявлення про неї, зрозуміти і відчути її.
Адже кожна мелодія є втіленням переживань та власної пригоди джазиста, які, як і саме життя, — подекуди веселі, іноді сумні, час від часу зворушливі, але завжди правдиві.
На нашому концерті джазу на даху на вас очікує дружня бесіда із келихом вина про створення блюзу, вміння імпровізувати, міфи та реальність навколо музичного слуху, і звісно – неперевершена музична насолода, яку подарує JAZZ in KYIV BAND.
Відчуйте місто по-новому – разом з нами: через звук, тишу й тепло джазу.