SELECT gallery.id FROM gallery INNER JOIN gallery_images_colors ON (gallery.id = gallery_images_colors.galleryid) WHERE gallery_images_colors.near_color_hex = '80A0E0' OR hex = '80A0E0'AND active = 1 GROUP BY gallery.id ORDER BY gallery.date_added desc LIMIT 0,40