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