SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE `catalog_national_finals` ( `id` int primary key auto_increment, `year` int, `title` varchar(64) ); INSERT INTO `catalog_national_finals` (`year`, `title`) VALUES (2021, 'Bla-bla-bla'), (2021, 'Tra-la-la'); CREATE TABLE `voting_data_national_finals` ( `id` int primary key auto_increment, `id_participant` int, `id_user` int, `vote` int ); INSERT INTO `voting_data_national_finals` (`id_participant`, `id_user`, `vote`) VALUES (2, 23, 7); SELECT * FROM `catalog_national_finals` as A LEFT JOIN `voting_data_national_finals` as B ON (A.id = B.id_participant) WHERE A.year = 2021 AND (B.id_user = 23 OR B.id_user IS NULL)