Digital Query v.2

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

SELECT p.Title, p.Body, p.OwnerUserId, p.OwnerDisplayName,
p.LastEditorUserID, p.LastEditorDisplayName, p.Id, p.Score,
p.ViewCount,
p.ContentLicense, p.ParentId, p.PostTypeID, 
p.AcceptedAnswerID, p.AnswerCount,
p.CommentCount, p.FavoriteCount, p.Tags
  FROM Posts p
    WHERE p.PostTypeID = 1 AND -- TypeID of 1 is Question; TypeID of 2 is Answer
          (p.Tags like '%uvm%'
          OR p.Tags like '%<system-verilog>%'
          OR p.Tags like '%<vhdl>%'
          OR p.Tags like '%<questasim>%'
          OR p.Tags like '%<hdl>%'
          OR p.Tags like '%<system-verilog-assertions>%'
          OR p.Tags like '%<digital-logic>%'
          OR p.Tags like '%<systemc>%'
          OR p.Tags like '%<modelsim>%')

--u.DisplayName AS "Author",
--u.Id AS "Author-UID",
    --JOIN Users u ON p.OwnerUserId = u.Id

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results