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