BQExn6i2

1SELECT COUNT(*) totalCollegiates, SUM(getFee(c.collegiate_id, dateS)) totalMoney
2FROM collegiates c
3LEFT JOIN (
4    SELECT collegiate_id FROM collegiateRemittances r
5    INNER JOIN remittances r1 USING(remittance_id)
6    WHERE r1.type_id = 1 AND r1.name = remesa   
7) hasRemittance ON hasRemittance.collegiate_id = c.collegiate_id
8WHERE hasRemittance.collegiate_id IS NULL AND c.typePayment = 1 AND c.active = 1 AND c.exentFee = 0 AND c.approvedBoard = 1 AND IF(notCollegiate, c.collegiate_id NOT IN (notCollegiate), '1=1');
9
10
11
12DROP TEMPORARY TABLE IF EXISTS hasRemittance;
13
14CREATE TEMPORARY TABLE hasRemittance
15    SELECT collegiate_id FROM collegiateRemittances r
16    INNER JOIN remittances r1 USING(remittance_id)
17    WHERE r1.type_id = 1 AND r1.name = remesa;
18
19SELECT COUNT(*) totalCollegiates, SUM(getFee(c.collegiate_id, dateS)) totalMoney
20FROM collegiates c
21LEFT JOIN hasRemittance ON hasRemittance.collegiate_id = c.collegiate_id
22WHERE hasRemittance.collegiate_id IS NULL AND c.typePayment = 1 AND c.active = 1 AND c.exentFee = 0 AND c.approvedBoard = 1 AND IF(notCollegiate, c.collegiate_id NOT IN (notCollegiate), '1=1');