EDD Child & Parent License Expiration.

query.sql

SELECT p.ID  as license_id,
       c_exp.meta_value as child_expiration,
       p_exp.meta_value as parent_expiration
         FROM `wp_posts` p
         LEFT JOIN `wp_postmeta` c_exp ON c_exp.post_id = p.ID AND c_exp.meta_key = "_edd_sl_expiration"
         LEFT JOIN `wp_postmeta` p_exp ON p_exp.post_id = p.post_parent AND p_exp.meta_key = "_edd_sl_expiration"
         WHERE p.`post_type` = 'edd_license' 
           AND p.post_parent != 0