Skip to content

Instantly share code, notes, and snippets.

@caseydentinger
Created June 8, 2015 21:39
Show Gist options
  • Save caseydentinger/42939c3b6a1b85fa5444 to your computer and use it in GitHub Desktop.
Save caseydentinger/42939c3b6a1b85fa5444 to your computer and use it in GitHub Desktop.
MariaDB [drupal]> select count(ct.id) from contribution_tracking ct left join contribution_source cs on ct.id = cs.contribution_tracking_id where ct.id > 20000000 and cs.contribution_tracking_id is null;
+--------------+
| count(ct.id) |
+--------------+
| 46960 |
+--------------+
1 row in set (8.95 sec)
MariaDB [drupal]> select count(ct.id) from contribution_tracking ct join contribution_source cs on ct.id = cs.contribution_tracking_id where ct.id > 20000000;
+--------------+
| count(ct.id) |
+--------------+
| 6592941 |
+--------------+
1 row in set (12.81 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment