gistfile1.txt

<?php
//speckcatalog product mapper

    public function getByCategoryId($categoryId, $siteId=1)
    {
        $table      = $this->getTableName();
        $linker     = 'catalog_category_product';
        $joinString = $linker . '.product_id = ' . $table . '.product_id';
        $where      = array(
            'category_id' => $categoryId,
            'website_id' => $siteId
        );

        $select = $this->getSelect()
            ->join($linker, $joinString)
            ->where($where);
        if ($this->enabledOnly()) {
            $select->where(array('enabled' => 1));
        }
        return $this->selectManyModels($select);
    }