January 1, 1970
BROWSE SITE BY
LOCATION Click here to expand the location list Click here to hide the location list
THEME Click here to expand the topic list Click here to hide the topic list
DATE Click here to expand the date list Click here to hide the date list
SELECT x2.objectIDlook, SUM(x2.strength) as rank, s.headline, s.storyID, p.filenameScroll FROM UBN_objectXtag x1 INNER JOIN UBN_objectXtag x2 ON x2.subjectIDlook = x1.subjectIDlook INNER JOIN UBN_objStory s ON s.storyID=x2.objectIDlook INNER JOIN UBN_photoXstory x ON x.storyIDlook=s.storyID INNER JOIN objPhoto p ON p.photoID=x.photoIDlook WHERE x1.objectIDlook = AND x1.objectType LIKE 'story' AND x2.objectType LIKE 'story' AND x2.objectIDlook != AND x.storyOrder = 1 GROUP BY x2.objectIDlook ORDER BY rank DESC

Share this page: Del.icio.us | Digg | Reddit | Facebook | StumbleUpon |