Home
Search
Print
Login
Add Bookmark
Cannot execute query: SELECT distinct tng_media.mediaID as mediaID, description , tng_media.notes, thumbpath, path, form, mediatypeID, tng_media.gedcom as gedcom, alwayson, usecollfolder, DATE_FORMAT(changedate,'%d %b %Y') as changedatef, status, plot, abspath, newwindow
FROM tng_media LEFT JOIN tng_medialinks on tng_media.mediaID = tng_medialinks.mediaID WHERE TO_DAYS(NOW()) - TO_DAYS(changedate) <= 30 AND (tng_media.gedcom = "1" || tng_media.gedcom = "") AND mediatypeID = "photos" ORDER BY changedate DESC, description LIMIT 20