[thelist] Gallery3 - Using SQL queries

Anthony Baratta anthony at baratta.com
Sat Mar 20 13:53:48 CDT 2010

On 3/20/2010 8:57 AM, Todd Richards wrote:
> - Id (record id)
> - Name (such as the name of the album (ie "my-album" or "image.jpg"))
> - Parent_id (the id of the album that the images belong to)
> - Relative_path_cache (ie "my-album/image.jpg")
> - Relative_url_cache (ie "my-album/image)
> - Slug (ie "my-album" or "image")
> - Type (photo or album - it also allows for videos)
> - View count (number of hits)

Something like this?

from <table> as Image
join <table> as Album on
	Image.Parent_Id = Album.Id
	Image.Name = @Name
	Album.Name = @Album

Is that what you are looking for?

Anthony Baratta

Freedom is messy.
-- Mark Steyn

More information about the thelist mailing list