-------> print(select([ReposTable, PackageBuildTable, PackageBuildTagsTable, TagsTable, LanguagesTable], and_(ReposTable.c.shortname.in_(repos), PackageBuildTable.c.repoid==ReposTable.c.id, PackageBuildTable.c.id==PackageBuildTagsTable.c.packagebuildid, PackageBuildTagsTable.c.tagid==TagsTable.c.id, TagsTable.c.language==LanguagesTable.c.shortname, LanguagesTable.c.shortname.in_(langs))).distinct())

SELECT DISTINCT repos.id, repos.shortname, repos.name, repos.failovermethod, repos.collectionid, packagebuild.id, packagebuild.packageid, packagebuild.epoch, packagebuild.version, packagebuild.release, packagebuild.name, packagebuild.license, packagebuild.architecture, packagebuild.desktop, packagebuild.size, packagebuild.changelog, packagebuild.committime, packagebuild.committer, packagebuild.repoid, packagebuildtags.packagebuildid, packagebuildtags.tagid, packagebuildtags.score, tags.id, tags.name, tags.language, languages.name, languages.shortname
FROM repos, packagebuild, packagebuildtags, tags, languages
WHERE repos.shortname IN (%(shortname_1)s) AND packagebuild.repoid = repos.id AND packagebuild.id = packagebuildtags.packagebuildid AND packagebuildtags.tagid = tags.id AND tags.language = languages.shortname AND languages.shortname IN (%(shortname_2)s)