SELECT s.* , g.gal_id , g.gal_prefix , COUNT(c.gc_id) as comments FROM gg_fav_sets s INNER JOIN gg_galleries g ON g.gal_id = s.fs_gal_id LEFT JOIN gg_galleries_comments c ON c.gc_gal_id = s.fs_gal_id WHERE fs_user_id = 18378 GROUP BY g.gal_id LIMIT -40, 40