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

Anleitungen

Ein allgemeines Bild

array(17) { ["products_image"]=> string(30) "newstuffNovember3_2023_014.jpg" ["products_name"]=> string(34) "GBA DK - King of Swing NEU6 Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79430" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(30) "newstuffNovember3_2023_018.jpg" ["products_name"]=> string(37) "GBA Donkey Kong Country 2 NEU6 Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79434" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "7.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "7.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.990000000000" } array(17) { ["products_image"]=> string(30) "newstuffNovember3_2023_017.jpg" ["products_name"]=> string(42) "GBA Dr. Mario & Puzzle League NFHUG Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79433" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "7.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "7.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.990000000000" } array(17) { ["products_image"]=> string(30) "newstuffNovember3_2023_034.jpg" ["products_name"]=> string(34) "GBA F-Zero - GP Legend NEU6 Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79449" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(30) "newstuffNovember3_2023_049.jpg" ["products_name"]=> string(34) "GBA F-Zero - GP Legend NEU6 Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79463" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "14.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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) "newstuffNovember3_2023_033.jpg" ["products_name"]=> string(53) "GBA Final Fantasy I & II - Dawn of Souls NFHUG Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79448" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "12.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(30) "newstuffNovember3_2023_027.jpg" ["products_name"]=> string(41) "GBA Final Fantasy VI Advance NFHUG Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79442" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "39.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(30) "newstuffNovember3_2023_026.jpg" ["products_name"]=> string(44) "GBA Game & Watch Gallery Advance NEU6 Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79441" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "4.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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) "newstuffNovember3_2023_043.jpg" ["products_name"]=> string(26) "GBA Golden Sun NNOE Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79457" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(30) "newstuffNovember3_2023_036.jpg" ["products_name"]=> string(32) "GBA Kurukuru Kururin NEU6 Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79451" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "6.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(30) "newstuffNovember3_2023_032.jpg" ["products_name"]=> string(42) "GBA Mario Kart - Super Circuit NEU5 Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79447" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "7.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "7.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.990000000000" } array(17) { ["products_image"]=> string(30) "newstuffNovember3_2023_015.jpg" ["products_name"]=> string(35) "GBA Mario Power Tennis NFHUG Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79431" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(30) "newstuffNovember3_2023_028.jpg" ["products_name"]=> string(39) "GBA Metroid - Zero Mission NFHUG Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79443" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "44.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(7) "44.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) "44.990000000000" } array(17) { ["products_image"]=> string(30) "newstuffNovember3_2023_039.jpg" ["products_name"]=> string(41) "GBA NES Classics - Excitebike NEU6 Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79453" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(30) "newstuffNovember3_2023_040.jpg" ["products_name"]=> string(38) "GBA NES Classics - Pac-Man NEU6 Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79454" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(29) "newstuffDecember11_201518.jpg" ["products_name"]=> string(16) "GBA Penny Racers" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "26574" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> NULL ["products_price"]=> string(6) "4.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(11) "Manual only" ["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(29) "newstuffJanuary31_2018_70.jpg" ["products_name"]=> string(41) "GBA Pinobee Wings of Adventure NOE Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "40500" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "3.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(30) "newstuffNovember3_2023_045.jpg" ["products_name"]=> string(52) "GBA Pokemon - Mystery Dungeon - Team Rot NNOE Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79459" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "7.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "7.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.990000000000" } array(17) { ["products_image"]=> string(30) "newstuffNovember3_2023_047.jpg" ["products_name"]=> string(52) "GBA Pokemon - Mystery Dungeon - Team Rot NNOE Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79461" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "7.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["specials_new_products_price"]=> NULL ["final_price"]=> string(6) "7.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.990000000000" } array(17) { ["products_image"]=> string(30) "newstuffNovember3_2023_046.jpg" ["products_name"]=> string(48) "GBA Pokemon Pinball - Rubin & Saphir NNOE Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79460" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "29.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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_2023_041.jpg" ["products_name"]=> string(29) "GBA Sword of Mana NFRG Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79455" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "19.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(30) "newstuffNovember3_2023_013.jpg" ["products_name"]=> string(35) "GBA Tales of Phantasia NFHUG Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79429" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(7) "14.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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) "newstuffNovember3_2023_016.jpg" ["products_name"]=> string(57) "GBA The Legend of Zelda - A Link to the Past NFHUG Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "79432" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "9.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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(29) "newstuffJanuary31_2018_72.jpg" ["products_name"]=> string(20) "GBA Wings EUR Manual" ["products_quantity"]=> string(1) "1" ["products_id"]=> string(5) "40501" ["products_type"]=> string(1) "1" ["master_categories_id"]=> string(3) "192" ["manufacturers_id"]=> string(1) "0" ["products_price"]=> string(6) "4.9900" ["products_tax_class_id"]=> string(1) "3" ["products_description"]=> string(18) "

Manual only

" ["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" }