<?php 
/* SELECT `id`, `StudentCode`, `ParticipateTestId`, `Name`, `ParentsName`, `EmailId`, `DoB`, `Education`, `LastExaminationMarks`, `DistrictCode`, `TrainingCenterCode`, `State`, `IsActive`, `CreatedDate` FROM `tblstudents` WHERE 1 */
/* SELECT `id`, `StudentId`, `TestId`, `TestTypeId`, `QuestionId`, `QuestionMarks`, `IsActive`, `MarksDate` FROM `tblstudent_marks` WHERE 1 */
/* SELECT `id`, `StudentId`, `ParticipateTestId`, `IsAptitudeAccept`, `IsPersonalityAccept`, `IsInterestAccept`, `AptitudeStatus`, `PersonalityStatus`, `InterestStatus`, `IsActive`, `CreatedDate` FROM `tblstudents_test_status` WHERE 1 */
/* SELECT `id`, `TestId`, `VocationalCareerName`, `IsActive`, `CreatedDate` FROM `mtblvocational_career_name` WHERE 1 */
/* SELECT `id`, `TestId`, `TestTypeName`, `TotalQuestion`, `IsActive`, `CreatedDate` FROM `mtblcareer_test_type` WHERE 1 */

/* SELECT `id`, `TestId`, `TestTypeId`, `SectionName`, `TotalMap`, `IsActive`, `CreatedDate` FROM `mtblcareer_test_type_section` WHERE 1 */
/* 	SELECT  FROM mtblcareer_test_type_section s
left join mtblcareer_test_type_section_mapping sm on s.id=sm.SectionId
left join tblstudent_marks as m on m.QuestionId=sm.QuestionId
WHERE m.TestId=1 and s.TestTypeId=1 and m.TestTypeId=1 and m.StudentId=1 group by sm.SectionId order by sm.SectionId asc */

/* SELECT VocationalCareerId, count(VocationalCareerId) Total FROM `mtblvocational_career_group_mapping` WHERE GroupId in('8','18') group by VocationalCareerId having Total>1  */


/* SELECT * FROM `mtblcareer_test_type_questions` where TestId=2 and TestTypeId=3 order by QuestionId asc limit 12,6 */

 



