SELECT COUNT(id_camping) as nb_camping, id_theme, theme_en
FROM camping AS c
RIGHT JOIN theme AS t
ON c.theme LIKE CONCAT('%/',id_theme,'/%')
GROUP BY id_theme
ORDER BY theme_en - MySQL server has gone away