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

Neuware

Ein allgemeines Bild

array(17) { ["products_image"]=> string(28) "NewstuffMarch29_2021_032.jpg" ["products_name"]=> string(15) "PC Value Pack 1" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "61061" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "79.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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) "79.990000000000" } array(17) { ["products_image"]=> string(28) "newstuffApril11_2024_013.jpg" ["products_name"]=> string(50) "PC Vampire Cows! - Die Attacke der kackenden Kühe" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "83983" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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) "7.992000000000" } array(17) { ["products_image"]=> string(28) "2012newstuffoctober15074.jpg" ["products_name"]=> string(33) "PC Verrat in der verbotenen Stadt" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(4) "8925" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "289" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "6.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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) "newstuffNovember29_2018_034.jpg" ["products_name"]=> string(23) "PC VIP Classic Wings 98" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "45778" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "39.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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) "27.990000000000" } array(17) { ["products_image"]=> string(32) "newstuffSeptember28_2022_014.jpg" ["products_name"]=> string(33) "PC Virtual Chess for Windows 3.11" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "71241" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "29.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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(30) "newstuffNovember3_2021_016.jpg" ["products_name"]=> string(11) "PC Virtuoso" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "64135" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "39.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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(28) "newstuffMarch11_2019_019.jpg" ["products_name"]=> string(38) "PC Wall Street Trader 98 Börsenfieber" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "47311" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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(27) "newstuffJuly22_2024_013.jpg" ["products_name"]=> string(16) "PC War Commander" ["products_quantity"]=> string(1) "3" ["products_id"]=> string(5) "86468" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "289" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "25.2017" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(59) "

Big Box, New + Sealed, cellophane may not be perfect

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "25.2017" ["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.990023000000" } array(17) { ["products_image"]=> string(32) "newstuffDecember17_201300071.jpg" ["products_name"]=> string(20) "PC War of the Worlds" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "13579" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "24.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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) "newstuffSeptember2_2024_007.jpg" ["products_name"]=> string(11) "PC War Wind" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87426" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "21.0000" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(42) "

Big Box, New + Sealed, Squashed box

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "21.0000" ["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(27) "newstuffJune24_2024_074.jpg" ["products_name"]=> string(11) "PC Wardoves" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "85694" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "7.5546" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "7.5546" ["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) "7.192003000000" } array(17) { ["products_image"]=> string(28) "NewstuffMarch29_2021_008.jpg" ["products_name"]=> string(41) "PC Wardoves - Secret Weapon of Worldwar I" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "61051" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "12.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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(27) "newstuffJune24_2024_068.jpg" ["products_name"]=> string(18) "PC Wildlife Park 2" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "85688" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "16.7983" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(36) "

Big Box, New + Sticker sealed

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "16.7983" ["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) "15.991934000000" } array(17) { ["products_image"]=> string(28) "newstuffOctober13_201417.jpg" ["products_name"]=> string(27) "PC Williams Arcade Classics" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "16953" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> NULL ["products_price"]=> string(7) "33.6050" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(21) "Big Box, New + Sealed" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "33.6050" ["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) "27.988800000000" } array(17) { ["products_image"]=> string(30) "newstuffNovember3_2021_078.jpg" ["products_name"]=> string(18) "PC Wings of Honour" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "64161" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "39.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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(28) "NewstuffMarch29_2021_233.jpg" ["products_name"]=> string(47) "PC Wissen von A-Z - Das Spiel für kluge Köpfe" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "61156" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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(28) "newstuffApril11_2024_018.jpg" ["products_name"]=> string(34) "PC Worms and Reinforcements United" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "83988" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(8) "199.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(54) "

Big Box, New + Sealed, rare Argentinian version

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(8) "199.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(16) "159.992000000000" } array(17) { ["products_image"]=> string(29) "newstuffAugust21_2024_012.jpg" ["products_name"]=> string(18) "PC Wunderwerk Auto" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87071" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "10.0756" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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(30) "newstuffOctober16_2024_005.jpg" ["products_name"]=> string(15) "PC X multi-pack" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "88451" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "25.2017" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(36) "

Big Box, New + Sticker sealed

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "25.2017" ["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.990023000000" } array(17) { ["products_image"]=> string(27) "newstuffApril13_2018_45.jpg" ["products_name"]=> string(31) "PC X-Mas Explosion Rollenspiele" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "42026" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "39.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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) "27.990000000000" } array(17) { ["products_image"]=> string(28) "NewstuffMarch29_2021_001.jpg" ["products_name"]=> string(31) "PC X-Mas Explosion Rollenspiele" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "61048" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "39.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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(25) "newstuffJune9_2015036.jpg" ["products_name"]=> string(19) "PC X:treme Velocity" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "23852" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> NULL ["products_price"]=> string(7) "39.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(21) "Big Box, New + Sealed" ["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) "27.990000000000" } array(17) { ["products_image"]=> string(30) "newstuffOctober23_2024_025.jpg" ["products_name"]=> string(26) "PC Z - The Bitmap Brothers" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "88576" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(8) "100.8319" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(8) "100.8319" ["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(16) "119.989961000000" } array(17) { ["products_image"]=> string(31) "newstuffNovember29_2018_044.jpg" ["products_name"]=> string(7) "PC Zeus" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "45783" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "49.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["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) "34.990000000000" } array(17) { ["products_image"]=> string(31) "newstuffSeptembe19_2024_012.jpg" ["products_name"]=> string(15) "PC Zone Raiders" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "87954" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "246" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "50.4118" ["products_tax_class_id"]=> string(1) "2" ["products_description"]=> string(28) "

Big Box, New + Sealed

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "50.4118" ["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) "59.990042000000" }