User:Akkakk/issues/link without label/en

select concat("[[Q", ips_item_id, "]] ([[User:YMS/LC#Q", ips_item_id, "|LC]])") as item, ips_site_id, ips_site_page from wb_items_per_site join s51880_akkakkbot.languages on lang_db = "enwiki" and lang_db = ips_site_id and (ips_site_page like "%, %" or ips_site_page like "% (%)") and not exists (select term_language from wb_terms where ips_item_id = term_entity_id and lang_wd = term_language and term_type = "label") limit 100;

1 Q2808309 (LC) enwiki 15 chansons d'avant le déluge, suite et fin
2 Q17652288 (LC) enwiki 2014–15 Serie A (futsal)
3 Q16160285 (LC) enwiki 2nd Rifle Division (Soviet Union, 1st Formation)
4 Q16160305 (LC) enwiki 2nd Rifle Division (Soviet Union, 2nd Formation)
5 Q16160326 (LC) enwiki 2nd Rifle Division (Soviet Union, 3rd Formation)
6 Q16485447 (LC) enwiki 2nd Rifle Division (Soviet Union, 4th Formation)
7 Q298114 (LC) enwiki ASV Dachau (volleyball)
8 Q20023132 (LC) enwiki Adam Smith (footballer, born 1992)
9 Q12808279 (LC) enwiki Adana (electoral district)
10 Q15644725 (LC) enwiki Adi Badri (Haryana)
11 Q5658288 (LC) enwiki Adrian Moss (basketball, born 1981)
12 Q6099080 (LC) enwiki Adıyaman (electoral district)
13 Q6098710 (LC) enwiki Afyonkarahisar (electoral district)
14 Q7393495 (LC) enwiki Agricultural Museum (Malaysia)
15 Q12358530 (LC) enwiki Aken (novel)
16 Q6095517 (LC) enwiki Aksaray (electoral district)
17 Q2080761 (LC) enwiki Al Hijr (Kaaba)
18 Q20045227 (LC) enwiki Al-Hasakah city offensive (May–June 2015)
19 Q12190454 (LC) enwiki Alamart (Khartoum)
20 Q5662694 (LC) enwiki Alberti Norte (Buenos Aires Underground)
21 Q4195916 (LC) enwiki Aleksandr Ivanov (footballer, born 1973)
22 Q4225559 (LC) enwiki Aleksandr Kovalyov (footballer, born 1980)
23 Q4088735 (LC) enwiki Aleksei Bobrov (footballer, born 1973)
24 Q18575255 (LC) enwiki Alexandri (amora)
25 Q16830343 (LC) enwiki Alliance (esports)
26 Q19607487 (LC) enwiki Almirante (board game)
27 Q12194087 (LC) enwiki Almorada (Omdurman)
28 Q18599924 (LC) enwiki Alternatiba, Village of Alternatives
29 Q16301064 (LC) enwiki Amador, Panama
30 Q6099030 (LC) enwiki Amasya (electoral district)
31 Q10408108 (LC) enwiki Amelia (magazine)
32 Q3614188 (LC) enwiki Amica (magazine)
33 Q20021704 (LC) enwiki Aminul Hoque (writer)
34 Q20051698 (LC) enwiki Anahita (disambiguation)
35 Q17620988 (LC) enwiki Ancon (archaeological site)
36 Q4402514 (LC) enwiki Andrei Ryabykh (footballer, born 1982)
37 Q6099205 (LC) enwiki Ankara (electoral districts)
38 Q6099132 (LC) enwiki Antalya (electoral district)
39 Q16081213 (LC) enwiki Anton Chico, New Mexico
40 Q19753270 (LC) enwiki Aozora no Shita, Kimi no Tonari
41 Q20010013 (LC) enwiki Apulian regional election, 2015
42 Q6094332 (LC) enwiki Ardahan (electoral district)
43 Q16301107 (LC) enwiki Arosemena, Panama
44 Q15784120 (LC) enwiki Arthur Hay, 15th Earl of Kinnoull
45 Q6099248 (LC) enwiki Artvin (electoral district)
46 Q18732955 (LC) enwiki Ashley (restaurant)
47 Q8774292 (LC) enwiki Asturian parliamentary election, 1983
48 Q8774294 (LC) enwiki Asturian parliamentary election, 1987
49 Q8774297 (LC) enwiki Asturian parliamentary election, 1991
50 Q8774299 (LC) enwiki Asturian parliamentary election, 1995
51 Q2889967 (LC) enwiki Asturian parliamentary election, 1999
52 Q8774302 (LC) enwiki Asturian parliamentary election, 2003
53 Q5827471 (LC) enwiki Asturian parliamentary election, 2007
54 Q19838091 (LC) enwiki Avda (given name)
55 Q12218123 (LC) enwiki Avenue Mohammed V (Tunis)
56 Q6099096 (LC) enwiki Aydın (electoral district)
57 Q2465100 (LC) enwiki Azóia (Sintra)
58 Q12808681 (LC) enwiki Ağrı (electoral district)
59 Q18191395 (LC) enwiki Baby Boom (Israeli TV Series)
60 Q5653660 (LC) enwiki Baco, Chiriquí
61 Q799152 (LC) enwiki Badischer Hof (Tauberbischofsheim)
62 Q16372234 (LC) enwiki Bagaran (ancient city)
63 Q19886353 (LC) enwiki Bahía Honda, Los Santos
64 Q2880241 (LC) enwiki Bakhuysen (crater)
65 Q2880681 (LC) enwiki Baldet (Martian crater)
66 Q6099251 (LC) enwiki Balıkesir (electoral district)
67 Q12195873 (LC) enwiki Bant (Omdurman)
68 Q14597534 (LC) enwiki Barabashov (crater)
69 Q11687333 (LC) enwiki Baranowice, Żory
70 Q19815549 (LC) enwiki Baren (TV Sweden)
71 Q18398242 (LC) enwiki Barrios Unidos, Coclé
72 Q6095173 (LC) enwiki Bartın (electoral district)
73 Q3635768 (LC) enwiki Basilica of Santa Maria delle Grazie, Cortemaggiore
74 Q9167795 (LC) enwiki Basilica of St. Jacob and St. Agnes, Nysa
75 Q6094903 (LC) enwiki Batman (electoral district)
76 Q5722246 (LC) enwiki Battle of Bucaramanga (1854)
77 Q5722248 (LC) enwiki Battle of Bucaramanga (1899)
78 Q5722426 (LC) enwiki Battle of Eisenach (908)
79 Q16301163 (LC) enwiki Bayano, Los Santos
80 Q6094883 (LC) enwiki Bayburt (electoral district)
81 Q19852321 (LC) enwiki Be With You (TV Series)
82 Q16301181 (LC) enwiki Bejuco, Panama
83 Q19842804 (LC) enwiki Beli, Croatia
84 Q19613766 (LC) enwiki Beridze, Alexandre
85 Q12785821 (LC) enwiki Besnica (creek)
86 Q10863014 (LC) enwiki Bichaghchi (tribe)
87 Q2986349 (LC) enwiki Bignon Commission (French Revolution)
88 Q6099151 (LC) enwiki Bilecik (electoral district)
89 Q6099223 (LC) enwiki Bingöl (electoral district)
90 Q6098841 (LC) enwiki Bitlis (electoral district)
91 Q19885807 (LC) enwiki Blind Date (2015 film)
92 Q6098846 (LC) enwiki Bolu (electoral district)
93 Q661065 (LC) enwiki Bombarde (organ stop)
94 Q1969679 (LC) enwiki Born to Kill (1967 film)
95 Q9177897 (LC) enwiki Borynia, Jastrzębie-Zdrój
96 Q2925066 (LC) enwiki Briault (crater)
97 Q2926539 (LC) enwiki Brujas (telenovela)
98 Q9180891 (LC) enwiki Brzezie, Racibórz
99 Q11688989 (LC) enwiki Brzezinka, Mysłowice
100 Q9396024 (LC) enwiki Brzęczkowice, Mysłowice