wikimedia / mediawiki

		// left join with watchlist table to highlight watched rows

		$uid = $this->getUser()->getId();

		if ( $uid && $this->getUser()->isAllowed( 'viewmywatchlist' ) ) {

			$tables[] = 'watchlist';

			$select[] = 'wl_user';

			$join_conds['watchlist'] = [ 'LEFT JOIN', [

				'wl_user' => $uid,

				'wl_title=rc_title',

				'wl_namespace=rc_namespace'

			] ];

		}

		if ( $this->getUser()->isAllowed( 'rollback' ) ) {

			$tables[] = 'page';

			$join_conds['page'] = [ 'LEFT JOIN', 'rc_cur_id=page_id' ];

		$join_conds = [];

		// JOIN on watchlist for users

		if ( $user->getId() && $user->isAllowed( 'viewmywatchlist' ) ) {

			$tables[] = 'watchlist';

			$fields[] = 'wl_user';

			$fields[] = 'wl_notificationtimestamp';

			$join_conds['watchlist'] = [ 'LEFT JOIN', [

				'wl_user' => $user->getId(),

				'wl_title=rc_title',

				'wl_namespace=rc_namespace'

			] ];

		}

		if ( $user->isAllowed( 'rollback' ) ) {

			$tables[] = 'page';