home / russian-ads

russian-ads

Custom SQL query returning 119 rows

select
    target_id,
    targets.name,
    count(*) as n,
    json_object(
        "href", "/russian-ads/faceted-targets?targets=" || urllib_quote_plus(
            json_insert(:targets, '$[' || json_array_length(:targets) || ']', target_id)
        ),
        "label", json_insert(:targets, '$[' || json_array_length(:targets) || ']', target_id)
    ) as apply_this_facet,
    json_object(
        "href", "/russian-ads/display_ads?_targets_json=" || urllib_quote_plus(
            json_insert(:targets, '$[' || json_array_length(:targets) || ']', target_id)
        ),
        "label", "See " || count(*) || " ads matching " || json_insert(:targets, '$[' || json_array_length(:targets) || ']', target_id)
    ) as browse_these_ads
from ad_targets
join targets on ad_targets.target_id = targets.id
where
    json_array_length(:targets) == 0 or
    ad_id in (
        select ad_id
        from "ad_targets"
        where "ad_targets".target_id in (select value from json_each(:targets))
        group by "ad_targets".ad_id
        having count(distinct "ad_targets".target_id) = json_array_length(:targets)
    )
    and target_id not in (select value from json_each(:targets))
group by
    target_id order by n desc

Query parameters

target_idnamenapply_this_facetbrowse_these_ads
b1201 placements:News Feed on mobile devices 171 ['a2d21', 'b1201'] See 171 ads matching ["a2d21","b1201"]
e6200 placements:News Feed on desktop computers 169 ['a2d21', 'e6200'] See 169 ads matching ["a2d21","e6200"]
a1307 people_who_match:interests:African-American Civil Rights Movement (1954—68) 164 ['a2d21', 'a1307'] See 164 ads matching ["a2d21","a1307"]
abb72 people_who_match:interests:African-American history 144 ['a2d21', 'abb72'] See 144 ads matching ["a2d21","abb72"]
27369 people_who_match:interests:Malcolm X 111 ['a2d21', '27369'] See 111 ads matching ["a2d21","27369"]
862ed people_who_match:interests:Jr. 108 ['a2d21', '862ed'] See 108 ads matching ["a2d21","862ed"]
8a7ee people_who_match:interests:Martin Luther King 108 ['a2d21', '8a7ee'] See 108 ads matching ["a2d21","8a7ee"]
371f0 age:18 - 65+ 102 ['a2d21', '371f0'] See 102 ads matching ["a2d21","371f0"]
59d75 language:English (US) 84 ['a2d21', '59d75'] See 84 ads matching ["a2d21","59d75"]
5e075 language:English (UK) 80 ['a2d21', '5e075'] See 80 ads matching ["a2d21","5e075"]
cc5ed location_living_in:United States 79 ['a2d21', 'cc5ed'] See 79 ads matching ["a2d21","cc5ed"]
e128e people_who_match:interests:Black (Color) 75 ['a2d21', 'e128e'] See 75 ads matching ["a2d21","e128e"]
ec3ac location:United States 68 ['a2d21', 'ec3ac'] See 68 ads matching ["a2d21","ec3ac"]
ebf60 people_who_match:interests:Pan-Africanism 60 ['a2d21', 'ebf60'] See 60 ads matching ["a2d21","ebf60"]
41b26 people_who_match:interests:Black Consciousness Movement 58 ['a2d21', '41b26'] See 58 ads matching ["a2d21","41b26"]
6a38c people_who_match:interests:Stop Police Brutality 57 ['a2d21', '6a38c'] See 57 ads matching ["a2d21","6a38c"]
d6347 people_who_match:interests:Black nationalism 57 ['a2d21', 'd6347'] See 57 ads matching ["a2d21","d6347"]
9a8c6 people_who_match:interests:Police misconduct 56 ['a2d21', '9a8c6'] See 56 ads matching ["a2d21","9a8c6"]
2db78 people_who_match:interests:Martin Luther King III 54 ['a2d21', '2db78'] See 54 ads matching ["a2d21","2db78"]
4801f age:16 - 65+ 45 ['a2d21', '4801f'] See 45 ads matching ["a2d21","4801f"]
4225c people_who_match:interests:African—American history 23 ['a2d21', '4225c'] See 23 ads matching ["a2d21","4225c"]
2aa57 and_must_also_match:interests:Self Defense Family 17 ['a2d21', '2aa57'] See 17 ads matching ["a2d21","2aa57"]
425d7 and_must_also_match:interests:Active Self Protection 17 ['a2d21', '425d7'] See 17 ads matching ["a2d21","425d7"]
724f8 and_must_also_match:interests:The Women's Self Defense Institute 17 ['a2d21', '724f8'] See 17 ads matching ["a2d21","724f8"]
809af people_who_match:interests:Black History Month 17 ['a2d21', '809af'] See 17 ads matching ["a2d21","809af"]
8b0bf and_must_also_match:interests:Personal Defense 17 ['a2d21', '8b0bf'] See 17 ads matching ["a2d21","8b0bf"]
b6f60 and_must_also_match:interests:PERSONAL & HOME DEFENSE 17 ['a2d21', 'b6f60'] See 17 ads matching ["a2d21","b6f60"]
01e8a and_must_also_match:interests:Right of self—defense 16 ['a2d21', '01e8a'] See 16 ads matching ["a2d21","01e8a"]
18a64 people_who_match:interests:Black Power 16 ['a2d21', '18a64'] See 16 ads matching ["a2d21","18a64"]
66f82 people_who_match:interests:African American 16 ['a2d21', '66f82'] See 16 ads matching ["a2d21","66f82"]
7c580 and_must_also_match:interests:Martial arts 16 ['a2d21', '7c580'] See 16 ads matching ["a2d21","7c580"]
9c206 and_must_also_match:interests:Mixed martial arts 16 ['a2d21', '9c206'] See 16 ads matching ["a2d21","9c206"]
37724 people_who_match:interests:Self Defense Family 15 ['a2d21', '37724'] See 15 ads matching ["a2d21","37724"]
7c38f people_who_match:interests:Black Panther Party 15 ['a2d21', '7c38f'] See 15 ads matching ["a2d21","7c38f"]
80def people_who_match:interests:The Self Defense Company 15 ['a2d21', '80def'] See 15 ads matching ["a2d21","80def"]
93975 people_who_match:interests:Angela Davis 15 ['a2d21', '93975'] See 15 ads matching ["a2d21","93975"]
d5ec6 people_who_match:interests:Martial arts 15 ['a2d21', 'd5ec6'] See 15 ads matching ["a2d21","d5ec6"]
ebcbb location_living_in:united_states:New York (+25 mi) New York 15 ['a2d21', 'ebcbb'] See 15 ads matching ["a2d21","ebcbb"]
f788a people_who_match:interests:Black history 15 ['a2d21', 'f788a'] See 15 ads matching ["a2d21","f788a"]
13ab6 people_who_match:interests:Pan—Africanism 14 ['a2d21', '13ab6'] See 14 ads matching ["a2d21","13ab6"]
902e5 placements:Right column on desktop computers 13 ['a2d21', '902e5'] See 13 ads matching ["a2d21","902e5"]
06d39 and_must_also_match:interests:SeIf-defense 12 ['a2d21', '06d39'] See 12 ads matching ["a2d21","06d39"]
7b150 age:18 — 65+ 11 ['a2d21', '7b150'] See 11 ads matching ["a2d21","7b150"]
c3b9b age:16 — 65+ 11 ['a2d21', 'c3b9b'] See 11 ads matching ["a2d21","c3b9b"]
2ab82 and_must_also_match:interests:Self- defense (United States) 10 ['a2d21', '2ab82'] See 10 ads matching ["a2d21","2ab82"]
13c3e excluded_connections:Exclude people who like Black guns matter 6 ['a2d21', '13c3e'] See 6 ads matching ["a2d21","13c3e"]
77d7e people_who_match:interests:Gun Owners of America 6 ['a2d21', '77d7e'] See 6 ads matching ["a2d21","77d7e"]
39ce1 and_must_also_match:interests:Self— defense (United States) 5 ['a2d21', '39ce1'] See 5 ads matching ["a2d21","39ce1"]
5b456 people_who_match:interests:National Rifle Association 5 ['a2d21', '5b456'] See 5 ads matching ["a2d21","5b456"]
6d811 and_must_also_match:interests:SeIf—defense 5 ['a2d21', '6d811'] See 5 ads matching ["a2d21","6d811"]
1d2ab people_who_match:interests:African—American Civil Rights Movement (1954—68) 4 ['a2d21', '1d2ab'] See 4 ads matching ["a2d21","1d2ab"]
6ec75 people_who_match:interests:2nd Amendment 4 ['a2d21', '6ec75'] See 4 ads matching ["a2d21","6ec75"]
189ac location_living_in:united_states:Charlotte (+25 mi) North Carolina 3 ['a2d21', '189ac'] See 3 ads matching ["a2d21","189ac"]
1e076 and_must_also_match:interests:Kemetism 3 ['a2d21', '1e076'] See 3 ads matching ["a2d21","1e076"]
23f8e and_must_also_match:interests:Afrocentrism 3 ['a2d21', '23f8e'] See 3 ads matching ["a2d21","23f8e"]
3da9b excluded_connections:Exclude people who like Pan-African roots MOVE 3 ['a2d21', '3da9b'] See 3 ads matching ["a2d21","3da9b"]
06e38 and_must_also_match:interests:Black nationalism 2 ['a2d21', '06e38'] See 2 ads matching ["a2d21","06e38"]
2ce65 people_who_match:interests:Black is beautiful 2 ['a2d21', '2ce65'] See 2 ads matching ["a2d21","2ce65"]
4096e people_who_match:interests:Huey P. Newton 2 ['a2d21', '4096e'] See 2 ads matching ["a2d21","4096e"]
42bf9 people_who_match:interests:Refugees of the Syrian Civil War 2 ['a2d21', '42bf9'] See 2 ads matching ["a2d21","42bf9"]
4accc placements:on pages: News Feed on desktop computers 2 ['a2d21', '4accc'] See 2 ads matching ["a2d21","4accc"]
60170 placements:Suggested Video on desktop computers 2 ['a2d21', '60170'] See 2 ads matching ["a2d21","60170"]
7746b people_who_match:interests:Black Girls Rock! 2 ['a2d21', '7746b'] See 2 ads matching ["a2d21","7746b"]
7a9b5 placements:Suggested Video on mobile devices 2 ['a2d21', '7a9b5'] See 2 ads matching ["a2d21","7a9b5"]
8183a and_must_also_match:interests:Right of self-defense 2 ['a2d21', '8183a'] See 2 ads matching ["a2d21","8183a"]
82db1 excluded_connections:Exclude people who like Black Excellence 2 ['a2d21', '82db1'] See 2 ads matching ["a2d21","82db1"]
8d650 and_must_also_match:interests:Black Power 2 ['a2d21', '8d650'] See 2 ads matching ["a2d21","8d650"]
943de and_must_also_match:interests:Pan-Africanism 2 ['a2d21', '943de'] See 2 ads matching ["a2d21","943de"]
9c846 people_who_match:interests:African—Amerioan Civil Rights Movement (1954—68) 2 ['a2d21', '9c846'] See 2 ads matching ["a2d21","9c846"]
bbdfd people_who_match:interests:Kemetism 2 ['a2d21', 'bbdfd'] See 2 ads matching ["a2d21","bbdfd"]
c2b64 and_must_also_match:interests:SeIf-defense (United States) 2 ['a2d21', 'c2b64'] See 2 ads matching ["a2d21","c2b64"]
c4c8c people_who_match:interests:Syria-News 2 ['a2d21', 'c4c8c'] See 2 ads matching ["a2d21","c4c8c"]
c4d21 location_living_in:united_states:Orlando (+50 mi) Florida 2 ['a2d21', 'c4d21'] See 2 ads matching ["a2d21","c4d21"]
d1aa5 people_who_match:interests:My Black is Beautiful 2 ['a2d21', 'd1aa5'] See 2 ads matching ["a2d21","d1aa5"]
e1dcf and_must_also_match:interests:Black history 2 ['a2d21', 'e1dcf'] See 2 ads matching ["a2d21","e1dcf"]
ef21b interests:Mexico 2 ['a2d21', 'ef21b'] See 2 ads matching ["a2d21","ef21b"]
f6c6f people_who_match:interests:Syria Charity 2 ['a2d21', 'f6c6f'] See 2 ads matching ["a2d21","f6c6f"]
f9b79 people_who_match:interests:Legal education 2 ['a2d21', 'f9b79'] See 2 ads matching ["a2d21","f9b79"]
feaa7 people_who_match:interests:Guns & Ammo 2 ['a2d21', 'feaa7'] See 2 ads matching ["a2d21","feaa7"]
086cd people_who_match:interests:Martin Luther King I” 1 ['a2d21', '086cd'] See 1 ads matching ["a2d21","086cd"]
0de51 location:georgia,_united_states:Mississippi 1 ['a2d21', '0de51'] See 1 ads matching ["a2d21","0de51"]
0deb1 people_who_match:interests:Police brutality in the United States 1 ['a2d21', '0deb1'] See 1 ads matching ["a2d21","0deb1"]
15228 and_must_also_match:interests:Pan-African colours 1 ['a2d21', '15228'] See 1 ads matching ["a2d21","15228"]
1dfee location:georgia,_united_states:Texas 1 ['a2d21', '1dfee'] See 1 ads matching ["a2d21","1dfee"]
23e78 and_must_also_match:interests:Kwame Nkrumah 1 ['a2d21', '23e78'] See 1 ads matching ["a2d21","23e78"]
2f9c3 location:georgia,_united_states:Arizona 1 ['a2d21', '2f9c3'] See 1 ads matching ["a2d21","2f9c3"]
3c576 people_who_match:interests:Martin Luther King lll 1 ['a2d21', '3c576'] See 1 ads matching ["a2d21","3c576"]
3f884 and_must_also_match:interests:South Africa 1 ['a2d21', '3f884'] See 1 ads matching ["a2d21","3f884"]
4698a age:16 - 40 1 ['a2d21', '4698a'] See 1 ads matching ["a2d21","4698a"]
49bb7 and_must_also_match:interests:Hotep 1 ['a2d21', '49bb7'] See 1 ads matching ["a2d21","49bb7"]
4e97e location_living_in:united_states:Atlanta (+25 mi) Georgia 1 ['a2d21', '4e97e'] See 1 ads matching ["a2d21","4e97e"]
54d8d and_must_also_match:interests:Nelson Mandela 1 ['a2d21', '54d8d'] See 1 ads matching ["a2d21","54d8d"]
564d4 and_must_also_match:interests:Personal Defense Network 1 ['a2d21', '564d4'] See 1 ads matching ["a2d21","564d4"]
57c73 location:georgia,_united_states:New York 1 ['a2d21', '57c73'] See 1 ads matching ["a2d21","57c73"]
64dc9 and_must_also_match:interests:Marcus Garvey 1 ['a2d21', '64dc9'] See 1 ads matching ["a2d21","64dc9"]
6b1c5 location_living_in:united_states:Astoria (+50 mi) New York 1 ['a2d21', '6b1c5'] See 1 ads matching ["a2d21","6b1c5"]
6f328 people_who_match:interests:Afrocentrism 1 ['a2d21', '6f328'] See 1 ads matching ["a2d21","6f328"]
75d32 people_who_match:interests:Baltimore 1 ['a2d21', '75d32'] See 1 ads matching ["a2d21","75d32"]
75d80 location:georgia,_united_states:Washington 1 ['a2d21', '75d80'] See 1 ads matching ["a2d21","75d80"]
762c9 and_must_also_match:interests:The Self Defense Company 1 ['a2d21', '762c9'] See 1 ads matching ["a2d21","762c9"]
7cf42 people_who_match:interests:Visual perception 1 ['a2d21', '7cf42'] See 1 ads matching ["a2d21","7cf42"]
88b45 people_who_match:interests:Color 1 ['a2d21', '88b45'] See 1 ads matching ["a2d21","88b45"]
8a38a location:georgia,_united_states:Alabama 1 ['a2d21', '8a38a'] See 1 ads matching ["a2d21","8a38a"]
99464 and_must_also_match:interests:Safety 1 ['a2d21', '99464'] See 1 ads matching ["a2d21","99464"]
9ee6c people_who_match:interests:Freckle 1 ['a2d21', '9ee6c'] See 1 ads matching ["a2d21","9ee6c"]
a59ba location:georgia,_united_states:California 1 ['a2d21', 'a59ba'] See 1 ads matching ["a2d21","a59ba"]
a5de3 excluded_connections:Exclude people who like Black Edification 1 ['a2d21', 'a5de3'] See 1 ads matching ["a2d21","a5de3"]
add29 location:georgia,_united_states:Florida 1 ['a2d21', 'add29'] See 1 ads matching ["a2d21","add29"]
b01c4 and_must_also_match:interests:Self—defense 1 ['a2d21', 'b01c4'] See 1 ads matching ["a2d21","b01c4"]
b3b48 people_who_match:interests:Firearm 1 ['a2d21', 'b3b48'] See 1 ads matching ["a2d21","b3b48"]
b5c9f and_must_also_match:interests:Nigeria 1 ['a2d21', 'b5c9f'] See 1 ads matching ["a2d21","b5c9f"]
b8c83 location_living_in:Russia 1 ['a2d21', 'b8c83'] See 1 ads matching ["a2d21","b8c83"]
b9e70 location:georgia,_united_states:Oklahoma 1 ['a2d21', 'b9e70'] See 1 ads matching ["a2d21","b9e70"]
c46d7 people_who_match:interests:Second Amendment to the United States Constitution 1 ['a2d21', 'c46d7'] See 1 ads matching ["a2d21","c46d7"]
cd49b excluded_connections:Exclude people who like Pan—African roots MOVE 1 ['a2d21', 'cd49b'] See 1 ads matching ["a2d21","cd49b"]
d27ad and_must_also_match:interests:martial arts and self defense 1 ['a2d21', 'd27ad'] See 1 ads matching ["a2d21","d27ad"]
e5437 people_who_match:interests:Concealed carry in the United States 1 ['a2d21', 'e5437'] See 1 ads matching ["a2d21","e5437"]
e80a9 age:14 - 4O 1 ['a2d21', 'e80a9'] See 1 ads matching ["a2d21","e80a9"]
f5af1 location:georgia,_united_states:New Mexico 1 ['a2d21', 'f5af1'] See 1 ads matching ["a2d21","f5af1"]
Powered by Datasette · Query took 77.911ms