$lng[gallery_albums]\n";
//Album with photos with dates
$q = mysqli_query($con, "SELECT album.id AS id, album.permalink AS permalink, album, album.title_$lang AS title, album.description_$lang AS description FROM photo_album, photo, album WHERE album.id = photo_album.album AND photo = photo.id GROUP BY album ORDER BY avg(photo.uploaded) DESC;");
while ($r = mysqli_fetch_array($q)){
echo "
\n";
echo "\n";
echo "
\n";
$q_count = mysqli_query($con, "SELECT album FROM photo_album WHERE album = $r[id];");
if (mysqli_num_rows($q_count) == 1)
echo "
\n";
}
//Albums with no photos or photos without dates
$q = mysqli_query($con, "SELECT id, title_es FROM album WHERE id NOT IN (SELECT album FROM photo_album, photo WHERE photo = photo.id GROUP BY album);");
?>
 | \n";
$i ++;
if ($i == 2)
echo "
$r[title] - 1 $lng[gallery_photos_singular]
\n"; else echo "$r[title] - " . mysqli_num_rows($q_count) . " $lng[gallery_photos_plural]
\n"; if (strlen($r['description']) > 0){ echo "". cutText($r['description'], 100, "$lng[gallery_read_more]", "http://$http_host/galeria/$r[permalink]") . "
\n"; } echo "