John Jansen
From Sega Retro
|
| John Jansen |
|---|
| Employment history:
Divisions:
|
| Role(s): Tester |
This teeny-tiny article needs some work. You can help us by expanding it.
John Jansen.
Contents
Production history
Games
Query: SELECT `cargo__credits`.`role` AS `role`,`cargo__credits`.`name` AS `name`,`cargo__credits`.`game` AS `game`,`cargo__credits`.`console` AS `console`,`cargo__releases`.`date` AS `date`,`cargo__credits`.`pdf` AS `pdf`,`cargo__credits`.`pdfpage` AS `pdfpage` FROM `cargo__credits` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__credits`.`game`=`cargo__releases`.`name`)) WHERE `cargo__releases`.`type`="0" and (`cargo__credits`.`name`="John Jansen") and `cargo__credits`.`console`=`cargo__releases`.`console` GROUP BY `cargo__credits`.`console`, `cargo__credits`.`game`, `cargo__credits`.`role` ORDER BY `cargo__releases`.`date` LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-e54fa-552.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Query: SELECT `cargo__credits`.`role` AS `role`,`cargo__credits`.`name` AS `name`,`cargo__credits`.`game` AS `game`,`cargo__credits`.`console` AS `console`,`cargo__credits`.`date` AS `date`,`cargo__credits`.`pdf` AS `pdf`,`cargo__credits`.`pdfpage` AS `pdfpage` FROM `cargo__credits` LEFT OUTER JOIN `cargo__unreleased` ON ((`cargo__credits`.`game`=`cargo__unreleased`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__unreleased`.`format`=`cargo__codeformat`.`format`)) WHERE (`cargo__credits`.`name`="John Jansen") and `cargo__unreleased`.`name` != "" and `cargo__credits`.`console`=`cargo__codeformat`.`code` GROUP BY `cargo__credits`.`console`, `cargo__credits`.`game`, `cargo__credits`.`role` ORDER BY `cargo__unreleased`.`name` LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-e54fa-556.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Videos
Query: SELECT `cargo__credits`.`role` AS `role`,`cargo__credits`.`name` AS `name`,`cargo__credits`.`game` AS `game`,`cargo__credits`.`console` AS `console`,`cargo__releases`.`date` AS `date`,`cargo__credits`.`pdf` AS `pdf`,`cargo__credits`.`pdfpage` AS `pdfpage` FROM `cargo__credits` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__credits`.`game`=`cargo__releases`.`name`)) WHERE `cargo__releases`.`type`="6" and (`cargo__credits`.`name`="John Jansen") GROUP BY `cargo__credits`.`console`, `cargo__credits`.`game`, `cargo__credits`.`role` ORDER BY `cargo__releases`.`date` LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-e54fa-559.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Music
Query: SELECT `cargo__credits`.`role` AS `role`,`cargo__credits`.`name` AS `name`,`cargo__credits`.`game` AS `game`,`cargo__credits`.`console` AS `console`,`cargo__releases`.`date` AS `date`,`cargo__credits`.`pdf` AS `pdf`,`cargo__credits`.`pdfpage` AS `pdfpage` FROM `cargo__credits` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__credits`.`game`=`cargo__releases`.`name`)) WHERE `cargo__releases`.`type`="3" and (`cargo__credits`.`name`="John Jansen") GROUP BY `cargo__credits`.`console`, `cargo__credits`.`game`, `cargo__credits`.`role` ORDER BY `cargo__releases`.`date` LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-e54fa-55c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Books
Query: SELECT `cargo__credits`.`role` AS `role`,`cargo__credits`.`name` AS `name`,`cargo__credits`.`game` AS `game`,`cargo__credits`.`console` AS `console`,`cargo__releases`.`date` AS `date`,`cargo__credits`.`pdf` AS `pdf`,`cargo__credits`.`pdfpage` AS `pdfpage` FROM `cargo__credits` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__credits`.`game`=`cargo__releases`.`name`)) WHERE `cargo__releases`.`type`="4" and (`cargo__credits`.`name`="John Jansen") GROUP BY `cargo__credits`.`console`, `cargo__credits`.`game`, `cargo__credits`.`role` ORDER BY `cargo__releases`.`date` LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-e54fa-55f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Hardware
Query: SELECT `cargo__credits`.`role` AS `role`,`cargo__credits`.`name` AS `name`,`cargo__credits`.`game` AS `game`,`cargo__credits`.`console` AS `console`,`cargo__releases`.`date` AS `date`,`cargo__credits`.`pdf` AS `pdf`,`cargo__credits`.`pdfpage` AS `pdfpage` FROM `cargo__credits` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__credits`.`game`=`cargo__releases`.`name`)) WHERE `cargo__releases`.`type`="2" and (`cargo__credits`.`name`="John Jansen") GROUP BY `cargo__credits`.`console`, `cargo__credits`.`game`, `cargo__credits`.`role` ORDER BY `cargo__releases`.`date` LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-e54fa-562.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)
Accessories
Query: SELECT `cargo__credits`.`role` AS `role`,`cargo__credits`.`name` AS `name`,`cargo__credits`.`game` AS `game`,`cargo__credits`.`console` AS `console`,`cargo__releases`.`date` AS `date`,`cargo__credits`.`pdf` AS `pdf`,`cargo__credits`.`pdfpage` AS `pdfpage` FROM `cargo__credits` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__credits`.`game`=`cargo__releases`.`name`)) WHERE `cargo__releases`.`type`="1" and (`cargo__credits`.`name`="John Jansen") GROUP BY `cargo__credits`.`console`, `cargo__credits`.`game`, `cargo__credits`.`role` ORDER BY `cargo__releases`.`date` LIMIT 5000 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-e54fa-565.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)