public function selectMaisVistos()
{
$sql = "SELECT * ";
$sql .= "FROM galeria glr ";
$sql .= "JOIN categorias_galeria ctg ON ctg.ctg_id = glr.glr_categoria ";
$sql .= "ORDER BY glr.glr_visualizacoes DESC ";
$sql .= "LIMIT 0 , 3";
$result = $this->retrieve($sql);
$lista = array();
while ($qr = mysqli_fetch_array($result)) {
$glr = new Galeria();
$glr->setGlr_idgaleria($qr["glr_idgaleria"]);
$glr->setGlr_nome($qr["glr_nome"]);
$glr->setGlr_arquivo($qr["glr_arquivo"]);
$glr->setGlr_descricao($qr["glr_descricao"]);
$glr->setGlr_data($qr["glr_data"]);
$glr->setGlr_categoria(new CategoriaGaleria());
$glr->getGlr_categoria()->setCtg_id($qr["ctg_id"]);
$glr->getGlr_categoria()->setCtg_categoria($qr["ctg_categoria"]);
$glr->getGlr_categoria()->setCtg_classe($qr["ctg_classe"]);
$glr->setGlr_visualizacoes($qr["glr_visualizacoes"]);
array_push($lista, $glr);
}
return $lista;
}
