Created
June 8, 2015 21:39
-
-
Save caseydentinger/42939c3b6a1b85fa5444 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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