• Artist: KISS
  • ◀ Hide Side Panel
    • PhotoSession.asp | Line 135 | sqlgetPS=/*4*/SELECT _02State.State, _04EventDate.EventDate, _03City.City, _03City.CityID, _01Country.CID, _01Country.Country, _02States.SID, _06Photoshoot.PhotoshootName, _06Photoshoot.PhotoshootID, _06PhotoshootLocation.PSLName, _06PhotoshootLocation.PSLID, DATENAME(weekday, _04EventDate.EventDate) AS EventDay, DATENAME(month, _04EventDate.EventDate) AS EventMonth, DATENAME(year, _04EventDate.EventDate) AS EventYear, DATENAME(day, _04EventDate.EventDate) AS Eventdays, DATENAME(weekday, _04EventDate.EventDate) + ' ' + DATENAME(month, _04EventDate.EventDate) + ' ' + DATENAME(day, _04EventDate.EventDate) + ', ' + DATENAME(year, _04EventDate.EventDate) AS EventsDate, Artists.ArtistID, Artists.ArtistName, (SELECT Top 1 PicsPath FROM ImageServer WHERE (PhotoShootID = _06Photoshoot.PhotoshootID) AND (ProfPic = 11)) as PicsPath, (SELECT Top 1 ThumbnailWH FROM ImageServer WHERE (PhotoShootID = _06Photoshoot.PhotoshootID) AND (ProfPic = 11)) as ThumbnailWH, (SELECT Top 1 TinyWH FROM ImageServer WHERE (PhotoShootID = _06Photoshoot.PhotoshootID) AND (ProfPic = 11)) as TinyWH, (SELECT Top 1 FolderWH FROM ImageServer WHERE (PhotoShootID = _06Photoshoot.PhotoshootID) AND (ProfPic = 11)) as FolderWH, (SELECT Top 1 RSSWH FROM ImageServer WHERE (PhotoShootID = _06Photoshoot.PhotoshootID) AND (ProfPic = 11)) as RSSWH, (SELECT Top 1 ProfileWH FROM ImageServer WHERE (PhotoShootID = _06Photoshoot.PhotoshootID) AND (ProfPic = 11)) as ProfileWH FROM Artists INNER JOIN _06Photoshoot INNER JOIN _06PhotoshootLocations ON _06Photoshoot.PhotoshootID = _06PhotoshootLocations.PhotoshootID INNER JOIN _01Countrys ON _06Photoshoot.PhotoshootID = _01Countrys.PhotoshootID INNER JOIN _02States ON _06Photoshoot.PhotoshootID = _02States.PhotoshootID INNER JOIN _03Citys ON _06Photoshoot.PhotoshootID = _03Citys.PhotoshootID INNER JOIN _04EventDates ON _06Photoshoot.PhotoshootID = _04EventDates.PhotoshootID INNER JOIN _04EventDate ON _04EventDates.EDID = _04EventDate.EDID INNER JOIN _02State ON _02States.SID = _02State.SID INNER JOIN _03City ON _03Citys.CityID = _03City.CityID INNER JOIN _01Country ON _01Countrys.CID = _01Country.CID INNER JOIN _06PhotoshootLocation ON _06PhotoshootLocations.PSLID = _06PhotoshootLocation.PSLID ON Artists.ArtistID = _06Photoshoot.ArtistID WHERE Artists.ArtistID = ? | ParamCol=ArtistID | theQuery=1
  • ◀ Hide Side Panel