Query Run
SELECT REGEXP_REPLACE(page_title, '_.*$', '') AS `prefix`, COUNT(*) AS... 7 months ago
SELECT REGEXP_REPLACE(page_title, '_.*$', '') AS `prefix`, COUNT(*) AS... 7 months ago
SELECT REGEXP_REPLACE(page_title, '_.*$', '') AS `prefix`, COUNT(*) AS... 7 months ago
SELECT page_title, REGEXP_REPLACE(page_title, '_.*$', '') AS `prefix` FROM... 7 months ago
SELECT page_title, REGEXP_REPLACE(page_title, '_.*$', '') AS `prefix` FROM... 7 months ago
SELECT page_title, REGEXP_REPLACE(page_title, '^[^_]+_', '') AS... 7 months ago
SELECT page_title, REGEXP_REPLACE(page_title, '^[^_]+_', '') AS... 7 months ago
SELECT page_title, REGEXP_REPLACE(page_title, '^[^_]+_', '') AS... 7 months ago