Filters
OR
SELECT DISTINCT p.products_image, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND c.categories_id <> 1 AND ((pd.products_name LIKE '%science%' OR p.products_model LIKE '%science%' OR p.products_author LIKE '%science%' OR m.manufacturers_name LIKE '%science%' OR (mtpd.metatags_keywords LIKE '%science%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%science%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%science%') and (pd.products_name LIKE '%iq%' OR p.products_model LIKE '%iq%' OR p.products_author LIKE '%iq%' OR m.manufacturers_name LIKE '%iq%' OR (mtpd.metatags_keywords LIKE '%iq%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%iq%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%iq%') and (pd.products_name LIKE '%challenge%' OR p.products_model LIKE '%challenge%' OR p.products_author LIKE '%challenge%' OR m.manufacturers_name LIKE '%challenge%' OR (mtpd.metatags_keywords LIKE '%challenge%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%challenge%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%challenge%') )) AND p.is_hidden = 0 order by p.products_sort_order, pd.products_name
OSDS mobile Banner 2017-18

Advanced Search


Product Image Item Name- Price
Science IQ Challenge

Science IQ Challenge

The Science IQ challenge book is a question practice book for competitive exams like National talent search exams and Science Olympiad exam. It is...
Content:    1.Physics 2.Chemistry 3.Biology 4.Everyday Science  5.National Science Olympiad 6.Answer
Rs.150.00



Science IQ Challenge (Instant download eBook)

Science IQ Challenge (Instant download eBook)

The Science IQ challenge book is a question practice book for competitive exams like National talent search exams and Science Olympiad exam. It is...
You can pay and download this book instantly. You do not have to wait for the shipment to arrive to start your preparation since in this case only...
Rs.130.00




Back
Have you seen ...
IEO Mocktest Banner