pageView4

Query

 
  SELECT 
    blockType.name as 'block',
    cmsBlock.title as 'title',
    cmsBlock.content as 'content',
    cmsPage.cmsPageID as 'pageID',
    cmsPage.title as 'page'    
  FROM 
    cmsBlock, blockType, cmsPage
  WHERE 
    cmsBlock.blockTypeID = blockType.blockTypeID;

Result