Control + V (Page 6 of 12)

          $query = "

            SELECT SQL_CALC_FOUND_ROWS A.id_instance, A.id_form, A.title as formtitle, A.start as formstart,
                   B.deadline, B.title as activestep, (B.deadline<now()) as urgent,
                   concat_ws(' ',D.firstname,D.lastname) as initiator,

                   -- if i am owner of the current step, or there is no owner _and_ i initiated it then it needs action
                   (
                     (
                       NOT EXISTS (
                         SELECT * from inst_owners where id_step_instance=A.id_step_instance
                       )
                       AND
                       EXISTS (
                         SELECT * from inst_forms where id_instance=A.id_instance AND 
                         A.id_user=".intval($context->getUser()->getUserID())."
                       )
                     )
                     OR
                     EXISTS (
                       SELECT * from inst_owners where id_step_instance=A.id_step_instance
                         and id_user=".intval($context->getUser()->getUserID())."
                     )

                   ) as action

            FROM inst_forms as A
            -- current step only
            LEFT JOIN inst_steps as B on (A.id_step_instance=B.id_instance)
            LEFT JOIN users as D on (A.id_user=D.id_user)

            WHERE (
              (
                -- i'm initiator
                (A.id_user=".intval($context->getUser()->getUserID()).")

              )
            OR
              -- i'm associated as step-owner in this or previous step
              (
                EXISTS (
                  SELECT * from inst_owners as AA
                  left join inst_steps as BB on (AA.id_step_instance=BB.id_instance)
                  WHERE AA.id_user=".intval($context->getUser()->getUserID())."
                  AND BB.id_instance<=A.id_step_instance AND BB.id_form_instance=A.id_instance)
              )
            )
            AND isnull(A.end)

            ORDER BY action desc,B.deadline asc, B.id_instance asc

          ";