Request error on format as table

[Asgoret]

Hi to all. First if all thanks for your work. Panel is good. I have string data in my DB and can`t display them in panel. When i use 'format as table', panel showed "Request Error" (but don't write any errors) if i change format to time all is good. But, if it's timeserias format all data is null, not string... My SQL:

SELECT
  UNIX_TIMESTAMP(OpenHAB.Item8.Time) as time_sec,
  OpenHAB.Item8.Value as value
FROM OpenHAB.Item8
WHERE $__timeFilter(OpenHAB.Item8.Time)

[8666]

IF(OpenHAB.Item8.Value= 'OPEN', 1, 0) AS value,

[Bagunda]

How to setting up ON OFF view? Discrete plugin don't show real data.