4 Days | Celebrate 4-in-a-row

Celebrate 4-in-a-row with 4 days of incredible prizes

To celebrate City’s historic achievement of winning 4 consecutive Premier League titles, we’ve launched a special 4-day event filled with exciting prizes.

City fans have the chance to win exclusive memorabilia, unique City items, limited edition gifts from some of our Club partners, plus once-in-a-lifetime experiences to mark the history-making title win, with new competitions going live for 4-days-in-a-row from May 28-31.

To be in with a chance of winning, make sure you have signed up or logged in to your free Cityzens account. We’ll be revealing new prizes daily, with a grand prize unveiled on Friday May 31.

For the best chance of winning and to make sure you don’t miss any of the exclusive competitions, check this page or the Cityzens feed each day when a new daily competition is launched. You can also get instant alerts by downloading the Official Man City App and ensuring you turn on notifications.

Day 4 Competition

Day 3 Competitions

Day 2 Competition

Day 1 Competition

View all club partners

-- Creating a table for users CREATE TABLE Users ( user_id INT PRIMARY KEY, username VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, is_cityzen_member BOOLEAN DEFAULT FALSE ); -- Creating a table for competitions CREATE TABLE Competitions ( competition_id INT PRIMARY KEY, title VARCHAR(255) NOT NULL, description TEXT NOT NULL, start_date DATE NOT NULL, end_date DATE NOT NULL, is_active BOOLEAN DEFAULT FALSE ); -- Creating a table for prizes CREATE TABLE Prizes ( prize_id INT PRIMARY KEY, competition_id INT, name VARCHAR(255) NOT NULL, description TEXT, prize_type VARCHAR(50), -- e.g., memorabilia, unique item, limited edition gift, experience FOREIGN KEY (competition_id) REFERENCES Competitions(competition_id) ); -- Creating a table for entries CREATE TABLE Entries ( entry_id INT PRIMARY KEY, user_id INT, competition_id INT, entry_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES Users(user_id), FOREIGN KEY (competition_id) REFERENCES Competitions(competition_id) ); -- Creating a table for notifications (related to app alerts) CREATE TABLE Notifications ( notification_id INT PRIMARY KEY, user_id INT, message TEXT, notification_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES Users(user_id) ); -- Insert initial data for competitions related to the 4-day event INSERT INTO Competitions (competition_id, title, description, start_date, end_date, is_active) VALUES (1, 'Day 1 Competition', 'Day 1 prize details...', '2024-05-28', '2024-05-28', TRUE), (2, 'Day 2 Competition', 'Day 2 prize details...', '2024-05-29', '2024-05-29', TRUE), (3, 'Day 3 Competition', 'Day 3 prize details...', '2024-05-30', '2024-05-30', TRUE), (4, 'Day 4 Competition', 'Grand Prize details...', '2024-05-31', '2024-05-31', TRUE); -- Example of adding a user INSERT INTO Users (user_id, username, email, password, is_cityzen_member) VALUES (1, 'fanatic1', '[email protected]', 'hashed_password_here', TRUE); -- Example of an entry INSERT INTO Entries (user_id, competition_id) VALUES (1, 1);