public static function getPromocionesFirmaFamilia($idFirma, $idFamilia, $soloVigentes = true) { $rows = array(); $promo = new Promociones(); $database = $promo->getDataBaseName(); $table = $promo->getTableName(); $promo->conecta(); if (is_resource($promo->_dbLink)) { $query = "SELECT p.Id " . "FROM {$database}.{$table} p, {$database}.AgtArticulos a " . "WHERE p.IdArticulo=a.Id AND " . " a.IdFirma='{$idFirma}' AND " . " a.IdFamilia='{$idFamilia}'"; //echo $query,"<br/>"; $promo->_em->query($query); $rows = $promo->_em->fetchResult(); } return $rows; }