ad_targets

67 rows where target_id = "cb80d"

descending

Link	rowid	target_id	ad_id
5338	5338	cb80d	2955 2955
7660	7660	cb80d	2965 2965
16375	16375	cb80d	2942 2942
16615	16615	cb80d	2970 2970
16758	16758	cb80d	2945 2945
17070	17070	cb80d	2961 2961
17201	17201	cb80d	2962 2962
17271	17271	cb80d	2960 2960
17715	17715	cb80d	2958 2958
18238	18238	cb80d	2963 2963
18293	18293	cb80d	2959 2959
21231	21231	cb80d	2939 2939
21336	21336	cb80d	2898 2898
21365	21365	cb80d	2951 2951
21413	21413	cb80d	2906 2906
21508	21508	cb80d	2903 2903
21626	21626	cb80d	2938 2938
21665	21665	cb80d	2952 2952
21683	21683	cb80d	2900 2900
21761	21761	cb80d	2905 2905
21907	21907	cb80d	2950 2950
22230	22230	cb80d	2954 2954
22262	22262	cb80d	2902 2902
22324	22324	cb80d	2940 2940
22996	22996	cb80d	2953 2953
23026	23026	cb80d	2901 2901
23257	23257	cb80d	2941 2941
23336	23336	cb80d	2920 2920
23381	23381	cb80d	2926 2926
23420	23420	cb80d	2922 2922
23466	23466	cb80d	2928 2928
23550	23550	cb80d	2934 2934
23609	23609	cb80d	2911 2911
23662	23662	cb80d	2917 2917
23695	23695	cb80d	2915 2915
23892	23892	cb80d	2897 2897
24006	24006	cb80d	2912 2912
24055	24055	cb80d	2916 2916
24144	24144	cb80d	2909 2909
24177	24177	cb80d	2899 2899
24330	24330	cb80d	2925 2925
24383	24383	cb80d	2927 2927
24432	24432	cb80d	2921 2921
24545	24545	cb80d	2933 2933
24649	24649	cb80d	2929 2929
24833	24833	cb80d	2910 2910
24903	24903	cb80d	2907 2907
24965	24965	cb80d	2914 2914
24992	24992	cb80d	2937 2937
25051	25051	cb80d	2931 2931
25141	25141	cb80d	2935 2935
25189	25189	cb80d	2919 2919
25232	25232	cb80d	2923 2923
25292	25292	cb80d	2936 2936
25329	25329	cb80d	2932 2932
25398	25398	cb80d	2930 2930
25509	25509	cb80d	2924 2924
25576	25576	cb80d	2918 2918
25663	25663	cb80d	2904 2904
25797	25797	cb80d	2908 2908
26044	26044	cb80d	2943 2943
26089	26089	cb80d	2957 2957
26210	26210	cb80d	2944 2944
29574	29574	cb80d	2966 2966
29677	29677	cb80d	2967 2967
36201	36201	cb80d	2969 2969
36351	36351	cb80d	2968 2968

Advanced export

JSON shape: default, array, newline-delimited

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