SELECT COUNT(id_camping) as nb_camping, id_theme, theme_fr
FROM camping AS c
RIGHT JOIN theme AS t
ON c.theme LIKE CONCAT('%/',id_theme,'/%')
GROUP BY id_theme
ORDER BY theme_fr - User 'bcxisancamping' has exceeded the 'max_questions' resource (current value: 10239)