Sex Dolls
These dolls bring Japanese craftsmanship and product quality together in a unique harmony with Japanese sexual subcultures and fetishes. From anime character hug pillows to porn star replica dolls, from modestly priced air dolls to luxury silicone companions for life, our line of sex dolls is one of the most varied and original in the world.
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 (66,91,73,59,37,54,58) 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 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 (66,91,73,59,37,54,58) 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 p.paypal_blocked = 0 order by p.products_date_added desc, pd.products_name, p.products_id
