SELECT *
FROM absent AS a
INNER JOIN report AS r ON r.report_id = a.report_id
INNER JOIN vkinfo AS v ON v.staticperson_id = r.staticperson_id
INNER JOIN tablelog AS tlabm ON tlabm.entetyid = a.absent_id
INNER JOIN tablename AS tnabm ON tnabm.tablename_id = tlabm.tablename_id
INNER JOIN z_eventdate_person AS ze ON ze.staticperson_id = r.staticperson_id
INNER JOIN z_contingent_eventdate AS zc ON zc.eventdate_id = ze.eventdate_id
INNER JOIN contingent AS c ON c.contingent_id = zc.contingent_id
WHERE tnabm.tablename LIKE 'absent'
AND tlabm.state_id =1
AND c.contingent = '18/06'
AND tlabm.date < CURDATE() - INTERVAL 8 DAY
AND a.absentfrom <= c.contingent_to AND a.absentto >= c.contingent_from
GROUP BY a.absent_id