SELECT  gc.description,
        g.description,
        COALESCE(m.LastLongtitude, '0'),
        COALESCE(m.lastLatitude,'0'),
        CAST(gc.categoryID AS VARCHAR(4)),
        CAST(g.engine AS VARCHAR(4)),
        COALESCE(g.panel_id,'0'),
        COALESCE(CAST(m.StatusZ2 AS VARCHAR(4)),'0'),
        COALESCE(CAST(m.isGPSValid AS VARCHAR(4)),'1'),
        CASE WHEN   (DATEDIFF(SECOND, COALESCE(GPSArriveTime, getdate()), getdate()) > 20) AND
                    (m.isGPSValid IS NOT NULL) THEN '1' ELSE '0' END,
        CASE WHEN   COALESCE(g.panel_id,'0') = '0' THEN 'Нет' ELSE g.panel_id END,
        CASE WHEN   g.engine = 0 THEN 'Выкл.' ELSE 'Вкл.' END,
        CASE WHEN   COALESCE(CAST(m.StatusZ2 AS VARCHAR(4)),'0') = '0'
             THEN   '<p style="color: #ff0000">Норма</p>'
             ELSE   '<p style="color: #ff0000">НАРУШЕН!</p>'
        END,

        CASE WHEN   COALESCE(CAST(m.isGPSValid AS VARCHAR(4)),'1') = '1'
             THEN   '<p style="color: #ff0000">Норма</p>'
             ELSE   '<p style="color: #ff0000">НЕВАЛИДНЫ!</p>'
        END,

        CASE WHEN   (DATEDIFF(SECOND, COALESCE(GPSArriveTime, getdate()), getdate()) > 20) AND
                    (m.isGPSValid IS NOT NULL)
             THEN   '<p style="color: #ff0000">Более 10 сек назад</color>'
             ELSE   '<p style="color: #ff0000">Норма</p>'
        END

FROM    MPhone m, groupresponse g, GroupResponseCategory gc
WHERE   m.mphone_id = g.mphone_id AND
        gc.categoryID = g.category