Advertisement
dvjsharma

count query

Mar 28th, 2024
1,052
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.18 KB | Source Code | 0 0
  1. SELECT COUNT(*)
  2. FROM (
  3.     SELECT mcontent
  4.     FROM (
  5.         SELECT
  6.             (CASE WHEN (ce.content IS NULL OR ce.content = '') THEN cp.content ELSE ce.content END) AS mcontent
  7.         FROM copyright AS cp
  8.         INNER JOIN uploadtree_a AS UT ON cp.pfile_fk = UT.pfile_fk
  9.         LEFT JOIN copyright_event AS ce ON ce.copyright_fk = cp.copyright_pk
  10.                                         AND ce.upload_fk = $5
  11.                                         AND ce.uploadtree_fk = UT.uploadtree_pk
  12.         WHERE cp.content != ''
  13.             AND (UT.lft BETWEEN $1 AND $2)
  14.             AND cp.type = $3
  15.             AND cp.agent_fk = ANY($4::int[])
  16.             AND (ce.is_enabled IS NULL OR ce.is_enabled = 'true')
  17.             AND UT.upload_fk = $5  
  18.         GROUP BY mcontent
  19.  
  20.         UNION ALL
  21.  
  22.         SELECT DISTINCT textfinding AS mcontent
  23.         FROM copyright_decision AS cd
  24.         INNER JOIN pfile AS PF ON cd.pfile_fk = PF.pfile_pk
  25.         INNER JOIN uploadtree_a AS UT ON PF.pfile_pk = UT.pfile_fk
  26.         WHERE UT.lft BETWEEN $1 AND $2
  27.             AND (cd.is_enabled IS NULL OR cd.is_enabled = 'true')
  28.             AND UT.upload_fk = $5
  29.     ) AS combined
  30. ) AS K;
Tags: FOSSology
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement