0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for artists and crafters

SELECT Id, Body, Title, Tags, isPandas, ViewCount
FROM (
  SELECT TOP 10000 Id, Body, Title, Tags, ViewCount, 0 AS isPandas
  FROM
    Posts p
  WHERE
     p.tags LIKE '%python-3.x%'
     AND p.tags NOT LIKE '%pandas%'
     AND p.CreationDate >= '2015-01-01'
     AND p.CreationDate < '2020-01-01'
  ORDER BY
    ViewCount DESC
 ) AS withPandas
UNION
SELECT TOP 2000 Id, Body, Title, Tags, ViewCount, 1 AS isPandas
FROM
  Posts p
WHERE
   p.tags LIKE '%python-3.x%'
   AND p.tags LIKE '%pandas%'
   AND p.CreationDate >= '2015-01-01'
   AND p.CreationDate < '2020-01-01'
ORDER BY
  ViewCount DESC

fork query

edited nov 28

created oct 30 jon.doe34735