Unexpected results in cross engine join

The following query produces unexpected results. The predicates are acting as an OR instead of AND.

select

 fk

 ,tags

 ,sum(clicks) 

from

 cs_test cs

inner join

 dim_test d on cs.fk=d.id

where

 locate('cpa',tags) > 0

 AND locate('1clickflow',tags) > 0

group by 1,2

Results:

Expected results:

The query is produced by Tableau and cannot be tweaked. mysqldump file attached in order to create example tables.