[Vlad Drakula]

select page.id as page_id, type2.name as page_type
from site, page, type as type1, type as type2
where
(site.id = page.site_id
and site.type_id = type1.id
and page.type_id = type2.id
)
and site.id='1'