SELECT DISTINCT 
inv.name_paying_phy, 
std.last_name_std, 
std.first_name_std,
lvl.name_lvl,
clg.name_clg  
FROM invoice inv 
JOIN invoice_detail invd ON inv.serial_phy = invd.serial_phy 
JOIN student_year_debts syd ON invd.serial_deb = syd.serial_deb 
JOIN student std ON syd.serial_std = std.serial_std 
JOIN student_by_course stc ON std.serial_std = stc.serial_std AND stc.status_stc = 'ACTIVE'
JOIN course crs ON stc.serial_crs = crs.serial_crs AND crs.status_crs = 'ACTIVE' AND crs.serial_scy = 3
JOIN level lvl ON crs.serial_lvl = lvl.serial_lvl
JOIN class_group clg ON crs.serial_clg = clg.serial_clg
WHERE inv.name_paying_phy 
LIKE '%AGECON%'
AND inv.status_phy = 'ACTIVE' 
AND invd.status_psd = 'ACTIVE'