SELECT DISTINCT
                                                s.id,
                                                s.name,
                                                s.context,
                                                st.status,
                                                s.gettext_context,
                                                st.value AS tra,
                                                st.mo_string AS mo_string,
                                                s.value AS orig
                                        FROM wordpresswp_icl_string_pages sp
                                        INNER JOIN wordpresswp_icl_string_urls su
                                                ON su.id = sp.url_id
                                        INNER JOIN wordpresswp_icl_strings s
                                                ON s.id = sp.string_id
                                        LEFT JOIN wordpresswp_icl_string_translations st
                                                ON s.id=st.string_id
                                                        AND st.language=su.language
                                                        AND s.language!=su.language
                                        WHERE (su.language='de' and su.url='(.?.+?)(?:/([0-9]+))?/?$') or (su.language='de' and su.url IS NULL)