|
|
|
 |
|
Date of Last GEDCOM Import: 19 Jul 2010 20:37:32 This is what we've been working on most recently. Cannot execute query: SELECT distinct gger_media.mediaID as mediaID, description , gger_media.notes, thumbpath, path, form, mediatypeID, gger_media.gedcom as gedcom, alwayson, usecollfolder, DATE_FORMAT(changedate,'%e %b %Y') as changedatef, status, plot, abspath, newwindow
FROM gger_media LEFT JOIN gger_medialinks on gger_media.mediaID = gger_medialinks.mediaID WHERE TO_DAYS(NOW()) - TO_DAYS(changedate) <= 30 AND (gger_media.gedcom = "Our_Family_Tree" || gger_media.gedcom = "") AND mediatypeID = "photos" ORDER BY changedate DESC, description LIMIT 14 | |