Loading a product collection through multiple stores

We’ve created an additional indexer that is started by using the backend indexer functions. We have flat tables enabled. We have multiple storeviews that correspond to different languages.

The following code is an excerpt from the indexer code.

public function rebuildIndex ($productIds) {
  $stores = Mage::app()->getStores();
  foreach ($stores AS $store) {
    Mage::app()->setCurrentStore($store);
    $products = Mage::getModel('catalog/product')
      ->getCollection()
      ->setStore($store)
      ->addAttributeToFilter('status', 1)
      ->addAttributeToFilter('visibility', array ('in' => array (Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_SEARCH, Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH)))
      ->addAttributeToSelect('*')
      ->setPageSize(1000)
      ->setCurPage(++$page);
  }
}

The problem is that for the second and third store, the products loaded use the language of the first storeview.

We’ve tried finding out what the problem is. So far, we’ve seen that when using flat tables, the product flat tables created are these:

• catalog_product_flat_1
• catalog_product_flat_2
• catalog_product_flat_3

The number at the end corresponds to the storeview (and therefor the language). However, in all cases, the generated SELECT statement selects from the first table, making the language of the products loaded in all 3 storeviews the language of the first storeview.

We can’t disable flat tables (which we tried, and that fixes the problem). Is there any way to load the products for each of the storeviews?

Mage::app()->setCurrentStore(0);