Consulta
WordPress database error: [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 'AND R.relacio='és obra de'
AND V.relacio='és sobre'
AND F.nomp='editorial...' at line 16]SELECT E.nom as titol, D.nom as autor, REGEXP_SUBSTR(C.nom, '\\d+') as tema, substr(REGEXP_SUBSTR(C.nom, '\\D+!'),2,CHAR_LENGTH(REGEXP_SUBSTR(C.nom, '\\D+!'))-2) as nomtema, substr(REGEXP_SUBSTR(C.nom, '!\\D+'),2) as alfa, C.nom as dewey,
F.valorp as editorial, H.valorp as registre, I.valorp as idioma, N.valorp as pags, L.valorp as llegit, M.valorp as serie
FROM elements E
INNER JOIN Relacions R ON E.IDelement2=R.ID1
INNER JOIN elements D ON D.IDelement2=R.ID2
INNER JOIN Relacions V ON E.IDelement2=V.ID1
INNER JOIN elements C ON C.IDelement2=V.ID2
INNER JOIN Propietats F ON F.IDE2=R.ID1
INNER JOIN Propietats H ON H.IDE2=R.ID1
INNER JOIN Propietats I ON I.IDE2=R.ID1
INNER JOIN Propietats N ON N.IDE2=R.ID1
INNER JOIN Propietats L ON L.IDE2=R.ID1
INNER JOIN Propietats M ON M.IDE2=R.ID1
where
E.IDelement2=
AND R.relacio='és obra de'
AND V.relacio='és sobre'
AND F.nomp='editorial'
AND H.nomp='registre'
AND I.nomp='idioma'
AND N.nomp='pags'
AND L.nomp='llegit'
AND M.nomp='serie'