This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
15835 | 15835 | cc5ed | 2788 2788 |
15836 | 15836 | cba3e | 2788 2788 |
15837 | 15837 | 1c31d | 2788 2788 |
15838 | 15838 | e6200 | 2788 2788 |
15839 | 15839 | b1201 | 2788 2788 |
15840 | 15840 | 902e5 | 2788 2788 |
15841 | 15841 | 7e7c6 | 2788 2788 |
15842 | 15842 | 4f54f | 2788 2788 |
15843 | 15843 | 20a66 | 2788 2788 |
15844 | 15844 | 99241 | 2788 2788 |
15845 | 15845 | 02a85 | 2788 2788 |
15846 | 15846 | be0e2 | 2788 2788 |
15847 | 15847 | 12cf3 | 2788 2788 |
15848 | 15848 | 397c1 | 2788 2788 |
15849 | 15849 | 55a79 | 2788 2788 |
15850 | 15850 | ccbed | 2788 2788 |
15851 | 15851 | 2e370 | 2788 2788 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )