Files

10 lines
1.5 KiB
SQL

-- Klantverzoek: verwijder de "(~N tekens)"-hints uit de SEO-labels.
UPDATE _emdash_fields SET label='SEO · standaard paginatitel' WHERE slug='meta_title' AND collection_id=(SELECT id FROM _emdash_collections WHERE slug='site_settings');
UPDATE _emdash_fields SET label='SEO · standaard omschrijving / Google-snippet' WHERE slug='meta_description' AND collection_id=(SELECT id FROM _emdash_collections WHERE slug='site_settings');
UPDATE _emdash_fields SET label='SEO · titel voor Google (leeg = paginatitel)' WHERE slug='meta_title' AND collection_id=(SELECT id FROM _emdash_collections WHERE slug='paginas');
UPDATE _emdash_fields SET label='SEO · omschrijving / Google-snippet' WHERE slug='meta_description' AND collection_id=(SELECT id FROM _emdash_collections WHERE slug='paginas');
UPDATE _emdash_fields SET label='SEO · titel voor Google (leeg = paginakop)' WHERE slug='meta_title' AND collection_id=(SELECT id FROM _emdash_collections WHERE slug='locaties');
UPDATE _emdash_fields SET label='SEO · omschrijving / Google-snippet' WHERE slug='meta_description' AND collection_id=(SELECT id FROM _emdash_collections WHERE slug='locaties');
UPDATE _emdash_fields SET label='SEO · paginatitel' WHERE slug='meta_title' AND collection_id=(SELECT id FROM _emdash_collections WHERE slug='over_ons');
UPDATE _emdash_fields SET label='SEO · omschrijving' WHERE slug='meta_description' AND collection_id=(SELECT id FROM _emdash_collections WHERE slug='over_ons');