Purchase mobileappIcon Download our Mobile App
Call Us at 011-40705070  or  
Click to Call
Select your Board & Class
  • Select Board
  • Select Class
Customized Course: If you want our counselors to design a course best suited for you click here to leave your contact details
  Select Board & Class        
0 Selected Course(s)
MRP : Rs. 0
Offer Price: Rs. 0
Prices are inclusive of all taxes.
Note: All courses are valid till April 15, 2015, unless stated otherwise.
(slave2) 8 queries took 104 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT subjectId, SUM(IF(hasLp='1',1,0)) AS hasLp, SUM(IF(hasCurr='1',1,0)) AS hasCurr, SUM(IF(isSolutionPaid='1',1,0)) AS isSolutionPaid, SUM(IF(hasPuzzle>='1',1,0)) AS hasPuzzle, SUM(IF(hasChapterTest='1',1,0)) AS hasChapterTest, SUM(IF(hasModelTest='1',1,0)) AS hasModelTest, SUM(IF(hasBoardTest='1',1,0)) AS hasBoardTest, SUM(IF(hasSubjectTest='1',1,0)) AS hasSubjectTest, SUM(IF(hasTestGenerator='1',1,0)) AS hasTestGenerator, SUM(IF(hasFat='1',1,0)) AS hasFat, SUM(IF(hasRevisionNotes='1',1,0)) AS hasRevisionNotes, SUM(IF(hasLiveTestSeries='1',1,0)) AS hasLiveTestSeries, SUM(IF(hasBoardTest='1',1,0)) AS hasBoardTest, SUM(IF(hasTranslation='1',1,0)) AS hasTranslation, SUM(IF(hasTranslation='2',1,0)) AS hasSummary, SUM(IF(hasOtba='1',1,0)) AS hasOtba FROM textbooks WHERE gradeId='9' AND curriculumId='1' AND isActive='1' GROUP BY subjectId10102
2SELECT t.id,t.title,t.name,t.flow,t.subjectId,s.name as subjectName FROM `textbooks` t inner join subjects s on (t.subjectId=s.id and s.isActive='1') WHERE t.curriculumId='1' and t.gradeId='9' and t.isActive='1' and (hasTextbookSolution='1' or hasTextbookSolution='2') order by flow 551
3SELECT SUM(IF(hasChapterTest='1',1,0)) AS hasChapterTest FROM textbooks WHERE gradeId='9' AND subjectId='9'111
4SELECT COUNT(*) AS `count` FROM `product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`id`='104543' AND CURDATE() BETWEEN startDate AND endDate111
5 SELECT Product.id, GROUP_CONCAT(ProductSubjectMap.subjectId) subjectIds,Product.categoryId, Product.gradeId,Product.isAddOn, Product.title, Product.subTitle, Product.isOffline, Product.contentDetail, Product.type, Product.description, Product.curriculumId, ProductFee.fee, ProductFee.origFee, Curriculum.name, Grade.name,Curriculum.isShared, Product.tooltip, if(ProductExpiration.type = '1',DATE_FORMAT(ProductExpiration.expiryDate,'%D %b %Y'),DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL ProductExpiration.days DAY),'%D %b %Y')) as expiryDate FROM products Product INNER JOIN product_fees ProductFee ON (Product.id=ProductFee.productId) INNER JOIN product_subject_map ProductSubjectMap on (ProductSubjectMap.productId=Product.id and ProductSubjectMap.isActive = '1') INNER JOIN curriculums AS Curriculum ON (Product.curriculumId = Curriculum.id) INNER JOIN grades AS Grade ON (Product.gradeId = Grade.id) INNER JOIN product_expiration ProductExpiration on (Product.id = ProductExpiration.productId and ProductExpiration.isActive = '1') WHERE Product.isActive ='1' AND now() between ProductFee.startDate AND ProductFee.endDate AND now() BETWEEN ProductExpiration.startDate AND ProductExpiration.endDate GROUP BY Product.id ORDER BY Product.curriculumId, Product.gradeId, Product.isAddOn, Product.flow, Product.id;70570588
6 SELECT curriculumId, curriculumName,gradeId,gradeName, gradeFlow, subjectName, flow, isActive, isSelectable from (SELECT DISTINCT(Curriculum.id) curriculumId, Curriculum.displayOrder flow, Curriculum.isActive, Curriculum.isSelectable, Curriculum.name curriculumName, Grade.id gradeId, Grade.flow gradeFlow, Grade.name gradeName, '' subjectName FROM products Product INNER JOIN curriculums Curriculum ON Curriculum.id = Product.curriculumId INNER JOIN grades Grade ON Grade.id = Product.gradeId AND Grade.isActive = '1' WHERE Curriculum.isActive = '1' AND Product.isActive = '1' GROUP BY gradeId,curriculumId order by Curriculum.displayOrder,Curriculum.name) as ChapterSummary ORDER BY flow,curriculumName,gradeFlow; 99995
7 SELECT Product.id, Product.gradeId, Product.title, Product.subTitle, Product.contentDetail,Product.type, Product.description, Product.curriculumId,Product.categoryId, ProductFee.fee, ProductFee.origFee, Product.tooltip, if(ProductExpiration.type = '1',DATE_FORMAT(ProductExpiration.expiryDate,'%D %b %Y'),DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL ProductExpiration.days DAY),'%D %b %Y')) as expiryDate FROM products Product INNER JOIN product_fees ProductFee ON (Product.id=ProductFee.productId) INNER JOIN product_expiration ProductExpiration on (Product.id = ProductExpiration.productId and ProductExpiration.isActive = '1') WHERE (Product.id IN (263,264) OR (Product.isOffline='1' AND Product.categoryId=11)) AND Product.isActive ='1' AND now() between ProductFee.startDate AND ProductFee.endDate AND now() BETWEEN ProductExpiration.startDate AND ProductExpiration.endDate ORDER BY Product.curriculumId, Product.gradeId, Product.flow, Product.parentId, Product.id; 37373
8SELECT `TestSeriesSchedule`.`id`, `TestSeriesSchedule`.`testType`, `TestSeriesSchedule`.`curriculumId`, `TestSeriesSchedule`.`gradeId`, `TestSeriesSchedule`.`subject`, `TestSeriesSchedule`.`scheduleDate`, `TestSeriesSchedule`.`status`, `TestSeriesSchedule`.`created`, `TestSeriesSchedule`.`modified` FROM `test_series_schedules` AS `TestSeriesSchedule` WHERE `TestSeriesSchedule`.`status` = '1' ORDER BY `TestSeriesSchedule`.`scheduleDate` ASC6406403