Liste des jeux sur Nintendo Switch2709 jeux trouvés
SELECT `g`.`gamepk` AS `pk`, `g`.`game_name` AS `name`, `g`.`game_date_eu` AS `date`, `g`.`game_thumbnail` AS `thumbnail`, `g`.`game_rewriting` AS `rewriting`, `g`.`game_cancelled` AS `cancelled`, `s`.`system_shortname` AS `system`, `s`.`systempk`, `s`.`system_rewriting` FROM `game` AS `g`
LEFT JOIN `system` AS `s` ON g.systemfk= s.systempk WHERE ((1=1 AND game_name LIKE '%%') OR (1=1 AND game_keyword LIKE '%%')) AND (g.systemfk = '51') AND (game_date_eu != '0000-00-00') AND (game_date_eu != 'none') AND (game_date_eu != 'nc') AND (game_date_eu != 'NC') AND (game_date_eu not like '%Q%') AND (game_date_eu is not null) ORDER BY `game_date_eu` desc LIMIT 24 OFFSET 3528
