SELECT distinct(p.product_id),p.* FROM categories c, products p, products_mappings pm WHERE c.category_id = pm.category_id and p.product_id = pm.product_id and parent_category_id in (2001,2006,2879,2880,2881,2007,2008,2009,2062,2885) and p.online = 'Online' limit 400