$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");
echo("\n");
echo("\n");
echo("\n");
echo("\n");
echo("\n");
echo("\n");
echo("
\n");
echo "");
echo("\n");
echo(" | \n");
$i ++;
if ($i == 2)
echo "
$r[title]
\n"; echo("1 $lng[gallery_photos_singular]"); } else{ echo "$r[title]
\n"; echo(mysqli_num_rows($q_count) . " $lng[gallery_photos_plural]"); } if (strlen($r['description']) > 0){ echo("". cutText($r['description'], 100, "$lng[gallery_read_more]", "$proto$http_host/galeria/$r[permalink]") . "
\n"); } echo "