SELECT DISTINCT albuns.id,
ncat.nome as categoria,
ncat.slug as slugcat,
nimg.ordem,
albuns.nome,
albuns.destaque,
albuns.status,
nimg.img,
albuns.slug,
albuns.conteudo,
albuns.tags,
albuns.data,
nimg.destaque,nimg.path
FROM albuns
INNER JOIN albuns_cat as ncat ON ncat.id = albuns.categoria
INNER JOIN albuns_fotos as nimg ON nimg.album = albuns.id
WHERE ncat.slug = 'restaurantes-pizzarias' AND albuns.status = '1' AND nimg.destaque = '1' AND nimg.status = '1' ORDER BY albuns.data DESC LIMIT 0,10
