Startseite PC Spiele auf CD / DVD Big Box Spiele Gebrauchte Spiele

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 = 247 ORDER BY p.products_sort_order, pd.products_name"

Gebrauchte Spiele

array(17) { ["products_image"]=> string(31) "newstuffFebruary14_2023_029.jpg" ["products_name"]=> string(24) "PC Outpost - Neo Genesis" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "74466" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "24.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "24.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) "24.990000000000" } array(17) { ["products_image"]=> string(32) "newstuffDecember17_201300024.jpg" ["products_name"]=> string(13) "PC Paris 1313" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "13532" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "289" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big 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(28) "newstuffAugust05_2014005.jpg" ["products_name"]=> string(14) "PC Patrizier 2" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "15797" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "14.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["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.990000000000" } array(17) { ["products_image"]=> string(24) "newstuffMay12_201531.jpg" ["products_name"]=> string(33) "PC Pax Imperia Die Sternenkolonie" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "22338" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> NULL ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(7) "Big Box" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "19.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) "13.990000000000" } array(17) { ["products_image"]=> string(26) "newstuffJune7_2023_125.jpg" ["products_name"]=> string(32) "PC Pearl Harbor - Strike at Dawn" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "75063" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "24.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) "17.490000000000" } array(17) { ["products_image"]=> string(31) "newstuffNovember21_2018_084.jpg" ["products_name"]=> string(16) "PC Pepper Pack 1" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "45689" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big 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(27) "newstuffAugust3_2015074.jpg" ["products_name"]=> string(17) "PC Phantasmagoria" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "23695" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> NULL ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(7) "Big Box" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "19.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) "13.990000000000" } array(17) { ["products_image"]=> string(26) "newstuffJuly5_2021_187.jpg" ["products_name"]=> string(17) "PC Phantasmagoria" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "62496" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "49.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "49.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) "49.990000000000" } array(17) { ["products_image"]=> string(27) "newstuffJuly14_2021_004.jpg" ["products_name"]=> string(27) "PC Phoenix - Ashes to Ashes" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "62701" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "14.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "34.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) "34.990000000000" } array(17) { ["products_image"]=> string(29) "newstuffAugust25_2024_044.jpg" ["products_name"]=> string(20) "PC Pinball Fantasies" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87197" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "39.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "39.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) "39.990000000000" } array(17) { ["products_image"]=> string(29) "newstuffAugust30_2023_042.jpg" ["products_name"]=> string(26) "PC Play the Games - Vol. 3" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "77301" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "24.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "24.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) "24.990000000000" } array(17) { ["products_image"]=> string(29) "newstuffAugust30_2023_043.jpg" ["products_name"]=> string(26) "PC Play the Games - Vol. 5" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "77302" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "19.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) "19.990000000000" } array(17) { ["products_image"]=> string(12) "IMAG0994.jpg" ["products_name"]=> string(23) "PC Play the Games Vol.1" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(4) "6931" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> NULL ["products_price"]=> string(7) "24.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(7) "Big Box" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "24.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) "17.490000000000" } array(17) { ["products_image"]=> string(25) "newstuffJuly21_201557.jpg" ["products_name"]=> string(23) "PC Play the Games Vol.1" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "23802" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> NULL ["products_price"]=> string(7) "24.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(7) "Big Box" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "24.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) "17.490000000000" } array(17) { ["products_image"]=> string(30) "newstuffOctober15_2019_043.jpg" ["products_name"]=> string(24) "PC Pod - Planet of Death" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "50462" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "14.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "24.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) "24.990000000000" } array(17) { ["products_image"]=> string(30) "newstuffOctober19_2021_128.jpg" ["products_name"]=> string(7) "PC Pong" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "63929" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

Big Box + Wing Commander III

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "99.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) "99.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffFebruary14_2023_014.jpg" ["products_name"]=> string(32) "PC Pro Sieben Mystery - Obsidian" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "74461" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "49.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) "49.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffDecember30_2021_016.jpg" ["products_name"]=> string(13) "PC Psychotron" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "65977" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "24.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) "19.992000000000" } array(17) { ["products_image"]=> string(27) "newstuffAugust3_2015062.jpg" ["products_name"]=> string(12) "PC Raiden II" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "23683" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(8) "129.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(8) "129.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) "90.990000000000" } array(17) { ["products_image"]=> string(29) "newstuffAugust25_2024_020.jpg" ["products_name"]=> string(25) "PC Raily 2.0 für Windows" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87174" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "39.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) "39.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffFebruary25_2022_147.jpg" ["products_name"]=> string(19) "PC Rallye Racing 97" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "67199" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "29.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) "29.990000000000" } array(17) { ["products_image"]=> string(25) "newstuffJune9_2015040.jpg" ["products_name"]=> string(9) "PC Rayman" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "23856" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> NULL ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(7) "Big Box" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "19.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) "13.990000000000" } array(17) { ["products_image"]=> string(29) "newstuffAugust25_2024_039.jpg" ["products_name"]=> string(11) "PC Rayman M" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87192" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["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) "10.490000000000" } array(17) { ["products_image"]=> string(30) "newstuffFebruary12_2015070.jpg" ["products_name"]=> string(24) "PC Reah Face the Unknown" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "20019" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> NULL ["products_price"]=> string(7) "24.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(7) "Big Box" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "24.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) "17.490000000000" } array(17) { ["products_image"]=> string(28) "newstuffApril11_2024_089.jpg" ["products_name"]=> string(16) "PC Real Airports" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "84056" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "14.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "79.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) "63.992000000000" } array(17) { ["products_image"]=> string(27) "newstuffJune26_2019_037.jpg" ["products_name"]=> string(25) "PC Rendezvous im Weltraum" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "48625" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "247" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "24.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(14) "

Big Box

Zeige 577 bis 624 (von 945 Artikeln)