AND not working with Nested Select sql query

SELECT 
    `db1t1`.`userid`, `db1t1`.`customer_id`, `db2t1`.`customers_id`,
    `db2t1`.`orders_id`, `db2t2`.`products_price`
FROM `database1`.`table1` AS `db1t1`
    LEFT JOIN `database2`.`table1` AS `db2t1` 
        USING (`customers_id`)
    LEFT JOIN `database2`.`table2` AS `db2t2`
        USING (`orders_id`)  
WHERE `db1t1`.`userid` IN (
    SELECT `l`.`userid`
    FROM `database1`.`table3` AS `l`
        LEFT JOIN `database2`.`table4` AS `r`
            USING (`username`)
    WHERE `r`.`cus_id` = 1234
)

  /*  SET @teamg_id := 0; */
    SELECT 
        /* @teamg_id := player.team_id, */
        player.team_id AS player_team, 
        event.local_team_id AS local_team, 
        event.visitor_team_id AS visitor_team, 
        action.unique_id AS action_id, 
        action.player_id AS player_id,
        player.name AS player_name,
        playerindex.rank AS player_pos, 
        playerindex.ses_var_nest AS ses_var_nest 
    FROM  
        er_players player, 
        er_events event, 
        er_actions action 
    LEFT JOIN 
        (SELECT 
            unique_id, team_id, @pn:=@pn+1 AS rank, team_id AS ses_var_nest ,
            case when team_id <> @lastteam
                 then  (@pn:=-1) <> (@lastteam:=team_id) end
        FROM 
            er_players, (SELECT (@pn:=-1),(@lastteam:=0)) p2 
     /*   WHERE 
            team_id = @teamg_id */
        ORDER BY 
            team_id, dorsal ASC, id DESC) playerindex 
    ON 
        playerindex.unique_id = action.player_id  
        AND playerindex.team_id = player.team_id /* new join condition */     
    WHERE 
        action.unique_id = '1374572622'  
        AND player.unique_id = action.player_id 
        AND event.unique_id = (SELECT event_id 
            FROM er_analysis 
            WHERE unique_id = action.analysis_id)