Open main menu

User:Akkakk/issues/link without label/brackets

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 = 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 60;

1 Q12481109 (LC) acewiki Deuah, Sama Tiga, Acèh Barat
2 Q728001 (LC) afwiki Afleiding (taalkunde)
3 Q212348 (LC) afwiki Angus (bees)
4 Q19711 (LC) afwiki Avon (Bristol)
5 Q971767 (LC) afwiki Beloved (roman)
6 Q17461073 (LC) afwiki Ben, in the World
7 Q897314 (LC) afwiki Brahman (bees)
8 Q5025319 (LC) afwiki Cambridge, Oos-Kaap
9 Q100041 (LC) afwiki Carpi, Emilia-Romagna
10 Q1736876 (LC) afwiki Cat's Eye (Atwood-roman)
11 Q948818 (LC) afwiki Ee (Dongeradeel)
12 Q138046 (LC) afwiki England, England
13 Q16168 (LC) afwiki Ferrara (provinsie)
14 Q16180 (LC) afwiki Forlì-Cesena (provinsie)
15 Q1132324 (LC) afwiki Glos (teks)
16 Q141881 (LC) afwiki Granby, Quebec
17 Q387961 (LC) afwiki Independence Day (Ford-roman)
18 Q3163324 (LC) afwiki Jazz (roman)
19 Q18433757 (LC) afwiki Kabinet van Jacob Zuma, Mei 2009
20 Q40041 (LC) afwiki Konserwatiewe Party (dubbelsinnig)
21 Q1088792 (LC) afwiki Lakewood, New Jersey
22 Q150494 (LC) afwiki Leopold I, Heilige Romeinse Keiser
23 Q151321 (LC) afwiki Leopold II, Heilige Romeinse Keiser
24 Q959410 (LC) afwiki Lexington, Nebraska
25 Q501761 (LC) afwiki Lexington, Virginië
26 Q6690144 (LC) afwiki Love, etc (Barnes-roman)
27 Q52983 (LC) afwiki Lugo, Emilia-Romagna
28 Q4784 (LC) afwiki Metroland (Barnes-roman)
29 Q786298 (LC) afwiki Modderrivier, Noord-Kaap
30 Q16209 (LC) afwiki Modena (provinsie)
31 Q1000806 (LC) afwiki Nes (Dongeradeel)
32 Q951587 (LC) afwiki Never Let Me Go (roman)
33 Q401537 (LC) afwiki Night and Day (Woolf-roman)
34 Q2454855 (LC) afwiki Norwich, Ohio
35 Q3821704 (LC) afwiki Offshore (roman)
36 Q131346 (LC) afwiki Pandora (mitologie)
37 Q7134233 (LC) afwiki Paradise (roman)
38 Q11464 (LC) afwiki Ploeg (werktuig)
39 Q7274451 (LC) afwiki R21 (Suid-Afrika)
40 Q7274459 (LC) afwiki R24 (Gauteng)
41 Q16252 (LC) afwiki Ravenna (provinsie)
42 Q7322430 (LC) afwiki Ribbes (voedsel)
43 Q245423 (LC) afwiki Samestelling (taalkunde)
44 Q625884 (LC) afwiki Selters (Taunus)
45 Q132041 (LC) afwiki Sleutel (slot)
46 Q228039 (LC) afwiki Slot (sluiting)
47 Q138811 (LC) afwiki Soethout (geursel)
48 Q3480330 (LC) afwiki Song of Solomon (roman)
49 Q210523 (LC) afwiki Stam (taalkunde)
50 Q27630 (LC) afwiki Stratum (taalkunde)
51 Q7646051 (LC) afwiki Surfacing (Atwood-roman)
52 Q15080194 (LC) afwiki The Goldfinch (roman)
53 Q1331310 (LC) afwiki The Sense of an Ending (Barnes-roman)
54 Q1000769 (LC) afwiki Waaxens (Dongeradeel)
55 Q2504767 (LC) afwiki Westergeest (Kollumerland)
56 Q256051 (LC) alswiki Baar (Schwaben)
57 Q526553 (LC) alswiki Biberbach (Schwaben)
58 Q219447 (LC) alswiki Bill of Rights (England)
59 Q542907 (LC) alswiki Bonstetten (Schwaben)
60 Q627506 (LC) alswiki Breitenthal (Schwaben)