SELECT DATE AS DATE, method AS METHOD, red AS red, state AS STATE
FROM table
WHERE STATE = 155
GROUP BY DATE