getDbName()); $c->clearOrderByColumns(); $c->addSelectColumn(self::PRODUCT_ID); $sql = BasePeer::createSqlQuery($c); $rs = $con->executeQuery('SELECT count(*) as cnt FROM ('.$sql.') as temp'); return $rs->next() ? $rs->getInt('cnt') : 0; } }