Advertisement
joxeankoret

Untitled

Sep 10th, 2018
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.64 KB | None | 0 0
  1. SELECT * FROM functions WHERE name LIKE '%KERNEL32%'
  2. ;
  3.  
  4. attach "mpengine.sqlite" AS diff;
  5.  
  6. SELECT COUNT(*) FROM diff.functions; -- 33614
  7.  
  8. SELECT COUNT(*) FROM functions; -- 34146
  9.  
  10. SELECT f.address ea, f.name name1
  11.  FROM functions f,
  12.       diff.functions df,
  13.       (SELECT md_index
  14.      FROM diff.functions
  15.     WHERE md_index != 0
  16.     GROUP BY md_index
  17.        HAVING COUNT(*) <= 2
  18.     UNION
  19.        SELECT md_index
  20.      FROM main.functions
  21.     WHERE md_index != 0
  22.     GROUP BY md_index
  23.        HAVING COUNT(*) <= 2
  24.       ) shared_mds
  25. WHERE f.md_index = df.md_index
  26.   AND df.md_index = shared_mds.md_index
  27.   AND f.nodes > 10
  28.   AND f.name LIKE 'KERNEL%'
  29. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement