SELECT Product.ProductID FROM Additional WITH (NOLOCK) INNER JOIN PartnerProduct WITH (NOLOCK) ON Additional.ProductID = PartnerProduct.ProductID AND PartnerProduct.PartnerID = 2 AND PartnerProduct.Active = CONVERT(bit, 1) INNER JOIN Product WITH (NOLOCK) ON Additional.ProductID = Product.ProductID AND Product.Active = CONVERT(bit, 1) AND (Product.Deleted = CONVERT(bit, 0) OR (Product.Deleted = CONVERT(bit, 1) AND Product.SOH > 0)) INNER JOIN MenuProduct WITH (NOLOCK) ON Additional.ProductID = MenuProduct.ProductID AND MenuProduct.MenuID IN (4294,4295,4296,4297,5426,7079,4298,7078,4299,4300,4301,5462,4302,4303) INNER JOIN Artist WITH (NOLOCK) ON Product.ArtistID = Artist.ArtistID INNER JOIN PartnerGenre WITH (NOLOCK) ON Product.GenreID = PartnerGenre.GenreID AND PartnerGenre.PartnerID = 2 INNER JOIN PartnerFormat WITH (NOLOCK) ON Product.FormatID = PartnerFormat.FormatID AND PartnerFormat.PartnerID = 2 INNER JOIN Format WITH (NOLOCK) ON Product.FormatID = Format.FormatID LEFT OUTER JOIN Supplier WITH (NOLOCK) ON Product.SupplierID = Supplier.SupplierID LEFT OUTER JOIN CampaignView Campaign ON Additional.ProductID = Campaign.ProductID LEFT OUTER JOIN PartnerCampaign ON Campaign.CampaignID = PartnerCampaign.CampaignID AND PartnerCampaign.PartnerID = 2 WHERE ((CASE WHEN Campaign.DateStart >= GETDATE() THEN Campaign.DateStart ELSE dbo.fn_AdjustReleaseDate(Additional.ReleaseDate) END) BETWEEN CONVERT(datetime, '6/07/2008 00:00:00', 103) AND CONVERT(datetime, '6/07/2009 23:59:59', 103)) AND (dbo.fn_InStockOnly(ISNULL(Supplier.InStockOnly, 0), ISNULL(Supplier.InStockOnlyPreRelease, 0), Product.SOH, dbo.fn_AdjustReleaseDate(Additional.ReleaseDate), GETDATE()) = CONVERT(bit, 1)) ORDER BY (CASE WHEN Campaign.DateStart >= GETDATE() THEN Campaign.DateStart ELSE dbo.fn_AdjustReleaseDate(Additional.ReleaseDate) END), Format.Format, Artist.Artist, Product.Title

---

Results 1-35 of 35 for home > games > playstation 2 > Coming Soon

Thu 10 Jul 2008
Playstation 2 Game	IMPOSSIBLE MISSION Once again you can become Special Agent 4125, and undertake the desparate mission of saving the world from Elvin Atombenders evil plot to...	$37.46
	SUPER FRUIT FALL SUPER FRUITFALL, a true puzzle game, simple in concept but with enormous depth as the challenge increases. Super Fruitfall is very easy to...	$18.70
Tue 15 Jul 2008
Playstation 2 Game	AGENT HUGO ROBORUMBLE	$20.63
Thu 17 Jul 2008
Playstation 2 Game	INCREDIBLE HULK (VIDEO GAME) Fuelled with fury, SEGAs The Incredible Hulk features key moments from the film, as well as additional plotlines and characters from the...	$46.82
Sun 3 Aug 2008
Playstation 2 Game	FINAL ARMADA	$27.78
	SNOW X RACING	$37.07
	SUMMER ATHLETICS	$48.13
Wed 6 Aug 2008
Playstation 2 Game	GUITAR HERO AEROSMITH / GUITAR HERO AEROSMITH (GAME & GUITAR)	$144.03
	GUITAR HERO AEROSMITH / GUITAR HERO AEROSMITH (GAME ONLY)	$65.57
Thu 7 Aug 2008
Playstation 2 Game	STEALTH FORCE 2	$23.39
Thu 14 Aug 2008
Playstation 2 Game	MADDEN NFL 2009	$65.62
	SING STAR / SING STAR AMPED	$46.84
	SING STAR / SING STAR AMPED BUNDLE (GAME & 2 USB MICROPHONES)	$93.71
	SKYSCRAPER (GAME)	$23.39
Sun 17 Aug 2008
Playstation 2 Game	HARRY POTTER & THE HALF BLOOD PRINCE	$65.62
	HASBRO FAMILY GAME NIGHT	$65.62
	MERCENARIES 2: WORLD IN FLAMES	$84.37
	NHL 2009	$65.62
	RISING STAR 3	$48.13
Thu 21 Aug 2008
Playstation 2 Game	MARGOT'S WORD BRAIN	$28.08
Thu 28 Aug 2008
Playstation 2 Game	TIGER WOODS PGA TOUR 2009	$65.62
	WALL-E	$65.57
Thu 4 Sep 2008
Playstation 2 Game	TNA IMPACT! TNA Wrestling is the exclusive Total Nonstop Action wrestling game based on the top-rated weekly television show, TNA Impact! Choose the...	$46.84
	YAMAHA SUPERCROSS	$46.84
Mon 15 Sep 2008
Playstation 2 Game	HARRY POTTER & THE ORDER OF THE PHOENIX / HARRY POTTER & THE ORDER OF THE PHOENIX (PLATINUM)	$28.12
	MONOPOLY (VIDEO GAME)	$65.62
Wed 17 Sep 2008
Playstation 2 Game	STAR WARS: FORCE UNLEASHED	$65.57
Thu 25 Sep 2008
Playstation 2 Game	HANNAH MONTANA 2	$46.84
	YAKUZA 2	$46.82
Sun 28 Sep 2008
Playstation 2 Game	DANCING STAGE SUPERNOVA 2 Dance Dance Revolution SuperNOVA2 continues the legacy of the music genre's most popular franchise and expands on every aspect of what made...	$67.38
Thu 9 Oct 2008
Playstation 2 Game	NBA LIVE 2009	$65.62
Wed 15 Oct 2008
Playstation 2 Game	AVATAR: INTO THE INFERNO	$46.84
	BRATZ / BRATZ: GIRLS REALLY ROCK	$46.84
	MONSTER LAB	$48.13
	SPONGEBOB SQUAREPANTS: GLOBS OF DOOM	$46.84