SELECT e.entry_id, DATE(e.date_created) AS tgl, DATE_FORMAT(e.date_created, '%Y-%m-%d %H:%i:%s') AS exact,
MAX(CASE WHEN m.meta_key = 'hidden-1' THEN m.meta_value END) AS userid, 
MAX(CASE WHEN m.meta_key = 'hidden-2' THEN m.meta_value END) AS name, MAX(CASE WHEN m.meta_key = 'hidden-3' THEN m.meta_value END) AS email, MAX(CASE WHEN m.meta_key = 'textarea-2' THEN m.meta_value END) AS catatan, MAX(CASE WHEN m.meta_key = 'radio-1' THEN m.meta_value END) AS Jenis, 
MAX(CASE WHEN m.meta_key = 'text-1' THEN CAST(CONCAT('https://maps.google.com/?q=', m.meta_value) AS CHAR) END ) AS Location
 FROM wpbw_frmt_form_entry_meta m JOIN wpbw_frmt_form_entry e ON e.entry_id = m.entry_id WHERE m.meta_key IN ('hidden-1','hidden-2','hidden-3','textarea-2','radio-1','text-1') GROUP BY e.entry_id, tgl order by exact desc