Test Gallery View – DEV

***
SELECT distinct jora_photo.photoFilename, jora_shoot.shootType, jora_shoot.shootName, jora_photo.photoID
FROM jora_photo
JOIN jora_photoTag ON jora_photoTag.photoID=jora_photo.photoID
JOIN jora_shoot ON jora_shoot.shootID=jora_photo.shootID
WHERE jora_photo.photoID in (Select sub1.photoID from
(Select * from jora_photoTag WHERE photoID IN (Select photoID from jora_photoTag WHERE tag=” )) sub1 WHERE sub1.tag=”)

albumID =
tag count =

tags 1 =

count = 0
pageHost = jeepoffroadadventures.com
pageURL = /wp/

Go to Page