SELECT l6.id, l6.parent_id, l6.level_type, l6.name, l6.db_id, l6.ldate, count(DISTINCT l7.name) 
FROM levels l1 
JOIN levels l2 ON (l2.parent_id=l1.id) 
JOIN levels l3 ON (l3.parent_id=l2.id) 
JOIN levels l4 ON (l4.parent_id=l3.id) 
JOIN levels l5 ON (l5.parent_id=l4.id) 
JOIN levels l6 ON (l6.parent_id=l5.id) 
JOIN levels l7 ON (l7.parent_id=l6.id) 

WHERE l1.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%bd') 
AND l2.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%complex') 
AND l3.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%region') 
AND l4.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%mest') 
AND l5.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%well') 
AND l6.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%task') 
AND l7.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%logdate') 
AND (l1.db_id =  1 ) 
AND (l1.name='02') 
AND (l2.name='Контроль') 
AND (l3.name='Бла-бла-бла') 
AND (l4.name='501') 
AND (l5.name='106R') 

GROUP BY l6.id, l6.parent_id, l6.level_type, l6.name, l6.db_id, l6.ldate 

ORDER BY l6.ldate, l6.name

SELECT f.ftype, f.path, f.extra_path, f.name, pn.name, f.id_level, tn.name, cn.name, cv.start_v, cv.stop_v, cv.step, cv.n_vers, l7.id, l7.parent_id, l7.level_type, l7.name, l7.db_id, l7.ldate 
FROM levels l1 
JOIN levels l2 ON (l2.parent_id=l1.id) 
JOIN levels l3 ON (l3.parent_id=l2.id) 
JOIN levels l4 ON (l4.parent_id=l3.id) 
JOIN levels l5 ON (l5.parent_id=l4.id) 
JOIN levels l6 ON (l6.parent_id=l5.id) 
JOIN levels l7 ON (l7.parent_id=l6.id) 

JOIN files f ON f.id_level=l7.id 
JOIN (table_names tn JOIN tables t ON tn.id = t.name_id) ON f.id = t.id_ws 
JOIN table_rows r ON r.id_table = t.id 
JOIN (curve_names cn JOIN curv_versions cv ON cn.id = cv.name_id) ON cv.id_row = r.id 
LEFT JOIN (plansh_names pn JOIN planshets p ON p.name_id=pn.id) ON p.id_ws=f.id 

WHERE l1.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%bd') 
AND l2.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%complex') 
AND l3.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%region') 
AND l4.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%mest') 
AND l5.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%well') 
AND l6.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%task') 
AND l7.level_type = (SELECT lt.type_v FROM level_types lt WHERE lt.name='%logdate') 

AND (l1.db_id =  1 ) 
AND (l1.name='03') 
AND (l2.name='Контроль') 
AND (l3.name='Бла-бла-бла') 
AND (l4.name='501') 
AND (l5.name='93R') 
AND (l6.name='INTOK') 

ORDER BY l7.ldate, l7.name