[thelist] Gallery3 - Using SQL queries

[Anthony Baratta]

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?


select
	Image.Relative_path_cache
from <table> as Image
join <table> as Album on
	Image.Parent_Id = Album.Id
where
	Image.Name = @Name
	AND
	Album.Name = @Album

Is that what you are looking for?



--
Anthony Baratta

Freedom is messy.
-- Mark Steyn