SELECT DISTINCT
CONCAT (grd.last_name_grd,' ',grd. first_name_grd) AS name_grd,
grd.id_grd,
grd.phone_grd,
CONCAT(grda.main_street_gda,' ',grda.number_gda,' ',grda.secondary_street_gda) AS address
FROM student_guardian stg
JOIN student_year sty ON stg.serial_std = sty.serial_std
JOIN guardian grd ON grd.serial_grd = stg.serial_grd
JOIN guardian_address grda ON grda.serial_grd = grd.serial_grd
WHERE status_stg = 'ACTIVE'
AND status_sty != 'RETIRED'
AND sty.serial_scy = 3 
AND grda.main_address_gda = 'YES'
ORDER BY grd.last_name_grd, grd.id_grd 
LIMIT 0 , 1600