select photo_id from colors where g in (78,120,180) and blue in (23,25,27)