TYPO3 / TYPO3.CMS

        // For "real" workspace numbers, select by that.

        // If = -98, select all that are NOT online (zero).

        // Anything else below -1 will not select on the wsid and therefore select all!

        if ($wsid > self::SELECT_ALL_WORKSPACES) {

            $constraints[] = $queryBuilder->expr()->eq(

                'A.t3ver_wsid',

                $queryBuilder->createNamedParameter($wsid, \PDO::PARAM_INT)

            );

        } elseif ($wsid === self::SELECT_ALL_WORKSPACES) {

            $constraints[] = $queryBuilder->expr()->neq(

                'A.t3ver_wsid',

                $queryBuilder->createNamedParameter(0, \PDO::PARAM_INT)

            );

        }

        // lifecycle filter:

        // 1 = select all drafts (never-published),

                'C.t3ver_wsid',

                $queryBuilder->createNamedParameter($wsid, \PDO::PARAM_INT)

            );

        } elseif ($wsid === self::SELECT_ALL_WORKSPACES) {

            $constraints[] = $queryBuilder->expr()->neq(

                'A.t3ver_wsid',

                $queryBuilder->createNamedParameter(0, \PDO::PARAM_INT)

            );

            $constraints[] = $queryBuilder->expr()->neq(

                'C.t3ver_wsid',

                $queryBuilder->createNamedParameter(0, \PDO::PARAM_INT)

            );

        }

        // lifecycle filter:

        // 1 = select all drafts (never-published),