This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18338 | 18338 | 81cf6 | 2619 2619 |
| 18424 | 18424 | 81cf6 | 2586 2586 |
| 18756 | 18756 | 81cf6 | 2611 2611 |
| 18942 | 18942 | 81cf6 | 2576 2576 |
| 19172 | 19172 | 81cf6 | 2650 2650 |
| 19645 | 19645 | 81cf6 | 2651 2651 |
| 19780 | 19780 | 81cf6 | 2657 2657 |
| 19818 | 19818 | 81cf6 | 2659 2659 |
| 19836 | 19836 | 81cf6 | 2555 2555 |
| 19868 | 19868 | 81cf6 | 2670 2670 |
| 19892 | 19892 | 81cf6 | 2557 2557 |
| 20216 | 20216 | 81cf6 | 2558 2558 |
| 20281 | 20281 | 81cf6 | 2554 2554 |
| 20605 | 20605 | 81cf6 | 2665 2665 |
| 20623 | 20623 | 81cf6 | 2578 2578 |
| 20671 | 20671 | 81cf6 | 2663 2663 |
| 20733 | 20733 | 81cf6 | 2597 2597 |
| 21288 | 21288 | 81cf6 | 2612 2612 |
| 21543 | 21543 | 81cf6 | 2643 2643 |
| 21642 | 21642 | 81cf6 | 2631 2631 |
| 21720 | 21720 | 81cf6 | 2642 2642 |
| 21784 | 21784 | 81cf6 | 2678 2678 |
| 21948 | 21948 | 81cf6 | 2590 2590 |
| 22475 | 22475 | 81cf6 | 2559 2559 |
| 23100 | 23100 | 81cf6 | 2676 2676 |
| 24287 | 24287 | 81cf6 | 2675 2675 |
| 24635 | 24635 | 81cf6 | 2677 2677 |
| 25073 | 25073 | 81cf6 | 2630 2630 |
| 25629 | 25629 | 81cf6 | 2621 2621 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)