NULL Spiele mit OVP - Retro Game Collector Heaven - Zen Cart 1.5.7 deutsch
0 - €0.00
NULL string(1308) "SELECT p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) AS final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_price_sorter * (1 + IFNULL(tr.tax_rate, 0) / 100) AS srb_price_sorter FROM products p LEFT JOIN specials s ON s.products_id = p.products_id LEFT JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = 43 LEFT JOIN products_to_categories p2c ON p2c.products_id = p.products_id LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id LEFT JOIN tax_rates tr ON tr.tax_class_id = p.products_tax_class_id WHERE p.products_status = 1 AND p2c.categories_id = 180 ORDER BY p.products_sort_order, pd.products_name"

Spiele mit OVP

Ein allgemeines Bild

array(17) { ["products_image"]=> string(27) "newstuffJuly28_2020_109.jpg" ["products_name"]=> string(52) "Xbox One The Elder Scrolls Online: Tamriel Unlimited" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "56311" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "3.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(24) "

CD + Box + Manual

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "3.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "3.990000000000" } array(17) { ["products_image"]=> string(32) "newstuffSeptember13_2021_072.jpg" ["products_name"]=> string(49) "Xbox One The Escapists - The Walking Dead Edition" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "63048" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(15) "

CD + Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "9.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "9.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptember2_2024_102.jpg" ["products_name"]=> string(24) "Xbox One The Evil Within" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87514" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "6.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(42) "

Disc + Box, DLCs may have been used

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "6.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "6.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptember2_2024_083.jpg" ["products_name"]=> string(26) "Xbox One The Evil Within 2" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87496" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "6.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(42) "

Disc + Box, DLCs may have been used

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "6.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "6.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptember2_2024_091.jpg" ["products_name"]=> string(43) "Xbox One The Sinking City - Day One Edition" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87504" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(42) "

Disc + Box, DLCs may have been used

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "9.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "9.990000000000" } array(17) { ["products_image"]=> string(32) "newstuffSeptember13_2021_079.jpg" ["products_name"]=> string(55) "Xbox One The Walking Dead - Die komplette Erste Staffel" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "63055" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(15) "

CD + Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "9.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "9.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptember2_2024_136.jpg" ["products_name"]=> string(36) "Xbox One The Witcher III - Wild Hunt" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87548" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "11.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(70) "

Discs + Box + Manual + Poster + Sleeve, DLCs may have been used

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "11.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(15) "11.990000000000" } array(17) { ["products_image"]=> string(28) "newstuffOctober29_201514.jpg" ["products_name"]=> string(39) "Xbox One Thief Limitierte Sonderedition" ["products_quantity"]=> string(1) "2" ["products_id"]=> string(5) "25733" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "12.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(16) "CD + Box + Cards" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "12.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(15) "12.340500000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptember2_2024_123.jpg" ["products_name"]=> string(45) "Xbox One Tom Clancy's Ghost Recon - Wildlands" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87535" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "6.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(42) "

Disc + Box, DLCs may have been used

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "6.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "6.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptember2_2024_107.jpg" ["products_name"]=> string(39) "Xbox One Tom Clancy's Rainbow Six Siege" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87519" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "3.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(42) "

Disc + Box, DLCs may have been used

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "3.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "3.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptember2_2024_059.jpg" ["products_name"]=> string(34) "Xbox One Tom Clancy's The Division" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87472" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "3.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(15) "

CD + Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "3.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "3.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptember2_2024_112.jpg" ["products_name"]=> string(36) "Xbox One Tom Clancy's The Division 2" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87524" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "4.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(42) "

Disc + Box, DLCs may have been used

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "4.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "4.990000000000" } array(17) { ["products_image"]=> string(30) "newstuffJanuary19_2021_030.jpg" ["products_name"]=> string(51) "Xbox One Tom Clancy's The Division 2 - Gold Edition" ["products_quantity"]=> string(1) "2" ["products_id"]=> string(5) "59870" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "10.0756" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(24) "

CD + Box + Manual

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "10.0756" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(15) "11.989964000000" } array(17) { ["products_image"]=> string(32) "newstuffSeptember13_2021_061.jpg" ["products_name"]=> string(12) "Xbox One UFC" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "63037" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "6.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(21) "

CD + Box 

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "6.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "6.990000000000" } array(17) { ["products_image"]=> string(26) "newstuffJune3_2016_054.jpg" ["products_name"]=> string(35) "Xbox One Wasteland 2 Director's Cut" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "30794" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "8.3950" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(24) "

CD + Box + Manual

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "8.3950" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "9.490607000000" } array(17) { ["products_image"]=> string(28) "newstuffMarch17_2017_148.jpg" ["products_name"]=> string(35) "Xbox One Wasteland 2 Director's Cut" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "35708" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(24) "

CD + Box + Manual

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "9.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "9.490500000000" } array(17) { ["products_image"]=> string(27) "newstuffJuly28_2020_108.jpg" ["products_name"]=> string(19) "Xbox One Watch Dogs" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "56310" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "4.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(24) "

CD + Box + Manual

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "4.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "4.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptember2_2024_103.jpg" ["products_name"]=> string(21) "Xbox One Watch Dogs 2" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87515" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "5.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(42) "

Disc + Box, DLCs may have been used

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "5.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "5.990000000000" } array(17) { ["products_image"]=> string(29) "newstuffNovember2_2015080.jpg" ["products_name"]=> string(35) "Xbox One Watch Dogs Special Edition" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "25863" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "14.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(17) "CD + Box + Manual" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "14.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(15) "14.240500000000" } array(17) { ["products_image"]=> string(28) "newstuffDecember9_201520.jpg" ["products_name"]=> string(36) "Xbox One Wolfenstein - The New Order" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "26558" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(15) "

CD + Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "9.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "9.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptember2_2024_063.jpg" ["products_name"]=> string(42) "Xbox One Wreckfest - Drive Hard. Die Last." ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87476" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "14.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(42) "

Disc + Box, DLCs may have been used

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "14.9900" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(15) "14.990000000000" } array(17) { ["products_image"]=> string(30) "newstuffJanuary14_2020_079.jpg" ["products_name"]=> string(17) "Xbox One WWE 2K15" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "52115" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "3.3529" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(24) "

CD + Box + Manual

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "3.3529" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "3.790507000000" } array(17) { ["products_image"]=> string(30) "newstuffJanuary14_2020_074.jpg" ["products_name"]=> string(17) "Xbox One WWE 2K16" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "52110" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "180" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "4.1933" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(24) "

CD + Box + Manual

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "4.1933" ["products_sort_order"]=> string(1) "0" ["product_is_call"]=> string(1) "0" ["product_is_always_free_shipping"]=> string(1) "0" ["products_qty_box_status"]=> string(1) "1" ["srb_price_sorter"]=> string(14) "4.740484000000" }