home / russian-ads

russian-ads

Custom SQL query returning 133 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
18a64 people_who_match:interests:Black Power 134 ['7c38f', '18a64'] See 134 ads matching ["7c38f","18a64"]
b1201 placements:News Feed on mobile devices 121 ['7c38f', 'b1201'] See 121 ads matching ["7c38f","b1201"]
e6200 placements:News Feed on desktop computers 115 ['7c38f', 'e6200'] See 115 ads matching ["7c38f","e6200"]
59d75 language:English (US) 102 ['7c38f', '59d75'] See 102 ads matching ["7c38f","59d75"]
5e075 language:English (UK) 96 ['7c38f', '5e075'] See 96 ads matching ["7c38f","5e075"]
7ee91 people_who_match:interests:Cop Block 81 ['7c38f', '7ee91'] See 81 ads matching ["7c38f","7ee91"]
4801f age:16 - 65+ 80 ['7c38f', '4801f'] See 80 ads matching ["7c38f","4801f"]
31177 people_who_match:interests:Social justice 51 ['7c38f', '31177'] See 51 ads matching ["7c38f","31177"]
9295b people_who_match:interests:Racial equality 51 ['7c38f', '9295b'] See 51 ads matching ["7c38f","9295b"]
862ed people_who_match:interests:Jr. 44 ['7c38f', '862ed'] See 44 ads matching ["7c38f","862ed"]
8a7ee people_who_match:interests:Martin Luther King 44 ['7c38f', '8a7ee'] See 44 ads matching ["7c38f","8a7ee"]
27369 people_who_match:interests:Malcolm X 42 ['7c38f', '27369'] See 42 ads matching ["7c38f","27369"]
371f0 age:18 - 65+ 39 ['7c38f', '371f0'] See 39 ads matching ["7c38f","371f0"]
f788a people_who_match:interests:Black history 37 ['7c38f', 'f788a'] See 37 ads matching ["7c38f","f788a"]
809af people_who_match:interests:Black History Month 36 ['7c38f', '809af'] See 36 ads matching ["7c38f","809af"]
abb72 people_who_match:interests:African-American history 33 ['7c38f', 'abb72'] See 33 ads matching ["7c38f","abb72"]
ebcbb location_living_in:united_states:New York (+25 mi) New York 33 ['7c38f', 'ebcbb'] See 33 ads matching ["7c38f","ebcbb"]
a1307 people_who_match:interests:African-American Civil Rights Movement (1954—68) 32 ['7c38f', 'a1307'] See 32 ads matching ["7c38f","a1307"]
e128e people_who_match:interests:Black (Color) 32 ['7c38f', 'e128e'] See 32 ads matching ["7c38f","e128e"]
01e8a and_must_also_match:interests:Right of self—defense 31 ['7c38f', '01e8a'] See 31 ads matching ["7c38f","01e8a"]
2aa57 and_must_also_match:interests:Self Defense Family 31 ['7c38f', '2aa57'] See 31 ads matching ["7c38f","2aa57"]
425d7 and_must_also_match:interests:Active Self Protection 31 ['7c38f', '425d7'] See 31 ads matching ["7c38f","425d7"]
66f82 people_who_match:interests:African American 31 ['7c38f', '66f82'] See 31 ads matching ["7c38f","66f82"]
724f8 and_must_also_match:interests:The Women's Self Defense Institute 31 ['7c38f', '724f8'] See 31 ads matching ["7c38f","724f8"]
7c580 and_must_also_match:interests:Martial arts 31 ['7c38f', '7c580'] See 31 ads matching ["7c38f","7c580"]
8b0bf and_must_also_match:interests:Personal Defense 31 ['7c38f', '8b0bf'] See 31 ads matching ["7c38f","8b0bf"]
93975 people_who_match:interests:Angela Davis 31 ['7c38f', '93975'] See 31 ads matching ["7c38f","93975"]
9c206 and_must_also_match:interests:Mixed martial arts 31 ['7c38f', '9c206'] See 31 ads matching ["7c38f","9c206"]
b6f60 and_must_also_match:interests:PERSONAL & HOME DEFENSE 31 ['7c38f', 'b6f60'] See 31 ads matching ["7c38f","b6f60"]
cc5ed location_living_in:United States 31 ['7c38f', 'cc5ed'] See 31 ads matching ["7c38f","cc5ed"]
ebf60 people_who_match:interests:Pan-Africanism 27 ['7c38f', 'ebf60'] See 27 ads matching ["7c38f","ebf60"]
06d39 and_must_also_match:interests:SeIf-defense 25 ['7c38f', '06d39'] See 25 ads matching ["7c38f","06d39"]
2ab82 and_must_also_match:interests:Self- defense (United States) 24 ['7c38f', '2ab82'] See 24 ads matching ["7c38f","2ab82"]
37724 people_who_match:interests:Self Defense Family 19 ['7c38f', '37724'] See 19 ads matching ["7c38f","37724"]
80def people_who_match:interests:The Self Defense Company 19 ['7c38f', '80def'] See 19 ads matching ["7c38f","80def"]
d5ec6 people_who_match:interests:Martial arts 19 ['7c38f', 'd5ec6'] See 19 ads matching ["7c38f","d5ec6"]
48e80 location:united_states:Philadelphia, Pittsburgh Pennsylvania 17 ['7c38f', '48e80'] See 17 ads matching ["7c38f","48e80"]
c6b59 location_living_in:united_states:Minneapolis (+25 mi) Minnesota 17 ['7c38f', 'c6b59'] See 17 ads matching ["7c38f","c6b59"]
3502d placements:Instagram Feed 16 ['7c38f', '3502d'] See 16 ads matching ["7c38f","3502d"]
a2d21 people_who_match:interests:African-American culture 15 ['7c38f', 'a2d21'] See 15 ads matching ["7c38f","a2d21"]
7b150 age:18 — 65+ 11 ['7c38f', '7b150'] See 11 ads matching ["7c38f","7b150"]
902e5 placements:Right column on desktop computers 11 ['7c38f', '902e5'] See 11 ads matching ["7c38f","902e5"]
bd3d9 people_who_match:interests:Black panther 10 ['7c38f', 'bd3d9'] See 10 ads matching ["7c38f","bd3d9"]
2ce65 people_who_match:interests:Black is beautiful 8 ['7c38f', '2ce65'] See 8 ads matching ["7c38f","2ce65"]
d65e1 people_who_match:interests:Fight the Power 7 ['7c38f', 'd65e1'] See 7 ads matching ["7c38f","d65e1"]
df1f0 people_who_match:interests:African- American culture 7 ['7c38f', 'df1f0'] See 7 ads matching ["7c38f","df1f0"]
ec3ac location:United States 7 ['7c38f', 'ec3ac'] See 7 ads matching ["7c38f","ec3ac"]
13ab6 people_who_match:interests:Pan—Africanism 6 ['7c38f', '13ab6'] See 6 ads matching ["7c38f","13ab6"]
1518e people_who_match:interests:Behaviors: African American (US) 6 ['7c38f', '1518e'] See 6 ads matching ["7c38f","1518e"]
39ce1 and_must_also_match:interests:Self— defense (United States) 6 ['7c38f', '39ce1'] See 6 ads matching ["7c38f","39ce1"]
4accc placements:on pages: News Feed on desktop computers 6 ['7c38f', '4accc'] See 6 ads matching ["7c38f","4accc"]
6d811 and_must_also_match:interests:SeIf—defense 6 ['7c38f', '6d811'] See 6 ads matching ["7c38f","6d811"]
a340a placements:Instream Video on desktop computers 6 ['7c38f', 'a340a'] See 6 ads matching ["7c38f","a340a"]
d003e placements:Instream Video on mobile devices 6 ['7c38f', 'd003e'] See 6 ads matching ["7c38f","d003e"]
d1aa5 people_who_match:interests:My Black is Beautiful 6 ['7c38f', 'd1aa5'] See 6 ads matching ["7c38f","d1aa5"]
15db9 people_who_match:interests:Pan- Africanism 5 ['7c38f', '15db9'] See 5 ads matching ["7c38f","15db9"]
189ac location_living_in:united_states:Charlotte (+25 mi) North Carolina 5 ['7c38f', '189ac'] See 5 ads matching ["7c38f","189ac"]
38705 people_who_match:interests:Black (Color) or Cop Block 5 ['7c38f', '38705'] See 5 ads matching ["7c38f","38705"]
4225c people_who_match:interests:African—American history 5 ['7c38f', '4225c'] See 5 ads matching ["7c38f","4225c"]
ad8b2 people_who_match:interests:Human rights 5 ['7c38f', 'ad8b2'] See 5 ads matching ["7c38f","ad8b2"]
d2749 people_who_match:interests:African— American culture 5 ['7c38f', 'd2749'] See 5 ads matching ["7c38f","d2749"]
4f515 location_living_in:united_states:Long Beach (+25 mi) California 4 ['7c38f', '4f515'] See 4 ads matching ["7c38f","4f515"]
94bdc people_who_match:interests:Multicultural Affinity: African American (US) 4 ['7c38f', '94bdc'] See 4 ads matching ["7c38f","94bdc"]
04e82 people_who_match:interests:Malcolm X or Black (Color) 3 ['7c38f', '04e82'] See 3 ads matching ["7c38f","04e82"]
1d2ab people_who_match:interests:African—American Civil Rights Movement (1954—68) 3 ['7c38f', '1d2ab'] See 3 ads matching ["7c38f","1d2ab"]
302cc people_who_match:interests:Black Girls Rock! or HuffPost Black Voices 3 ['7c38f', '302cc'] See 3 ads matching ["7c38f","302cc"]
5ea35 people_who_match:interests:Black Arts Movement 3 ['7c38f', '5ea35'] See 3 ads matching ["7c38f","5ea35"]
940ef location:united_states:Houston (+50 mi) Texas 3 ['7c38f', '940ef'] See 3 ads matching ["7c38f","940ef"]
9c17e location_living_in:united_states:Lansing (+25 mi) Michigan 3 ['7c38f', '9c17e'] See 3 ads matching ["7c38f","9c17e"]
a5ab5 people_who_match:interests:African-Amerioan culture 3 ['7c38f', 'a5ab5'] See 3 ads matching ["7c38f","a5ab5"]
a8e8b location:united_states:Astoria (+25 mi) New York 3 ['7c38f', 'a8e8b'] See 3 ads matching ["7c38f","a8e8b"]
ddd45 people_who_match:interests:The African History Network 3 ['7c38f', 'ddd45'] See 3 ads matching ["7c38f","ddd45"]
07be8 location:united_states:Atlanta (+50 mi) Georgia 2 ['7c38f', '07be8'] See 2 ads matching ["7c38f","07be8"]
100e0 people_who_match:interests:Our World with Black Enterprise 2 ['7c38f', '100e0'] See 2 ads matching ["7c38f","100e0"]
14760 people_who_match:interests:Black Enterprise 2 ['7c38f', '14760'] See 2 ads matching ["7c38f","14760"]
1c5f0 people_who_match:interests:Broad-Based Black Economic Empowerment 2 ['7c38f', '1c5f0'] See 2 ads matching ["7c38f","1c5f0"]
35dce people_who_match:interests:Behaviors: Small business owners 2 ['7c38f', '35dce'] See 2 ads matching ["7c38f","35dce"]
3da9b excluded_connections:Exclude people who like Pan-African roots MOVE 2 ['7c38f', '3da9b'] See 2 ads matching ["7c38f","3da9b"]
3fef5 people_who_match:interests:Black Enterprise Business Report 2 ['7c38f', '3fef5'] See 2 ads matching ["7c38f","3fef5"]
57006 location:united_states:New York 2 ['7c38f', '57006'] See 2 ads matching ["7c38f","57006"]
64bc4 people_who_match:interests:Black Economic Empowerment 2 ['7c38f', '64bc4'] See 2 ads matching ["7c38f","64bc4"]
65f5f people_who_match:interests:Afrocentric education 2 ['7c38f', '65f5f'] See 2 ads matching ["7c38f","65f5f"]
6a05f people_who_match:interests:New Black Panther Party 2 ['7c38f', '6a05f'] See 2 ads matching ["7c38f","6a05f"]
6b1c5 location_living_in:united_states:Astoria (+50 mi) New York 2 ['7c38f', '6b1c5'] See 2 ads matching ["7c38f","6b1c5"]
6f328 people_who_match:interests:Afrocentrism 2 ['7c38f', '6f328'] See 2 ads matching ["7c38f","6f328"]
72a45 people_who_match:interests:Malcolm X (EI-Hajj Malik EI-Shabazz) 2 ['7c38f', '72a45'] See 2 ads matching ["7c38f","72a45"]
91693 people_who_match:interests:African—American culture 2 ['7c38f', '91693'] See 2 ads matching ["7c38f","91693"]
c4d21 location_living_in:united_states:Orlando (+50 mi) Florida 2 ['7c38f', 'c4d21'] See 2 ads matching ["7c38f","c4d21"]
d6347 people_who_match:interests:Black nationalism 2 ['7c38f', 'd6347'] See 2 ads matching ["7c38f","d6347"]
da17a people_who_match:interests:Melanin 2 ['7c38f', 'da17a'] See 2 ads matching ["7c38f","da17a"]
e42ca people_who_match:interests:Slavery by Another Name 2 ['7c38f', 'e42ca'] See 2 ads matching ["7c38f","e42ca"]
eb152 people_who_match:interests:Black Women Are Beautiful 2 ['7c38f', 'eb152'] See 2 ads matching ["7c38f","eb152"]
014b0 age:13 — 65+ 1 ['7c38f', '014b0'] See 1 ads matching ["7c38f","014b0"]
045ef location:united_states:Louisiana 1 ['7c38f', '045ef'] See 1 ads matching ["7c38f","045ef"]
1d380 age:18 - 43 1 ['7c38f', '1d380'] See 1 ads matching ["7c38f","1d380"]
203d9 age:13 - 6O 1 ['7c38f', '203d9'] See 1 ads matching ["7c38f","203d9"]
20711 excluded_connections:Exclude people who like Black4Black 1 ['7c38f', '20711'] See 1 ads matching ["7c38f","20711"]
23f6d people_who_match:interests:The Honorable Minister Louis Farrakhan or National Black Police Association (United Kingdom) 1 ['7c38f', '23f6d'] See 1 ads matching ["7c38f","23f6d"]
27335 excluded_connections:Exclude people who like Woke Blacks 1 ['7c38f', '27335'] See 1 ads matching ["7c38f","27335"]
2d05d location_living_in:united_states:Alabama; Florida; Georgia; Illinois; Louisiana; Mississippi; New York; South Carolina; Virginia 1 ['7c38f', '2d05d'] See 1 ads matching ["7c38f","2d05d"]
384b9 location:united_states:Georgia 1 ['7c38f', '384b9'] See 1 ads matching ["7c38f","384b9"]
3eb1f people_who_match:interests:Black Church 1 ['7c38f', '3eb1f'] See 1 ads matching ["7c38f","3eb1f"]
41b26 people_who_match:interests:Black Consciousness Movement 1 ['7c38f', '41b26'] See 1 ads matching ["7c38f","41b26"]
49b74 location:united_states:Florida 1 ['7c38f', '49b74'] See 1 ads matching ["7c38f","49b74"]
4e97e location_living_in:united_states:Atlanta (+25 mi) Georgia 1 ['7c38f', '4e97e'] See 1 ads matching ["7c38f","4e97e"]
564d4 and_must_also_match:interests:Personal Defense Network 1 ['7c38f', '564d4'] See 1 ads matching ["7c38f","564d4"]
61c1a age:18 - 50 1 ['7c38f', '61c1a'] See 1 ads matching ["7c38f","61c1a"]
65b27 location:united_states:Cleveland (+40 km) Ohio 1 ['7c38f', '65b27'] See 1 ads matching ["7c38f","65b27"]
711dd location:united_states:Chicago (+40 km) Illinois 1 ['7c38f', '711dd'] See 1 ads matching ["7c38f","711dd"]
762c9 and_must_also_match:interests:The Self Defense Company 1 ['7c38f', '762c9'] See 1 ads matching ["7c38f","762c9"]
7746b people_who_match:interests:Black Girls Rock! 1 ['7c38f', '7746b'] See 1 ads matching ["7c38f","7746b"]
7f1e9 age:16 - 60 1 ['7c38f', '7f1e9'] See 1 ads matching ["7c38f","7f1e9"]
89dda age:13 - 60 1 ['7c38f', '89dda'] See 1 ads matching ["7c38f","89dda"]
8eeb0 x_field_of_study:African-American history 1 ['7c38f', '8eeb0'] See 1 ads matching ["7c38f","8eeb0"]
99464 and_must_also_match:interests:Safety 1 ['7c38f', '99464'] See 1 ads matching ["7c38f","99464"]
ac76f location_living_in:united_states:New York 1 ['7c38f', 'ac76f'] See 1 ads matching ["7c38f","ac76f"]
ac7e2 location:united_states:Baltimore (+40 km) Maryland 1 ['7c38f', 'ac7e2'] See 1 ads matching ["7c38f","ac7e2"]
b8132 girls_rock_behaviors:Field of study: African- American history 1 ['7c38f', 'b8132'] See 1 ads matching ["7c38f","b8132"]
b8c83 location_living_in:Russia 1 ['7c38f', 'b8c83'] See 1 ads matching ["7c38f","b8c83"]
c2b64 and_must_also_match:interests:SeIf-defense (United States) 1 ['7c38f', 'c2b64'] See 1 ads matching ["7c38f","c2b64"]
c3801 people_who_match:interests:Black 1 ['7c38f', 'c3801'] See 1 ads matching ["7c38f","c3801"]
c69e6 people_who_match:interests:Field of study: African-American history 1 ['7c38f', 'c69e6'] See 1 ads matching ["7c38f","c69e6"]
ca0eb location:united_states:Baton Rouge (+40 km) Louisiana 1 ['7c38f', 'ca0eb'] See 1 ads matching ["7c38f","ca0eb"]
ced33 people_who_match:interests:Malcolm 1 ['7c38f', 'ced33'] See 1 ads matching ["7c38f","ced33"]
d27ad and_must_also_match:interests:martial arts and self defense 1 ['7c38f', 'd27ad'] See 1 ads matching ["7c38f","d27ad"]
d3b45 excluded_connections:Exclude people who like BIack4Black 1 ['7c38f', 'd3b45'] See 1 ads matching ["7c38f","d3b45"]
d75c0 people_who_match:interests:HuffPost Black Voices 1 ['7c38f', 'd75c0'] See 1 ads matching ["7c38f","d75c0"]
e0435 location:united_states:Minnesota 1 ['7c38f', 'e0435'] See 1 ads matching ["7c38f","e0435"]
ec8fd people_who_match:interests:Louis Farrakhan 1 ['7c38f', 'ec8fd'] See 1 ads matching ["7c38f","ec8fd"]
ecfcb girls_rock_behaviors:African American (US) 1 ['7c38f', 'ecfcb'] See 1 ads matching ["7c38f","ecfcb"]
f32e5 people_who_match:interests:Pan-Africahism 1 ['7c38f', 'f32e5'] See 1 ads matching ["7c38f","f32e5"]
f5427 age:14 - 65+ 1 ['7c38f', 'f5427'] See 1 ads matching ["7c38f","f5427"]
fec0a people_who_match:interests:Huey P. Newton or Malcolm X 1 ['7c38f', 'fec0a'] See 1 ads matching ["7c38f","fec0a"]
Powered by Datasette · Query took 115.92ms