Liste des jeux du genre Sport sur Nintendo Entertainment System0 jeu trouvé
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
LEFT JOIN `game_thematic` AS `gt` ON gt.gamefk = g.gamepk
LEFT JOIN `jmalin`.`thematic` AS `t` ON t.thematicpk = gt.thematicfk
LEFT JOIN `jmalin`.`kind` AS `k` ON k.kindpk = t.kindfk WHERE ((1=1 AND game_name LIKE '%%') OR (1=1 AND game_keyword LIKE '%%')) AND (g.systemfk = '5') AND (k.kindpk = '10') 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) GROUP BY `g`.`gamepk` ORDER BY `game_date_eu` desc LIMIT 24
