All pastes #495629 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-05-18 21:23 UTC
rendered paste body
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