SELECT
books__categories.id AS "id",
books__categories.id_parent AS "id_parent",
books__categories_translations.permalink AS "permalink",
books__categories_translations.title AS "title"
FROM books__categories
LEFT JOIN books__categories_translations
ON books__categories_translations.id_shared = books__categories.id
WHERE books__categories_translations.language = ?
ORDER BY books__categories.sequence DESC