class Showing extends Zend_Db_Select
{
	protected $_name = 'subs_showings';

	$select = $db->select()
    ->from(array('p' => 'products'), array('product_id', 'product_name'))
    ->join(array('l' => 'line_items'), 'p.product_id = l.product_id', array() ); // empty list of columns
	
}