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

block title content pageID page
head it's a binary thing 1 main page
menu menu 1 main page
content1 Factual Error Found on Internet LONGMONT, CO - The Information Age was dealt a stunning blow Monday, when a factual error was discovered on the Internet. The error was found on TedsUltimateBradyBunch.com, a Brady Bunch fan site that incorrectly listed the show's debut year as 1968, not 1969. 1 main page
content2 Nation's Snowmen March Against Global Warming WASHINGTON, DC - Braving balmy temperatures and sunny skies, millions of scarfless snowmen and snowwomen gathered in cities across the world Tuesday to raise public awareness about the heavy toll global warming is taking on their health and well-being. 1 main page
footer all 'news' items from The Onion 1 main page