Skip to content

Instantly share code, notes, and snippets.

@bcmiller

bcmiller/bad-prod-events.txt

Created September 9, 2011 15:34
Show Gist options
  • Save bcmiller/1206531 to your computer and use it in GitHub Desktop.
Save bcmiller/1206531 to your computer and use it in GitHub Desktop.
Download ZIP
prod-bad-events
Raw
bad-prod-events.txt
mysql> select n.nid,title,delta,field_date_value, from_unixtime(n.created) FROM content_type_vevent ctv LEFT JOIN content_field_date cfd ON ctv.nid = cfd.nid JOIN node n ON ctv.nid = n.nid WHERE field_date_value IS NULL AND n.nid IS NOT NULL;
+--------+----------------------------+-------+------------------+--------------------------+
| nid | title | delta | field_date_value | from_unixtime(n.created) |
+--------+----------------------------+-------+------------------+--------------------------+
| 137758 | @ Waukesha West | 0 | NULL | 2010-09-21 15:08:45 |
| 137778 | 18 White Practice | 0 | NULL | 2010-09-21 15:43:00 |
| 145088 | Tryout | 0 | NULL | 2010-10-07 16:29:42 |
| 145098 | Tryout | 0 | NULL | 2010-10-07 16:32:40 |
| 145328 | PTO Meeting | 0 | NULL | 2010-10-10 20:11:27 |
| 145338 | PTO Meeting | 0 | NULL | 2010-10-10 20:12:10 |
| 145348 | PTO Meeting | 0 | NULL | 2010-10-10 20:13:33 |
| 145358 | PTO Meeting | 0 | NULL | 2010-10-10 20:15:18 |
| 145398 | Test Event | 0 | NULL | 2010-10-11 08:24:18 |
| 145468 | Test event | 0 | NULL | 2010-10-11 09:37:28 |
| 145488 | Test Even | 0 | NULL | 2010-10-11 10:32:04 |
| 145498 | Test Event | 0 | NULL | 2010-10-11 10:33:52 |
| 145508 | Test Party | 0 | NULL | 2010-10-11 10:37:52 |
| 145678 | Game | 0 | NULL | 2010-10-11 12:27:44 |
| 148478 | Practice - LOCATION CHANGE | 0 | NULL | 2010-10-13 08:02:40 |
| 148488 | Practice - LOCATION CHANGE | 0 | NULL | 2010-10-13 08:04:31 |
+--------+----------------------------+-------+------------------+--------------------------+
16 rows in set (0.16 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment