Lingerie / Cosplay
From crazy character cosplay outfits to incredible underwear, our range of lingerie wear includes the top Japanese adult and fetish clothing items available online. Try exciting new role plays and make your kinkiest sexual fantasies a reality by dressing up for a partner.
select count(p.products_id) as total 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_quantity > 0 or p.products_date_available >= (now() - interval 1 day)) and p2c.categories_id in (43,96,97,98,99,100,95,77) and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '5' and p.paypal_blocked = 0
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_base_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_quantity > 0 or p.products_date_available >= (now() - interval 1 day)) and p2c.categories_id in (43,96,97,98,99,100,95,77) and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '5' and p.paypal_blocked = 0 order by p.products_date_added desc, pd.products_name, p.products_id
