ad_targets

59 rows where target_id = "3da9b"

descending

Link	rowid	target_id	ad_id
133	133	3da9b	2827 2827
287	287	3da9b	2875 2875
405	405	3da9b	2868 2868
646	646	3da9b	2870 2870
1147	1147	3da9b	2869 2869
1849	1849	3da9b	2882 2882
2022	2022	3da9b	2883 2883
5021	5021	3da9b	2844 2844
5231	5231	3da9b	2867 2867
5420	5420	3da9b	2866 2866
5537	5537	3da9b	2846 2846
5693	5693	3da9b	2847 2847
5946	5946	3da9b	2826 2826
6443	6443	3da9b	2845 2845
15610	15610	3da9b	2829 2829
15899	15899	3da9b	2865 2865
16775	16775	3da9b	2872 2872
17741	17741	3da9b	2871 2871
17876	17876	3da9b	2862 2862
18319	18319	3da9b	2836 2836
18472	18472	3da9b	2820 2820
18615	18615	3da9b	2848 2848
18890	18890	3da9b	2824 2824
18983	18983	3da9b	2839 2839
19372	19372	3da9b	2834 2834
19473	19473	3da9b	2837 2837
19524	19524	3da9b	2825 2825
19576	19576	3da9b	2843 2843
19609	19609	3da9b	2841 2841
20652	20652	3da9b	2823 2823
21082	21082	3da9b	2830 2830
21797	21797	3da9b	2850 2850
21997	21997	3da9b	2833 2833
22507	22507	3da9b	2840 2840
22558	22558	3da9b	2852 2852
22610	22610	3da9b	2831 2831
22782	22782	3da9b	2832 2832
22796	22796	3da9b	2838 2838
22863	22863	3da9b	2853 2853
22924	22924	3da9b	2849 2849
24530	24530	3da9b	2854 2854
25036	25036	3da9b	2822 2822
25313	25313	3da9b	2851 2851
25908	25908	3da9b	2835 2835
26108	26108	3da9b	2856 2856
26153	26153	3da9b	2874 2874
26257	26257	3da9b	2864 2864
26510	26510	3da9b	2857 2857
26921	26921	3da9b	2860 2860
27111	27111	3da9b	2863 2863
27158	27158	3da9b	2858 2858
27825	27825	3da9b	2878 2878
28981	28981	3da9b	2879 2879
29413	29413	3da9b	2873 2873
29449	29449	3da9b	2859 2859
29905	29905	3da9b	2876 2876
30149	30149	3da9b	2880 2880
30174	30174	3da9b	2861 2861
30216	30216	3da9b	2881 2881

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE ad_targets (
               target_id TEXT   REFERENCES [targets]([id]),
   ad_id INTEGER   REFERENCES [ads]([id])
        )