Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
SELECT package_number
FROM location
inner join dogtag_knots as dl on location.id = object_id and dl.object_type = 'location'
inner join dogtag_knots as dh on dh.dogtag_id = dl.dogtag_id and dh.object_type = 'hotel'
inner join object_object_knots on object1_id = dh.object_id and object1_type = 'hotel' and object2_type = 'package'
inner join package on object2_id = package.id and package.brand = 'SMR'
where location.name like '%moneybase cvv shop, 【 Visit Amsiga.com 】 ojM3t2s., ccvshop tw, mr white cvv, working fullz eVma%'