I will try get all pages assign to the website with name
$collection = Mage::getModel('cms/page')->getCollection(); $collection->getSelect() ->join( array('cps' => $collection->getTable('cms/page_store')), 'cps.page_id = main_table.page_id', array('store_id') );
but after the query I receive on my page such message
Item (Mage_Cms_Model_Page) with the same id "9" already exist
as a result I want receive something like that
About Us about-magento-demo-store 2 columns with right bar All Store Views Enabled Mar 13, 2015 1:30:07 AM Mar 13, 2015 1:30:07 AM ...