gistfile1.php

// in action tab
$category_ids = array(array(5,10,6,7));
 
$this->data['products'] = Shop_Product::create()
                              ->apply_filters()
                            ->join('shop_products_categories', 'shop_products_categories.shop_product_id=shop_products.id')
                              ->where('shop_products_categories.shop_category_id in (?)', $category_ids);
$this->data['products']->reset_order();                              
$this->data['products'] = $this->data['products']->order('shop_products.created_at desc')
                              ->limit(16)
                              ->find_all();

Page.php

<?php
foreach($products as $p){
	
	echo $p->categories[0]->name . '  ' . $p->sku . '  ' . $p->created_at . ' </br>';
	
}