SELECT
gc.id,
gc.insertdate,
gc.description,
gc.title,
gc.visible,
COUNT(gi.id) AS imageCount
FROM
gallery_collection gc
JOIN
gallery_image gi
ON
gi.collectionID = gc.id
GROUP BY
gc.id