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) |