Code
MariaDB [epg2vdr]> select * from timers where state in ('P','R') or state is null;
+-----+--------------------------------------+------------+------------+---------+---------------------+------------+--------+------+-------+------+--------+------------+----------+--------+------------+----------+--------+------------+----------+-----------+---------+-------------------------------------------------------------------------------+-----------+----------+----------+------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+-------------+----------------+--------+------------+
| id | vdruuid | inssp | updsp | eventid | channelid | _starttime | source | type | state | info | action | tccmailcnt | wrncount | retrys | namingmode | template | active | day | weekdays | starttime | endtime | file | directory | priority | lifetime | vps | childlock | aux | autotimername | autotimerid | autotimerinssp | doneid | expression |
+-----+--------------------------------------+------------+------------+---------+---------------------+------------+--------+------+-------+------+--------+------------+----------+--------+------------+----------+--------+------------+----------+-----------+---------+-------------------------------------------------------------------------------+-----------+----------+----------+------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+-------------+----------------+--------+------------+
| 388 | 04AC3772-9569-4E06-B7E2-5BEB95158FCC | 1479637273 | 1496394331 | 833350 | C-61441-10008-50700 | 1479720266 | webif | NULL | P | NULL | D | NULL | 1 | NULL | NULL | NULL | 1 | 1479682800 | 0 | 1022 | 1126 | Serien~Emergency Room - Die Notaufnahme~S14E14 - Gebrochenes Herz | | 50 | 99 | 0 | 0 | <epgsearch><channel>27 - sixx</channel><searchtimer>Emergency Room</searchtimer><start>1479720120</start><stop>1479723960</stop><s-id>10</s-id><eventid>833350</eventid></epgsearch><epgd><timerid>388</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 389 | 04AC3772-9569-4E06-B7E2-5BEB95158FCC | 1479637273 | 1496394331 | 833358 | C-61441-10008-50700 | 1479772849 | webif | NULL | P | NULL | D | NULL | 1 | NULL | NULL | NULL | 1 | 1479769200 | 0 | 58 | 152 | Serien~Emergency Room - Die Notaufnahme~S13E14 - Heimsuchung | | 50 | 99 | 0 | 0 | <epgsearch><channel>27 - sixx</channel><searchtimer>Emergency Room</searchtimer><start>1479772680</start><stop>1479775920</stop><s-id>10</s-id><eventid>833358</eventid></epgsearch><epgd><timerid>389</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 390 | 04AC3772-9569-4E06-B7E2-5BEB95158FCC | 1479637273 | 1496394331 | 878630 | C-61441-10008-50700 | 1480378500 | webif | NULL | P | NULL | D | NULL | 1 | NULL | NULL | NULL | 1 | 1480374000 | 0 | 113 | 205 | Serien~Emergency Room - Die Notaufnahme~S13E16 - Gewissenskonflikte | | 50 | 99 | 0 | 0 | <epgsearch><channel>27 - sixx</channel><searchtimer>Emergency Room</searchtimer><start>1480378380</start><stop>1480381500</stop><s-id>10</s-id><eventid>878630</eventid></epgsearch><epgd><timerid>390</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 799 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1495481786 | 1496387657 | 0 | C-1-1051-10304 | 0 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1496440800 | 0 | 2148 | 2330 | Hannes und der Bürgermeister - Lachgeschichten~Hannes und der Bürgermeister | | 50 | 99 | 0 | 0 | <epgsearch><channel>5 - SWR RP HD</channel><searchtimer>Hannes und der Bürgermeister</searchtimer><start>1496519280</start><stop>1496525400</stop><s-id>15</s-id><eventid>2048106</eventid></epgsearch><epgd><timerid>799</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 800 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1495481787 | 1496393426 | 0 | C-1-1051-10304 | 0 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1496527200 | 0 | 2143 | 2225 | Hannes und der Bürgermeister~Amtsbotenakademie / Himmlische Pforten | | 50 | 99 | 0 | 0 | <epgsearch><channel>5 - SWR RP HD</channel><searchtimer>Hannes und der Bürgermeister</searchtimer><start>1496605380</start><stop>1496607900</stop><s-id>15</s-id><eventid>2050123</eventid></epgsearch><epgd><timerid>800</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 801 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1495481795 | 1495539705 | 2046479 | C-61441-10017-11150 | 1496494500 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1496440800 | 0 | 1453 | 1535 | Natur im Garten~Der Genussgarten | | 50 | 99 | 0 | 0 | <epgsearch><channel>21 - 3sat HD</channel><searchtimer>Natur im Garten</searchtimer><start>1496494380</start><stop>1496496900</stop><s-id>61</s-id><eventid>2046479</eventid></epgsearch><epgd><timerid>801</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 802 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1495481865 | 1495539705 | 2043980 | C-1-1079-11110 | 1496435400 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1496354400 | 0 | 2228 | 2310 | heute-show~Nachrichtensatire mit Oliver Welke | | 40 | 99 | 0 | 0 | <epgsearch><channel>2 - ZDF HD</channel><searchtimer>heute-show</searchtimer><start>1496435280</start><stop>1496437800</stop><s-id>16</s-id><eventid>2043980</eventid></epgsearch><epgd><timerid>802</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 803 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1495645403 | 1495648985 | 2058514 | C-1-1051-11100 | 1496699100 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1496613600 | 0 | 2343 | 125 | Kommissar Wallander - Der Feind im Schatten~Der Feind im Schatten | | 50 | 99 | 0 | 0 | <epgsearch><channel>1 - Das Erste HD</channel><searchtimer>Kommissar Wallander</searchtimer><start>1496698980</start><stop>1496705100</stop><s-id>81</s-id><eventid>2058514</eventid></epgsearch><epgd><timerid>803</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 806 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1495660104 | 1495697866 | 2065095 | C-61441-10017-11150 | 1496742000 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1496700000 | 0 | 1138 | 1220 | Natur im Garten~Der Genussgarten | | 50 | 99 | 0 | 0 | <epgsearch><channel>21 - 3sat HD</channel><searchtimer>Natur im Garten</searchtimer><start>1496741880</start><stop>1496744400</stop><s-id>61</s-id><eventid>2065095</eventid></epgsearch><epgd><timerid>806</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 812 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1495832162 | 1495874072 | 2078030 | C-61441-10008-53621 | 1496869800 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1496786400 | 0 | 2308 | 10 | Serien~Gotham~Ein neuer Tag bricht an | | 50 | 99 | 0 | 0 | <epgsearch><channel>9 - ProSieben</channel><searchtimer>Gotham</searchtimer><start>1496869680</start><stop>1496873400</stop><s-id>97</s-id><eventid>2078030</eventid></epgsearch><epgd><timerid>812</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 817 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1496083322 | 1496096421 | 2086072 | C-61441-10014-11120 | 1497022800 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1496959200 | 0 | 1738 | 1835 | Geheimnisvoller Garten~Erntezeit | | 50 | 99 | 0 | 0 | <epgsearch><channel>4 - arte HD</channel><searchtimer>Natur im Garten</searchtimer><start>1497022680</start><stop>1497026100</stop><s-id>61</s-id><eventid>2086072</eventid></epgsearch><epgd><timerid>817</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 818 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1496083323 | 1496096421 | 2086062 | C-61441-10014-11120 | 1497028800 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1496959200 | 0 | 1918 | 1955 | Arte Journal~Nachrichten (F/D 2017) | | 50 | 99 | 0 | 0 | <epgsearch><channel>4 - arte HD</channel><searchtimer>Natur im Garten</searchtimer><start>1497028680</start><stop>1497030900</stop><s-id>61</s-id><eventid>2086062</eventid></epgsearch><epgd><timerid>818</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 819 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1496083324 | 1496096421 | 2088581 | C-61441-10017-11150 | 1497099600 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1497045600 | 0 | 1458 | 1545 | Natur im Garten~Duftende Blütenpracht | | 50 | 99 | 0 | 0 | <epgsearch><channel>21 - 3sat HD</channel><searchtimer>Natur im Garten</searchtimer><start>1497099480</start><stop>1497102300</stop><s-id>61</s-id><eventid>2088581</eventid></epgsearch><epgd><timerid>819</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 823 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1496266562 | 1496390158 | 2098495 | C-61441-10017-11150 | 1497346800 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1497304800 | 0 | 1138 | 1220 | Natur im Garten~Duftende Blütenpracht | | 50 | 99 | 0 | 0 | <epgsearch><channel>21 - 3sat HD</channel><searchtimer>Natur im Garten</searchtimer><start>1497346680</start><stop>1497349200</stop><s-id>61</s-id><eventid>2098495</eventid></epgsearch><epgd><timerid>823</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 824 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1496266566 | 1496390158 | 2096364 | C-61441-10008-53621 | 1497294600 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1497218400 | 0 | 2108 | 2150 | Serien~The Big Bang Theory~S08E09 - Eine Urne für Leonard | | 50 | 99 | 0 | 0 | <epgsearch><channel>9 - ProSieben</channel><searchtimer>The Big Bang Theory</searchtimer><start>1497294480</start><stop>1497297000</stop><s-id>37</s-id><eventid>2096364</eventid></epgsearch><epgd><timerid>824</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
| 825 | 5E47F4F5-F842-4EEC-961F-5E32E4625B96 | 1496384272 | 1496390158 | 2104751 | C-61441-10008-53621 | 1497474600 | epgs | NULL | P | NULL | a | 1 | NULL | NULL | NULL | NULL | 1 | 1497391200 | 0 | 2308 | 10 | Serien~Gotham~Alles für Dich | | 50 | 99 | 0 | 0 | <epgsearch><channel>9 - ProSieben</channel><searchtimer>Gotham</searchtimer><start>1497474480</start><stop>1497478200</stop><s-id>97</s-id><eventid>2104751</eventid></epgsearch><epgd><timerid>825</timerid></epgd> | NULL | NULL | NULL | NULL | NULL |
+-----+--------------------------------------+------------+------------+---------+---------------------+------------+--------+------+-------+------+--------+------------+----------+--------+------------+----------+--------+------------+----------+-----------+---------+-------------------------------------------------------------------------------+-----------+----------+----------+------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+-------------+----------------+--------+------------+
16 rows in set (0.01 sec)
Display More