0 Productos   Ver |  Realizar Pedido 

 0 productos   Ver |  Realizar Pedido 

More Fun & Play

List View
Array ( [0] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Bichiku Rin Rin Fashion Nipple Clips [value] => Bichiku Rin Rin Fashion Nipple Clips [special] => [link] => https://www.kanojotoys.com/ES-bichiku-rin-rin-fashion-nipple-clips-p-2859.html [product_id] => 2859 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Bichiku Rin Rin Fashion Nipple Clips [value] => Bichiku Rin Rin Fashion Nipple Clips [special] => [link] => https://www.kanojotoys.com/ES-bichiku-rin-rin-fashion-nipple-clips-p-2859.html [product_id] => 2859 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 6 [value] => € 6 [special] => [link] => [product_id] => 2859 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2859&action=buy_now&page=4 [product_id] => 2859 ) ) [1] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Bichiku Ran Ran Fashion Nipple Clamps [value] => Bichiku Ran Ran Fashion Nipple Clamps [special] => [link] => https://www.kanojotoys.com/ES-bichiku-ran-ran-fashion-nipple-clamps-p-2860.html [product_id] => 2860 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Bichiku Ran Ran Fashion Nipple Clamps [value] => Bichiku Ran Ran Fashion Nipple Clamps [special] => [link] => https://www.kanojotoys.com/ES-bichiku-ran-ran-fashion-nipple-clamps-p-2860.html [product_id] => 2860 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 20 [value] => € 20 [special] => [link] => [product_id] => 2860 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2860&action=buy_now&page=4 [product_id] => 2860 ) ) [2] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Chissai Ojisan 2 Small Man Tongue [value] => Chissai Ojisan 2 Small Man Tongue [special] => [link] => https://www.kanojotoys.com/ES-chissai-ojisan-small-man-tongue-p-2775.html [product_id] => 2775 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Chissai Ojisan 2 Small Man Tongue [value] => Chissai Ojisan 2 Small Man Tongue [special] => [link] => https://www.kanojotoys.com/ES-chissai-ojisan-small-man-tongue-p-2775.html [product_id] => 2775 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 14 [value] => € 14 [special] => [link] => [product_id] => 2775 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2775&action=buy_now&page=4 [product_id] => 2775 ) ) [3] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Okamoto Zero One 0.01mm Condoms [value] => Okamoto Zero One 0.01mm Condoms [special] => [link] => https://www.kanojotoys.com/ES-okamoto-zero-one-001mm-condoms-p-2770.html [product_id] => 2770 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Okamoto Zero One 0.01mm Condoms [value] => Okamoto Zero One 0.01mm Condoms [special] => [link] => https://www.kanojotoys.com/ES-okamoto-zero-one-001mm-condoms-p-2770.html [product_id] => 2770 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 11 [value] => € 11 [special] => [link] => [product_id] => 2770 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2770&action=buy_now&page=4 [product_id] => 2770 ) ) [4] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Kupaa Scope Pussy Viewer [value] => Kupaa Scope Pussy Viewer [special] => [link] => https://www.kanojotoys.com/ES-kupaa-scope-pussy-viewer-p-2738.html [product_id] => 2738 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Kupaa Scope Pussy Viewer [value] => Kupaa Scope Pussy Viewer [special] => [link] => https://www.kanojotoys.com/ES-kupaa-scope-pussy-viewer-p-2738.html [product_id] => 2738 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 11 [value] => € 11 [special] => [link] => [product_id] => 2738 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2738&action=buy_now&page=4 [product_id] => 2738 ) ) [5] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Hokka Hoka Onahole USB Warmer [value] => Hokka Hoka Onahole USB Warmer [special] => [link] => https://www.kanojotoys.com/ES-hokka-hoka-onahole-usb-warmer-p-2728.html [product_id] => 2728 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Hokka Hoka Onahole USB Warmer [value] => Hokka Hoka Onahole USB Warmer [special] => [link] => https://www.kanojotoys.com/ES-hokka-hoka-onahole-usb-warmer-p-2728.html [product_id] => 2728 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 11 [value] => € 11 [special] => [link] => [product_id] => 2728 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2728&action=buy_now&page=4 [product_id] => 2728 ) ) [6] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Chojiro Penis Pump [value] => Chojiro Penis Pump [special] => [link] => https://www.kanojotoys.com/ES-chojiro-penis-pump-p-2643.html [product_id] => 2643 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Chojiro Penis Pump [value] => Chojiro Penis Pump [special] => [link] => https://www.kanojotoys.com/ES-chojiro-penis-pump-p-2643.html [product_id] => 2643 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 21 [value] => € 21 [special] => [link] => [product_id] => 2643 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2643&action=buy_now&page=4 [product_id] => 2643 ) ) [7] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Play with Doctor Kit [value] => Play with Doctor Kit [special] => [link] => https://www.kanojotoys.com/ES-play-with-doctor-kit-p-2616.html [product_id] => 2616 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Play with Doctor Kit [value] => Play with Doctor Kit [special] => [link] => https://www.kanojotoys.com/ES-play-with-doctor-kit-p-2616.html [product_id] => 2616 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 23 [value] => € 23 [special] => [link] => [product_id] => 2616 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2616&action=buy_now&page=4 [product_id] => 2616 ) ) [8] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Finger Condoms [value] => Finger Condoms [special] => [link] => https://www.kanojotoys.com/ES-finger-condoms-p-2589.html [product_id] => 2589 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Finger Condoms [value] => Finger Condoms [special] => [link] => https://www.kanojotoys.com/ES-finger-condoms-p-2589.html [product_id] => 2589 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 39 [value] => € 39 [special] => [link] => [product_id] => 2589 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2589&action=buy_now&page=4 [product_id] => 2589 ) ) [9] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Disposable Speculum Vaginal Inspector [value] => Disposable Speculum Vaginal Inspector [special] => [link] => https://www.kanojotoys.com/ES-disposable-speculum-vaginal-inspector-p-2352.html [product_id] => 2352 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Disposable Speculum Vaginal Inspector [value] => Disposable Speculum Vaginal Inspector [special] => [link] => https://www.kanojotoys.com/ES-disposable-speculum-vaginal-inspector-p-2352.html [product_id] => 2352 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 12 [value] => € 12 [special] => [link] => [product_id] => 2352 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2352&action=buy_now&page=4 [product_id] => 2352 ) ) [10] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Sagami Original 0.01 Condoms [value] => Sagami Original 0.01 Condoms [special] => [link] => https://www.kanojotoys.com/ES-sagami-original-001-condoms-p-2033.html [product_id] => 2033 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Sagami Original 0.01 Condoms [value] => Sagami Original 0.01 Condoms [special] => [link] => https://www.kanojotoys.com/ES-sagami-original-001-condoms-p-2033.html [product_id] => 2033 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 13 [value] => € 13 [special] => [link] => [product_id] => 2033 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=2033&action=buy_now&page=4 [product_id] => 2033 ) ) [11] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Kaikan Tekoki Handjob Glove [value] => Kaikan Tekoki Handjob Glove [special] => [link] => https://www.kanojotoys.com/ES-kaikan-tekoki-handjob-glove-p-1610.html [product_id] => 1610 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Kaikan Tekoki Handjob Glove [value] => Kaikan Tekoki Handjob Glove [special] => [link] => https://www.kanojotoys.com/ES-kaikan-tekoki-handjob-glove-p-1610.html [product_id] => 1610 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 3 [value] => € 3 [special] => [link] => [product_id] => 1610 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=1610&action=buy_now&page=4 [product_id] => 1610 ) ) [12] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Higo Taiho Erection Pump [value] => Higo Taiho Erection Pump [special] => [link] => https://www.kanojotoys.com/ES-higo-taiho-erection-pump-p-1233.html [product_id] => 1233 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Higo Taiho Erection Pump [value] => Higo Taiho Erection Pump [special] => [link] => https://www.kanojotoys.com/ES-higo-taiho-erection-pump-p-1233.html [product_id] => 1233 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 324 [value] => € 324 [special] => [link] => [product_id] => 1233 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=1233&action=buy_now&page=4 [product_id] => 1233 ) ) [13] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Man's Trump Card Joker Spray [value] => Man's Trump Card Joker Spray [special] => [link] => https://www.kanojotoys.com/ES-mans-trump-card-joker-spray-p-1150.html [product_id] => 1150 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Man's Trump Card Joker Spray [value] => Man's Trump Card Joker Spray [special] => [link] => https://www.kanojotoys.com/ES-mans-trump-card-joker-spray-p-1150.html [product_id] => 1150 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 18 [value] => € 18 [special] => [link] => [product_id] => 1150 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=1150&action=buy_now&page=4 [product_id] => 1150 ) ) [14] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Te Kunishan Masturbation Glove [value] => Te Kunishan Masturbation Glove [special] => [link] => https://www.kanojotoys.com/ES-kunishan-masturbation-glove-p-1032.html [product_id] => 1032 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Te Kunishan Masturbation Glove [value] => Te Kunishan Masturbation Glove [special] => [link] => https://www.kanojotoys.com/ES-kunishan-masturbation-glove-p-1032.html [product_id] => 1032 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 7 [value] => € 7 [special] => [link] => [product_id] => 1032 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=1032&action=buy_now&page=4 [product_id] => 1032 ) ) [15] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Soapland Bath Sex Stool [value] => Soapland Bath Sex Stool [special] => [link] => https://www.kanojotoys.com/ES-soapland-bath-sex-stool-p-976.html [product_id] => 976 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Soapland Bath Sex Stool [value] => Soapland Bath Sex Stool [special] => [link] => https://www.kanojotoys.com/ES-soapland-bath-sex-stool-p-976.html [product_id] => 976 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 50 [value] => € 50 [special] => [link] => [product_id] => 976 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=976&action=buy_now&page=4 [product_id] => 976 ) ) [16] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Yumemusou [value] => Yumemusou [special] => [link] => https://www.kanojotoys.com/ES-yumemusou-p-772.html [product_id] => 772 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Yumemusou [value] => Yumemusou [special] => [link] => https://www.kanojotoys.com/ES-yumemusou-p-772.html [product_id] => 772 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 102 [value] => € 102 [special] => [link] => [product_id] => 772 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=772&action=buy_now&page=4 [product_id] => 772 ) ) [17] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Love Assist inflatable sex aid [value] => Love Assist inflatable sex aid [special] => [link] => https://www.kanojotoys.com/ES-love-assist-inflatable-sex-aid-p-385.html [product_id] => 385 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Love Assist inflatable sex aid [value] => Love Assist inflatable sex aid [special] => [link] => https://www.kanojotoys.com/ES-love-assist-inflatable-sex-aid-p-385.html [product_id] => 385 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => € 13 [value] => € 13 [special] => [link] => [product_id] => 385 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Añadir a la cesta [value] => Añadir a la cesta [special] => [link] => https://www.kanojotoys.com/ES-more-fun-play-c-48.html?products_id=385&action=buy_now&page=4 [product_id] => 385 ) ) ) select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_quantity, p.products_tax_class_id, p.products_sort_order, p.products_date_available, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c LEFT JOIN categories c ON c.categories_id = p2c.categories_id) left join specials s on p.products_id = s.products_id WHERE c.hidden = '0' AND p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '3' and p2c.categories_id = '48' AND (p.products_quantity > 0 OR p.products_date_available >= (NOW() - INTERVAL 1 DAY)) order by p.products_date_added DESC, pd.products_name, p.products_id