CREATE VIEW `page_id_categories` AS (
SELECT p.page_id, c.id, c.name
FROM pages_categories p
LEFT JOIN categories c
ON p.category_id = c.id
);
CREATE VIEW `page_id_categories` AS (
SELECT p.page_id, c.name
FROM pages_categories p
LEFT JOIN categories c
ON p.category_id = c.id
);
Remove category id from view
Remove category id from view
