\begin{Verbatim}[commandchars=\\\{\}] \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{action}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{act\PYZus{}user\PYZus{}id}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{issue}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{poster\PYZus{}id}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{notification}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{updated\PYZus{}by}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{team}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{org\PYZus{}id}\PY{+w}{ }\PY{k}{IN}\PY{+w}{ }\PY{p}{(}\PY{k}{SELECT}\PY{+w}{ }\PY{n}{org\PYZus{}id}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{org\PYZus{}user}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{uid}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{)}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{user}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{id}\PY{+w}{ }\PY{k}{IN}\PY{+w}{ }\PY{p}{(}\PY{k}{SELECT}\PY{+w}{ }\PY{n}{org\PYZus{}id}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{org\PYZus{}user}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{uid}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{)}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{org\PYZus{}user}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{uid}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{repo\PYZus{}unit}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{repo\PYZus{}id}\PY{+w}{ }\PY{k}{IN}\PY{+w}{ }\PY{p}{(}\PY{k}{SELECT}\PY{+w}{ }\PY{n}{id}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{repository}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{owner\PYZus{}id}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{)}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{repository}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{owner\PYZus{}id}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{team\PYZus{}user}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{uid}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{watch}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{user\PYZus{}id}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{issue\PYZus{}user}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{repo\PYZus{}id}\PY{+w}{ }\PY{k}{IS}\PY{+w}{ }\PY{k}{NULL}\PY{+w}{ }\PY{k}{OR}\PY{+w}{ }\PY{n}{uid}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{l+m+mf}{1646}\PY{p}{;} \PY{k}{DELETE}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{team}\PY{l+s+sName}{\PYZdq{}}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{org\PYZus{}id}\PY{+w}{ }\PY{k}{NOT}\PY{+w}{ }\PY{k}{IN}\PY{+w}{ }\PY{p}{(}\PY{k}{SELECT}\PY{+w}{ }\PY{n}{id}\PY{+w}{ }\PY{k}{from}\PY{+w}{ }\PY{l+s+sName}{\PYZdq{}}\PY{l+s+sName}{user}\PY{l+s+sName}{\PYZdq{}}\PY{p}{)}\PY{p}{;} \PY{k}{UPDATE}\PY{+w}{ }\PY{n}{repository}\PY{+w}{ }\PY{n}{r}\PY{+w}{ }\PY{k}{SET}\PY{+w}{ }\PY{n}{num\PYZus{}issues}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{p}{(}\PY{k}{SELECT}\PY{+w}{ }\PY{n}{count}\PY{p}{(}\PY{o}{*}\PY{p}{)}\PY{+w}{ }\PY{k}{FROM}\PY{+w}{ }\PY{n}{issue}\PY{+w}{ }\PY{n}{i}\PY{+w}{ }\PY{k}{WHERE}\PY{+w}{ }\PY{n}{i}\PY{l+m+mf}{.}\PY{n}{repo\PYZus{}id}\PY{+w}{ }\PY{o}{=}\PY{+w}{ }\PY{n}{r}\PY{l+m+mf}{.}\PY{n}{id}\PY{+w}{ }\PY{k}{GROUP}\PY{+w}{ }\PY{k}{BY}\PY{+w}{ }\PY{n}{r}\PY{l+m+mf}{.}\PY{n}{id}\PY{p}{)}\PY{p}{;} \end{Verbatim}