select p.*, t.*, coalesce(pm.meta_value, p.post_title) title from wp_7_posts p
join wp_7_icl_translations t on t.element_id = p.ID and t.language_code = 'en'
left join wp_7_postmeta pm on pm.post_id = p.ID and pm.meta_key = 'menuname'
left join wp_7_postmeta pm1 on pm1.post_id = p.ID and pm1.meta_key = 'areaw'
left join wp_7_postmeta pm2 on pm2.post_id = p.ID and pm2.meta_key = 'areah'
left join wp_7_postmeta pm3 on pm3.post_id = p.ID and pm3.meta_key = 'maxthickness'
where p.post_status = 'publish' and p.post_type = 'laser'
Found 35 lasers