Data Connection intersect query

I am trying to build in a SQL query for a data quad to intersect a particular column in an assessor parcels layer. The column in the attribute table contains http links to web pdfs and i am hopping i can create a data connection interesect, where when a user selects one of my data quads, it can and will return a value based of the intersected http link field. Here is my sql quad that i have built in the data connection tab of my data quad layer in geocortex:

 

SELECT s.PDF_WEB_PATH (this is the field in the assessor parcel layer that has http links to web pdf's)

 

FROM   [SCD_GDBA].[AGOL__ASSESSOR_QUADS] s,

 

                                [SCD_GDBA].[AGOL__MAPPAPP_QUADS]  p

 

WHERE                 p.Shape.STIntersects(s.Shape) = 1

 

Can anyone see where or why i am not getting this data connection to work properly? Is it my SQL query? Is it the DB connections? Any help is appreciated.