+--------------------------+----------------+--------+
| id                       | date           | status |
+--------------------------+----------------+--------+
| 1cnlfwzzad2w9lzix84f5dgq | 20190625 20:00 |     1  |
| 2122y5vcyvwb9bx6ip79wtii | 20190625 20:00 |     1  |
| 2q1ajk48ui8km2qjc97vcokq | 20190625 20:00 |     1  |
| 3a7fb2mqdgkdr1xnn2a84ktm | 20190625 19:30 |     15 |
| m7owytgaxd5b6yr793pminoq | 20190626 17:00 |      1 |
| humk25vauzcsqyuoq23hwrxm | 20190626 19:30 |      0 |
| jeug4lgbkyhr2hmjjo6ux5yi | 20190626 19:30 |      0 |
| jxrk4jsimjaj86pm7f26i0ru | 20190626 19:15 |      0 |
| kehro35wrwn6txt1hn783bsa | 20190626 19:00 |      0 |
| kv8f7xpx41ibkwi9himn2aui | 20190626 19:30 |      0 |
| la30lbd9bt2ke7gydzip18iy | 20190626 19:00 |      0 |
| mqvprcg9c833rqwy1th36nai | 20190626 19:30 |      0 |
| neashojz9f8s1qgk4fwy120a | 20190626 19:30 |      0 |
+--------------------------+----------------+--------+

SELECT id_game as id,date_game as date,id_status_game as status FROM stats_opta_lmb_schedule_nueva WHERE STR_TO_DATE(date_game, '%Y%m%d')=DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 5 HOUR), '%Y-%m-%d')