Select ID, (Select ID from GoCardLess_Payments__r Order By CreatedDate DESC NULLS LAST) FROM vlocity_cmt__PaymentMethod__c Where GEO_ID_Mandate__c IN ('MD00045H83H7XA',  'MD00046CDQRVCF',  'MD00047H7NRSB3',  'MD00048B2GWWAJ',  'MD00048WZXQHXB',  'MD00048X6VMJHH',  'MD0004983MEWXP',  'MD00049JBF46A1')