add select from translate tables and add site_id