คำถามเกี่ยวกับบันทึก (ภาพยนตร์และทีวี) ไม่จำเป็นต้องใช้ตารางทั้งหมด
Questions about Records (Movies & TV).It is not neccessary to use all the tables.
 Posts:  Id [ number]  PostTypeId [ number]  AcceptedAnswerId [ number]  ParentId [ number]  CreationDate [ time]  DeletionDate [ time]  Score [ number]  ViewCount [ number]  Body [ text]  OwnerUserId [ number]  OwnerDisplayName [ text]  LastEditorUserId [ number]  LastEditorDisplayName [ text]  LastEditDate [ time]  LastActivityDate [ time]  Title [ text]  Tags [ text]  AnswerCount [ number]  CommentCount [ number]  FavoriteCount [ number]  ClosedDate [ time]  CommunityOwnedDate [ time]  ContentLicense [ text] 
SELECT DISTINCT Id AS "post_link", Tags FROM Posts WHERE PostTypeId = 1 AND (Title LIKE 'What is the%' OR Title LIKE 'What was the%' OR Title LIKE 'Which%' OR Title LIKE 'Who was%' OR Title LIKE 'When did the%') AND (Title LIKE '%most%' OR Title LIKE '%longest%' OR Title LIKE '%first%' OR Title LIKE '%biggest%' OR Title LIKE '%latest%' OR Title LIKE '%earliest%') AND NOT (Tags LIKE '%-appearance%' OR Tags LIKE '%cinema-history%' OR Tags LIKE '%identify-this-%' OR Tags LIKE '%analysis%' OR Tags LIKE '%breaking-bad%' OR Tags LIKE '%the-other-woman%' OR Tags LIKE '%friends%' OR Tags LIKE '%sleepy-hollow%' OR Tags LIKE '%soundtrack%')