SELECT * FROM (
    SELECT   id, name, status, starttime, priority, ordernumber, duetype, duedate, tour_name,     tour_pos, isNew, responsible,  ''||   COALESCE(name,'')||' '||   COALESCE(ordernumber,'')||' '||   COALESCE(tour_name,'')||' '||   COALESCE(task_object_id,'')||' '||   COALESCE(object_name,'')||' '||   COALESCE(object_shortterm,'')||' '||   COALESCE(object_recognition,'')||' '||   COALESCE(activity_object_id,'')||' '||   COALESCE(activity_object_name,'')||' '||   COALESCE(activity_shortterm,'')||' '||   COALESCE(activity_recognition,'') AS querytext
    FROM (
        SELECT     t.id as id,     t.name as name,     t.status as status,     case when resp.id is not null then 'true' else 'false' end as responsible,   t.starttime as starttime,     t.priority as priority,     t.ordernumber as ordernumber,   t.duetype as duetype,   t.duedate as duedate,   tour.name as tour_name,   t.tour_pos as tour_pos,   t.isNew as isNew,   t.object_id as task_object_id,   object.name as object_name,   opst.value as object_shortterm,   oprec.value as object_recognition,   GROUP_CONCAT(a.object_id,' ') as activity_object_id,   GROUP_CONCAT(aobj.name,' ') as activity_object_name,   GROUP_CONCAT(apst.value,' ') as activity_shortterm,   GROUP_CONCAT(aprec.value,' ') as activity_recognition
        FROM task t
        LEFT OUTER JOIN   (
            SELECT t.id AS id FROM task t WHERE t.responsible_id=?   UNION
            SELECT t.id AS id
            FROM task t
            INNER JOIN assignment a ON a.task_id = t.id
            INNER JOIN person p ON p.id = a.person_id
            WHERE p.user_id=? AND a.responsible = 'true'
        ) resp   ON resp.id = t.id
        LEFT OUTER JOIN object ON object.id = task_object_id
        LEFT OUTER JOIN property opst ON t.object_id = opst.object_id AND opst.name='Kurzname'
        LEFT OUTER JOIN property oprec ON t.object_id = oprec.object_id AND oprec.name='Kennung'
        LEFT OUTER JOIN activity a ON t.id = a.task_id
        LEFT OUTER JOIN object aobj ON a.object_id = aobj.id
        LEFT OUTER JOIN property apst ON a.object_id = apst.object_id AND apst.name='Kurzname'
        LEFT OUTER JOIN property aprec ON a.object_id = aprec.object_id AND aprec.name='Kennung'
        LEFT OUTER JOIN tour ON tour.id=t.tour_id
        GROUP BY t.id, t.name, t.status, t.starttime, t.priority, t.ordernumber, t.duetype, t.duedate, t.object_id, opst.value, oprec.value
    )
)