SHOW:
|
|
- or go back to the newest paste.
| 1 | select | |
| 2 | source_persona_id, | |
| 3 | relation_type, | |
| 4 | message_id, | |
| 5 | reply_to_message_id, | |
| 6 | reshare_of_message_id, | |
| 7 | target_object_id, | |
| 8 | target_persona_id, | |
| 9 | created_at, | |
| 10 | updated_at, | |
| 11 | sent_at | |
| 12 | from | |
| 13 | - | s_relations into outfile '/tmp/s_relations.csv' FIELDS TERMINATED BY ','; |
| 13 | + | s_relations where (target_object_id is NULL or target_object_id not in (XXX)) and id <XXX into outfile '/tmp/s_relations_new.csv' FIELDS TERMINATED BY ','; |