Back Catalog

Array ( [0] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/yukina-college-student-used-panties-p-4079.html [product_id] => 4079 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Yukina College Student Used Panties [value] => Yukina College Student Used Panties [special] => [link] => https://www.kanojotoys.com/yukina-college-student-used-panties-p-4079.html [product_id] => 4079 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4079 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4079 ) ) [1] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/otoko-crossdresser-padded-bra-and-panties-p-4073.html [product_id] => 4073 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Otoko no Ko Cross-dresser Padded Bra and Panties [value] => Otoko no Ko Cross-dresser Padded Bra and Panties [special] => [link] => https://www.kanojotoys.com/otoko-crossdresser-padded-bra-and-panties-p-4073.html [product_id] => 4073 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4073 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4073 ) ) [2] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/eromanko-xxsei-onahole-p-4067.html [product_id] => 4067 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Eromanko XXsei Onahole [value] => Eromanko XXsei Onahole [special] => [link] => https://www.kanojotoys.com/eromanko-xxsei-onahole-p-4067.html [product_id] => 4067 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4067 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4067 ) ) [3] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/asami-used-panties-with-female-cum-stains-p-4026.html [product_id] => 4026 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Asami Used Panties with Female Cum Stains [value] => Asami Used Panties with Female Cum Stains [special] => [link] => https://www.kanojotoys.com/asami-used-panties-with-female-cum-stains-p-4026.html [product_id] => 4026 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4026 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4026 ) ) [4] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/namiko-college-girl-stained-used-panties-p-4051.html [product_id] => 4051 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Namiko College Girl Stained Used Panties [value] => Namiko College Girl Stained Used Panties [special] => [link] => https://www.kanojotoys.com/namiko-college-girl-stained-used-panties-p-4051.html [product_id] => 4051 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4051 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4051 ) ) [5] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/sayaka-college-girl-used-panties-p-4041.html [product_id] => 4041 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Sayaka College Girl Used Panties [value] => Sayaka College Girl Used Panties [special] => [link] => https://www.kanojotoys.com/sayaka-college-girl-used-panties-p-4041.html [product_id] => 4041 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4041 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4041 ) ) [6] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/extreme-nub-pleasure-onahole-p-4064.html [product_id] => 4064 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Extreme Nub Pleasure Onahole [value] => Extreme Nub Pleasure Onahole [special] => [link] => https://www.kanojotoys.com/extreme-nub-pleasure-onahole-p-4064.html [product_id] => 4064 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4064 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4064 ) ) [7] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/full-bodystocking-costume-black-p-4057.html [product_id] => 4057 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Full Bodystocking Costume Black [value] => Full Bodystocking Costume Black [special] => [link] => https://www.kanojotoys.com/full-bodystocking-costume-black-p-4057.html [product_id] => 4057 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4057 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4057 ) ) [8] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/zurakyun-musume-mini-doll-with-costume-p-4056.html [product_id] => 4056 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Zurakyun Musume Mini Doll with Costume [value] => Zurakyun Musume Mini Doll with Costume [special] => [link] => https://www.kanojotoys.com/zurakyun-musume-mini-doll-with-costume-p-4056.html [product_id] => 4056 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4056 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4056 ) ) [9] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/juri-college-girl-stained-used-panties-p-4052.html [product_id] => 4052 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Juri College Girl Stained Used Panties [value] => Juri College Girl Stained Used Panties [special] => [link] => https://www.kanojotoys.com/juri-college-girl-stained-used-panties-p-4052.html [product_id] => 4052 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4052 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4052 ) ) [10] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/maiko-used-maternity-bra-pink-p-4040.html [product_id] => 4040 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Maiko Used Maternity Bra Pink [value] => Maiko Used Maternity Bra Pink [special] => [link] => https://www.kanojotoys.com/maiko-used-maternity-bra-pink-p-4040.html [product_id] => 4040 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4040 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4040 ) ) [11] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/otoko-lacy-babydoll-lingerie-p-4017.html [product_id] => 4017 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Otoko no Ko Lacy Babydoll Lingerie [value] => Otoko no Ko Lacy Babydoll Lingerie [special] => [link] => https://www.kanojotoys.com/otoko-lacy-babydoll-lingerie-p-4017.html [product_id] => 4017 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4017 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4017 ) ) [12] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/wakana-used-panties-p-4031.html [product_id] => 4031 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Wakana Used Panties [value] => Wakana Used Panties [special] => [link] => https://www.kanojotoys.com/wakana-used-panties-p-4031.html [product_id] => 4031 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4031 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4031 ) ) [13] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/emi-japanese-nurse-used-bra-and-panties-set-rose-p-4029.html [product_id] => 4029 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Emi Japanese Nurse Used Bra and Panties Set Rose [value] => Emi Japanese Nurse Used Bra and Panties Set Rose [special] => [link] => https://www.kanojotoys.com/emi-japanese-nurse-used-bra-and-panties-set-rose-p-4029.html [product_id] => 4029 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4029 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4029 ) ) [14] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/found-used-panties-p-4028.html [product_id] => 4028 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Found Used Panties [value] => Found Used Panties [special] => [link] => https://www.kanojotoys.com/found-used-panties-p-4028.html [product_id] => 4028 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4028 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4028 ) ) [15] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/nanako-used-maternity-bra-p-4011.html [product_id] => 4011 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Nanako Used Maternity Bra [value] => Nanako Used Maternity Bra [special] => [link] => https://www.kanojotoys.com/nanako-used-maternity-bra-p-4011.html [product_id] => 4011 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4011 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4011 ) ) [16] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/yumiko-used-panties-p-4013.html [product_id] => 4013 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Yumiko Used Panties [value] => Yumiko Used Panties [special] => [link] => https://www.kanojotoys.com/yumiko-used-panties-p-4013.html [product_id] => 4013 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4013 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4013 ) ) [17] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/sexy-cocoon-full-bodystocking-p-4002.html [product_id] => 4002 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Sexy Cocoon Full Bodystocking [value] => Sexy Cocoon Full Bodystocking [special] => [link] => https://www.kanojotoys.com/sexy-cocoon-full-bodystocking-p-4002.html [product_id] => 4002 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4002 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4002 ) ) [18] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/campus-life-matchmaking-party-date-onahole-p-4008.html [product_id] => 4008 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Campus Life Matchmaking Party Date Onahole [value] => Campus Life Matchmaking Party Date Onahole [special] => [link] => https://www.kanojotoys.com/campus-life-matchmaking-party-date-onahole-p-4008.html [product_id] => 4008 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4008 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4008 ) ) [19] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/risa-office-lady-used-negligee-p-4006.html [product_id] => 4006 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Risa Office Lady Used Negligee [value] => Risa Office Lady Used Negligee [special] => [link] => https://www.kanojotoys.com/risa-office-lady-used-negligee-p-4006.html [product_id] => 4006 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4006 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4006 ) ) [20] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/floral-babydoll-lingerie-costume-p-4005.html [product_id] => 4005 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Floral Babydoll Lingerie Costume [value] => Floral Babydoll Lingerie Costume [special] => [link] => https://www.kanojotoys.com/floral-babydoll-lingerie-costume-p-4005.html [product_id] => 4005 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 4005 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 4005 ) ) [21] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/animalchan-leopard-print-sexy-bondage-lingerie-p-3994.html [product_id] => 3994 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Animal-chan Leopard Print Sexy Bondage Lingerie [value] => Animal-chan Leopard Print Sexy Bondage Lingerie [special] => [link] => https://www.kanojotoys.com/animalchan-leopard-print-sexy-bondage-lingerie-p-3994.html [product_id] => 3994 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 3994 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 3994 ) ) [22] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/rori-panties-underwear-costume-set-p-3987.html [product_id] => 3987 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Rori Panties Underwear Costume Set [value] => Rori Panties Underwear Costume Set [special] => [link] => https://www.kanojotoys.com/rori-panties-underwear-costume-set-p-3987.html [product_id] => 3987 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 3987 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 3987 ) ) [23] => Array ( [PRODUCT_LIST_IMAGE] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => [special] => [link] => https://www.kanojotoys.com/sexy-zorro-lady-costume-p-3989.html [product_id] => 3989 ) [PRODUCT_LIST_NAME] => Array ( [align] => [params] => class="productGrid-data" [text] => Sexy Zorro Lady Costume [value] => Sexy Zorro Lady Costume [special] => [link] => https://www.kanojotoys.com/sexy-zorro-lady-costume-p-3989.html [product_id] => 3989 ) [PRODUCT_LIST_PRICE] => Array ( [align] => center [params] => class="productGrid-data" [text] => SOLD OUT [value] => SOLD OUT [special] => [link] => [product_id] => 3989 ) [PRODUCT_LIST_BUY_NOW] => Array ( [align] => center [params] => class="productGrid-data" [text] => [value] => Sold Out [special] => [link] => [product_id] => 3989 ) ) ) 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 p2c.categories_id > 0 AND p.products_status = '1' AND p.products_quantity = 0 AND p.products_date_available IS NULL and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' order by p.products_date_added DESC, pd.products_name