Generate 1st Merit List

[ErSKS]

Rules

1. Sort Applicants as per their Rank
2. Priorities with same value
3. Display As per quota

Merit List will be different for various programs

[ErSKS]

For BE Civil - Nagar

1. Sort by Rank
2. Conditions: p1=1 || p2=1 || p3=1
3. Quota = N
4. Display 29 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Bhaktapur Municipality" AND (dept_id_p1=1 OR dept_id_p2=1 OR dept_id_p3=1) ORDER BY entrance_rank LIMIT 29;

[ErSKS]

For BE Civil - District

1. Sort by Rank
2. Conditions: p1=1 || p2=1 || p3=1
3. Quota = D
4. Display 24 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Bhaktapur District" AND (dept_id_p1=1 OR dept_id_p2=1 OR dept_id_p3=1) ORDER BY entrance_rank LIMIT 24;

[ErSKS]

For BE Civil - Remote

1. Sort by Rank
2. Conditions: p1=1 || p2=1 || p3=1
3. Quota = R
4. Display 5 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Remote Area" AND (dept_id_p1=1 OR dept_id_p2=1 OR dept_id_p3=1) ORDER BY entrance_rank LIMIT 5;

[ErSKS]

For BE Civil - General

1. Sort by Rank
2. Conditions: p1=1 || p2=1 || p3=1
3. Quota = O
4. Display 38 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Other" AND (dept_id_p1=1 OR dept_id_p2=1 OR dept_id_p3=1) ORDER BY entrance_rank LIMIT 38;

[ErSKS]

Cross-Checked !

[ErSKS]

For BE Electrical - Nagar

1. Sort by Rank
2. Conditions: p1=2 || p2=2 || p3=2
3. Quota = N
4. Display 14 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Bhaktapur Municipality" AND (dept_id_p1=2 OR dept_id_p2=2 OR dept_id_p3=2) ORDER BY entrance_rank LIMIT 14;

[ErSKS]

For BE Electrical - District

1. Sort by Rank
2. Conditions: p1=2 || p2=2 || p3=2
3. Quota = D
4. Display 12 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Bhaktapur District" AND (dept_id_p1=2 OR dept_id_p2=2 OR dept_id_p3=2) ORDER BY entrance_rank LIMIT 12;

[ErSKS]

For BE Electrical - Remote

1. Sort by Rank
2. Conditions: p1=2 || p2=2 || p3=2
3. Quota = R
4. Display 2 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Remote Area" AND (dept_id_p1=2 OR dept_id_p2=2 OR dept_id_p3=2) ORDER BY entrance_rank LIMIT 2;

[ErSKS]

For BE Electrical - General

1. Sort by Rank
2. Conditions: p1=2 || p2=2 || p3=2
3. Quota = O
4. Display 20 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Other" AND (dept_id_p1=2 OR dept_id_p2=2 OR dept_id_p3=2) ORDER BY entrance_rank LIMIT 20;

[ErSKS]

BE Computer 1st Merit List - Remains

[ErSKS]

For BE Computer - Nagar

1. Sort by Rank
2. Conditions: p1=3 || p2=3 || p3=3
3. Quota = N
4. Display 14 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Bhaktapur Municipality" AND (dept_id_p1=3 OR dept_id_p2=3 OR dept_id_p3=3) ORDER BY entrance_rank LIMIT 14;

[ErSKS]

For BE Computer - District

1. Sort by Rank
2. Conditions: p1=3 || p2=3 || p3=3
3. Quota = D
4. Display 12 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Bhaktapur District" AND (dept_id_p1=3 OR dept_id_p2=3 OR dept_id_p3=3) ORDER BY entrance_rank LIMIT 12;

[ErSKS]

For BE Computer - Remote

1. Sort by Rank
2. Conditions: p1=3 || p2=3 || p3=3
3. Quota = R
4. Display 2 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Remote Area" AND (dept_id_p1=3 OR dept_id_p2=3 OR dept_id_p3=3) ORDER BY entrance_rank LIMIT 2;

[ErSKS]

For BE Computer - General

1. Sort by Rank
2. Conditions: p1=3 || p2=3 || p3=3
3. Quota = O
4. Display 20 Applicants

SELECT id, entrance_rank, firstName, middleName, lastName, amount_paid, dept_id_p1, dept_id_p2, dept_id_p3, district_id, quota FROM student_apply WHERE verified=1 AND quota="Other" AND (dept_id_p1=3 OR dept_id_p2=3 OR dept_id_p3=3) ORDER BY entrance_rank LIMIT 20;

[ErSKS]

Final Note: No duplicate listing of same applicant. Make listing of them as per their priority for example If an applicant is listed on both BE Civil & BE Electrical, but his/her priority was P1: Civil & P2: Electrical then display him/her only in Merit list of Civil.