gistfile1.sql

SELECT 
  T.DateOpenedUTC
  ,C.DataContent
  ,T.subject

FROM st_Tickets T
LEFT JOIN st_CustomDataFieldsInTickets C
  ON (T.TicketID = C.TicketID)
LEFT JOIN (
  SELECT <fourth column here>, Tin.TicketID
  FROM st_Tickets Tin
)
  ON (T.TicketID = Tin.TicketID)
WHERE C.CustomFieldID='4' AND WHERE C.CustomFieldID='7' AND C.DataContent !='<Select a Product>'