Autoridad
Database Error; SQL: SELECT DISTINCT r1f.*, r1f.autor
FROM (
SELECT DISTINCT r1.*, autores.name as autor
FROM i8yYn_pods_registro AS r1
LEFT JOIN i8yYn_podsrel AS rel_autores ON
rel_autores.field_id = 38 AND rel_autores.item_id = r1.id
LEFT JOIN i8yYn_terms AS autores ON
autores.term_id = rel_autores.related_item_id
LEFT JOIN i8yYn_podsrel AS rel_materias ON
rel_materias.field_id = 11 AND rel_materias.item_id = r1.id
LEFT JOIN i8yYn_terms AS materias ON
materias.term_id = rel_materias.related_item_id
LEFT JOIN i8yYn_podsrel AS rel_lugares ON
rel_lugares.field_id = 28 AND rel_lugares.item_id = r1.id
LEFT JOIN i8yYn_terms AS lugares ON
lugares.term_id = rel_lugares.related_item_id
LEFT JOIN i8yYn_podsrel AS rel_autoridades ON
rel_autoridades.field_id = 29 AND
rel_autoridades.item_id = r1.id
LEFT JOIN i8yYn_terms AS autoridades ON
autoridades.term_id = rel_autoridades.related_item_id
WHERE ( materias.name LIKE "%Laura Papo "Bohoreta"%" OR lugares.name LIKE "%Laura Papo "Bohoreta"%" OR autoridades.name LIKE "%Laura Papo "Bohoreta"%" )
) AS r1f
JOIN i8yYn_posts AS p ON p.id = r1f.id AND p.post_status IN ("publish")
ORDER BY REGEXP_REPLACE(r1f.titulo, "[^a-zA-Z0-9]", ""); Response: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Bohoreta"%" OR lugares.name LIKE "%Laura Papo "Bohoreta"%" OR autoridades.nam...' at line 22
