SELECT
    TRIM(
        BOTH ','
    FROM
    REPLACE
        (
            `s`.`MTA_francais_pre_rempli`,
            'PL-',
            ''
        )
    ) AS aaa,
    `s`.`MTA_francais_pre_rempli`,
    `s`.count,
    `p`.count
FROM
    `strains` AS `s`
INNER JOIN plasmids AS p
ON
    p.count IN(
        TRIM(
            BOTH ','
        FROM
        REPLACE
            (`MTA_francais_pre_rempli`, 'PL-', '')
        )
    )
WHERE
    `s`.`MTA_francais_pre_rempli` IS NOT NULL AND `s`.`MTA_francais_pre_rempli` <> ''