Volkswagen Offers

Array
(
    [featured] => 0
    [areaUrl] => offers
    [franchiseDetailId] => 10
    [notFirst] => 1
    [noParent] => 1
)



SELECT `cms_page_area_link`.* FROM `cms_page_area_link`
 INNER JOIN `franchise_area_setup` ON franchise_area_setup.id = cms_page_area_link.franchise_area_setup_id
 INNER JOIN `cms_area_detail` ON cms_area_detail.id = franchise_area_setup.cms_area_detail_id
 INNER JOIN `cms_page_content` ON cms_page_content.id = cms_page_area_link.cms_page_content_id WHERE (cms_area_detail.area_url = 'offers') AND (franchise_area_setup.franchise_detail_id = 10) AND ((display_start_date IS NULL) OR (display_start_date <= '2013-05-25')) AND ((display_end_date IS NULL) OR (display_end_date >= '2013-05-25')) AND (cms_page_area_link.live = 1) AND (cms_page_area_link.display_order <> 1) AND (cms_page_area_link.parent_cms_page_area_link_id = 0) ORDER BY `cms_page_area_link`.`display_order` ASC