1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like'
SELECT l.id,l.active,l.listorder,l.lat,l.lon,l.autor,l.link,l.fotos_groups_id,l.generic1,l.generic2,l.generic3,l.generic4,l.generic5,l.entered,
l.inscripcions,l.published,ld.language_id,ld.titol,ld.titol2,ld.titol3,ld.descripcio,ld.descripcio2,ld.descripcio3,ld.download,
ld.pais,ld.provincia,ld.ciutat,ld.empresa,ld.persona_contacte,ld.telefon,ld.adreca_electronica,ld.web,
ld.placa_vacant,ld.estudis,ld.experiencia,ld.tipus_de_contracte,ld.jornada_laboral,ld.sou,ld.tags
FROM llistats l
LEFT JOIN llistats_description ld ON l.id=ld.llistats_id AND ld.language_id = '1'
WHERE (l.group_id = 1007)
AND l.active='1'
AND ld.titol<>''
AND tags like '%��ptica%'
ORDER BY l.group_id,l.listorder,l.entered desc
