Filters
OR
select p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where 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 = '67' and p.is_hidden = 0
20% on workbook-combo banner-2017-Mobile inner

General Knowledge Books



Product Image Item Name- Price
Learning and Knowing Class 1

Learning and Knowing Class 1

Content:-   Number Magic Patterns Mother Nature Animals' Sounds Name these Flowers Fruits and Vegetables Animal World Food of...
Rs.175.00



Learning and Knowing Class 2

Learning and Knowing Class 2

Contents MOTHER NATURE : Large Mammals/SmallMammals/BirdsReptiles and AmphibiansWater Animals/Insect World/FruitsFlowers   MY SURROUNDINGS :...
Rs.175.00



Learning and Knowing Class 3

Learning and Knowing Class 3

Contents   MOTHER NATURE:Insect World/Did You Know ? /Animals of the Sea/Extinct and Endangered /Animals/Flora/Why Do We Need Plants? /Name...
Rs.200.00



Learning and Knowing Class 4

Learning and Knowing Class 4

Contents   MOTHER NATURE:Insects Near Us/The World of Birds/Identify Birds/Marine Animals/Graceful Trees/What do we get from trees? /Facts...
Rs.220.00



Learning and Knowing Class 5

Learning and Knowing Class 5

Contents   SCIENCE AND TECHNOLOGY:Body Systems/Body Search/Medical Specialists/Communicable Diseases/Computers Everywhere/Let's Get...
Rs.220.00



Learning and Knowing Class 6

Learning and Knowing Class 6

Contents   INDIA, MY COUNTRY:Rulers of India/Our Languages/Diverse Dresses/The Beautiful North-East/Land of Festivals/Indian Awards/Yoga : For...
Rs.250.00



Learning and Knowing Class 7

Learning and Knowing Class 7

Content:- Space Travel Biodiesel Net Terminology Mother Nature Flora of India Medicine from Plants Birds of India Kingdom of the Ocean Our...
Rs.250.00



Learning and Knowing Class 8

Learning and Knowing Class 8

Content:- Mother Nature Connecting the Dots of Nature Rainforests Animal Body Facts Desert Life Ornithology Animals in Adversity Mountains of...
Rs.250.00




How to buy (Video)
20% on workbook-combo banner-2017