0 items in cart   View |  Checkout 

 0 items   View |  Checkout 

Smell Fetish

List View
Array ( [0] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Boy's Penis Smell Bottle [value] => Boy's Penis Smell Bottle [special] => [link] => https://www.kanojotoys.com/boys-penis-smell-bottle-p-4084.html [product_id] => 4084 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Boy's Penis Smell Bottle [value] => Boy's Penis Smell Bottle [special] => [link] => https://www.kanojotoys.com/boys-penis-smell-bottle-p-4084.html [product_id] => 4084 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 13 [value] => US$ 13 [special] => [link] => [product_id] => 4084 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=4084&action=buy_now&page=2 [product_id] => 4084 ) ) [1] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Scent of Girl's Room Smell Fetish Spray [value] => Scent of Girl's Room Smell Fetish Spray [special] => [link] => https://www.kanojotoys.com/scent-girls-room-smell-fetish-spray-p-3930.html [product_id] => 3930 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Scent of Girl's Room Smell Fetish Spray [value] => Scent of Girl's Room Smell Fetish Spray [special] => [link] => https://www.kanojotoys.com/scent-girls-room-smell-fetish-spray-p-3930.html [product_id] => 3930 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 12 [value] => US$ 12 [special] => [link] => [product_id] => 3930 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=3930&action=buy_now&page=2 [product_id] => 3930 ) ) [2] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Ama Free Diver Jukujo Crotch Smell [value] => Ama Free Diver Jukujo Crotch Smell [special] => [link] => https://www.kanojotoys.com/ama-free-diver-jukujo-crotch-smell-p-3749.html [product_id] => 3749 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Ama Free Diver Jukujo Crotch Smell [value] => Ama Free Diver Jukujo Crotch Smell [special] => [link] => https://www.kanojotoys.com/ama-free-diver-jukujo-crotch-smell-p-3749.html [product_id] => 3749 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => COMING SOON [value] => COMING SOON [special] => [link] => [product_id] => 3749 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Preorder [special] => [link] => [product_id] => 3749 ) ) [3] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Classmate Panties with Smell Fetish Bottle [value] => Classmate Panties with Smell Fetish Bottle [special] => [link] => https://www.kanojotoys.com/classmate-panties-with-smell-fetish-bottle-p-3718.html [product_id] => 3718 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Classmate Panties with Smell Fetish Bottle [value] => Classmate Panties with Smell Fetish Bottle [special] => [link] => https://www.kanojotoys.com/classmate-panties-with-smell-fetish-bottle-p-3718.html [product_id] => 3718 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 46 [value] => US$ 46 [special] => [link] => [product_id] => 3718 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=3718&action=buy_now&page=2 [product_id] => 3718 ) ) [4] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Middle Sister Japanese Gyaru Aroma Spray [value] => Middle Sister Japanese Gyaru Aroma Spray [special] => [link] => https://www.kanojotoys.com/middle-sister-japanese-gyaru-aroma-spray-p-3698.html [product_id] => 3698 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Middle Sister Japanese Gyaru Aroma Spray [value] => Middle Sister Japanese Gyaru Aroma Spray [special] => [link] => https://www.kanojotoys.com/middle-sister-japanese-gyaru-aroma-spray-p-3698.html [product_id] => 3698 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 12 [value] => US$ 12 [special] => [link] => [product_id] => 3698 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=3698&action=buy_now&page=2 [product_id] => 3698 ) ) [5] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Scent of School Girls Sportswear Gym Uniform Smell [value] => Scent of School Girls Sportswear Gym Uniform Smell [special] => [link] => https://www.kanojotoys.com/scent-school-girls-sportswear-gym-uniform-smell-p-3694.html [product_id] => 3694 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Scent of School Girls Sportswear Gym Uniform Smell [value] => Scent of School Girls Sportswear Gym Uniform Smell [special] => [link] => https://www.kanojotoys.com/scent-school-girls-sportswear-gym-uniform-smell-p-3694.html [product_id] => 3694 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 12 [value] => US$ 12 [special] => [link] => [product_id] => 3694 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=3694&action=buy_now&page=2 [product_id] => 3694 ) ) [6] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Eldest Sister Aroma Spray [value] => Eldest Sister Aroma Spray [special] => [link] => https://www.kanojotoys.com/eldest-sister-aroma-spray-p-3679.html [product_id] => 3679 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Eldest Sister Aroma Spray [value] => Eldest Sister Aroma Spray [special] => [link] => https://www.kanojotoys.com/eldest-sister-aroma-spray-p-3679.html [product_id] => 3679 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 12 [value] => US$ 12 [special] => [link] => [product_id] => 3679 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=3679&action=buy_now&page=2 [product_id] => 3679 ) ) [7] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Scent of High School Girl Night Juices Smell Bottle [value] => Scent of High School Girl Night Juices Smell Bottle [special] => [link] => https://www.kanojotoys.com/scent-high-school-girl-night-juices-smell-bottle-p-3252.html [product_id] => 3252 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Scent of High School Girl Night Juices Smell Bottle [value] => Scent of High School Girl Night Juices Smell Bottle [special] => [link] => https://www.kanojotoys.com/scent-high-school-girl-night-juices-smell-bottle-p-3252.html [product_id] => 3252 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 12 [value] => US$ 12 [special] => [link] => [product_id] => 3252 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=3252&action=buy_now&page=2 [product_id] => 3252 ) ) [8] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Japanese Schoolgirl Sailor Uniform Scent Spray [value] => Japanese Schoolgirl Sailor Uniform Scent Spray [special] => [link] => https://www.kanojotoys.com/japanese-schoolgirl-sailor-uniform-scent-spray-p-2346.html [product_id] => 2346 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Japanese Schoolgirl Sailor Uniform Scent Spray [value] => Japanese Schoolgirl Sailor Uniform Scent Spray [special] => [link] => https://www.kanojotoys.com/japanese-schoolgirl-sailor-uniform-scent-spray-p-2346.html [product_id] => 2346 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 12 [value] => US$ 12 [special] => [link] => [product_id] => 2346 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=2346&action=buy_now&page=2 [product_id] => 2346 ) ) [9] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Shihori Endo Pregnant Young Wife Smell Perfume [value] => Shihori Endo Pregnant Young Wife Smell Perfume [special] => [link] => https://www.kanojotoys.com/shihori-endo-pregnant-young-wife-smell-perfume-p-2223.html [product_id] => 2223 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Shihori Endo Pregnant Young Wife Smell Perfume [value] => Shihori Endo Pregnant Young Wife Smell Perfume [special] => [link] => https://www.kanojotoys.com/shihori-endo-pregnant-young-wife-smell-perfume-p-2223.html [product_id] => 2223 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 10 [value] => US$ 10 [special] => [link] => [product_id] => 2223 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=2223&action=buy_now&page=2 [product_id] => 2223 ) ) [10] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Love Doll Smell Spray Aika Pee Aroma [value] => Love Doll Smell Spray Aika Pee Aroma [special] => [link] => https://www.kanojotoys.com/love-doll-smell-spray-aika-pee-aroma-p-2219.html [product_id] => 2219 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Love Doll Smell Spray Aika Pee Aroma [value] => Love Doll Smell Spray Aika Pee Aroma [special] => [link] => https://www.kanojotoys.com/love-doll-smell-spray-aika-pee-aroma-p-2219.html [product_id] => 2219 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 10 [value] => US$ 10 [special] => [link] => [product_id] => 2219 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=2219&action=buy_now&page=2 [product_id] => 2219 ) ) [11] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Love Doll Smell Spray Ranko Sweat Aroma [value] => Love Doll Smell Spray Ranko Sweat Aroma [special] => [link] => https://www.kanojotoys.com/love-doll-smell-spray-ranko-sweat-aroma-p-2182.html [product_id] => 2182 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Love Doll Smell Spray Ranko Sweat Aroma [value] => Love Doll Smell Spray Ranko Sweat Aroma [special] => [link] => https://www.kanojotoys.com/love-doll-smell-spray-ranko-sweat-aroma-p-2182.html [product_id] => 2182 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 10 [value] => US$ 10 [special] => [link] => [product_id] => 2182 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=2182&action=buy_now&page=2 [product_id] => 2182 ) ) [12] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Love Doll Smell Spray Nana Period Menstruation Aroma [value] => Love Doll Smell Spray Nana Period Menstruation Aroma [special] => [link] => https://www.kanojotoys.com/love-doll-smell-spray-nana-period-menstruation-aroma-p-2181.html [product_id] => 2181 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Love Doll Smell Spray Nana Period Menstruation Aroma [value] => Love Doll Smell Spray Nana Period Menstruation Aroma [special] => [link] => https://www.kanojotoys.com/love-doll-smell-spray-nana-period-menstruation-aroma-p-2181.html [product_id] => 2181 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 10 [value] => US$ 10 [special] => [link] => [product_id] => 2181 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=2181&action=buy_now&page=2 [product_id] => 2181 ) ) [13] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Wife Armpit Smell Perfume Chisa Kirishima [value] => Wife Armpit Smell Perfume Chisa Kirishima [special] => [link] => https://www.kanojotoys.com/wife-armpit-smell-perfume-chisa-kirishima-p-2174.html [product_id] => 2174 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Wife Armpit Smell Perfume Chisa Kirishima [value] => Wife Armpit Smell Perfume Chisa Kirishima [special] => [link] => https://www.kanojotoys.com/wife-armpit-smell-perfume-chisa-kirishima-p-2174.html [product_id] => 2174 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => COMING SOON [value] => COMING SOON [special] => [link] => [product_id] => 2174 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Preorder [special] => [link] => [product_id] => 2174 ) ) [14] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => Japanese Teen Girl Smell Lotion [value] => Japanese Teen Girl Smell Lotion [special] => [link] => https://www.kanojotoys.com/japanese-teen-girl-smell-lotion-p-1530.html [product_id] => 1530 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Japanese Teen Girl Smell Lotion [value] => Japanese Teen Girl Smell Lotion [special] => [link] => https://www.kanojotoys.com/japanese-teen-girl-smell-lotion-p-1530.html [product_id] => 1530 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => US$ 12 [value] => US$ 12 [special] => [link] => [product_id] => 1530 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => Add to cart [value] => Add to cart [special] => [link] => https://www.kanojotoys.com/smell-fetish-c-65.html?products_id=1530&action=buy_now&page=2 [product_id] => 1530 ) ) ) 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 = '1' and p2c.categories_id = '65' 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